Query

SELECT 
    fact.campaign_id campaign_id,
    fact.target_id target_id,
    fact.ams_profile_id ams_profile_id,
    fact.ad_group_name ad_group_name,
    fact.ad_group_id ad_group_id,
    fact.targeting_text targeting_text,
    dim.startDate AS campaign_start_date,
    fact.campaign_name campaign_name,
    fact.query query,
    fact.targeting_type targeting_type,
    fact.ad_type ad_type,
    fact.country country,
    SUM(attributed_sales1d) AS sales1d,
    SUM(attributed_sales7d) AS sales7d,
    SUM(attributed_sales14d) AS sales14d,
    SUM(attributed_sales30d) AS sales30d,
    SUM(attributed_sales14d_same_sku) AS sales14d_same_sku,
    SUM(attributed_sales14d) - SUM(attributed_sales14d_same_sku) AS halo_sales14d,
    SUM(attributed_sales_new_to_brand14d) AS sales14d_new_to_brand,
    term.salesLast60d AS sales_last60d,
    term.salesThisWeek AS sales_this_week,
    term.salesMTD AS sales_mtd,
    term.roasLast60d AS roas_last60d,
    term.roasThisWeek AS roas_this_week,
    term.roasMTD AS roas_mtd,
    CASE term.search_frequency_rank
        WHEN 99999999 THEN NULL
        ELSE term.search_frequency_rank
    END search_frequency_rank,
    SUM(cost) AS adspend,
    ROUND((SUM(cost) / SUM(attributed_sales14d)) * 100,
            2) AS acos14d,
    ROUND(SUM(attributed_sales14d) / SUM(cost), 2) AS roas14d,
    ROUND((SUM(attributed_conversions14d) / SUM(clicks)) * 100,
            2) AS conversion14d,
    SUM(attributed_conversions14d) AS conversions14d,
    SUM(attributed_conversions14d_same_sku) AS conversions14d_same_sku,
    ROUND((SUM(clicks) / SUM(impressions)) * 100,
            2) AS ctr,
    SUM(impressions) AS impressions,
    SUM(clicks) AS clicks,
    SUM(attributed_units_ordered14d) AS orders14d,
    ROUND((SUM(cost) / SUM(clicks)), 2) AS cpc,
    ROUND(SUM(cost) / SUM(impressions), 2) AS cpi,
    dim.state campaign_status,
    CASE keyword.bid
        WHEN 0 THEN adGroup.defaultBid
        ELSE keyword.bid
    END keyword_bid,
    fact.brand brand
FROM
    fact_targets_segmented_summary_daily AS `fact`
        INNER JOIN
    dim_search_terms_v1 AS term ON term.user_id = term.user_id
        AND term.keyword_id = fact.target_id
        AND fact.query = term.search_term
        INNER JOIN
    dim_keywords_v1 AS keyword ON fact.target_id = keyword.keywordId
        AND keyword.userId = fact.user_id
        INNER JOIN
    dim_campaign_v1 AS dim ON fact.campaign_id = dim.campaignId
        AND dim.userId = fact.user_id
        INNER JOIN
    dim_adgroup_v1 AS adGroup ON keyword.adGroupId = adGroup.adGroupId
        AND keyword.userId = adGroup.userId
WHERE
    (fact.user_id = {user_id}
        AND (fact.report_type = 'keywords')
        AND (dim.state = 'enabled')
        AND (fact.country = {country})
        AND (fact.brand = {brand})
        AND fact.date BETWEEN '2022-09-18' AND '2022-10-22')
GROUP BY fact.user_id , fact.ams_profile_id , fact.campaign_id , fact.target_id , fact.query;

Tables

Explain plan