Missing data from Google Ads Data Transfer in VideoConversionStats table

[domfeg]

Hello, I'm experiencing a data discrepancy issue with Google Ads Data Transfer Service in BigQuery when trying to analyze video campaign conversions. The VideoConversionStats table shows almost no conversion data, despite seeing thousands of conversions in both the VideoBasicStats table and Google Ads UI.

I have tried also an alternative approach using AdConversionStats table (same result - minimal data for video ads)

Similar issues without a solution:
https://stackoverflow.com/questions/52207628/adwords-to-bigquery-data-transfer-service-does-not-send...

https://issuetracker.google.com/issues/114626784?pli=1

Is this a known limitation of the Google Ads Data Transfer Service for video campaigns?

Are there specific settings or configurations needed to ensure video conversion data transfers properly?

Has anyone found a reliable workaround for accessing video campaign conversion data by action name in BigQuery?

Thank you!

[nikacalupas]

Hi domfeg,

Welcome to the Google Cloud Community!

Let’s go through your question one by one: 

Is this a known limitation of the Google Ads Data Transfer Service for video campaigns?

• Yes, this is a known limitation of the Google Ads Data Transfer Service, as evidenced by the links you found. 

Are there specific settings or configurations needed to ensure video conversion data transfers properly?

• Currently, there aren't many "settings" within the Google Ads DTS itself to specifically address this video conversion discrepancy. The transfer service is generally set up to pull standard reports.

Has anyone found a reliable workaround for accessing video campaign conversion data by action name in BigQuery?

• Using Google Ads API + Cloud Functions: This approach involves writing a script that queries the Google Ads API for the exact report you need and then loads that data into a BigQuery table. You can schedule this script to run daily using a service like Google Cloud Functions.

Additionally, You might also find this documentation helpful for loading Google Ads data into BigQuery.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.