Visitor Figure logging and target tracking in Tessitura

Hi everyone,

A few of us had a chat about visitor figure tracking in Tessitura at TLCC London a few weeks back so I thought it might be helpful to throw this question out to the wider group.

As part of our visitor reporting, we monitor visitor attendance across a range of data points. Some of these are data we are already collecting in Tessitura (admission ticket purchases and attendance, exhibition and event ticket purchases and attendance) and others are data that is collected outside of Tessitura (people counting software, manual clickers, free school visits, etc).

We are embarking on a project to review the data points we report on and as part of this I would like to explore the potential of collecting more, if not all, in Tessitura. At present we have a number of spreadsheets where we plug in figures each day which risks human error and in users changing the figures regularly resulting in a lack of faith in the figures. Ideally we'd capture the data in Tessitura so we can use Analytics and reach a single source of truth for our visitor numbers and track our progress against targets.

I know that some ideas out there include hard coding data into Analytics, using custom tables or creating daily performances where people counting figures can be recorded through selling tickets. Can anyone share their experience of using Tessitura for visitor figures reporting and the strengths and weaknesses of their approach?

Many thanks

Hannah