Hello Tess Hive Mind,
I'm looking for a way to pull a list of subscribers that have consecutively subscribed for the last 10+ years that doesn't involve knowledge SQL (i.e. creating a stored procedure/view). I've been playing with Constituencies (and thinking about attributes too...), but we don't want a string of constituencies in the header. For example, I could create a Sub constituency for each fiscal year (S15 for 2014-15, S16 for 2015-16 etc), but the headers would have a ridiculously long list of constituencies.
Any ideas?
MB
Lucie SpielerIT Dev. & Training Manager
Hi,
We use a set up like Lucie suggests. The Constituency is for this years subs or single buyers and also for their status (new, renewed, reengaged). Everything else’s goes in Attributes for history. So I have every year they bought tickets, what kind of sub they bought, and a few other tags. Anything else I make lists using ticket order history as required.
kind regards,
Nichole
This is what I'm planning to do, thanks!
Thanks! This is what I'm planning to do. I've set up one attribute (Subscriber Year) and each year an attribute row will be added to the account. So if I had subscribed for the last 3 years, I would have 3 attributes (Subscriber Year = 2019, Subscriber Year = 2020, and Subscriber Year = 2021).