BigQuery data transfer service from Google Ads - missing some columns

1
votes

In Google BigQuery we have setup a data transfer from Google Ads. It's a very nice integration, but we do miss some columns about the so-called "quality score".

To be specific, we are looking for:

  • HistoricalQualityScore
  • HistoricalCreativeQualityScore
  • HistoricalLandingPageQualityScore
  • HistoricalSearchPredictedCtr

All from the report: KEYWORDS_PERFORMANCE_REPORT

They should be supported by the API (v201806 reports).

Might i be missing something? Or would it make sense, to request this from Google?

Screenshot of the Columns from the official doc:

enter image description here

1
google-bigquerygoogle-ads-api

1 Answers

0
votes

According to the "Column mapping for Google Ads reports", those columns are not included in the Google Ads Transfers. I specially checked the columns for the Keywords Performance Report but I don't see any related columns.

You may either ask the Google Ads team how to get those values from the data exported, or if this can't be obtained with the current columns exported, then file a feature request to the Bigquery team.