Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Marketo Data

Marketo Info
This integration was created by Stitch for Singer, an open-source, composable ETL platform. Check out & contribute to the repo on GitHub.

Marketo is currently in Open Beta. The info in this article is subject to change.

Now that Marketo is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

  1. How Stitch replicates Marketo data
  2. The tables that will be created in your data warehouse

Replicating Marketo Data

Historical Sync

By default, a historical sync of Marketo data goes back one year from the Stitch connection date.

Frequency

Stitch will replicate Marketo data based on the frequency you define. The default setting is every 30 minutes, but you can change it better suit your needs.

Replication Method

The majority of Marketo data is replicated using Incremental Replication. This means that when these tables are queued for replication, only new and updated rows will be replicated.

There is an exception to this, however. The activity_types (and its subtables, if there are any) use Full Table Replication. This means that every time HubSpot data is queued for replication, all rows in a table - including existing, new, and updated - will be replicated. only new and updated rows will be replicated to your data warehouse.

Marketo Tables in Your Data Warehouse

Below is a list of the Marketo tables that will be created in your data warehouse. Because Marketo uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables if your data warehouse doesn't natively support nested structures. Refer to the Handling of Nested Data Structures doc for more info.

Nested arrays are marked with a *.

Click the table names to check out Marketo's API docs.

activities
Replication Method: Incremental
Primary Key: id

The activities table contains info about lead activities.

Attributes include:

  • Activity ID (id)
  • leadid
  • attributes*
  • activitydate
  • activitytypeid
  • primaryattributevalueid
  • primaryattributevalue

activity_types
Replication Method: Full Table
Primary Key: id

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

Attributes include:

  • Activity Type ID (id)
  • attributes*
  • name
  • description
  • primaryattribute__name
  • primaryattribute__datatype

leads
Replication Method: Incremental
Primary Key: id

The leads table contains contains info about your Marketo leads.

Attributes include:

  • Lead ID (id)
  • acquiredby
  • isexhausted
  • membershipdate
  • nurturecadence
  • progressionstatus
  • reachedsuccess
  • reachedsuccessdate
  • stream

lists
Replication Method: Incremental
Primary Key: id

The lists table contains info about the static lists in your Marketo account. Note that due to some of the limitations in Marketo’s API, only static lists are available.

Attributes include:

  • List ID (id)
  • name
  • description
  • programname
  • workspacename
  • createdat
  • updatedat

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!