Build robust marketing campaigns on Marketo using rich customer data from your data warehouse
Setup
Create Marketo authorization details by navigating to Admin > Launchpoint and selecting a service.
You can find the Base URL in Admin > Integration > Web Services. Only use the part after https:// and before /rest as your base url, e.g.
284-RPR-133.mktorest.com.
Click "Add New"
Click "Marketo"
Add any destination name (e.g. "Marketo")
Copy Client ID, Client Secret, and Base URL into form
Click Add Marketo Destination
Modes
The Marketo destination has two possible modes:
- Upsert — Upsert mode pushes new objects to Marketo and updates fields that change in your warehouse.
- Update — Update mode updates particular fields on existing objects in Marketo.
Upsert
In this mode, new objects will be inserted into Marketo and all designated columns will be kept up-to-date within Marketo.
This mode is good for the following scenarios:
- You want to push objects into Marketo and want to keep the data up-to-date
Upsert has three configuration parameters:
| Name | Description |
|---|---|
| Marketo Object Name | The name of the object (Leads, Companies, etc..) that will be updated in Marketo |
| Hightouch to Marketo Merge Rule | The name of the column on the Hightouch query, and the name of the field to dedupe on in Marketo. For leads, this can be any field except ID. For any other object, this has to be a "Dedupe Field" in Marketo and not the ID field |
| Hightouch to Marketo Field Mappings | A list of columns that will be pushed to new objects in Marketo. Each time a sync occurs in Hightouch these columns will be updated. |
Update
In this mode, selected columns will be updated for an object within Marketo. For example, you could add an LTV column to an account or contact. This mode does not create new rows for an object within Marketo. Instead, it updates columns on existing objects.
Update mode requires you to have access to the IDs of the objects you want to update within your warehouse.
This mode is good for the following scenarios:
- You have objects in Marketo that you want to add additional information / columns to
- You want to continuously sync data from your warehouse and add this data to existing objects within Marketo
- You already have access to Marketo object IDs within your warehouse
Update has three configuration parameters:
| Name | Description |
|---|---|
| Marketo Object Name | The name of the object (Leads, Companies, etc..) that will be updated in Marketo |
| Hightouch to Marketo Merge Rule | The name of the column on the Hightouch query, and the name of the field to dedupe on in Marketo. For leads, this can be any field or the ID field. For any other object, this can be a "Dedupe Field" in Marketo or the ID field. |
| Hightouch to Marketo Field Mappings | A list of columns that will be pushed to new objects in Marketo. Each time a sync occurs in Hightouch these columns will be updated. |
- Connection issues with your data warehouse?
- Confusing API responses from destination systems?
- Unsupported destination objects or modes?
- Help with complex SQL queries?
Need help?
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
or
Feature Requests?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.