Marketo walkthrough

Prerequisites

A Marketo connection.

Pulling data from Marketo using Data Integration

1. Navigate to the Data Integration console.

2. Select River > Create New River.

3. Choose Data Source to Target as your river type.

4. In the General Info tab, name your river, describe it, and choose a group.

5. Find Marketo under CRM in the list of data sources and select it.

6. Under Source Connection, select the connection you created, or create a new one.

7. Select a report type. Each report has its related inputs.

List of reports

• Leads
• Leads Activities
• Campaigns
• Activities
• Lists
• Bulk Lead Extract by Date
• Bulk Leads Extract by List
• Bulk Activity Extract
• Bulk Program Member Extract
• Emails
• Programs

Date range

Select the start date and end date. Leave the end date empty to pull data until the river runs.

After each run of the river, the start date will be updated automatically with the end date, and the end date will be updated with the empty value. This enables the next run to pull data from the end of the previous run.

Bulk extract endpoints

The Marketo river provides interfaces for retrieving large sets of person and person-related data, called Bulk Extract. Currently, interfaces are offered for three object types:

Limits

• Maximum Concurrent Export Jobs: 2
• Maximum Queued Export Jobs (inclusive of currently exporting jobs): 10
• File Retention Period: 10 days
• Default Daily Export Allocation: 500MB (resets daily at 12:00 AM CST). Increases available for purchase.
• Maximum Time Span for Date Range Filter (createdAt or updatedAt): 31 days.

Queue

The maximum number of jobs in the queue is 10. If you try to enqueue a job when the queue is full,

The Enqueue Export Job endpoint returns an error “1029, Too many jobs in queue”. A maximum of 2 jobs can run concurrently (status is Processing).

File size

The bulk extract APIs are metered based on the disk size of the data retrieved by a bulk extract job. The explicit size in bytes for a job can be determined by reading the fileSize attribute from the completed status response of an export job.

The daily quota is a maximum of 500MB per day, which is shared between leads and activities. When the quota is exceeded, you cannot "Create or Enqueue" another job until the daily quota resets at midnight Central Time. Until then, an error “1029, Export daily quota exceeded” is returned. Aside from the daily quota, there is no maximum file size.