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] (https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| 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
The activities table contains info about lead activities.
|
Incremental |
|
|
Primary Key |
id |
|
Replication Key |
activityDate |
| Useful links |
|
activityDate
DATE-TIME |
||
|
activityTypeId INTEGER |
||
|
attributes ARRAY
|
||
|
id
INTEGER |
||
|
leadId INTEGER |
||
|
primaryAttributeValue STRING |
||
|
primaryAttributeValueId INTEGER |
activity_types
The activity_types table contains metadata about the activity types - form fill, web page visit, lead creation, and so on - available in Marketo.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
attributes ARRAY
|
||
|
description STRING |
||
|
id
INTEGER |
||
|
name STRING |
||
|
primaryAttribute OBJECT
|
leads
The leads table contains info about your Marketo leads.
|
Incremental |
|
|
Primary Key |
id |
| Useful links |
|
acquiredBy BOOLEAN |
|
id
INTEGER |
|
isExhausted BOOLEAN |
|
membershipDate DATE |
|
nurtureCadence STRING |
|
progressionStatus STRING |
|
reachedSuccess BOOLEAN |
|
reachedSuccessDate STRING |
|
stream STRING |
lists
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.
|
Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updatedAt |
| Useful links |
|
createdAt DATE-TIME |
|
description STRING |
|
id
INTEGER |
|
name STRING |
|
programName STRING |
|
updatedAt
DATE-TIME |
|
workspaceName STRING |
| 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.