no "results" section in response

[jerome delmar]

Hi,

I have a list of 18 advertiser and I'm trying to generate a Geographic view data report for each of them but it seems to succeed only for 2 of them.

I used the query builder tool to generate the following SQL query and request the following endpoint:

endpoint: /customers/{advertiser_id}/googleAds:search

query: SELECT segments.date, campaign.id, ad_group.id, ad_group.name, ad_group.status, campaign.name, segments.device, segments.ad_network_type, customer.time_zone, customer.currency_code, metrics.average_cost, metrics.average_cpc, metrics.average_cpm, metrics.average_cpv, metrics.clicks, metrics.cost_micros, metrics.cost_per_all_conversions, metrics.cost_per_conversion, metrics.ctr, metrics.impressions, metrics.interaction_rate, metrics.interactions, metrics.interaction_event_types, metrics.value_per_all_conversions, metrics.value_per_conversion, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.conversions_value, metrics.video_views, metrics.video_view_rate, geographic_view.country_criterion_id, customer.descriptive_name, customer.id, geographic_view.location_type, segments.geo_target_city, segments.geo_target_county, segments.geo_target_region, geographic_view.resource_name FROM geographic_view WHERE segments.date DURING LAST_7_DAYS ORDER BY segments.date ASC

When it seems to works I have all data in the "results" section in the response, but for all other advertisers, I only have the "fieldMask" section in the response.

In those advertisers I'm sure to have some running campaigns so it's not just an "empty report" because all campaigns are in paused or something like that.

I have no error messages, all queries are good, just the content of answers are different.

Regards.

[Google Ads API Forum Advisor]

Hi Jerome,

Thank you for raising your concern.

To take a closer look at the issue, please provide the complete request and response logs with request ID and request header generated on your end for each API request to retrieve the geographic view report of the Google Ads accounts. You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2QEyn3:ref