Marketo
Dashboard and Reporting Software

Due to the issue with long response time from Marketo API when filtering is applied, Databox applies pagination (breaking up a large set of data into smaller, more manageable chunks or pages when retrieving data from a server) to obtaining data from Marketo.
Due to long response time on the API, list of campaigns that get displayed when connecting Marketo to Databox is limited to two pages of the API response.
Campaign data is sorted by the updated time, so recent updates will appear on the list. The list of campaigns that are available to connect includes campaign IDs and only active campaigns are displayed.

Occasionally a timeout might still occur during the connection process, meaning the connection flow stops and a red error message might pop up in the bottom left corner. This occurs when all data is not received in the expected timeframe from the Marketo API. If this occurs, the only solution is to retry connecting the Data Source.

In order to access data from the Marketo API, users need to create a user with ‘RestApi User’ role In Marketo. If Marketo is connected in Databox with a user that only has an Admin role, data will not sync between Marketo and Databox.

If the user does not have the appropriate permissions when they initially connect Marketo, they will need to reconnect the Marketo Data Source once their permissions have been updated.

More information on how to create a user and assign a role is available here.

For one complete sync, Databox makes 7 API calls to Marketo. This amounts to 168 API calls per day, assuming there is not an excessive amount of data in the Marketo account.

Once the Marketo account exceeds 300 emails, Databox begins to paginate data to retrieve all of it. For example, if an account contains 3,000 emails, we make 10 API calls to sync all relevant data. Please note that we have a maximum limit of 1,000 pages (API calls) per sync.

Due to an API limitation on Marketo’s side, each Marketo campaign needs to be connected as a separate Data Source in Databox. While the Marketo API supports retrieving all data regardless of the campaign, the number of requests required for combining data from multiple campaigns in one Data Source connection would significantly increase in comparison to syncing data for one campaign. The increase could prevent proper syncing of the data.

All Marketo metrics available in Databox are non-aggregatable Metrics. This means that due to the nature of these metrics, summing daily/weekly/monthly values will not give correct results for longer time periods.
Additionally, all Marketo metrics available in Databox are no-reset metrics. No-reset metrics are not reset to value 0 with every new day.