Data Mismatch Between Ad_group_ad and dynamic_search_ads_search_term_view

27 views
Skip to first unread message

Matt Peyton

unread,
Jun 21, 2022, 12:13:45 PMJun 21
to Google Ads API and AdWords API Forum
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

unread,
Jun 22, 2022, 1:06:28 PMJun 22
to 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

unread,
Jun 29, 2022, 3:23:52 AMJun 29
to 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

unread,
Jul 4, 2022, 3:05:58 AMJul 4
to 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
Reply all
Reply to author
Forward
Message has been deleted
0 new messages