Hi Ernie, I want to clarify that we are using the google_ads dataset that we have in BigQuery after we setup a BQ Data Transfer.
Now, what we are wanting to get is the marketing metrics such as Impressions, Clicks, Cost broken down to an Adgroup level and by region. We took some time in finding out how to get the above on a Campaign level and we figured out finally that we can get the impressions, clicks and cost for a campaign broken down by region using the table *google_ads.CampaignLocationTargetStats* (https://developers.google.com/adwords/api/docs/appendix/reports/campaign-location-target-report) we get the geo data from the csv - https://developers.google.com/google-ads/api/reference/data/geotargets on joining the criteria ID from the csv to the criterionid from *google_ads.CampaignLocationTargetStats*, we get the region/city information of the campaign. We have looked at ad_group report that you mentioned, which I think is the *google_ads.adgroup* table and can't find any column which would indicate the location information. The only table that seems to have the campaign and adgroup with location is the *google_ads.GeoStats (*Find attached an image of the schema of the table* - GeoStats) [image: GeoStats_schema.PNG] *As can be seen in the file, we have the AdGroupId, CityCriteriaId, CountryCriteriaId, RegionCriteriaId, Impressions, Clicks, Cost. But the issue we have is when we get the Impressions etc. from the GeoStats table and compare it to the google_ads.Adgroup and the Adgroup report that we export online from the Google Ads interface, they never match, the GeoStats table seems to have extra/duplicate data. How can we resolve this? Thanks, Sri On Thursday, January 6, 2022 at 7:37:21 PM UTC+13 adsapi wrote: > Hi Sri, > > Thank you for posting your concern. > > Could you confirm if you tried using the ad_group > <https://developers.google.com/google-ads/api/fields/v9/ad_group> report > and including some of the geo related segment fields? If not, please do so > and let me know how it goes after. > > For this part of the issue, could you illustrate to us how this issue has > been observed? Also, please provide the relevant 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> > generated > on your end if you are using Google Ads API or report definition > <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition> > > if Adwords API. > > "*But when I want the same on an adgroup level, and I look at the data in > the table - GeoStats which is the only table where we have the > CountryCriteriaId, CityCriteriaId and RegionCriteriaId broken down by > AdGroupId and CampaignId but the data from GeoStats do not reconcile to > the CampaignLocationTargetStats and the data seems to be vastly overstated, > is there a reason why this is so?*" > > You can provide the requested details via *Reply privately to author* > option. If this option is not available, then send it instead on this email > address [email protected]. > > Regards, > [image: Google Logo] > Ernie John Blanca Tacata > Google Ads API Team > > > ref:_00D1U1174p._5004Q2Uh1Nb:ref > -- -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/0e99ad9f-de7f-4a80-a400-20dac3011d8dn%40googlegroups.com.
