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 Starter, так как она не поддерживает Шлюз движения данных. Если используется другой уровень подписки или не требуется использовать Шлюз движения данных, выберите Нет. Для получения информации о преимуществах Шлюз движения данных и о сценариях, требующих его использования, см. раздел Шлюз данных 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 |