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'
"""
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/f940daca-402d-46a7-b628-2eda900e8a8bn%40googlegroups.com.
