USER MANUALS

Marketo

Marketo is SaaS based marketing automation software built to help organizations automate and measure marketing engagement, tasks and workflows.

It is possible to configure Denodo to retrieve data from Marketo by creating JSON data sources and base views using the Marketo REST API.

As Marketo manages a very large amount of data and views, it may be hard work to add all the required data sources and base views in Denodo. To make this process easier and faster, you have available a Marketo wizard. You just have to configure a few parameters and click on Import to create into your Denodo server the needed data sources and views to get access to the following functionalities of Marketo:

  • Leads

  • Activities

  • campaigns

  • Custom objects

  • Named Accounts

  • Lists

  • Static Lists

  • Smart Lists

  • Programs

  • Tag Type

  • Channel

  • Segments

Importing Artifacts

To create the Marketo views, click the menu File > New > Data source and select Marketo.

Marketo wizard

Marketo wizard

Enter the following parameters:

  • Database. Name of the database in which the Marketo views will be created.

  • Client ID. The client id provided by your Marketo instance.

  • Client Secret. The client secret provided by your Marketo instance.

  • Scope . The Marketo user with API access permissions.

  • Marketo instance. Your Marketo instance.

Now, click Execute import to create the data sources and the views to query Marketo.

Important

The set of Stored Procedures included are used by final views and are in charge of the task of asking for new access tokens when the older ones expire. So, ONLY the FINAL VIEWS are meant to be directly used.

Marketo views

Marketo views

  • activity. Returns a list of activities of type given by the activity_type_id parameter from after a date time given by the since_date_time parameter.

  • campaign. Returns a list of smart campaign records.

  • custom_object. Returns a list of custom objects records based on filter and set of values.

  • named_account. Retrieves named account records from your Marketo instance based on the submitted filter.

  • named_account_list. Retrieves a list of named account list records based on the filter type and values given.

  • lead Returns a list of up to 300 leads based on a list of values in a particular field.

  • list Returns a set of static list records.

  • smartlists. Retrieves a list of user created Smart List records.

  • staticlist. Retrieves a list of Static List records.

  • program Retrieves the list of accessible programs from your Marketo instance.

  • tag_type. Retrieves a list of available tag types.

  • channel Retrieves all channels.

  • segment. Retrieves a list of accessible segmentation for your Marketo instance.

Query Example

Now, you can execute queries over the Marketo views that have been created:

Marketo lead query

Marketo lead query

Marketo lead query result

Marketo lead query result

Activity lead query

Marketo activity query

Marketo activity query result

Marketo activity query result

Add feedback