Empty response from ad_group_ad

[Johan Alpne]

Hello,

For a certain time span in the Google Ads UI we have 5 million + impressions

For that same time span we get an empty response from the API using the ad_group_ad resource.

This is the GAQL:
"SELECT customer.descriptive_name, customer.time_zone, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.id, campaign.name, campaign.tracking_url_template, campaign.url_custom_parameters, campaign.final_url_suffix, ad_group.name, ad_group.id, ad_group.type, ad_group.tracking_url_template, ad_group.final_url_suffix, ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.ad.text_ad.headline, 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.description, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.final_urls, ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.final_url_suffix, ad_group_ad.ad.name, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.app_ad.headlines, ad_group_ad.ad.responsive_display_ad.headlines, ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.image_ad.pixel_height, ad_group_ad.ad.image_ad.pixel_width, ad_group_ad.ad.image_ad.preview_image_url, ad_group_ad.ad.url_custom_parameters, ad_group_ad.ad.expanded_dynamic_search_ad.description, ad_group_ad.ad.expanded_dynamic_search_ad.description2, ad_group_ad.ad.display_url, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.responsive_search_ad.path1, ad_group_ad.ad.responsive_search_ad.path2, ad_group_ad.ad.responsive_display_ad.long_headline, ad_group_ad.ad.responsive_display_ad.descriptions, ad_group_ad.ad.responsive_display_ad.call_to_action_text, ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements, ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video, ad_group_ad.ad.display_upload_ad.display_upload_product_type, segments.date, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_quartile_p100_rate, metrics.active_view_impressions, metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.clicks, metrics.cost_micros, metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions, metrics.impressions, metrics.interactions, metrics.video_views, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage, customer.currency_code FROM ad_group_ad WHERE segments.date BETWEEN \'2022-09-05\' AND \'2022-10-02\'" 

We have the request and response logs if needed.

Best regards,

Johan Alpne

Developer @ Funnel

[Google Ads API Forum Advisor]

Hi Johan,

Thank you for reaching out to our API support team and for the details you have provided.

However, for our team to be able to investigate further, could you also share to our team your customer ID and the complete request and response logs that you mentioned?

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2f50LY:ref