Currently I am getting some email reports from Marketo to my gmail Account, Is it possible to fetch these Reports directly from the API using PHP ?
No, there's no API to fetch rendered reports.
No, there is no API for reports but what you can do is to fetch the activity data in database and use that to create reports.
Since Marketo have 90 days and 25 month data retention policy, it makes sense to have a backup database to have historical activity data.
Hi Amit,
Is there anyway to fetch stats data, most of the report which we are generating have stats like email name, delivered, open, bounce and etc.
so is there anyway to fetch this detail, and create the report at our end?
Thanks a lot
Aman
You cannot extract the stats directly but you can use Marketo bulk API to extract the activity data. The best part is that you can filter the data by activity type.
Lean more here and feel free to ask if you have any question.
https://developers.marketo.com/rest-api/bulk-extract/bulk-activity-extract
After extracting the raw activity data, slice and dice the same to create reports and dashboard in your external systems.
.png)