Exporting Email performance report

Elizabeth_Bonin
Level 4

Exporting Email performance report

Is there a way to export the email performance report to pull up in excel?

Tags (1)
5 REPLIES 5
Devraj_Grewal
Level 10 - Champion Alumni

Re: Exporting Email performance report

Liz,

Of course: Export a Report to Excel - Marketo Docs - Product Docs

Also this question is Products​ related so should go in that portal. Marketing Central​ is meant for general marketing discussions.

Chris_Saporito
Level 9

Re: Exporting Email performance report

Liz you can also subscribe to an email performance report and set it to automatically send the excel spreadsheet to your inbox as frequently as needed. Very helpful, especially when you are asked for it frequently!

Subscription.PNG

Anonymous
Not applicable

Re: Exporting Email performance report

Hi Liz,

There are two export the data to Excel:

Report > Excel

marketo2.jpg

Email Performance > Export

marketo22.JPG

The Excel spreadsheet looks like this:

marketo21.JPG

Remember to look at your setup

In particular which emails you are reporting against and the time period. I find it useful to set the time period to one year. If you leave the report in the default setting of 'last 7 days', when you check the report next month it says 0 emails opened/sent/delivered, because it is only looking at the performance over 7 days, which is probably not what you are looking for.

marketo23.JPG

Also it may be worth setting up 2 reports for Email Performance.

1) report where you monitor the emails for one campaign and/or month

2) report where you measure all the emails from similar campaigns or for an entire year

Hope this helps,

Sally Dickson

gus747
Level 1

Re: Exporting Email performance report

Hi, Is there anyway to automate this process using REST?

SanfordWhiteman
Level 10 - Community Moderator

Re: Exporting Email performance report

No, Marketo aggregate data/canned reports aren’t available using the REST API.

 

You can of course export the raw data and write your own reports against it.