Email Performance Report - how to show per record data

Forum|Forum|5 years ago
May 28, 2020
2 replies
7359 views

Hi,

I would like to know if there's a way to create an email performance report that would provide the per record details? Our stakeholders are not only concern about the percentages of delivered, opened etc., but they would also need to know the exact records who were delivered, opened, click.

Our team usually do this by building smartlists (was sent, was delivered etc.) but it is too much time consuming as we also need to consolidate all excel files then manipulate via pivot table. Is there any other much efficient way to do this or is there any other report that we can use aside the email performance? Please help and thank you in advance!

Marketo

Best answer by Darshil_Shah1

RCE is a different module altogether, and I would not recommend adding or purchasing the module just to get Email data which can be easily exported using REST APIs. If API limit is the issue you can use Bulk Extract to export last 30 days data in that way you don't have to worry about the limit.

@robert_villanue If your instance already has the RCE package then would recommend using it, else as @ajaymamgain1 said you can utilise activity API! 😀

Darshil_Shah1

Community Advisor and Adobe Champion

You can do this by using Revenue Cost Explorer, where-in you can combine email stats with lead information using "email analysis" report type. Refer Email Analysis in RCE here : https://docs.marketo.com/display/public/DOCS/Email+Analysis

A

ajaymamgain1

Level 3

If you are looking for individual metrics, in that case, you would need to leverage REST APIs to extract the activities and lead data from Marketo. If you are looking for email data then use the below ID in Activities REST APIs and in case of other activities you may need to extract the activity list using rest API as well. Are you planning to create the analysis in Excel or using any BI tool. I have done the analysis in both so I might be able to assist you with that.

id name description

6	Send Email	Send Marketo Email to a person
7	Email Delivered	Marketo Email is delivered to a lead/contact
8	Email Bounced	Marketo Email is bounced for a lead
9	Unsubscribe Email	Person unsubscribed from Marketo Emails
10	Open Email	User opens Marketo Email
11	Click Email	User clicks on a link in a Marketo Email
27	Email Bounced Soft	Campaign Email is bounced soft for a lead

Darshil_Shah1

Community Advisor and Adobe Champion

I would not recommend this until its extremely required, as the response for the getLeadActivities is limited to only 300 lead activities per call and extracting all the data for all the lead activities would actually require to page through all the activities by making multiple API calls and this would inturn consume the API limits of the instance.
Also if you wish to use Excel or Power BI as a data analysis tool then anyhow you can export the RCE reports and ingest them to data analysis tool.

A

ajaymamgain1

Level 3

We can extract more data using Next Paging token in a single call and create a loop to extract until there is "no more result". You can also pass an activity date so that you don't extract all data at once and rather do an incremental extract. Even if you think you have too much data you can do a Bulk Extract using REST APIs.

It doesn't consume that many API calls if you follow the above strategy and also you can monitor from the API calls from the backend, but the long term benefits are that you can get all the relevant data with a single click in Excel or any BI tool.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded