• Replies 6 replies
  • Subscribers 414 subscribers
  • Views 49 views
  • Users 0 members are here
Related

List builder Question

Amy Lehman (Past Member)
$organization

Any list gurus able to help me set up a report? 

My question is:
I am constantly asked for lists that include anyone who has EVER been a subscriber/season ticket holder and I just can't think of the easy way to do that. We put a constituency on current subscribers, but that constituency expires at the end of the fiscal year. 
Also, I asked for reports such as: "Give me a list of anyone who has purchased a season ticket every year the last 5 years." How do I set those up correctly!?
Parents
  • $organization

    Honestly, I would use T-STATS for this. You could then separate out by season. You could run a packages, seats, or tickets cube. If you give all your season ticket price types a category of season or something like that, you could easily compile a report of season ticket holders. You could even break it down further into season. Once you have your cube set, you can then export that information as a list directly into Tessitura. The other huge benefit of setting up a T-STATS cube for this is it will update nightly.

    Chris Cuhel

    The 5th Avenue Theatre

Reply
  • $organization

    Honestly, I would use T-STATS for this. You could then separate out by season. You could run a packages, seats, or tickets cube. If you give all your season ticket price types a category of season or something like that, you could easily compile a report of season ticket holders. You could even break it down further into season. Once you have your cube set, you can then export that information as a list directly into Tessitura. The other huge benefit of setting up a T-STATS cube for this is it will update nightly.

    Chris Cuhel

    The 5th Avenue Theatre

Children
No Data