• Replies 4 replies
  • Subscribers 333 subscribers
  • Views 164 views
  • Users 0 members are here
Related

Promotion Deletion - Is There Another Way?

Former Member
Former Member $organization

Hi,

I'm looking for another way to delete source codes from patron records beside the Delete Promotions and Source utility.

Ideally, I would like to be able to delete the promotions based on a list and the appeal (we want to unpromote the records of patrons who did not actually receive certain emails or mailings due to address issues, etc.). The current process is based on the appeal and source code, without allowing for me to specify who.

Does anyone have any suggestions or has anyone created a special utility for this?

Thanks,

Sabrina, 92Y

Parents
  • $organization

    Great, thought this would be the only way. I’ll put my SQL skills to the Test (literally in Test) and give it a go.

     

    Thanks,

     

    Josh

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Melissa Scott
    Sent: Saturday, 9 April 2016 1:33 AM
    To: Joshua Forward <JoshuaF@sydneydancecompany.com>
    Subject: Re: [Tessitura Marketing Forum] Promotion Deletion - Is There Another Way?

     

    I do this through sql. I have a really simple query to remove patrons. You can do it by list or just by customer no if it's just a handful of patrons.

    delete T_PROMOTION

    where source_no = XXXXX

     

    and customer_no in (select customer_no from t_list_contents where list_no = XXXXX)

    From: Sabrina Karpe <bounce-sabrinakarpe7566@tessituranetwork.com>
    Sent: 4/8/2016 8:37:44 AM

    Hi Josh,

    Not as of yet. 

    But I'll keep you posted when I do!

    Thanks,

    Sabrina




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Great, thought this would be the only way. I’ll put my SQL skills to the Test (literally in Test) and give it a go.

     

    Thanks,

     

    Josh

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Melissa Scott
    Sent: Saturday, 9 April 2016 1:33 AM
    To: Joshua Forward <JoshuaF@sydneydancecompany.com>
    Subject: Re: [Tessitura Marketing Forum] Promotion Deletion - Is There Another Way?

     

    I do this through sql. I have a really simple query to remove patrons. You can do it by list or just by customer no if it's just a handful of patrons.

    delete T_PROMOTION

    where source_no = XXXXX

     

    and customer_no in (select customer_no from t_list_contents where list_no = XXXXX)

    From: Sabrina Karpe <bounce-sabrinakarpe7566@tessituranetwork.com>
    Sent: 4/8/2016 8:37:44 AM

    Hi Josh,

    Not as of yet. 

    But I'll keep you posted when I do!

    Thanks,

    Sabrina




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data