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 :
"*Hello,* *We use http client to fetch data from Google Ads API* *Query : SELECT customer.currency_code,customer.descriptive_name,campaign.id <http://campaign.id/>,campaign.name <http://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 <http://ad_group.id/>,ad_group.name <http://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 <https://ads.google.com/aw/campaigns?ocid=204113459&euid=629273188&__u=9231276612&uscid=9304243&__c=4259417307&authuser=0> 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*" Moving forward to your concern, so our team can better check and investigate this issue, could you provide the Google Ads API complete request <https://developers.google.com/google-ads/api/docs/concepts/field-service#request> and response <https://developers.google.com/google-ads/api/docs/concepts/field-service#response> logs with request ID <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id> and request header <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers> and the AWQL that you used in AdWords API? You may then send the requested information directly to our googleadsa...@google.com <https://mail.google.com/mail/u/0/?fs=1&tf=cm&source=mailto&to=googleadsapi-supp...@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: > 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 > <https://ads.google.com/aw/campaigns?ocid=204113459&euid=629273188&__u=9231276612&uscid=9304243&__c=4259417307&authuser=0> > > 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 > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ec9e1483-0f19-49b8-910b-b8d1ef3956can%40googlegroups.com.
