Marketo
Marketo is a marketing automation platform. You can use Marketo as a data source when landing or replicating data.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
You need the Admin permissions in Marketo. Marketo Admin permissions are required to complete portions of the setup process.
Prior to set up, we recommend that you monitor your Marketo API call usage if other applications are also connected to your Marketo account. While Stitch is designed to use only a portion of your allotted API calls, replication may be impacted if numerous applications are using the API.
To obtain your client ID, client secret and user login ID, contact the 3PL Central Warehouse you are working with. They must submit a request for REST API access to their 3PL Central Customer Success Manager.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
| Setting | Description |
|---|---|
| Data gateway | Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
| Start Date | Enter the date, in the format |
| Endpoint Base URL | Endpoint base URL, for example: https://457-RFG-234.mktorest.com/rest. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
| Max Daily API Calls | Most Marketo subscriptions are allocated 50000 API calls per day. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
activities
In version 1 of Marketo integration, the activities table contained all data pertaining to lead activities.
In this version, you can choose to replicate lead activity data for specific activity types. For every activity type defined in your Marketo account, you’ll see an activities table in the Tables to Replicate tab. For example: activities_click_email contains lead activity data for the click_email activity type.
These tables will contain the fields listed below, along with any fields specific to that activity type.
Replication Method | CDC |
Primary Key | marketoGuid |
Replication Key | activityDate |
| Useful links |
activity_types
The activity_types table contains metadata about the activity types - form fill, web page visit, lead creation, and so on - available in Marketo.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
campaigns
The campaigns table contains info about your Marketo campaigns
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
leads
The leads table contains info about your Marketo leads.
Stitch replicates leads from Marketo using the Bulk API. The Replication Key for this table varies depending on your Marketo account setup:
- If updatedAt filtering is enabled, this table will use
updatedAtas the Replication Key - If updatedAt filtering isn’t enabled, this table will use
createdAtas the Replication Key. Additionally, data will be loaded using Append-Only loading.
Read more about replicating this table.
Replication Method | CDC |
Primary Key | id |
| Useful links |
lists
The lists table contains info about the static lists in your Marketo account.
Note: Due to some of the limitations in Marketo API, only static lists will be replicated.
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
programs
The programs table contains info about your Marketo programs. Programs can be parents to most types of assets in Marketo and allow you to track membership and success of leads.
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |