KPI mismatch for DSA campaign

[Hsin-Yi Lin]

Dear Google Ads support team,

I am seeing a discrepancy when I try to pull data from dynamic_search_ads_search_term_view and ad_group_ad. The dynamic_search_ads_search_term_view table is showing fewer impressions, clicks, and cost than ad_group_ad filtering for EXPANDED_DYNAMIC_SEARCH_AD. Also, when I create a report in the Ads UI, for expanded dynamic search ads, the numbers match ad_group_ad. Any idea why EXPANDED_DYNAMIC_SEARCH_AD seems to be missing some information?

dynamic_search_ads_search_term_view : provide more granular information (search-term, landing page)

query: 

query = """

                SELECT segments.date, campaign.id, campaign.name,

                ad_group.id, ad_group.name,

                dynamic_search_ads_search_term_view.search_term, dynamic_search_ads_search_term_view.landing_page,

                metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions

                FROM

                dynamic_search_ads_search_term_view

                WHERE segments.date BETWEEN '2024-01-01' AND '2024-01-31'

            """

ad_group_ad: less granular information (only down to ad-group level)

query = """

                SELECT

                segments.date, campaign.id, campaign.name,

                ad_group.id, ad_group.name,

                metrics.impressions, metrics.clicks, metrics.cost_micros

                FROM

                ad_group_ad

                WHERE segments.date BETWEEN '2024-01-01' AND '2024-01-31'

                AND ad_group_ad.ad.type = 'EXPANDED_DYNAMIC_SEARCH_AD'

            """