TMS

Hi ,

I would like to describe in detail which would make things more easy,

I have activated the stored procedure Lp_update_email_promotion.

I have enabled the code to unsubscribe

If @response_code = 5

  Begin

      Update      t_customer

      Set   emarket_ind = 1   -- tickets only

      Where customer_no = @customer_no

  End

If @response_code = 5

  Begin

      If Exists (Select * from tx_cust_keyword where customer_no = @customer_no and keyword_no = 215)

            Update      tx_cust_keyword

            Set   key_value = 'Unsubscribe'

            Where customer_no = @customer_no

                  and keyword_no = 215

      Else

            Insert      tx_cust_keyword(customer_no, keyword_no, key_value)

            Select      @customer_no, 215, 'Unsubscribe'

  End

RETURN

@responce_code is 5 ,which I have checked.

I have gone through the user tickects in TASK regarding this issue,I guess I am unable to visualize the change which needs to be made.

Any suggestions regarding this problem would be appreciated.

Are you tracking unsubscribes via an attribute or the emarket indicator or both? If using the attribute, are you sure the patrons in question have the attribute that is keyword 215? (Is 215 definitely the subscribe/unsubscribe attribute?) If they don't have that attribute, then it wouldn't be able to update the key value. Or if that attribute is not valid for the cust type in question that could also be a problem.

Thank you Amanda for you reply..

we are suppressing them with the emarket indicator “Tickets Only,” but their unsubscribe action should also show up in the Promotions tab, directly from the feedback loops. 

Coming to the Keyword_no 215 has Description: Inactive Reason Detail Tbl : t_customer

Detail Col: !.inactive_reason Ref Tbl: tr_inactive_reason Refidcol: id Refdesccol: description

Hope this information helps for you to suggest.

Thank you ,

Revanth.