Can you run a report on activity logs?

[trevlarrr]

We have multiple campaigns setup in Marketo that sync with campaigns in Salesforce, that the Sales team use to update member statuses so we can track where they are in the funnel.

Individual activity logs in Marketo record these updates to statuses with the activity type 'Change Status in SFDC Campaign' but I can't find a way to report on all occurrences of this activity type, only way seems to be to go in to each individual and export their activity log.

Salesforce only seems to report on the last activity date and doesn't seem to log the date of each status change so I was hoping there was a way to run a batch report on activity logs. Any ideas on how to achieve this?

Thanks

[Darshil_Shah1 · Accepted solution]

Well, not in Marketo UI, but this is a perfect use case for Marketo's bulk activity export API to export the required activity data of people out of Marketo. Check out the developer documentation on bulk activity export here.