1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Add-on Mailinglist addon to interface with Amazon SES Simple Email Service to send newsletters to members?

Discussion in 'Resource and Add-on Discussions' started by Stuart Wright, Jul 25, 2013.

  1. Stuart Wright

    Stuart Wright Well-Known Member

    Doesn't this exist yet? The idea being that
    • Admin can set up mailing lists - title, description. The description describes the type of email people will receive. (Ours will be latest news/reviews/articles newsletters for home cinema, movies, gaming, technology etc.)
    • Members can subscribe/unsubscribe via a mailing list page.
    • You compose newsletters externally or maybe using redactor. HTML and plain text versions (there should always be a plain text version).
    • You test the newsletter by sending to yourself from the system.
    • You send the newsletter to the selected mailing list(s). Our current mailing list is over 150,000 recipients.
    • The system uses the Amazon SES (Simple Email Service) API to send the emails and process bounces and unsubscribes. Automatically unsubscribing necessary members from the mailing lists with an alert sent to them informing them of their unsubscription.
    • You pay Amazon for the cost of sending the emails. It's not expensive.

    That's the idea. In a nutshell. Without fleshing out the details.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. Stuart Wright

    Stuart Wright Well-Known Member

    Thanks Brogan. Mailchimp works out 50 times more expensive than Amazon for our 150,000 recipient mailing list.
    Average email size : 100k (that's a big email!)
    Recipient list : 160,000
    That's a total email data transfer of 15.25, let's say 16 gig a month.

    Amazon cost :
    $.10 per thousand = $16
    $.12 per gigabyte (up to 10TB) = $1.92
    Total : $17.92

    Mailchimp cost : $897

    But it's worth sending Andy a PC.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Woah!
    Quite a difference.

    Definitely worth exploring the Amazon option then.
     
  5. arms

    arms Active Member

    A suggestion for this earlier was some sort of Sendy integration which uses amazon SES

    http://xenforo.com/community/threads/newsletter-function.713/page-2#post-510036

    http://sendy.co/

    Has a simple API too for joining up mailing lists

    http://sendy.co/api

    Also gives you default subscribe forms:

    Code:
    Subscribe form
    This is the subscribe form HTML code for Special list. To sign users up programmatically, use our API.
    
    <form action="http://sendy.co/demo/subscribe" method="POST" accept-charset="utf-8">
        <label for="name">Name</label><br/>
        <input type="text" name="name" id="name"/>
        <br/>
        <label for="email">Email</label><br/>
        <input type="text" name="email" id="email"/>
        <br/>
        <label for="ClientType">Client Type</label><br/>
        <input type="text" name="ClientType" id="ClientType"/>
        <br/>
        <label for="Phone">Phone</label><br/>
        <input type="text" name="Phone" id="Phone"/>
        <br/>
        <input type="hidden" name="list" value="8mGw3CVGBJcQLA7Z95ngDw"/>
        <input type="submit" name="submit" id="submit"/>
    </form>
    Its what I plan to use in the future.
     
    Last edited: Jul 25, 2013
  6. Stuart Wright

    Stuart Wright Well-Known Member

    Does Sendy just present a user friendly way of subscribing, send the emails via Amazon and charge you a % on top?
    If that's the case, then why not just use Amazon's SES API directly?
     
  7. arms

    arms Active Member

    Much simpler (and cheaper) than building fully integrated into xenforo and you are able to do almost all the things you listed, whilst using SES.

    Or don't integrate at all and use the html subscribe forms
     
  8. arms

    arms Active Member

    Does Sendy just present a user friendly way of subscribing,
    Yes
    send the emails via Amazon
    Yes
    and charge you a % on top?
    no, one off fee to purchase the software.
     
  9. Stuart Wright

    Stuart Wright Well-Known Member

    We don't want people to have to subscribe via Sendy though. I want them to subscribe via Xenforo. Can we do that?
    I currently use a mailing list service where I have to manually export the recipients from vBulletin, import into the mail service, send the newsletter, and then before the next newsletter, export the bounces and unsubscribes, update the user table to unsubscribe those users and then re-export.
    A real PITA.
     
  10. arms

    arms Active Member

    Import your current list and add a sign up html form on your forum for new people.
    You would need an add on for adding through xenforo user preferences though.
     
  11. Stuart Wright

    Stuart Wright Well-Known Member

    Still struggling to see what the benefits of Sendy are, when there is already a php class for Amazon's API. We could use that to call on the locally maintained mailing list (which we'd have to keep anyway) and send the newsletters directly via Amazon, bypassing Sendy altogether.
    I think Sendy is fine for people who don't have the capability to maintain their own mailing lists.
    But we can do that in Xenforo with relative ease.
     
  12. arms

    arms Active Member

    It was just a suggestion, if you prefer to have someone code another solution within xenforo, then great. Will you include the tracking and reporting of each mailshot and click reporting on links within as that's what I need.

    Screenshot_2013-07-25-12-35-11.png
     
  13. Andy.N

    Andy.N Well-Known Member

    That's what I did when I was moving into XF. There was a VB addon that connect to VB so we asked @xfrocks to code this Mailchimp addon for us.
    It's still working for us on XF 1.1.5 as far as I can tell. Not sure if it will work with 1.2 yet.

    We have a small list <10K subscribers and buy emailing credit in bulk (1 cent for sending each email) but obviously nobody can beat Amazon with cost.

    I like the features and mailing templates used by Mailchimp. I don't know how Amazon stacks up in term of features. I don't want to hand code templates for mailing campaign.

    In any case, I would like to see this addon upgraded and add new features.
     
  14. Chris D

    Chris D XenForo Developer Staff Member

    I suggested Sendy earlier, too, and this is my thought process...

    Let's keep this as a generic scenario.
    1. Create a list in Sendy with an ID of NEWSLETTER
    2. Have a XenForo add-on that uses the Sendy API:
      1. Set up an item in the Admin CP with the same ID as Sendy e.g. NEWSLETTER
      2. During registration, allow users to subscribe to the NEWSLETTER list (or indeed multiple lists if multiple items have been set up in step 1)
      3. Use the Sendy API to pass that information from XenForo to Sendy.
      4. In the user's preferences, show them which lists they are subscribed to.
      5. Allow them to unsubscribe from existing lists.
      6. Allow Sendy to get updated if a user changes their e-mail address.
      7. Perhaps update Sendy to remove banned users etc.
      8. The Sendy API is used again to pass the unsubscribe request.
    3. Use Sendy to get the bulk of your reports and analytics (As demonstrated by Arms above).
    4. Use Sendy to create the actual newsletters (the interface for this that they provide seems pretty good).
    5. Use Sendy to send the e-mails (via Amazon SES).
    So as far as your users are concerned, they are indeed subscribing and unsubscribing via XenForo. As far as you're concerned, from Sendy you've got a (very cheap) ready made interface with all of the reports you need and an excellent interface for producing the newsletters. You don't have to do any manual importing or removals. It's very cheap. $59 for the software plus dirt cheap e-mail sending from Amazon. It seems to me like it might actually be the solution for the bulk of the issues relating to managing lists and sending e-mails.
     
    ProCom, Alfa1 and Rob like this.
  15. Rob

    Rob Well-Known Member

    Well Chris, you are certainly qualified to make this add on and your workflow process there seems pretty much bang on. You can count me in as a buyer if this gets made.
     
  16. Stuart Wright

    Stuart Wright Well-Known Member

    Sounds good Chris provided that we could have around half a dozen different mailing lists and that the list of recipients is kept up to date so that 2.7. - banned users, and anyone else not eligible to receive the newsletter is removed from the mailing list. That's really important. We can't ban someone and then send them a newsletter. They'd be very inclined to send in a spam report to their ISP.
     
  17. arms

    arms Active Member

    Think the Api allows for unsubscribe from all lists that could be added to ban script
     
  18. Chris D

    Chris D XenForo Developer Staff Member

    There isn't an out of the box method of mass unsubscribing, but the solution is quite simple.

    It has a way to check the subscriber status for a list.

    So you first loop through each list and check if they're a subscriber of each list.

    For each list where they are a subscriber, unsubscribe them from that list.
     
  19. arms

    arms Active Member

    Sorry Chris I thought that if you didn't include a list in the unsubscribe it actually unsubscribed you from all
     
  20. Chris D

    Chris D XenForo Developer Staff Member

    Hmm. Maybe it does. That'd be useful. Either way not a huge issue.
     

Share This Page