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. 

[Snoshone07]

Hello @jordanb06 I was having the same problem. With custom solution you mean you finally pulled this data through a 3rd party? If that's the case, which one are you using? Just for curiosity as I ended using windsor.ai to export my data but I don't know if it was the best option or if there's one you would recommend

[jordanb06]

Hey @Snoshone07 ,

We're not using any "managed"/saas 3rd party tool to do it. We used our own custom scripting via Google Ad's official python client (https://github.com/googleads/google-ads-python), just interacting directly with the Google Ads API, that we setup with our workflow orchestration tool (used AWS MWAA). 

We were just hoping to use BigQuery Data Transfer Service for Google Ads as its out of the box but yeah it doesn't provide it sadly :(.

-Jordan