I'm looking to extract leads based on date and unsubscribe status.
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?
"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:
This blog post describes a polling process to retrieve email-related activities: