Impressions, Clicks and Cost by city/region available on campaign level but not on an adgroup level

[Srinand Arunkumar]

Hi there,

In our google_ads dataset, I see that we can get the impressions, Clicks and Cost on a campaign level broken down to region/city by using the table CampaignLocationTargetStats 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?

Where can we get the adgroup level impression, clicks and cost broken down to a region/city from the tables in google_ads dataset?

Cheers,

Sri

[Google Ads API Forum Advisor]

Hi Sri,

Thank you for posting your concern.

Could you confirm if you tried using the 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 and response logs with request ID and request header generated on your end if you are using Google Ads API or 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 googleadsa...@google.com.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Uh1Nb:ref

[Srinand Arunkumar]

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) 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

[Google Ads API Forum Advisor]

Hi Sri,

Since you mentioned that the GeoStats table has duplicate data as compared with the Adgroup report that was fetched via API and Google Ads UI, could you please provide the following:

• GeoStats table showing duplicate data
• Complete request and response logs with the request-id generated via Google Ads API
• Screenshots from the UI showing data

Kindly send to us via Reply privately to author option.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2Uh1Nb:ref