Marketo

This page describes how to use Census with Marketo.

🏃‍♀️ Getting Started

In this guide, we will show you how to connect Marketo to Census and create your first sync.

Prerequisites

• Have your Census account ready. If you need one, create a Free Trial Census account now.

• Have your Marketo account ready, with admin access to create API-only users and API credentials.

• Have the proper credentials to access to your data source. See our docs for each supported data source for further information:

  • Azure Synapse

  • Databricks

  • Elasticsearch

  • Google BigQuery

  • Google Sheets

  • MySQL

  • Postgres

  • Redshift

  • Rockset

  • Snowflake

  • SQL Server

1. Create a Marketo API User

Before setting up API credentials for Census, you'll first need a Marketo Role with API Access, as well as a user with that role.

API Access Role

None of the default Marketo Roles have API access so if this is your first API integration, you'll first need to create an API access role. Marketo's documentation walks through creating a new API Access role as well as your first user.

You can view/edit role permissions in Admin, Users & Roles, then clicking the Roles tab.

Whether you're using an existing role or creating a new one, please make sure it has at least the following permissions: Read-Write People and Read-Write Named Accounts. To use Custom Objects, we'll also need Read-Write Custom Object and Read-Write Custom Object Type.

Note: Even though your Marketo instance may support Custom Objects, the Custom Object Metadata API is not an out-of-the-box feature on Select Plans at Marketo and doesn’t automatically come with Custom Objects. If you still don't see Custom Objects in Census, you may need to contact your Marketo Account Manager to make sure you have access to the Custom Object Metadata API.

API Only User

We recommend you create a new Marketo API User so that you can track changes made by your Census syncs. Either way, the user must be marked API Only during creation.

2. Gather Marketo API Credentials

To connect Census to Marketo, you'll need to collect three pieces of information:

• Endpoint URL

• Client ID

• Client Secret

Back in Admin, expand the Integrations menu on the left and select the Web Services option. Scroll down to the REST API section. Copy and paste the Endpoint URL (you can excluding the /rest part).

Next we'll create a new LaunchPoint Service. Click on LaunchPoint and select New > New Service.

Your new service should have the following properties:

• Display Name: Census

• Service: Custom

• Description: Census Data Integration

• API Only User: [The user you created in step 1]

Once created, you'll see your new service in the list of services. Click on View Details. You will need to copy the Client ID and Client Secret here.

3. Adding Credentials to Census

With all three pieces of information, return to Census and visit the Destinations tab. Click on the New Destination button and select Marketo from the menu. Copy and paste the values into the dialog and hit save. You should be clear to create a new sync!

🗄 Supported Objects

Census currently supports syncing to the following Marketo objects.

Object Name	Supported?	Sync Keys
Lead	✅	Object ID, any Text/Number
Named Account	✅	Object ID, any Text/Number
Custom Objects	✅	Object ID, any Text/Number
Static List Membership	✅
Custom Activities	✅

Contact us if you want Census to support more objects for Marketo.

🔄 Supported Sync Behaviors

Learn more about all of our sync behaviors on our Core Concepts page.

Behaviors	Supported?	Objects
Update or Create	✅	Lead, Named Account, Custom Objects
Update Only	✅	Lead, Named Account, Custom Objects
Append	✅	Custom Activities
Mirror	✅	Lead, Static List Membership, Custom Objects

Please be aware that Update Only and Mirror make use of less efficient Marketo APIs and will result in more API usage for the same number of records.

Contact us if you want Census to support more Sync behaviors for Marketo.

🚑 Need help connecting to Marketo?

Contact us via [e-mail] or start a conversation with us via the in-app chat.