Advanced Analytica Advanced Analytica: IBOM
← All connectors
Marketo logo

Source connector

Marketo

Set up Marketo as a source and move its data into your chosen destination.

Version 2.1.3 community generally available

Marketo

Use this page to set up the Marketo source connector and find reference information.

Prerequisites

  • (Optional) Allowlist Airbyte’s IP address if required
  • An API-only Marketo User Role
  • An Airbyte Marketo API-only user
  • A Marketo API Custom Service
  • Marketo Client ID and Client Secret
  • Marketo Base URL

Setup guide

Step 1: Set up Marketo

Step 1.1: (Optional) Allowlist Airbyte’s IP address

Skip this step if you haven’t enabled IP Restriction in Marketo.

If you’ve enabled IP Restriction in Marketo, allowlist the IP address of the machine running your Airbyte instance. Run curl ifconfig.io from the node running Airbyte to get your IP address. Copy the returned IP address and keep it available.

After getting the IP address, follow the Marketo documentation for allowlisting IP addresses for API-based access to allowlist it.

Step 1.2: Create an API-only Marketo User Role

Follow the Marketo documentation for creating an API-only Marketo User Role.

Step 1.3: Create an Airbyte Marketo API-only user

Follow the Marketo documentation to create an API-only user.

Step 1.4: Create a Marketo API custom service

Follow the Marketo documentation for creating a custom service for use with a REST API.

Follow the “Credentials for API Access"" section in the Marketo docs to generate a Client ID and Client Secret.. Copy these credentials and keep them available for later use in the Airbyte UI.

Step 1.5: Get your Endpoint URL

Follow the Marketo documentation for obtaining your base URL. In Marketo, go to Admin > Integration > Web Services. Under REST API, copy the Endpoint URL without the trailing /rest. For example, if the endpoint is https://000-AAA-000.mktorest.com/rest, use https://000-AAA-000.mktorest.com.

You can configure the Marketo connector in Airbyte after getting your Endpoint URL, Client ID, and Client Secret.

Step 2: Set up the Marketo connector in Airbyte

For Airbyte Cloud:

  1. Sign in to your Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
  3. On the Set up the source page, name the Marketo connector. Select Marketo from the Source type dropdown.
  4. Enter the start date, domain URL, client ID, and secret.
  5. Submit the form.

For Airbyte Open Source:

  1. Go to the Airbyte Open Source dashboard.
  2. Name your source.
  3. Enter the start date.
  4. Enter the domain URL.
  5. Enter the client ID and secret.
  6. Click Set up source.

Advanced configuration

The Bulk Export Window in Days setting controls each date range the connector requests during an incremental sync. The default is 30 days, and you can enter 1 to 31 days. Values outside this range cause the sync to fail with a configuration error.

This setting affects these streams:

  • Leads and Activities_X streams request one Marketo Bulk Extract job for each window.
  • Programs and Emails streams send one request for each window, filtered on earliestUpdatedAt and latestUpdatedAt.
  • Campaigns and Lists streams filter records after fetching them, so this setting doesn’t affect them.

Reduce the window if a Leads sync struggles with one Bulk Extract job’s data volume. This issue is most common with large lead databases. It can also follow a backfill or enrichment process that updates many leads at once. Smaller windows create more jobs, with less data to download and process in each job.

Supported sync modes

The Marketo source connector supports these sync modes:

  • Full Refresh | Overwrite
  • Full Refresh | Append
  • Incremental | Append
  • Incremental | Deduped

Supported streams

This connector syncs these streams from Marketo:

StreamSync modeDescription
Activities_XIncrementalLead activities of type X. For example, activities_send_email contains lead activities related to the send_email activity type. One stream is created per activity type. Uses activityDate as the cursor field. See the Marketo Activities API docs for details.
Activity typesFull RefreshMetadata about activity types.
CampaignsIncrementalMarketo campaigns. Uses createdAt as the cursor field.
EmailsIncrementalMarketo email assets, including subject, sender info, status, and template. Uses updatedAt as the cursor field.
LeadsIncrementalMarketo leads. Uses updatedAt as the cursor field. The schema is dynamically generated from the leads/describe.json API, so custom fields are automatically discovered and included.
ListsIncrementalMarketo static lists. Uses createdAt as the cursor field.
ProgramsIncrementalMarketo programs, including user-defined tags, period costs, and Salesforce cross-reference fields (sfdcId and sfdcName) for programs synced with Salesforce. Uses updatedAt as the cursor field.
Program TokensFull RefreshToken definitions (My Tokens) for each program. This is a child stream of Programs, fetching tokens for every program.
SegmentationsFull RefreshMarketo segmentations.

Limitations and troubleshooting

