How to transfer your Google Ads Data to BigQuery
- Sylvain Paillard
- Ralf Baumgartner
- Ralf Baumgartner (Unlicensed)
MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU”
and not another one like “europe-west-6”
Set up Google Ads data transfer
Google Documentation: https://cloud.google.com/bigquery/docs/google-ads-transfer
Go to the BigQuery page in the console. https://console.cloud.google.com/bigquery
Click Data transfers.
If the API is not yet enabled do that now.
Create a new transfer.
For the source select Google Ads - Preview. Give a name to the transfer. Leave the default (daily) schedule options.
In the destination settings create a new dataset in the multi-region EU. You can name the new Dataset as you like, we suggest <your_eshop>_adstransfer.
MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU”
and not another one like “europe-west-6”
Do NOT enable Table Expiry!
In the Data source details add your Google Ads CustomerID. Find your Google Ads customer ID.
Do not exclude removed/disabled items
Include Tables new to Google Ads and include PMax Campaign Tables
Standard Refresh Window is 7 days.
Add Notifications as you like and save the transfer.
Schedule a Backfill
To get older Data then 7 Days we need to schedule a backfill. Click on the Transfer you just created. In the top right is the option to plan the backfill.
Make sure you do not select more then 180 days in your date range as the backfill might fail otherwise. you can do several backfills with less then 180 days one after another.
Share your datasets access with the Boxalino Service Account emails and the Datastudio email
You can share a dataset by clicking on the three dots next to the name and select “Share Dataset”.
In the Dataset Permissions Click on Add Principals in the top right corner.
Purpose |
|---|
General Testing |
General Service Account |
General Service Account |
Access to daily processing |
Access to full processing |
Access to delta processing |
Access for reports processing |
Access for lab processing |
Access to mailchimp processing |
Access for p13nsync processing |
Access for Dataform |
You can copy the list of emails from above and paste them in the “New principals“ field. Provide read access (Data Viewer/Metadata Viewer roles) and click on “Save”.
Let Boxalino know the name of the project and dataset and we will integrate it to your data lake.
As very well explained in this online article, there are quite direct ways to transfer your raw data from Google Ads to Google BigQuery. We recommend the approach with Data Transfer, but you can also investigate the other method using Google Ads Script.