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

[PabloPicc]

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!

[ms4446]

There are a few possible reasons why the aggregated data (Avg.CPM, Avg.CPC, etc.) in BigQuery may be different from the data in the Google Ads UI:

• Different data sources: The Google Ads UI and BigQuery Data Transfer Service use different data sources. The Google Ads UI displays data from the Google Ads reporting database, while BigQuery Data Transfer Service retrieves data from the Google Ads API. It is possible that there are some discrepancies between the two data sources.
• Different data processing: The Google Ads UI and BigQuery Data Transfer Service also use different data processing methods. The Google Ads UI aggregates data in real time, while BigQuery Data Transfer Service aggregates data in batches. It is possible that the different data processing methods may lead to some discrepancies in the aggregated data.
• Data transfer errors: It is also possible that there were some errors during the data transfer process. This could lead to some data being missing or corrupted in BigQuery.

To troubleshoot the issue, you can try the following:

1. Check the settings in both BigQuery and the Google Ads UI.Make sure that the following settings are the same in both platforms:
   • Time zone
   • Currency
   • Segmentation
   • Filters
2. Compare the data transfer logs to the data in BigQuery. This will help you to identify any errors that may have occurred during the data transfer process.
3. Compare the data in BigQuery to the data in the Google Ads reporting database. This will help you to determine if the discrepancies are due to different data processing methods.
4. Recalculate metrics like Avg.CPC and Avg.CPM in BigQuery using the base metrics. This can often resolve discrepancies.
5. If you are still unable to resolve the issue, contact Google Ads support for assistance.

Additional tips:

• Make sure that you are using the same date range in both BigQuery and the Google Ads UI.
• Make sure that you are using the same data format in both BigQuery and the Google Ads UI.
• Try exporting the data from the Google Ads UI to a CSV file and then importing the CSV file into BigQuery. This can help to rule out any issues with the data transfer process.
• If you are using any filters or segmentation in the Google Ads UI, make sure that you are applying the same filters and segmentation in BigQuery.

[Snoshone07]

Hi @PabloPicc here you have some suggestions that might help you resolve this issue:

Possible Solutions

1. Check Data Transformation:

   • Ensure that there are no transformations or filters applied to the data in BigQuery that might be affecting the aggregated metrics. Sometimes, data processing steps can inadvertently zero out certain metrics.

2. Verify API Data Source:

   • Confirm that the data source for the BigQuery Data Transfer Service is correctly configured and that it matches the scope and filters used in the Google Ads UI. Discrepancies can arise if different data scopes or filters are applied.

3. Compare Raw Data:

   • Compare the raw data from both sources (BigQuery and Google Ads UI) at a more granular level (e.g., daily metrics) to identify where the discrepancies start. This can help pinpoint any specific issues in data aggregation or transfer.

Alternative Solution

If you're looking for a more reliable and accurate way to handle data integration between Google Ads and BigQuery, you might consider using third-party connectors. For instance, Windsor.ai offers a comprehensive solution for integrating Google Ads data with BigQuery. Windsor.ai ensures that aggregated metrics like Avg. CPM and Avg. CPC are accurately captured and transferred, avoiding the issue of metrics appearing as zero. Hope this helps!