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
Hi Matt,
Good day.
how about you put a selection on the lt_sub_hist table?
in that table, you have all info you need to create a list.
have fun
Ben
Hi everyone,
Thanks for all your suggestions. I realised that I should have explained what we were using them for. What we're trying to do is pull everyone who subscribed in 2010 who doesn't have a 2011 subscription, so we can try a last-ditch marketing effort on them. However, we want to differentiate between someone who hasn't bought the 2011 season yet because they're slack and someone who was rolled over as a subscriber and then cancelled.
The way we've currently decided to handle it is to add an attribute with a cancellation reason drop-down that's unique this to this year (e.g. Cancellation Reasons 2011), and that way we can just eliminate anyone with a cancellation reason.
Now that I'm thinking about it, a CSI might be an even better idea for next year, so thanks, Ryan. The answer I'm getting, anyway, is that none of the out-of-the-box criteria will work for excluding subs history, unless we add some sort of flag to the Subs History table or do something like what we're doing with an attribute or a CSI.
Matthew,
We also have a Canx Subs CSI. It WORKS!!! We use it for a number of reasons but the best reason to do the switch to the CSI would be, in my estimation, the fact that you can:
a. Add notes
b. Tickle to the next year
c. Pull a list
d. Pull a report which makes sense for an executive to view/report on.
It's probably the most out of the box scenario you can get with reporting and comment all rolled into one....
Lesley