Report of 12 specific campaigns and output at individual level of activity?

Question

The analytics dept of my organization is looking for a data dump on a monthly campaign for 2022 (12 different smart campaigns), all the people that received it each month, whether they opened, clicked that month, and date of that activity. They will then take this data and compare it to conversions (housed in another system at the moment).
 
This is a monthly lead campaign so an individual could get the campaign multiple times.
 
I've been searching Marketo reports and this community for a bit and not seeing how this can be accomplished.

Darshil_Shah1 · Accepted Answer

As Sandy says, you'd need to set up an API-only user and create a custom service for generating the access token which is required for authenticating while making API calls (including bulk lead activity extract API). Check out this developer doc that discusses the API role, user, and custom service setup process.

Also, API lets you access Marketo programmatically (and not via GUI) for performing actions, querying data, etc., i.e., unlike email performance report, you wouldn't be able to see the data in the GUI and would rather have to use the response of API to generate insights/visualize data (default response format is CSV).

Darshil_Shah1 · Answer

You could use the bulk lead activity export or email analysis report available in the RCE module (if you have it in your subscription) for getting the email activities from Marketo! As per Marketo's data retention policy, email send and delivered activities are purged from the lead activity log after 90 days, and the email performance report excludes the same email-person-campaign trio activities from the report.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded