Eliminating cancelled subs from a list

Matt,

Are you using criteria in the “Subscription Summary” folder to pull your list?  If so, that’s why you’re getting cancelled subscribers.  Any rolled-over subscription order has a subscription summary in it, whether or not the package is renewed.  So if you used “Subs Summary Season” as your criteria, it would include those cancelled folks.

I’d recommend using the criteria elements under the “Ticketing” folder in List Manager.  There is a “Subscription Season” option which you can use easily to determine who has last year but not this.  The criteria elements in this folder come from the Ticket History tab in a constituent record – the good thing about that is that a subscription appears as Subscription History only if it’s been renewed.  Anything that’s been cancelled won’t appear (as long as your subscription history is updating correctly).

Hope that helps!

Christy

Seattle Rep

Hi all,

I was trying to pull a list of non-renewed subscribers - people who had a subscription last year but not this year. It seemed like a simple case of pulling who has one season but not the other - but cancelled subscribers snuck in to the list because they have an empty order with no season or package at all.

What's the best way to do this? What do other people do?

Cheers,

Matt

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!

Matt,

Are you using criteria in the “Subscription Summary” folder to pull your list?  If so, that’s why you’re getting cancelled subscribers.  Any rolled-over subscription order has a subscription summary in it, whether or not the package is renewed.  So if you used “Subs Summary Season” as your criteria, it would include those cancelled folks.

I’d recommend using the criteria elements under the “Ticketing” folder in List Manager.  There is a “Subscription Season” option which you can use easily to determine who has last year but not this.  The criteria elements in this folder come from the Ticket History tab in a constituent record – the good thing about that is that a subscription appears as Subscription History only if it’s been renewed.  Anything that’s been cancelled won’t appear (as long as your subscription history is updating correctly).

Hope that helps!

Christy

Seattle Rep

Hi all,

I was trying to pull a list of non-renewed subscribers - people who had a subscription last year but not this year. It seemed like a simple case of pulling who has one season but not the other - but cancelled subscribers snuck in to the list because they have an empty order with no season or package at all.

What's the best way to do this? What do other people do?

Cheers,

Matt

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!