Can we automate weekly Email performance report using API

[YashKA]

Hii all, 

We have a recurring email performance report/deck (made in Excel) I create weekly which has multiple parameters like Number of sends, clicks, etc for each brand we serve and we basically club it against each other to just have a view of different KPI percentages and email volume. 

I have to manually export weekly and monthly numbers every week and then once exported in excel replace the numbers in the main dashboard since I import a new sheet on every brand. Say 4 brands- 2 exports for each(weekly & month). 8 exports and with marketo being the gOldie it is, takes more than 30 mins to do it and feel it can be automated.

Let me know if anyone has a solve.

[SanfordWhiteman · Accepted solution]

You can export the raw data using the REST API and create whatever reports you want based on that data.

But you can’t automatically export pre-rolled Marketo reports. (OK, you can send subscription emails to an email-to-database kind of service, but that’s a whole other ball of wax.)