summary
Help page for ETL Configuration of Data Settings for Adobe Marketo Engage.
constraints
- In order to use the filter on the renewal date, you need to apply for API function activation to the Marketo Support Desk.
Please apply for activation of the filter function using updatedAt in the Bulk Lead Extract API by the customer.
Setting items
STEP1 Basic settings
common area
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Adobe Marketo Engage Connection Configuration | Yes | - | - |
| target | Yes | - | Select the type of data to be acquired. The data that can be obtained are as follows Lead Activities Campaign Programs Program Members Leads by static list Custom Objects List Activity Type Folder |
When the target is the lead
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Date & Time Columns | No | Use createdAt | Does it retrieve data created during the period specified in the retrieval period (createdAt)? You can choose to retrieve updated data (updatedAt). |
| Acquisition period | No | - | Enter the start and end dates of the filter range. Please enter in YYYYY-MM-DD format. (Example. 2020-11-19） |
When the target is an activity
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Acquisition period | No | - | Enter the start and end dates of the filter range. Please enter in YYYYY-MM-DD format. (Example :. 2020-11-19） |
When the target is a program member
| item name | indispensable | default value | Contents |
|---|---|---|---|
| program ID filter | No | - | Enter the program ID of the data you wish to retrieve, separated by commas. If not entered, all members under all programs will be covered. (Example :. (111,222,333) |
When the target is a lead by static list
| item name | indispensable | default value | Contents |
|---|---|---|---|
| list-ID filter | No | - | Enter the comma-separated list IDs of the data you wish to retrieve. If not entered, all leads under all lists will be targeted. (Example :) (111,222,333) |
When the target is a custom object
| item name | indispensable | default value | Contents |
|---|---|---|---|
| API Name | No | - | Specify the API name of the custom object you wish to retrieve. It is usually in the form of a custom object name with "_c". A list of API names that can be specified can be displayed by clicking the " Load API Name List " button. |
| field | No | - | Specify the field name of the custom object you wish to retrieve. A list of field names that can be specified can be displayed by clicking the " Load Field Name Candidates " button. |
| Filter type | No | - | Specify the condition of the custom object to be retrieved. Only integer and searchable fields can be treated as filters. If there is no column that corresponds to this, data transfer is not possible. You can view a list of available fields by reading the available filter types. |
| Filter range | No | - | Specifies the range of data values to be retrieved with respect to the value specified in the filter type. The default value of the start value is 1. If no end value is specified, data with a value greater than the start value can be retrieved. However, data acquisition is filtered by 300 values at a time, and data acquisition is terminated when there is no data to acquire. |
When the target is a folder
| item name | indispensable | default value | Contents |
|---|---|---|---|
| root folder ID | No | - | Specify the ID of the root folder that will be the starting point for retrieving data. If not entered, the folder with the workspace name becomes the root folder. |
| root folder type | Yes | folder | Select the type of root folder that will be the starting point for retrieving data. The default value is a folder. |
| Maximum data acquisition depth | Yes | 2 | Specify the maximum folder hierarchy of the data you wish to retrieve. The default value is 2. |
| workspace | No | - | Specify the workspace of the data you wish to retrieve. If not entered, all folders under all workspaces will be covered. |
About the data that can be obtained
lead (in a game, dance, etc.)
When the target is a read, the columns of data to be retrieved are all the columns retrieved by GET /rest/v1/leads/describe.json.
Activities
When the target is an activity, the columns of data to be retrieved are those in the table below.
| column name | Contents |
|---|---|
| marketoGUID | Marketo GUID |
| leadId | Lead Id |
| activityDate | Date the activity took place |
| activityTypeId | activity type ID |
| campaignId | campaign ID |
| primaryAttributeValueId | Marketform ID, etc. |
| primaryAttributeValue | Marquette form name, etc. |
| attributes | Detailed Activity Information |
campaign
When the target is a campaign, the columns of data to be retrieved are those in the table below.
| column name | Contents |
|---|---|
| id | campaign ID |
| name | Campaign Name |
| description | explanatory note |
| type | Campaign Type Show trigger or batch |
| workspaceName | workspace name |
| createdAt | creation-day |
| updatedAt | update date |
| active | Indicate whether the campaign is active or inactive |
Program
When the target is a program, the columns of data to be retrieved are those in the table below.
| column name | Contents |
|---|---|
| id | program ID |
| name | program-name |
| sfdcId | SFDC ID |
| sfdcName | SFDC Name |
| description | explanatory note |
| createdAt | creation-day |
| updatedAt | update date |
| startDate | Start Date |
| endDate | End Date |
| url | URL |
| type | type name |
| channel | Channel Name |
| folder | Information about the folder |
| status | status |
| costs | cost |
| tags | tag |
| workspace | workspace |
Program Members
When the target is a program member, the columns of data to be retrieved are all the columns retrieved by GET /rest/v1/programs/members/describe.json.
Lead by static list
When the target is a read, the columns of data to be retrieved are all the columns retrieved by GET /rest/v1/leads/describe.json plus the static list ID.
custom object
When the target is a custom object, the columns of data to be retrieved are those specified in the field.
list
When the target is a list, the columns of data to be retrieved are those in the table below.
| column name | content |
|---|---|
| id | list id |
| name | listname |
| description | description |
| programName | the name of the program containing the list |
| workspaceName | workspace name |
| createdAt | Creation Date |
| updatedAt | updated Date |
Activity Type
When the target is an activity type, the columns of data to be retrieved are those in the table below.
| column name | content |
|---|---|
| id | activity type ID |
| name | activity type name |
| description | description |
| primaryAttribute | Contents of the activity's primaryAttribute |
| attributes | content of attributes of activity |
| apiName | creation date |
folder
When the target is a folder, the columns of data to be retrieved are those in the table below.
| column name | content |
|---|---|
| id | folder id |
| name | folder name |
| description | description |
| createdAt | Creation Date |
| updatedAt | updated Date |
| url | URL |
| folderId | information about the folder |
| folderType | folderType |
| parent | Information about the parent folder |
| path | path |
| isArchive | archive folder or not |
| isSystem | is the system folder or not? |
| accessZoneId | accessZoneID |
| workspace | workspace |