Hi, is it possible to export email results (open/click by person & send) from Revenue Explorer via the REST API ? If not, has anyone developed a solution to retrieve the data automatically in another way?
Solved! Go to Solution.
No, the compiled reports are not available via API.
If you’re building your own BI dashboards, exporting the raw data (using the Bulk Extract APIs) will get what RCE can do and much, much more.
What Sanford said 🙂
Caveat that the reporting you see in Marketo has some nuance that won't be reflected in the bulk extracts. For example, if there's a click but no open, in Marketo reporting it infers the open. If you were extracting the bulk data, you wouldn't see that open - you would have to replicate that logic after extraction if you wanted to replicate the dashboard exactly. Probably not a huge deal overall though.
What Sanford said 🙂
Caveat that the reporting you see in Marketo has some nuance that won't be reflected in the bulk extracts. For example, if there's a click but no open, in Marketo reporting it infers the open. If you were extracting the bulk data, you wouldn't see that open - you would have to replicate that logic after extraction if you wanted to replicate the dashboard exactly. Probably not a huge deal overall though.