Marketo Email Raw Data API Export | Community
Skip to main content
Brian_Denneny
Brian_Denneny
Level 2
November 10, 2015
Question

Marketo Email Raw Data API Export

  • November 10, 2015
  • 1 reply
  • 4111 views

Hi All,

I'm trying to connect marketo email data (just email data) to my database housed on redshift. I am seeing marketo has the following API export fields: GetLead, GetMultipleLeads, GetLeadActivities, GetLeadChanges.

How would I go about getting email data? I know I can export it but I want the data by date. To give you a broader view of what I'm doing is making it so the links in my marketo emails which lead people to fill out a form on my site have a UTM parameter captured by a cookie on our site. That UTM parameter is then sent to salesforce on the campaign member object which will enable me to see form fills, then tasks, then opportunities coming from my email campaigns.

I want to be able to connect all this data in my instance of redshift like I currently do with adwords data and bing search data to optimize my campaign performance and house everything in one set of dashboards for company use.

Right now, after reading all the documentation, I do not see how I can get email data into my DWH and when I do an export on the email data it does not have a date range. To get around this I could in theory export email data every day and upload the csv into my DWH after adding a date column but that seems extremely unproductive. I was hoping there would be a way to just get the raw data.

-Brian

1 reply

Grant_Booth
Grant_Booth
Level 9
November 10, 2015

Hi Brian,


You should be able to do this using the Get Lead Activities call and related calls. First, you get the IDs for the activity types:

Get Activity Types » Marketo Developers

Then you  get the paging token (this is when you choose the time/date after which you want to pull activities):

Get Paging Token » Marketo Developers

Then you start pulling the activities, using the activity type ID(s) and paging token from the previous calls:

Get Lead Activities » Marketo Developers

As shown in the example at the last link, it should include date-time values of the activities in the response.


Grant

    Brian_Denneny
    Brian_DennenyAuthor
    Level 2
    November 10, 2015

    Thanks @Grant Booth ! Where would I put the connection call to the ETL tool I'm using (RJMetrics)?

    Also where/how would I run these scripts? Kind of a noob here I know... It seems like I can filter pretty easily for JUST email sends?

    Grant_Booth
    Grant_Booth
    Level 9
    November 10, 2015

    Hi Brian,


    I'm afraid I can't help much with that, since I'm not familiar with RJMetrics and I'm not a developer (I'm in Support and familiar with the APIs, but haven't done much live implementation myself). For that I recommend seeking the help of an experienced developer or consultant.

    Grant

    Terms & ConditionsAccessibility statement

    Loading footer...