1 Reply Latest reply on Aug 18, 2017 11:33 AM by David Everly

    Bulk Extract Leads based on Date and Unsubscribe status

    Cris Angelini

      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?