This version of Marketo reached end of life on September 23, 2019 and is no longer functioning.
Upgrade to the latest version (v2) to continue replicating data.
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 plan |
Standard |
API availability |
Not available |
Singer GitHub repository | |||
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
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
activities
API endpoint : |
The activities
table contains info about lead activities.
id
The ID of the activity. |
||
activityDate
The date of the activity. |
||
leadId
The ID of the lead associated with the activity. |
||
activityTypeId
The ID of the activity type. |
||
primaryAttributeValue
Value of the activity’s primary attribute. |
||
primaryAttributeValueId
The ID of the activity’s primary attribute. |
||
attributes
Secondary attributes of the activity.
|
activity_types
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
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.
id
The activity type ID. |
||
name
The name of the activity type. Ex: |
||
description
The description of the activity type. |
||
primaryAttribute
Primary attributes of the activity type.
|
||
attributes
Secondary attributes of the activity type.
|
leads
API endpoint : |
The leads
table contains info about your Marketo leads.
id
The ID of the lead. |
acquiredBy
Indicates if the lead was acquired by the parent program. |
isExhausted
Indicates if the lead is currently exhausted in the stream, if applicable. |
membershipDate
The date the lead first became a member of the program. |
nurtureCadence
Cadence of the parent stream, if applicable. |
progressionStatus
The program status of the lead in the parent program. |
reachedSuccess
Indicates if the the lead is in a success-status in the parent program. |
reachedSuccessDate
The date the lead reached success in the parent program. |
stream
The stream that the lead is a member of, if the parent program is an engagement program. |
API endpoint : |
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.
id
The ID of the list. |
updatedAt
The datetime when the list was most recently updated. |
name
The name of the list. |
description
The description of the list. |
programName
The name of the program associated with the list. |
workspaceName
The name of the parent workspace, if applicable. |
createdAt
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.