Marketo
Marketo is a marketing automation platform. You can use Marketo as a data source when landing or replicating data.
Marketo integration replicates data using the Marketo REST API and Marketo Bulk API.
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 this integration is designed to use only a portion of your allotted API calls, replication may be impacted if numerous applications are using the API.
Creating the connection
Mer information finns i Koppla till SaaS-program.
- Ange de kopplingsegenskaper som krävs.
Ange ett namn på kopplingen i Kopplingsnamn.
Välj Öppna kopplingsmetadata för att definiera metadata för kopplingen när den har skapats.
Klicka på Skapa.
| Setting | Description |
|---|---|
| Data gateway | Välj en Gateway för dataflytt om det krävs för ditt användningsfall. Anteckning om information Detta fält är inte tillgängligt med Qlik Talend Cloud Starter-prenumerationen eftersom den inte stöder Gateway för dataflytt. Om du har en annan prenumerationsnivå och inte vill använda Gateway för dataflytt väljer du Inget. Information om fördelarna med Gateway för dataflytt och användningsfall som kräver det finns i Qlik Data Gateway – dataflytt. |
| Start Date | Ange det datum, i formatet |
| 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.
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 |