Missing campaigns in GeoStats

[Yahor Bayarchuk]

Google Ads data shown in Geo Performance Report (GeoStats table) after BigQuery import is missing all campaigns except one our web campaign. But i can query and see all existing campaigns and their stats in Campaign Performance Report only (all related tables).
My query for GeoStats:

SELECT DISTINCT CampaignId FROM `myproject.google_ads.GeoStats_cid`

WHERE IsTargetingLocation IN UNNEST([true,false])
getting 1 campaign for query above.

My query for CampaignBasicStats:

SELECT DISTINCT CampaignId FROM `myproject.google_ads.CampaignBasicStats_cid`
getting 6 campaigns for query above.

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to us.

Please note that this forum channel can only provide assistance to issues/concerns related to the AdWords API / Google Ads API.

You've mentioned that the Google Ads data is shown in Geo Performance Report; however, after BigQuery import it is missing all campaigns except one of your web campaign. You can query all those data (existing campaigns and their stats) in Campaign Performance Report. Since the issue here is already related to the BigQuery import, we suggest that you reach out to the BigQuery Support Team via this link instead.

As an aside, since you're using the Geo Performance Report, please also note on the supported campaign types (in the AdWords API) via this guide. There might be campaigns in your account that aren't supported which is the reason why campaigns are missing.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2PJVKC:ref