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”
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.
Access to daily processing: 473358938625-compute@developer.gserviceaccount.com
Access to full processing: 748704719320-compute@developer.gserviceaccount.com
Access to delta processing : 178258671205-compute@developer.gserviceaccount.com
Access for reports processing: connection-daily@reports-290318.iam.gserviceaccount.com
Access for lab processing: connection-daily@lab-daily.iam.gserviceaccount.com
(optional) Access to mailchimp processing: 44011570818-compute@developer.gserviceaccount.com
(optional) Access for p13nsync processing: 57928973091-compute@developer.gserviceaccount.com
Provide a read access (Data Viewer/Metadata Viewer) on all relevant datasets in your custom GCP projects.
Let Boxalino know the name of the project and dataset and we will integrate it to your data lake.
Add Comment