Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

Marketo provides Marketing Automation software that allows companies to streamline, automate, and measure marketing tasks and workflows, so they can increase operational efficiency.

Use case(s)

  • Read and replicate all of Marketo's entity data tables (e.g leads, activities, campaigns etc.). This would allow users to extract and load all of their Marketo data into specified multi-table or multi-file sink.
  • Retrieve data from one of Marketo's entity data tables, allowing users to transform and enrich the data 

User Storie(s)

  • As a data pipeline developer, I should be able to import all of Marketo's entity data tables so that I can analyze Marketo data
  • As a data pipeline developer, I should be able to specify Marketo entity (e.g. Leads) for which I can retrieve and transform the data
  • As a data pipeline developer, I should be able to specify Client ID and Client secret that would allow me to extract the entity datasets from Marketo
  • As a data pipeline developer, I should be able to see any errors from Marketo API calls so that I can resolve those issues
  • As a data pipeline developer, I do not need to specify fields associated with the datasets to filter on so that I can get the entire dataset

...

This plugin should be used when the user would like to retrieve all of the Marketo datasets , specifically all the entities noted below:

...

associated with Leads and Activities entities: 

User Facing NameTypeDescriptionDefault valueNotes
Client IDstringMarketo Client ID

Client SecretstringMarketo Client secret

REST API EndpointstringREST API endpoint URL

REST API IdentitystringREST API identity

Entitydrop-downMarketo entity nameNonePossible values: Leads, Activities
Daily API limitintegerMarketo enforced daily API limit

Additional daily capacity can be purchased and hence user needs to provide this information.

https://developers.marketo.com/rest-api/marketo-integration-best-practices/

Report formatstringReport formatCSVOptions are CSV, TSV or SSV
Start datestringStart date for reports data
ISO 8601 format
End datestringEnd date for reports data
ISO 8601 format

...

User Facing NameTypeDescriptionDefault valueNotes
Entity NamestringMarketo entity name to fetch

Possible entity values include:

  • Lead Database: Leads, Activities, Campaigns, Companies, Opportunities, Sales Persons, Static Lists, Usage, Custom Objects
  • Asset: Channels, Email, Email Templates, Files, Folders, Landing Pages Templates, Programs, Snippets, Tags, Tokens
Client IDstringMarketo Client ID

Client SecretstringMarketo Client secret

REST API EndpointstringREST API endpoint URL

REST API IdentitystringREST API identity

Daily API limitintegerMarketo enforced daily API limit

Additional daily capacity can be purchased and hence user needs to provide this information.

https://developers.marketo.com/rest-api/marketo-integration-best-practices/

Report formatstringReport formatCSVOptions are CSV, TSV or SSV
Start datestringStart date for the report
ISO 8601 format
End datestringEnd date for the report
ISO 8601 format

...