Re: Bulk Extract Leads based on Date and Unsubscribe status

Ben_Flora
Level 1

Bulk Extract Leads based on Date and Unsubscribe status

I'm looking to extract leads based on date and unsubscribe status.

Example queries:

  • give me all leads on list "x" that unsubscribed since 8/1/2017
  • give me all leads on list "x" that subscribed since 8/1/2017

What would be the best way to do that?

Bulk Lead Extract API Proposal

Looking at the Bulk Lead Extract api http://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/

I see that I can filter on "create time", but "update time" has an asterisk next to it -

"Filter type is unavailable for some subscriptions.  Marketo Support can provide you with this information."

What does that mean exactly? In my scenario, multiple Marketo customers would be making queries like this.

Also, the api does not let me filter on unsubscribe status. I can specify the "unsubscribed" field in the "fields" parameter, so the information would be in the extracted results.

So would the correct approach be to just get all new records created since 8/1/2017 - 8/31/2017, and then throw away the records based on the unsubscribe value? Seems wasteful.

Also, this approach would not get me existing leads that switched unsubscribe status during the month since I can't rely on "update time"

Is there another way to do this?

1 REPLY 1
David_Everly
Marketo Employee

Re: Bulk Extract Leads based on Date and Unsubscribe status

Hello Cris,

"Unsubscribe Email" is an activity.  You can retrieve activities since a given time for a given list using the Get Lead Activities endpoint as described here:

http://developers.marketo.com/rest-api/lead-database/activities/#query

This blog post describes a polling process to retrieve email-related activities:

http://developers.marketo.com/blog/polling-for-activities-using-rest-api/

-Dave