| Note |
|---|
MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU” |
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.
| Note |
|---|
MAKE SURE THAT YOUR BIGQUERY REGION IS “Multi-Region EU” 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 read edit access (Data Viewer/Metadata Viewer roles“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.