Integrating BigQuery and Google ads's Offline conversions

[MimirTheWise]

Hello there!

Im currently working on this integration with Google Ads's offline conversions and was wondering why they don't have anything native with BigQuery or even just a doc guide for an integration "in house". I found it really odd that the api integrates seamlessly with both Salesforce and Zapier, but never even mentions any GCP native data base. (Google ads doc for reference )

The closest thing I was able to find is this TaglessCRM doc that mentions both GCS -> Googles Ads and BQ -> Google ads scenarios, but the dags are not available in the doc so its hard to make sense of it: (TaglessCRM doc)

Maybe Im just looking in the wrong places, sooo... Does anyone have any clever ideas? 

[OlegS]

Hi @MimirTheWise 

It looks like a rare case that someone needs a BigQuery to store offline sales data. The most common case is exporting data into Google Ads directly from CRM, instead of using BigQuery as an intermediate layer.

Even the TablessCRM doc you are referring shows this data flow: BigQuery -> CRM -> Google Ads.