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 <http://segments.keyword.info/>.ad_group_criterion, segments.keyword.info <http://segments.keyword.info/>.match_type, and segments.keyword.info <http://segments.keyword.info/>.text it works. Best, Kelly > On May 15, 2020, at 4:14 PM, Kelly Dougan <[email protected]> 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/ > <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 > <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 [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/adwords-api/9d467eac-45e0-4af5-80a6-0c4b0a86ba6a%40googlegroups.com > > <https://groups.google.com/d/msgid/adwords-api/9d467eac-45e0-4af5-80a6-0c4b0a86ba6a%40googlegroups.com?utm_medium=email&utm_source=footer>. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/5EE7D3D3-CC3D-44CB-BE49-68794B6F80D1%40curology.com.
