Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Discrepancies between the data provided by Google ADS console (UI) and BigQuery Data Transfer

Hi community, the issue that I am facing is this:

A data download has been made from G.Ads using BigQuery Data Transfer. I am trying to compare this data against Google Ads UI (G.Ads-->Campaigns-->export data as csv). Most of the metrics I am interested on, they do match, but some of them dont.

The ones that are not matching are mostly aggregated data (Avg.CPM, Avg.CPC, etc.). In the UI we can see a number, but in BigQuery this metrics are always 0. 

We have tried to change the scope of the selection (from campaign to "ad"), but nothing happened. We have also double-checked several times that the time range is correct. It is.

Do you know why this data is not matching? Can you help us solve this issue?

Thanks in advance!

 

 

 

 

 

 

0 2 2,122
2 REPLIES 2