BigQuery Data Transfer Service for Google Ads - Trouble Finding Specific Conversion Data

[jordanb06]

Hi,

We've had Google Ads transfers setup with our big query cluster for awhile now. Set it up via https://cloud.google.com/bigquery/docs/google-ads-transfer. It has worked for a lot of our needs but trying to find some other data components needed for reporting. We've also reviewed the data set that's available in Big Query from the Google Ads transfer here: 

https://cloud.google.com/bigquery/docs/google-ads-transformation#column_mapping_for_reports as part of our investigation.

We're trying to get conversion data that we need from this data set and have been looking at Google Ads Table Name: AccountConversionStats in particular. We see  "conversions" and "conv. value" except that the ones we need are grouped by the time of the conversion/sale (as opposed to the time of the click that led to the conversion which is all we can see that's available via this direct transfer data set).

Basically we need these metrics: 

https://developers.google.com/google-ads/api/fields/v14/customer#metrics.all_conversions_by_conversi... 

https://developers.google.com/google-ads/api/fields/v14/customer#metrics.all_conversions_value_by_co...

https://developers.google.com/google-ads/api/fields/v14/customer#metrics.conversions_by_conversion_d...

https://developers.google.com/google-ads/api/fields/v14/customer#metrics.conversions_value_by_conver...

We can pull it via the Google Ads API like so:

SELECT segments.date, customer.id, customer.descriptive_name, campaign.id, campaign.name, segments.conversion_action, segments.conversion_action_name, metrics.all_conversions_by_conversion_date, metrics.all_conversions_value_by_conversion_date, metrics.conversions_by_conversion_date, metrics.conversions_value_by_conversion_date FROM campaign WHERE segments.date = "${dateRange}"

But what we're hoping for is the Google Ads Transfers Service to Big Query provides that directly today. Before we move with a custom solution to pull that via Google Ads API, we wanted to confirm definitively whether or not BigQuery Data Transfer Service for Google Ads provides this data.

Can someone that's an expert confirm this please? We just want to make sure we're not missing something.

Thanks!

[jordanb06]

To add, we've also looked at this table in Big query (as part of the tables maintained by  BigQuery Data Transfer Service for Google Ads): Google Ads Table Name: AdConversionStats. But yeah doesn't have what we need either. Still can't find the metrics metrics.all_conversions_by_conversion_date, metrics.all_conversions_value_by_conversion_date, metrics.conversions_by_conversion_date, and metrics.conversions_value_by_conversion_date there either.

[jordanb06]

Note: This same question I asked in stack overflow (as recommended by https://cloud.google.com/bigquery/docs/getting-support as another resource for help): https://stackoverflow.com/questions/78271377/bigquery-data-transfer-service-for-google-ads-trouble-f... . No answer there yet but figured I'd share that thread too. Trying to get some help on this ASAP... Thanks y'all!

[jordanb06]

I wanted to follow up here that after chatting with Google Cloud Platform Technical Support it was confirmed that as of April 2024 BigQuery Data Transfer Service for Google Ads today does not provide these data elements. It sounds like it's in their backlog to add though (no ETA). We went with the custom solution to solve our reporting needs.