• Replies 10 replies
  • Subscribers 332 subscribers
  • Views 154 views
  • Users 0 members are here
Related

Reporting on non-fixed packages

Anh Le
$organization
Does anyone have any advice on how to extract data from Tessitura on non-fixed season packages? I’m trying to create a report of all our 2018 season subscribers (which includes several types of flex passes) that includes package code, number of seats, and total package revenue per constituent. Any advice would be greatly appreciated!
 
Anh Le | Assistant Director of Marketing
Opera Theatre of Saint Louis | ExperienceOpera.org
ale@opera-stl.org | (314) 963-4294
 
/Users/anhle/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_1897353022
Parents
  • Former Member
    Former Member $organization
    The output for it is quite large.  Here's screenshots of the parameters:




    And here's a quick screenshot of some of the subscription output - we seat our full subs in dummy houses before reseating so it won't show pricing or seat info like it would for our flex subs or for someone who doesn't seat this way.  If someone has multiple packages in breaks those out in Package 2, 3, etc. up to 5.  Same for single ticket and donation history.




Reply
  • Former Member
    Former Member $organization
    The output for it is quite large.  Here's screenshots of the parameters:




    And here's a quick screenshot of some of the subscription output - we seat our full subs in dummy houses before reseating so it won't show pricing or seat info like it would for our flex subs or for someone who doesn't seat this way.  If someone has multiple packages in breaks those out in Package 2, 3, etc. up to 5.  Same for single ticket and donation history.




Children