How many years a subscriber?

We created an attribute called "number of years subscribed" that gives us based on their subscription history the number of years they have been coming. We use this as a list builder element.

>>> "Phil Setchfield" 11/18/2010 3:02 PM >>>

Hello,
Has anyone created elements, e.g., custom list builder elements or custom reports that can be shared, for reporting out the number of years that patrons have been subscribers? I would like to be able to report out - for all the patrons in my database who have ever been subscribers, how many seasons have they been a subscriber. I would like to be able to further narrow down the query to ranges of seasons, such that, for example, for seasons between 2000-2010, those who have been a subscriber >= 5 years, etc.
I work for an organization that is very small and doesn't have internal IT resources. Clever solutions that don't require large IT resources are welcome, also!
Thanks in advance for your responses.
Phil Setchfield



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!

We created an attribute called "number of years subscribed" that gives us based on their subscription history the number of years they have been coming. We use this as a list builder element.

>>> "Phil Setchfield" 11/18/2010 3:02 PM >>>

Hello,
Has anyone created elements, e.g., custom list builder elements or custom reports that can be shared, for reporting out the number of years that patrons have been subscribers? I would like to be able to report out - for all the patrons in my database who have ever been subscribers, how many seasons have they been a subscriber. I would like to be able to further narrow down the query to ranges of seasons, such that, for example, for seasons between 2000-2010, those who have been a subscriber >= 5 years, etc.
I work for an organization that is very small and doesn't have internal IT resources. Clever solutions that don't require large IT resources are welcome, also!
Thanks in advance for your responses.
Phil Setchfield



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!

Thanks, Amy. That is helpful.

I think I should also post the question in the Technical forum to answer the question of what needs to be done on the back end to enable the gathering of such information.

Hi Phil,

For number of years as subscriber you could create a view like the following to be used as a list manager criteria.

select customer_no,count('x') as num_of_years from vs_cust_subscription_summary join tr_season on tr_season.id=vs_cust_subscription_summary.season group by customer_no,fyear order by num_of_years

Jon