Unable to pull ad_group and ad_group_ad data

[Kelly Dougan]

Hello, 

For one of my accounts, I'm unable to pull data from the ad_group and ad_group_ads tables. Can you help me to troubleshoot why I'm unable to pull this data, and determine which tables and fields are available for this account?

[Kelly Dougan]

Specifically, I am trying to run the following query, which returns values for one of my accounts but not the other:

select ad_group_ad.ad.device_preference, ad_group_ad.ad.display_url, ad_group_ad.ad.expanded_dynamic_search_ad.description, ad_group_ad.ad.expanded_dynamic_search_ad.description2, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.final_urls, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad.resource_name, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.path1, ad_group_ad.ad.responsive_search_ad.path2, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.type, ad_group_ad.ad.url_collections, ad_group_ad.ad.url_custom_parameters, ad_group_ad.ad.video_ad.bumper.companion_banner, ad_group_ad.ad.video_ad.discovery.description1, ad_group_ad.ad.video_ad.discovery.description2, ad_group_ad.ad.video_ad.discovery.headline, ad_group_ad.ad.video_ad.in_stream.action_button_label, ad_group_ad.ad.video_ad.in_stream.action_headline, ad_group_ad.ad.video_ad.in_stream.companion_banner, ad_group_ad.ad.video_ad.media_file, ad_group_ad.ad.video_ad.non_skippable.companion_banner, ad_group_ad.ad.video_ad.out_stream.description, ad_group_ad.ad.video_ad.out_stream.headline, ad_group_ad.ad_group, ad_group_ad.ad_strength, ad_group_ad.resource_name, ad_group_ad.ad.final_app_urls, ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.final_url_suffix, ad_group_ad.ad.final_urls, segments.ad_network_type, segments.date, segments.keyword.ad_group_criterion, segments.keyword.info.match_type, segments.keyword.info.text, metrics.all_conversions, metrics.bounce_rate, metrics.clicks, metrics.cost_micros, metrics.cross_device_conversions, metrics.engagements, metrics.impressions, metrics.interactions, metrics.top_impression_percentage, metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, metrics.video_view_rate, metrics.video_views from ad_group_ad where segments.date DURING LAST_MONTH LIMIT 100 

Can someone help determine why the query is returning nothing? When I run the same query without segments.keyword.info.ad_group_criterion, segments.keyword.info.match_type, and segments.keyword.info.text it works. 

Best,

Kelly

On May 15, 2020, at 4:14 PM, Kelly Dougan <kelly....@curology.com> wrote:

Hello, 

For one of my accounts, I'm unable to pull data from the ad_group and ad_group_ads tables. Can you help me to troubleshoot why I'm unable to pull this data, and determine which tables and fields are available for this account?

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9d467eac-45e0-4af5-80a6-0c4b0a86ba6a%40googlegroups.com.

[Google Ads API Forum Advisor Prod]

Hi Kelly,

In order for me to take a closer look, can you please provide the CIDs of the accounts in which you are making this query against? Additionally, can you specify which account returns values and which one doesn't? When providing this information, please "Reply privately to author."

Thanks,
Danica Calusin, Google Ads API Team

ref:_00D1U1174p._5004Q1zphP2:ref