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!