• Replies 5 replies
  • Subscribers 359 subscribers
  • Views 111 views
  • Users 0 members are here
Options
Related

Tracking & Targets in Tessitura for Exhibitions/Admissions

Kyle Jarvis (Past Member)
$organization

Hello, 

We're now over 2 years into using Tessitura here at Somerset House and we're starting to look at how we can track against targets more effectively in the system. Currently it's all done in Spreadsheets. 

For an exhibition we would have a financial and visitor target for the exhibition as a whole and then also daily - the daily targets will vary day to day. 

Is there anyone on here who is using Tessitura to track both financial and visitors against your targets?

Thank you,
Kyle

  • $organization

    Hi!

    For the revenue you can use the existing Budget field on the performances. You could use prods or prod seasons to split the performances by exhibition...or just throw the exhibitions on the performances as a keyword. As for attendance goals, I've used one of the ticket text fields on each performance. It was an easy to see and easy to pull place to plug a number in on each performance. 

  • $organization in reply to Amanda Abernathy

    Hi Amanda, 

    I had considered that as a possibility. I'm glad to see that was the right path. 

    We're currently using the ticket text fields for ticket design. Sadly some (nearly all) of our curators like to use as many words as possible in their exhibition titles :') How do you pull that information out from the ticket text to report on? 

    Thanks,
    Kyle

  • $organization in reply to Kyle Jarvis (Past Member)

    I don't have anything to add on this front, but I did want to say that I feel your pain on the super long exhibition titles. Our museum name (The Historic New Orleans Collection -- and yes, they require us to include and capitalize "The") is enough words. Then every exhibition has a title and a subtitle. I used to be in our marketing department and trying to write underwriting copy for NPR radio was a nightmare because we'd run out of words by the time we said our name and the exhibition title.

  • $organization in reply to Kyle Jarvis (Past Member)

    It lives in T_Inventory so we had a custom report that displayed that for each perf. If you have SSMS access you can run something like the following.

    Here's a little example to get you started. Happy to walk through this if you or your team are unfamiliar with SQL!


    SELECT
    i.description AS Performance, --perf name
    p.perf_dt AS Perf_Date, --perf date
    i.text1 AS Attendace_Goal, --ticket text 1 field
    p.budget_amt AS Revenue_Goal --budget field
    FROM dbo.T_INVENTORY i
    JOIN t_perf p ON i.inv_no=p.perf_no
    WHERE p.perf_dt BETWEEN '2020-01-01 00:00:00' AND '2020-01-31 11:59:59' --date range
    AND p.prod_season_no=112847 --filtering to one prod season

  • Former Member
    Former Member $organization

    Hi -

    We only look at our goals weekly and have a local system table to hold all of the information we need and a custom report to view the data with actuals. We worked with Extended Services to create the process and report.