Leads fields and schema behaviour

The Leads stream schema combines every static schema field with custom fields found through the Marketo leads/describe.json API. The static schema contains standard Marketo fields, but some aren’t available in every Marketo instance. For consistency, unavailable fields remain in the schema and always contain null in synced records. Bulk export API calls only request fields confirmed by the leads/describe.json endpoint. Selected fields unavailable through your Marketo instance’s describe endpoint are silently excluded from the export request. This prevents Marketo API error 1003 (“Invalid fields”).

Stalled requests and timeouts

From version 2.1.1, every Marketo request has a 30-second connection timeout and a 300-second read timeout. The read timeout measures the gap between response chunks, not the total download time. Bulk export files can therefore take as long as needed while Marketo continues sending data. If a connection stalls, the request fails and Airbyte retries it, preventing the sync from hanging indefinitely. Repeated timeout errors in your sync logs usually indicate network problems between Airbyte and Marketo, not a configuration issue.

Failed or cancelled bulk export jobs

The Leads and Activities streams create one Marketo Bulk Extract job for each date window. They then poll the job until Marketo reports it as Completed. If Marketo reports Failed or Cancelled instead, the sync stops with an error naming the affected stream. The error log also includes the export job ID and the window’s date range. From version 2.1.3, the connector reports this as a transient error instead of a configuration error. The failure is usually temporary and doesn’t indicate a problem with your connector settings. Repeated failures for the same stream and date window indicate that the job is failing in Marketo. Check the export job in Marketo. Consider reducing Bulk Export Window in Days so each job exports less data.

Activity attributes and value conversion

Each activities_X stream builds its schema from Marketo’s attribute metadata for that activity type. Attributes become top-level columns with snake_case names. Every activity also includes marketoGUID, leadId, activityDate, activityTypeId, campaignId, primaryAttributeValueId, and primaryAttributeValue. Attribute values arrive inside a JSON blob in the bulk export file. Marketo may describe an attribute as a boolean, but deliver it as 0 or 1 instead of "true" or "false". From version 2.1.2, the connector converts numbers to booleans. It writes null for values it can’t convert instead of failing the sync. See Data type map for the complete conversion rules.

If you add an attribute to a Marketo activity type, refresh the source schema in Airbyte. The new column will then appear in the stream.

Program Tokens performance

The Program Tokens stream makes one API call for each program in your Marketo instance. With many programs, this stream may take longer to sync and consume more of your daily API quota.

Performance considerations

Marketo applies these API limits:

  • Daily API call quota: 50,000 calls per day, resetting at 12:00 AM CST.
  • Rate limit: 100 calls per 20 seconds.
  • Concurrency limit: 10 concurrent API calls.
  • Bulk extract quota: 500 MB per day, shared between leads and activities. Resets at midnight CST.

The Leads and Activities streams use the Marketo Bulk Extract API. This is subject to the bulk extract quota, not the daily API call quota. If you exceed the bulk extract quota, the connector stops replicating data until the quota resets.

For large incremental Leads catch-up syncs, reduce Bulk Export Window in Days. This splits the updatedAt cursor range into smaller Bulk Extract jobs. It helps you avoid very large export files after external processes update many of your leads.

All other streams use the standard REST API and count against the daily API call quota.

If these limits are too restrictive, contact your Marketo account manager to request a quota increase.

Data type map

Integration TypeAirbyte TypeNotes
string, text, textarea, url, phone, email, reference, lead_functionstringMarketo types the connector doesn’t recognize are also mapped to string.
integer, percent, scoreintegerDecimals arriving as strings are truncated, so "4.7" becomes 4. Anything else the connector can’t read as a whole number, including a JSON float in an activity attribute, becomes null.
float, currencynumberValues the connector can’t parse as a number become null.
booleanbooleanStrings become true only when they read true, in any capitalization; every other string becomes false. Numbers follow 0 is false and anything else is true. Values of any other type become null.
datestringFormat: date
datetimestringFormat: date-time
arrayarrayPrimitive arrays are converted into arrays of the types described in this table.

