Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Pulling data out of Sendy via API
  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    Hi Ben,

    Would you consider interfaces which allow us to pull data out of Sendy via API? E.g. lists of unsubscribes and bounces by date?

    Trying to keep a CRM in sync with CSV extracts is going to become a bit of a pain potentially!

    Thanks,

    Martin

  • 9 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,410Sendy support

    Hi Martin,

    Let me know if I'm wrong. When you send out a newsletter, you want to remove users from your CRM if users unsubscribes from your newsletter?

    Ben

  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    Hi Ben,

    That's the top priority (updating the contact_canemail flag rather than removing altogether), yes. For unsubscribes, bounces and spam reports.

    Martin

  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    Might be interesting to look at push options as well as pull (e.g. setting up triggered actions via http for events such as unsubscribe).

    Martin

  • Vote Up0Vote Down BenBen
    Posts: 3,410Sendy support

    Hi Martin,

    This is a unique use case and can be solved be exporting CSVs of recipients who unsubscribed, bounced and marked as spam (even though I understand it's beginning to be a pain for you).

    Ben

  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    We can always write our own API if necessary, no big deal. I'm sure lots of people would find it useful.

  • Vote Up0Vote Down jpvdpoeljpvdpoel
    Posts: 2Sendy user

    It shouldn't be hard writing the API file for this. Is the following what you want?

    1. Query the API for a specific subscriber list.
    2. Recieve data (email addresses?) for the people who are:
      • unsubscribed
      • hard bounced
      • soft bounced
      • complaint
  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    Hi @jpvdpoel,

    Pretty much, yes. Though the point you make about the specific subscriber list, it would actually be interesting to have an option this work across all lists. Or return results for a subscriber's most recent action.

    Best,

    Martin

  • Vote Up0Vote Down jpvdpoeljpvdpoel
    Posts: 2Sendy user

    Hi @addactive,

    Can you explain in more detail what you want exactly when you say "Or return results for a subscriber's most recent action".

  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    Hi @jpvdpoel,

    Because we often segment the database when running a campaign (and produce a new list as a result), we may have a number of lists which are difficult to keep track of as they are subsets of the same thing.

    For each email address we'd want to know the unsubscribe, bounce and complaint information for the latest campaign they were included in.

    For instance, we could query the API with a "show me all unsubscriptions since 1st March". And that would look at all the campaigns sent since that date, group the results by email address and return only those who have unsubscribed to one or more campaigns.

    Does that make sense?

    Martin