How to transfer your Google Merchant Center Data to BigQuery
- Sylvain Paillard
- Ralf Baumgartner
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/merchant-center-transfer#set_up_a_google_merchant_center_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. 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.
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 Merchant ID and enable the desired inventories/insights.
Add Notifications as you like and save the transfer.
Share your datasets access with the Boxalino Service Account emails and the Datastudio email (EDITOR)
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 edit access (“BigQuery Data Editor” role) and click on “Save”.
Let Boxalino know the name of the project and dataset and we will integrate it to your data lake.