WordFly and Unsubscribes from accounts with multiple interests

Hi Peter -

Sadly, this is one of the big 'bang your head' pieces of WordFly. Currently, the only way to get around this is to upload your people manually on a periodic basis and manually override that unsubscribe. 

Several of us have been in extended discussions with WordFly about this 'feature' which causes us great pain. The more voices they hear that this actually is NOT a benefit, the more likely we'll be to get some sort of solution coded.

In solidarity,

Heather
Seattle Rep 

Hi all,

Has there been any change to this functionality as of now? This just came up for us and we're trying to figure out how to address it.

Thanks!
Beth

We offer both an unsubscribe from all emails (which is the standard wordfly unsubscribe) as well as an unsubscribe from interest.

Talked to Wordfly team about this ages ago and the solutrion they came up with that works really well for us is as follows.

The unsubscribe from interest we direct to a static html page (on a fixed url)
ie http://www.nationaltheatre.org.uk/unsubscribe_ntnews

Ths page does nothing just display static text saying we have recieved your request to unsubscribe and it should be processed in next 48 hours.

As Wordfly sends back to Tessitura an action that the user has clicked on the URl we intercept that in 

LP_UPDATE_EMAIL_PROMOTION

Then use the following sql in that procedure.

If @response_code = 4
Begin

      If  @url = 'http://www.nationaltheatre.org.uk/unsubscribe_ntnews'
      Begin
         if not exists (select 1 from TX_CUST_TKW where customer_no=@customer_no and tkw=1)
         begin
            insert into TX_CUST_TKW (customer_no, tkw, selected, weight)
            select distinct @customer_no, 1, 'N', 8
            where not exists (select 1 from TX_CUST_TKW k where @customer_no=k.customer_no and k.tkw=1)
         end
         else
         begin
            update TX_CUST_TKW
            set selected='N',
            weight=ISNULL(weight,-1)
            where customer_no=@customer_no
            and tkw=1
         end
      End

End

which updates the interest to N (add the weight so that the interest will persist)

Mark

Mark