Sync BigQuery to Marketo in Five Minutes

Having accurate and up-to-date information synced from BigQuery to Marketo is crucial for effective marketing campaigns.

However, no native integration exists between these two systems.

Luckily, Polytomic enables fast data syncing between BigQuery and Marketo.

This blog post will explore how you can use Polytomic to set up a sync between BigQuery and Marketo in less than five minutes. No coding required.

Step 1 - Setup

Once you get started with Polytomic, the first thing you’ll do is connect BigQuery and Marketo to Polytomic.

To connect BigQuery, you’ll need to create a JSON service account key in BigQuery and upload it to Polytomic. See our docs page for more information.

To connect Marketo, you will need to enter three pieces of information: Client ID, Client Secret, and the Web Services REST API endpoint. Our docs page will help you find this information.

Once everything is connected to Polytomic, the next step is to create your data model.

Step 2 - Create a Model

A data model is a specific selection of data from your source system (BigQuery in this case) that you can then set up a sync for.

You can select any BigQuery dataset, table, and even specific fields that you have access to and save them into your data model.

For example, you could select the ‘Contacts’ table from a ‘Sales CRM’ dataset to save into your data model.

You might also want to create another model with account information and then join it to your first model so the data can be sent over together.

Whatever data you can join across BigQuery and Marketo using a common key, you can save that data into a model and sync it over. This leads us to the final step…

Step 3 - Set Up the Sync

Setting up the sync starts with you choosing your destination (Marketo in this case) as well as the target object in the destination system.

For example, the ‘Leads’ object within Marketo.

You can then select from one of three modes:

• Create: Create records when they don’t exist; don’t update existing ones
• Update: Update existing records only; don’t create new ones
• Create or Update: Update records when they exist and create them when they don’t

From there, you map the data from BigQuery to Marketo starting with the identity (the key) and then individual fields. That way, the data arrives where you expect it to.

Additionally, you can select model filters so that only data that meets certain criteria get synced, and you can select certain overrides.

The last step in this process is to select how often you’d like the data to sync. It could be continuous, hourly, daily, weekly, one-time, or based on a custom schedule.

Once that sync is saved, you can choose to sync five random records as a test or go ahead and enable the sync to start running.

And that’s it! Your data is now seamlessly flowing from BigQuery to Marketo.

Other Nice Features

Some other things we think you’ll love:

• Only sync data that has changed
• Minimal API usage
• Custom SQL queries
• Error detection and handling
• ‘Best Support’ in our category according to G2

Conclusion

With three quick steps, Polytomic makes it easy to have seamless data integration between BigQuery and Marketo.

Start today by getting a free trial.