geo_target_region showing blank in BQ

26 views
Skip to first unread message

Deborah Balme

unread,
Apr 17, 2023, 2:16:26 PM4/17/23
to Google Ads API and AdWords API Forum
Hi, 

We have a BQ Data Transfer setup for GAds account using Preview Data Transfer, we have noticed over the last couple of days that the segments_geo_target_region is returning blank, previously we have data recorded but now its all returning null.

I can access the data via UI and via other platforms, but the data transfer is blank.
Any Ideas?

SELECT distinct
segments_date,
segments_geo_target_region

FROM pj-gaf-j7v122.google_mcc_google_ads_v2.ads_GeoStats_9782911894

WHERE
segments_date = '2023-03-21'

Google Ads API and AdWords API Forum

unread,
Apr 18, 2023, 8:10:30 AM4/18/23
to Google Ads API and AdWords API Forum
Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/229yH2tXVqI) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads API Team

Google Ads API and AdWords API Forum

unread,
Apr 18, 2023, 9:13:04 AM4/18/23
to Google Ads API and AdWords API Forum
Hi Deborah,

Thank you for reaching out to the Google Ads API support team. I hope that you are doing well today.

Moving forward to your concern, I checked the query you provided and to be honest with you, in Google Ads API, we are not aware of this resource "pj-gaf-j7v122.google_mcc_google_ads_v2.ads_GeoStats_9782911894" which you selected in FROM clause. With this, what we can do is to advise you to reach out to the Big Query Support team via this link https://cloud.google.com/support-hub to assist you further with your concern.

Kind regards,
Google Ads API
Reply all
Reply to author
Forward
0 new messages