Marketo feature snapshot

A high-level look at Stitch's Marketo (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Sunset on September 23, 2019

 Supported by

Stitch
Stitch plan

Standard

 API availability

Not available
Singer GitHub repository

singer-io/tap-marketo
REPLICATION SETTINGS
Anchor Scheduling

Supported

 Advanced Scheduling

Unsupported
Table-level reset

Unsupported

 Configurable Replication Methods

Unsupported
DATA SELECTION
Table selection

Supported

 Column selection

Unsupported
Select all

Supported
TRANSPARENCY
Extraction Logs

Supported

 Loading Reports

Supported

Marketo replication

Stitch and Marketo Daily API Call Limits

By default, all Marketo accounts have a maximum number of 10,000 daily account calls. Stitch’s Marketo integration is designed to use up to 8,000 of these calls per day to allow other applications API access to your Marketo account.

When the 10,000 account call limit has been reached, Stitch will be unable to replicate any Marketo data until more API quota is available. If you find that the 10,000 call limit isn’t enough, contact Marketo support to inquire about raising the limit.

Marketo table reference

activities

View table schema on GitHub
API endpoint :

getLeadActivities

The activities table contains info about lead activities.

activities table schema

id
INTEGER

The ID of the activity.

activityDate
DATE-TIME

The date of the activity.

leadId
INTEGER

The ID of the lead associated with the activity.

activityTypeId
INTEGER

The ID of the activity type.

primaryAttributeValue
STRING

Value of the activity’s primary attribute.

primaryAttributeValueId
INTEGER

The ID of the activity’s primary attribute.

attributes
ARRAY

Secondary attributes of the activity.

Click to expand attributes

name
STRING

The name of the secondary attribute.

value
STRING

The value of the secondary attribute.
activities (table), attributes (attribute)

activity_types

View table schema on GitHub
Replication Method :

Full Table

 Primary Key :

id
API endpoint :

getAllActivityTypes

The activity_types table contains metadata about the activity types - form fill, web page visit, lead creation, and so on - available in Marketo.

Filter Deleted Leads

When joined with the activities table, you can use specific activity types to filter out deleted leads, assess list membership, and more. Here are a few noteworthy activity types:

  • Add to List and Remove from List - These events can be used to discover lead list membership.
  • Delete Lead - A delete lead event indicates leads that have been deleted. We recommend using this activity to filter out deleted leads.
  • Add a Lead to a Nurture Program, Change Nurture Track, and Change Nurture Cadence - These events can help you determine what nurture programs a lead is in and lead activity against that program.

activity_types table schema

id
INTEGER

The activity type ID.

name
STRING

The name of the activity type. Ex: Change Nurture Track

description
STRING

The description of the activity type.

primaryAttribute
OBJECT

Primary attributes of the activity type.

Click to expand primaryAttribute

name
STRING

The name of the primary attribute.

dataType
STRING

The data type of the primary attribute.
activity_types (table), primaryAttribute (attribute)

attributes
ARRAY

Secondary attributes of the activity type.

Click to expand attributes

name
STRING

The name of the secondary attribute.

dataType
STRING

The data type of the secondary attribute.
activity_types (table), attributes (attribute)

leads

API endpoint :

getLeads

The leads table contains info about your Marketo leads.

leads table schema

id
INTEGER

The ID of the lead.

acquiredBy
BOOLEAN

Indicates if the lead was acquired by the parent program.

isExhausted
BOOLEAN

Indicates if the lead is currently exhausted in the stream, if applicable.

membershipDate
DATE

The date the lead first became a member of the program.

nurtureCadence
STRING

Cadence of the parent stream, if applicable.

progressionStatus
STRING

The program status of the lead in the parent program.

reachedSuccess
BOOLEAN

Indicates if the the lead is in a success-status in the parent program.

reachedSuccessDate
STRING

The date the lead reached success in the parent program.

stream
STRING

The stream that the lead is a member of, if the parent program is an engagement program.

lists

View table schema on GitHub
API endpoint :

getLists

The leads table contains info about the static lists in your Marketo account.

Note: Due to some of the limitations in Marketo’s API, only static lists will be replicated.

lists table schema

id
INTEGER

The ID of the list.

updatedAt
DATE-TIME

The datetime when the list was most recently updated.

name
STRING

The name of the list.

description
STRING

The description of the list.

programName
STRING

The name of the program associated with the list.

workspaceName
STRING

The name of the parent workspace, if applicable.

createdAt
DATE-TIME

The datetime the list was created.
Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.