Hi there,
I've set up a Storage Transfer Service to pull data from the Google Ads to BigQuery which serves as a DWH system for us. The issue is that we are interested in GEO and as suggested by Google Docs I tried to query GeoStats views.
The issue is that the numbers (e.g. number of clicks) don't much.
E.g.
SELECT
_DATA_DATE, sum(clicks)
FROM `_project_._dataset_.GeoStats_XXX`
where LocationType='LOCATION_OF_PRESENCE'
and IsTargetingLocation IN (true, false)
group by 1
It constantly shows fewer clicks than the Google Ads platform or a similar query based on the CampaignBasicStats table.
Is it any solution to it or is it a bug in the Transfer Service?
I've also noticed that there are very few rows with the IsTargetingLocation=false for the LOCATION_OF_PRESENCE LocationType.
LinkedIn
Twitter
