Google BigQuery is a leading cloud-based data warehouse solution from Google that enables customers to store and analyse large volumes of business data. By integrating BigQuery with Dotdigital, you can import both contact and product datasets directly, without restructuring your data, to power highly targeted email, SMS, and WhatsApp campaigns.
Dotdigital allows you to connect and map your existing data without forcing it into a pre-set format. This avoids duplicate storage needs and saves time, making onboarding faster and reducing costs.
Public preview
This feature is currently in public preview. To join the preview, contact your Customer Success representative.
What you can do
Import contact data from BigQuery to create targeted campaigns.
This lets you bring together customer information from multiple systems into Dotdigital.
Import product data from BigQuery to enrich marketing campaigns with dynamic content, product recommendations, and personalised offers.
Use product data alongside contact data to improve relevance and engagement.
Choose different sync frequencies for each dataset, such as more frequent contact syncs and less frequent product syncs.
Before you start
Thing you need to know:
You must have a Google BigQuery Service account email address and private key.
1. Integrate BigQuery with Dotdigital
Start the integration by finding BigQuery in the self-serve integrations menu.
Go to Connect > Integrations.
In the left menu, under SHOW, select Self-serve.
Find Google BigQuery, then select +ADD.
2. Connect your accounts
Set up the connection between Dotdigital and your BigQuery account.
Read the integration information, then select NEXT.
For Connect to BigQuery, select Connect account.
For Your authentication name, enter a descriptive name for this connection (to help identify the integration later).
Enter the service account email address and associated private key from your BigQuery service account.
Select CREATE.
Select NEXT.
3. Sync contacts
Decide if you want to import contact data from BigQuery into Dotdigital.
If you already get your contacts from another source (such as a CRM), select No.
You can still sync product data even if you choose not to sync contacts.
Select Yes or No.
Select NEXT.
4. Sync product catalog
Decide if you want to import product data from BigQuery into Dotdigital.
If your product data lives in another platform, select No.
You can still sync contact data even if you choose not to sync products.
Select Yes or No.
Select NEXT.
5. Select view
Choose whether your data source is a table or a view in BigQuery.
Select View to combine data from multiple tables, for example, online and offline product data, without restructuring.
Your choice here affects only how Dotdigital reads the data, not what data is imported.
Select Table or View.
Select NEXT.
6. Select your data source for products
Choose where your product or customer data lives in BigQuery.
Expand the Project drop-down menu, and choose the Google Cloud Project that contains your data.
Expand the Dataset drop-down menu, and choose the dataset that organises your tables/views.
Expand the Table/View drop-down menu, and choose the table (or view) that holds the data you want to sync.
Select NEXT.
7. Select your timestamp column
Choose the column that tracks when records were last updated.
This lets Dotdigital sync only the changes since your last import, enabling incremental syncs.
Expand the Timestamp column drop-down menu, and choose the column that shows when each record was last modified.
Select NEXT.
8. Map your data fields
Connect your BigQuery data to the right places in Dotdigital.
You must map either an email address or mobile number to sync contacts.
When syncing products, you must map mandatory schema fields. Mandatory fields are shown in grey. You can map optional fields as needed, but you can’t add additional custom fields.
Expand the Dotdigital field drop-down menu, and choose where you want the data to appear in your Dotdigital account.
Expand the BigQuery field drop-down menu, and choose the column that contains this information.
To map additional fields, select ADD A NEW MAPPING and repeat the process.
Select NEXT.
9. Set sync schedule
Choose how often your data syncs. You can set a different schedule for each dataset.
For example, you can sync contact data more frequently than product data.
Sync options:
Hourly
Every four hours
Once a day (default)
Expand the Sync data every drop-down menu, and choose your sync frequency.
Select COMPLETE.