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
We have a no-criteria list called "responded not renewing" that we manually add people to when they cancel and we suppress that from this sort of list. You could also in theory create either an order category or channel called "cancelled" and use that for suppression.
It's a policy here that when someone cancels their subscription we create an auto-close CSI with the reason listed. I know this doesn't help you with your current issue, but I thought I would mention it because it's a good thing to have record of, and would be a way to sort these people out for the future.