Data Mismatch Between Ad_group_ad and dynamic_search_ads_search_term_view

[Matt Peyton]

Good morning,

I am seeing a discrepancy when I try to pull data from dynamic_search_ads_search_term_view and ad_group_ad. The dynamic..._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?

Ad_group_ad gaql query:

SELECT
    campaign.name,
    metrics.impressions,
    metrics.clicks,
    metrics.cost_micros
FROM
    ad_group_ad
WHERE
    segments.date BETWEEN '2022-04-30' AND '2022-05-05'
    AND ad_group_ad.ad.type = 'EXPANDED_DYNAMIC_SEARCH_AD'

dynamic_search_ads_search_term_view gaql query:

SELECT
    campaign.name,
    metrics.impressions,
    metrics.clicks,
    metrics.cost_micros
FROM
    dynamic_search_ads_search_term_view
WHERE
    segments.date BETWEEN '2022-04-30' AND '2022-05-05'"

[Google Ads API and AdWords API Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-api/c/hovKG3LZzVs) from the forum as it wasn't routed to our support queue.

Cheers,
Peter Laurence
Google Ads API Team

[Google Ads API and AdWords API Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-api/c/hovKG3LZzVs) from the forum as it wasn't routed to our support queue.

Cheers,

Ernie John
Google Ads API Team

[Google Ads API and AdWords API Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-api/c/hovKG3LZzVs) from the forum as it wasn't routed to our support queue.

Cheers,

Carmela
Google Ads API Team