Geo Performance Report skips row if cityCriteria Id or metroCriteriaId is blank

[Abhishek Verma]

Hello,

We use http client to fetch data from Google Ads API

Query : SELECT customer.currency_code,customer.descriptive_name,campaign.id,campaign.name,campaign.status,segments.geo_target_city,geographic_view.country_criterion_id,segments.geo_target_metro,segments.geo_target_most_specific_location,segments.geo_target_region,ad_group.id,ad_group.name,ad_group.status,segments.device,geographic_view.location_type,metrics.clicks,metrics.cost_micros,metrics.impressions FROM geographic_view WHERE metrics.impressions > 0 AND segments.date >= "2022-04-01" AND segments.date <= "2022-04-01" PARAMETERS omit_unselected_resource_names=true' for clientId=1912824586

Total clicks as per Google ADS UI is 2071, 

But as per above query Total clicks is 1951 (PFA sheet).

When the query was done for Adwords API, the total matches with Google Ads UI PFA sheet.

How can we fetch details when segments.geo_target_city or  geographic_view.country_criterion_id is blank 

Regards,

Abhishek Verma

 

[Google Ads API and AdWords API Forum]

Reposting the last inquiry ( https://groups.google.com/g/adwords-api/c/vSRYciQq3es ) from the forum as it wasn't routed to our support queue.

Regards,
Carmela
Google Ads API Team

[Google Ads API and AdWords API Forum]

Hi Abhishek,

Thank you for reaching out to the Google Ads API team. Please note that I had to delete your initial post as it contains your provided attached file with data. That said, I am reposting below your concern without the attached file :

Moving forward to your concern, so our team can better check and investigate this issue, could you provide the Google Ads API complete request and response logs with request ID and request header and the AWQL that you used in AdWords API? You may then send the requested information directly to our googleadsa...@google.com.

Regards,

Carmela
Google Ads API Team

On Friday, August 5, 2022 at 1:52:32 AM UTC+8 ae_a...@idcontractors.net wrote: