Data Extract by Marketo Table (full dataset) | Community
Skip to main content
A
Anonymous
November 1, 2016
Solved

Data Extract by Marketo Table (full dataset)

  • November 1, 2016
  • 2 replies
  • 3815 views

Hey,

Is there a way to extract data from Marketo tables within Marketo? I'm not an API coder so I'm looking for the functionality within Marketo.

I'd love to get a full list of:

(1) Emails we've sent

     Email Id, Email Name, Datetime Sent

(2) Leads that were targeted for those email (initial send list pre-delivery failure)

     Lead Id, Email Id, Email Send Id, Email Address

(3) Successful deliveries

     Email Send Id, Delivery Datetime

(4) A full list of Unsubscribes

     Lead Id, Unsubscribe Date, Unsubscribe Reason, Unsubscribe source (a link back to an Email Send if possible or any other source)

I want to be able to extract the full set of information without having to go into each campaign or email separately.  That would be so many manual extracts.. my hope is that this can just be a few and I can import the data into a MySQL database to run some queries off of.

Why the ask? I'm looking to use this to study our unsubscribes.  I want to know:

(1) How often are we emailing our leads - # of sends by lead within any timeframe

(2) Of those who have unsubscribed, how many emails did they receive within 7 days (or any timeframe)  prior to their unsub?

(3) Is there a specific email type (webinar invite, tradeshow invite, whitepaper mention, etc..) or email pattern that leads to unsubscribes?

I hope this makes sense - I was thinking this would be easy but I can't seem to find a way to get the data I'm after in larger extracts. 

Thanks,

Quinton

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Josh_Hill13

You should be able to use smart lists to do this. I did a similar analysis using the email filters and some excel work. Is it perfect? No. Was it good enough? Yes. Clearly showed a small, but defensible increase in unsubscribes if a lead received 2 emails in one day.

If you can use the API, you can download the entire activity log and dataset if you want. May slow down your system though.

2 replies

A
Anonymous
November 3, 2016

This would be so useful to have in Analytics...unsubscribe trends with email by channel, #'s of times received. And for bonus points, with drill down to the actual leads.

Josh_Hill13
Josh_Hill13Accepted solution
New Participant
November 1, 2016

You should be able to use smart lists to do this. I did a similar analysis using the email filters and some excel work. Is it perfect? No. Was it good enough? Yes. Clearly showed a small, but defensible increase in unsubscribes if a lead received 2 emails in one day.

If you can use the API, you can download the entire activity log and dataset if you want. May slow down your system though.

    A
    Anonymous
    November 3, 2016

    Thanks for the response Josh!

    Smart lists are definitely a great way to look at email volume (people who received 1,2,3,4 emails in x timeframe). I'll start with that but I have a feeling that I'm going to struggle to answer any follow-up questions about the types of emails being received since smart lists restrict me to just exporting lead information.

    Emmanuelle_Biss
    Emmanuelle_Biss
    New Participant
    November 3, 2016

    Hi Quinton,

    You could just create a new field to populate this data (just like a Concatenate formula in Excel). You will see the journey of all the emails that were sent/received/opened/clicked (whichever value you look at) of that specific lead.

    Terms & ConditionsAccessibility statement

    Loading footer...