Re: Fetch Report using API's

Aman_Chandel
Level 1

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 ?

4 REPLIES 4
Amit_Jain
Level 8 - Community Advisor

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.

Aman_Chandel
Level 1

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 

Amit_Jain
Level 8 - Community Advisor

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.

SanfordWhiteman
Level 10 - Community Moderator

No, there's no API to fetch rendered reports.