Can't find rating/score data in BigQuery Google Ads Transfer Service tables

Gord Nuttall

unread,

Oct 25, 2023, 8:58:38 PM10/25/23

to Google Ads API and AdWords API Forum

Hi,

No error was observed, but looking for confirmation on where the rating/score data might be found in BigQuery Google Ads Data Transfer tables or if it can be retrieved using the Google Ads API (v15 or v14). See the attached screenshot for confirmation that the data does exist in Google Ads (Local Service Ads (LSA))

I reviewed the BigQuery Data Transfer Docs which basically say the transfer is based on the Google Ads API v14. I then reviewed the Google Ads API documentation in which the transfer above used.

In the end, I cannot find any fields with "Score" or "Rating" available in the Google Ads API and thus the BQ Google Ads Data Transfer Service, yet the screenshot attached shows that the data exists in the MCC report for these local service ads (LSA). How can I retrieve this rating/score data with an API call?

To summarize, no error is occurring, I'm just looking for where I can find this review/score data for LSA Google Ads accounts as it does exist (see the screenshot attached and column highlighted in yellow)

Previous somewhat related thread. I don't understand what " asset linkage" means in the response.

Log in to Adswerve Connect to check out our services, view training opportunities, find resources and learn about upcoming events.

Gord Nuttall

unread,

Nov 6, 2023, 7:08:42 PM11/6/23

to Google Ads API and AdWords API Forum

Any ideas here? The data obviously exists within the product, seems surprising that no API call can extract it out.

Gord Nuttall

unread,

Nov 6, 2023, 7:08:44 PM11/6/23

to Google Ads API and AdWords API Forum

any thoughts here. Seems strange the data is not available via an API of some sort.