Sync data from BigQuery to Marketo

The world's most innovative companies choose Hightouch as their Composable CDP

Activate your data in 3 easy steps

Step 1

Connect your source and destination

Connect to 35+ data sources, like BigQuery, and 200+ destinations, like Marketo.

Step 2

Define your model

Use SQL or select an existing dbt or Looker model.

Step 3

Sync your data

Map your fields, set your sync schedule, and hit “Go!”

Email

Email

Name

Name

Total_orders

All_orders

Last_login

Last_login

What Marketo objects can you sync to?

• Leads

  The Marketo Lead’s API provides a large set of capabilities for simple CRUD applications against lead records, as well as the ability to modify a lead’s membership in static lists and programs, and initiate Smart Campaign processing for leads.

  Hightouch docsMarketo API

• Companies

  Companies represent the organization to which lead records belong. Leads are added to a Company by populating their corresponding externalCompanyId field using Sync Leads or Bulk Lead Import endpoints.

  Hightouch docsMarketo API

• Opportunities

  Marketo exposes APIs for reading, writing, creating and updating opportunity records. In Marketo, opportunity records are linked to lead and contact records through the intermediate Opportunity Role object, so an opportunity may be linked to many individual leads.

  Hightouch docsMarketo API

• Custom Activities

  Custom activities help you track an activity that isn’t related to a Marketo form, email, or landing page. Want to track when someone deposits a check? Use a custom activity. Want to keep tabs on when someone attends a webinar? Use a custom activity.

  Hightouch docsMarketo API

• Static lists

  Static lists are one of the most simple and useful features of Marketo. They are simply a list of names from your Database. You will find plenty of reasons to use them.

  Hightouch docsMarketo API

• Campaigns

  Hightouch allows you to trigger campaigns through Marketo Campaign API with records in your model.

  Hightouch docsMarketo API

What methods can I use to model my BigQuery data?

• dbt model selector

  

  Sync directly with your dbt models saved in a git repository.

• Looker

  

  Query using Looks. Hightouch turns your look into SQL and will pull from your source.

• SQL editor

  

  Create and Edit SQL from your browser. Hightouch supports SQL native to BigQuery.

• Sigma model

  

  Hightouch converts your Sigma workbook element into a SQL query that runs directly on BigQuery.

• Table selector

  

  Select available tables and sheets from BigQuery and sync using existing views without having to write SQL.

• Customer Studio

  

  For less technical users, pass traits and audiences from BigQuery using our visual segmentation builder.

FAQs