Skip to main content
YashKA
Level 1
Aug 19, 2025 3:17 PM UTC
Solved

Can we automate weekly Email performance report using API

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
User Group Leader
Aug 19, 2025 5:56 PM UTC

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.)

View in thread

1 reply

SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Aug 19, 2025 5:56 PM UTC

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.)

Translate
Terms & ConditionsAccessibility statement

Loading footer...