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
如需詳細資訊，請參閱連線到 SaaS 應用程式。
- 填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。
| Setting | Description |
|---|---|
| Data gateway | 如您的使用情況有需要，選取 資料移動閘道。 資訊備註 此欄位無法用於 Qlik Talend Cloud 啟動器 訂閱，因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道，選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。 |
| Start Date | 以 |
| 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 |