Marketo develops and sells marketing automation software for account-based marketing and other marketing services and products including SEO and content creation. The Datacoral Marketo connector collects data from a Marketo API and writes it to an AWS S3 bucket and to the destination data warehouse
Features & Capabilities
- Backfill: Full historical sync of your entire data
- Data Extraction Modes: snapshot, incremental with pagination
- Data Load Modes: replace, append and merge
- Tables and Columns selection: Ability to select tables in all loadunits and individual columns in
- Data-layout: changing the data type of your columns
- Customizations: Update the configurations easily using the UI
- Scheduling: Highly flexible scheduling system
Click here to learn about the limitations for API calls in Marketo connector
Supported load units
The Marketo slice automatically collects the following loadunits from the Marketo API and makes them available in your warehouse for analysis.
|activities||Supported through bulk export API||Data will be fetched with createdAt filter from API|
|activity types||The REST API endpoint supports snapshot pull through pagination||Not Supported|
|activity types attributes||Supported||Not supported|
|campaigns||supports snapshot pull through pagination using pagingToken||Not supported|
|deleted leads||Not Supported||The REST API endpoint supports incremental pull through pagination using pagingToken|
|leads||Through Bulk API||We fetch leads through an |
|lists||The REST API endpoint supports snapshot pull through pagination using pagingToken||Not Supported|
|list membership||The REST API endpoint supports snapshot pull through pagination using pagingToken||Not Supported|
|program membership||Supported for backfill||Data fetched via the REST API endpoint|
|programs||The REST API endpoint supports snapshot pull through pagination||Supported, we will filter programs list through |
program_membership loadunit, we obtain the program IDs from the
activities and then sync all the leads that belong to a specific program into the loadunit.
Output of this connector is stored in S3 and destination warehouse.
Data stored in AWS S3 is partitioned by date and time
Warehouse: Schema - schema name will be same as a connector-name. Tables produced by the connector are:
- Create a Marketo Connector through UI or CLI
- Schedule a Demo
Got a question?
Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.