Empty values, empty strings, and the literal string null always sync as null.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
2.1.32026-09-0279644Raise structured AirbyteTracedException with context when Marketo bulk export jobs fail or are cancelled.
2.1.22026-08-2885097Handle numeric and other non-string values for boolean-typed fields in activity streams instead of failing the sync.
2.1.12026-07-2780926Configure HTTP streaming and read timeouts for Marketo requests to detect stalled connections.
2.1.02026-07-2778362Expose Bulk Export Window in Days so large incremental Marketo syncs can use smaller Bulk Extract jobs.
2.0.12026-06-0478428Stream Marketo bulk export downloads to reduce memory usage for large CSV exports.
2.0.02026-05-0776892Fix leads stream to filter Bulk Lead Extract on updatedAt so incremental syncs capture updates to pre-existing leads. See the migration guide for details.
1.6.22026-03-2675461Add sfdcId and sfdcName fields to programs stream schema
1.6.12026-03-2574088Fix CSV column misalignment when syncing leads containing CJK characters
1.6.02026-03-1974826Add Emails and Program Tokens streams
1.5.02026-03-1874136Add dynamic schema discovery for custom fields on Leads stream; add tags and costs to Programs schema; add workspace to Segmentations schema
1.4.402026-02-2573309Fix KeyError and TypeError when Marketo API responses lack ‘result’ key in export status and create endpoints
1.4.392026-01-2671849Add error handling for type conversion in format_value
1.4.382025-10-2168475Update dependencies
1.4.372025-10-1467858Update dependencies
1.4.362025-10-0767394Update dependencies
1.4.352025-09-3066352Update dependencies
1.4.342025-09-0965855Update dependencies
1.4.332025-08-2365168Update dependencies
1.4.322025-08-1664988Update dependencies
1.4.312025-08-0964729Update dependencies
1.4.302025-08-0264262Update dependencies
1.4.292025-07-2663912Update dependencies
1.4.282025-07-1263152Update dependencies
1.4.272025-07-0561142Update dependencies
1.4.262025-05-2860823Fix Attribute Errors on Leads stream
1.4.252025-05-2460693Update dependencies
1.4.242025-05-1059770Update dependencies
1.4.232025-05-0358788Update dependencies
1.4.222025-04-1257702Update dependencies
1.4.212025-04-0557071Update dependencies
1.4.202025-03-2956674Update dependencies
1.4.192025-03-2256016Update dependencies
1.4.182025-03-0855426Update dependencies
1.4.172025-03-0154761Update dependencies
1.4.162025-02-2254321Update dependencies
1.4.152025-02-1553790Update dependencies
1.4.142025-02-0152711Update dependencies
1.4.132025-01-2552278Update dependencies
1.4.122025-01-1151165Update dependencies
1.4.112025-01-0450890Update dependencies
1.4.102024-12-2850655Update dependencies
1.4.92024-12-2143736Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
1.4.82024-12-2049972Pin CDK due to breaking changes in newer versions.
1.4.72024-07-0640629Update dependencies
1.4.62024-06-2640530Update dependencies
1.4.52024-06-2540318Update dependencies
1.4.42024-06-2340001Update dependencies
1.4.32024-06-1839549Refactor: use client_side_incremental feature
1.4.22024-06-0639297[autopull] Upgrade base image to v1.2.2
1.4.12024-05-2338631Update deprecated authenticator package
1.4.02024-04-1536854Migrate to low-code
1.3.22024-04-1936650Updating to 0.80.0 CDK
1.3.12024-04-1236650schema descriptions
1.3.02024-03-1936267Pin airbyte-cdk version to ^0
1.2.62024-02-0935078Manage dependencies with Poetry.
1.2.52024-01-1534246prepare for airbyte-lib
1.2.42024-01-0833999Fix for Export daily quota exceeded
1.2.32023-08-0228999Fix for _csv.Error: line contains NUL
1.2.22023-10-1931599Base image migration: remove Dockerfile and use the python-connector-base image
1.2.12023-09-1830533Fix json_schema for stream Leads
1.2.02023-06-2627726License Update: Elv2
1.1.02023-04-1823956Add Segmentations Stream
1.0.42023-04-2525481Minor fix for bug caused by <= producing additional API call when there is a single date slice
1.0.32023-02-1322938Specified date formatting in specification
1.0.22023-02-0122203Handle Null cursor values
1.0.12023-01-3122015Set AvailabilityStrategy for streams explicitly to None
1.0.02023-01-2521790Fix activities_* stream schemas
0.1.122023-01-1920973Fix encoding error (note: this change is not in version 1.0.0, but is in later versions
0.1.112022-09-3017445Do not use temporary files for memory optimization
0.1.102022-09-3017445Optimize memory consumption
0.1.92022-09-2817304Migrate to per-stream sate.
0.1.72022-08-2315817Improved unit test coverage
0.1.62022-08-2115824Fix semi incremental streams: do not ignore start date, make one api call instead of multiple
0.1.52022-08-1615683Retry failed creation of a job instead of skipping it
0.1.42022-06-2013930Process failing creation of export jobs
0.1.32021-12-258578Updated titles and descriptions
0.1.22021-12-038483Improve field conversion to conform schema
0.1.12021-11-290000Fix timestamp value format issue
0.1.02021-09-065863Release Marketo CDK Connector
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.