Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Choose one of the following sources:
    Lead, Activity, Lead by Static List, Member Leads by Program, Campaign, Programs and Programs Program Members.

  2. Type values for the following common parameters depending on the source type you have selected:

Expand
titleLeads


Parameters

Description



Incremental

Bulk extract sources support the incremental import feature through the createdAt filter. When running in incremental mode, the connector calculates the next ‘from_date’ based on the previous filter.

Example:

  • 1st run from_date: 2018-01-01 to_date: 2018-01-11(generated by plugin) fetch_days: 10

  • 2nd run from_date: 2018-01-11 to_date: 2018-01-21 fetch_days: 10

Limitation: – Bulk extract source preview shows only mock data.

From Date

Data that has a createdAt or updatedAt filter after the specified date.

Fetch Days

The To date is calculated using From day + Fetch days

Escape Character

Marketo CSV file escape character.

Quote Character

Marketo CSV file quote character.



Expand
titleActivities

Retrieve large amounts of activity data out of Marketo.

Activity attributes are imported to the column attributes. This column is in JSON format.

Parameters

Description

ACTIVITY TYPE IDS

Integer values, corresponding to the desired activity types.

Incremental

Bulk extract sources support the incremental import feature through the createdAt filter. When running in incremental mode, the connector calculates the next ‘from_date’ based on the previous filter.

Example:

  • 1st run from_date: 2018-01-01 to_date: 2018-01-11(generated by plugin) fetch_days: 10

  • 2nd run from_date: 2018-01-11 to_date: 2018-01-21 fetch_days: 10

Limitation: – Bulk extract source preview shows only mock data.

From Date

Data that has a createdAt or updatedAt filter after the specified date.

Fetch Days

The To date is calculated using From day + Fetch days.

Escape Character

Marketo CSV file escape character.

Quote Character

Marketo CSV file quote character.



Expand
titleCampaigns

Import Marketo Campaign data. There are no other fields to fill out

...

Expand
titleLead by Static List


Parameter

Description

List IDs

Retrieves person records that are members of the given static list. Results include the column listId that contains the lead list ID.

Optional. Comma separated List IDs, or leave the field blank to import all lists.



Expand
titleMembers Leads by Program

Import Marketo members leads by program data.

Parameter

Description

Program IDs

Optional. Comma separated program IDs, or leave the field blank to import all programs.



Expand
titlePrograms

Import Marketo program data. Retrieves the list of accessible programs from the target instance.

Parameter

Description

Incremental

Bulk extract sources support the incremental import feature through the createdAt filter. When running in incremental mode, the connector calculates the next ‘from_date’ based on the previous filter.

Example:

  • 1st run from_date: 2018-01-01 to_date: 2018-01-11(generated by plugin) fetch_days: 10

  • 2nd run from_date: 2018-01-11 to_date: 2018-01-21 fetch_days: 10

Limitation: – Bulk extract source preview shows only mock data.

Query By

Query Programs by Tag Type or Date Range. Leave blank to import all programs.

With Query By: Tag Type, Incremental import is not supported, and therefore is omitted.

With Query By Date Range and Incremental import is selected, the next run Earliest Updated At and Latest Updated At will be calculated based on previous range, example:

  • 1st run: Earliest Updated At = 02/01/2018 10:00, Latest Updated At = 02/10/2018 10:00

  • 2nd run: Earliest Updated At = 02/10/2018 10:01, Latest Updated At = 02/20/2018 10:01



Expand
titleCustom Object

Retrieves a list of custom objects records based on filter and a set of values. See Custom Objects API document to learn more about configuration keys.

Parameter

Description

API Name

The API name of the custom object

Fields

Comma separated API name of fields of the custom object (Optional).

Filter Type

The API name of field of the custom object use to filter result. Only support integer field.

Input as Text

Input filter values as text (comma separated), or by range (From Value to To Value).

Filter Values

Comma-separated list of field values to match.

From Value

Filter start value. Only supports integer.

To Value

Filter end value (Optional). Only supports integer. If not set, only records that have value greater than "From Value" will be returned. Job will stop if no record found in 300 consecutive value.



Expand
titleProgram Members

Import Marketo members by program data.

Parameter

Description

Program IDs

Optional. Comma separated program IDs, or leave the field blank to import members of all programs.


Data Settings

  1. Select Next.
    The Data Settings page opens.

  2. Optionally, edit the data settings or skip this page.

...

Expand
titleParameters and descriptions


Parameters

Description

LEAD INCLUDED FIELDS

Add a list of Lead fields to be included in data import, only affects Lead family target.

 Interval limit in milliseconds

Time wait for the next call if the request reaches Marketo concurrent limit.

 Maximum retries

Maximum times to retry Marketo request when error occurs.

 Batch size

Marketo REST API Batch size (default 300).

 Max return

Max records return in a single request. Program endpoint use offset for paging (default 200).

Bulk job timeout in seconds

Total time wait for bulk extract before fail the job.

Bulk job polling interval in seconds

Interval to poll job status.

Read timeout in milliseconds

Time to wait for Marketo response.



Data Preview 

You can see a preview of your data before running the import by selecting Generate Preview.

...