Sync your customer data from Marketo to Optimizely Data Platform (ODP) to enrich your customer profiles, reports, and segmentation with Marketo lead record data, email activities, form submissions, and program member statuses.
You can also sync ODP segments and customer attributes to Marketo lists to power your Marketo automation and personalization strategy.
Prerequisites
- Marketo account
- Marketo API user with the following access permissions:
- Read-Only Activity
- Read-Only Activity Metadata
- Read-Only Assets
- Read-Write Person
- ODP account
Configure the integration
- Go to the App Directory in ODP.
- Select the Marketo app.
- Click Install App.
- Go to the Settings tab.
- In the Authentication section, enter your Marketo Base URL, Client ID, and Client Secret.
- Click Authenticate.
- In the Sync section, enable the Marketo objects you want to sync to ODP and then click Save:
- Leads – Syncs leads created in the last day, daily. Updates the ODP customer profile.
- Email Activities – Syncs hourly. Updates the ODP customer profile.
- Programs – Syncs updates from the last day, daily. Each program creates corresponding fields in ODP that you can use in reports and segmentation. Does not update the ODP customer profile.
- Forms – Syncs form submission events every 5 minutes. Updates the ODP customer profile.
If you enable the Leads, Programs, and Forms Marketo objects, a corresponding section for each displays to manage leads field mappings, select programs to sync, and select forms to sync.
The data that you enable in step seven begins syncing from Marketo to ODP after you complete the configuration in each corresponding section. To sync historical Marketo data, see Import historical data.
Leads Field Mapping
The Leads Field Mapping section includes a table that lists the Marketo fields that sync to ODP by default. You can add field mappings if you want to sync additional fields that are not listed in the table. Repeat these steps for each field mapping you want to add:
- Expand the Leads Field Mapping section.
- Below the table, select the Marketo field from the first drop-down list.
- Select the ODP field from the second drop-down list that you want to map the Marketo field to.
If the Marketo field does not have a corresponding field in ODP, you must first create that custom field in ODP.
- Click Save Field Map.
You can delete custom field mappings. Repeat these steps for each field mapping you want to delete:
- Expand the Leads Field Mapping section.
- Select the field mapping you want to delete from the Field Map drop-down list.
- Click Delete Field Map.
Programs
In the Programs section, select the Marketo programs from which you want to sync member statuses to ODP, then click Save.
Forms
The Forms section includes a table that lists your Marketo forms and their corresponding fields that you can sync to ODP. Each form's sync status and field mappings are not configured by default. You must manually enable the sync and configure the field mappings for each form that you want to sync:
- Expand the Forms section.
- Select the form from the Configure Marketo Form drop-down list.
- Toggle the Sync Status to On.
- Select the Marketo form field that you want to map from the Form Field drop-down list.
- Select the corresponding ODP field from the Customer Field drop-down list.
- The form mapping autosaves and displays in the table.
- After you configure the sync status and form mappings, click Done.
If you add, remove, or modify forms in Marketo after configuring this integration, you can click Reload from Marketo in the Forms section to sync those forms over to ODP. The reload does not affect your configuration changes to existing Marketo forms in ODP.
Import historical data
This integration syncs Marketo lead, program, and form events that occur after you complete each section's settings. You can import historical data in a maximum of 31-day batches:
- Expand the Import section.
- Enter the start date and time for the import.
- Enter the end date and time for the import.
The end date cannot be more than 31 days after the start date.
- Click Start Sync.
If you want to import more than 31 days of data, repeat the steps above as many times as needed in 31-day intervals.
Sync data from ODP to Marketo
After you configure the app, you can set up an activation in ODP to sync your customer data from ODP to Marketo.
- Go to Activation > Engage.
- Click Create New Campaign.
- To sync your segments and data once, click One-Time. To set up an automated, recurring sync, click Behavioral.
- Click Create From Scratch.
- Enter a name for your activation that represents the data you are syncing to Marketo (for example, Marketo Data Sync).
- Select your desired segment and click Apply or click Create New Segment, select your desired segment conditions, and click Save.
- Expand Enrollment Rules and adjust as desired.
- Expand Touchpoints.
- Click to edit Touchpoint 1 and select Marketo.
- Select the Marketo List you want to sync this data to.
- (Optional) Select the Number of Additional Fields you want to sync to Marketo (up to 20).
A drop-down list and input field display for the number of additional fields you selected. In each Field # drop-down list, select the Marketo field you want to populate. In each corresponding Field # Value, enter the ODP field you want to send to the selected Marketo field. For example, if you selected Company Name from the Field # drop-down list, enter {{customer.company_name}} for the corresponding Field # Value.
- Click Save and then click your activation name in the breadcrumb trail.
- In the Touchpoints section, click Select start time and schedule.
- For a recurring sync (behavioral campaign), complete the following settings, then click Apply:
- Recurring or Continuous – Select Recurring.
- Start Date – Enter the date you want to send the data to Marketo.
- End – Defaults to Never. If you want to end the Marketo data sync on a specific date, set that here.
- Repeats – Set to Daily.
- Repeat Every – Set to 1 day.
- Timing – Enter the time you want to send the data to Marketo.
- Time Zone – Select the time zone in which you want to send this data.
-
Delivery Strategy – Set to Send all at scheduled time. Click Apply.
- For a one-time sync (one-time campaign), complete the following settings, then click Apply:
- Send Date – Enter the date you want to send the data to Marketo.
- Send Time – Enter the time you want to send the data to Marketo.
- Time Zone – Select the time zone in which you want to send this data.
- Delivery Strategy – Set to Send all at scheduled time.
- Click Apply.
- Click Save and then click Go Live. Your sync starts at your designated start date and time.
Troubleshoot the data sync
To ensure data is syncing as expected from ODP to Marketo:
- Go to Account Settings > Event Inspector in ODP.
- Click Start Inspector.
- When data is available in the inspector, a number displays next to Refresh. Click to view the data.
- The raw data that ODP and Marketo sends back and forth displays. Click View Details to see the formatted version of that raw data.
- Data fields sent from Marketo back to ODP start with
_marketo
.
Each data sync is also logged in the ODP activity log:
- Go to Account Settings > Activity Log.
- Filter the categories by marketo.
- Click View Details for a formatted view of the log details, including the number of matches.
Article is closed for comments.