Hello all -
So I have four custom views that I use for all ticketing reporting here - one for all "main" season tickets, one for "main" season single tickets only, one for education products and one for what we call here "alternative" programming. All the program function basically the same way: they take all seats sold (from t_sub_lineitem) and reports sales on them and with each SLI representing a seat, it's both a revenue and seating program that we use across multiple other reports here in the company.
However, the report is never 100% accurate for past dates due to exchanges and such, so it's never been fully reliable for, say, looking at sales at this point last year v this year.
So I'm attempting to build a transactional seating report - but I'm running into obstacles and I'm not sure where the obstacles are. I have a new program that pulls transactionally (actually via seat history, not transactions), but I cannot get it to reconcile against any common field: for example
I can't reconcile against customer because seats can be transferred; I can't reconcile against order because the seats move from order to order; I can't reconcile against performance number because folks go in and out of performances at different prices... the list goes on and on.
Has anyone ever writing a transaction-ish seating report that is both accurate over history and in the present? I'm happy get into more detail with anyone interested - any assistance is appreciated!
RJ
Hello Everyone,
I’d like to introduce myself, I’m John Jakovich Tessitura’s VP of Business Intelligence. You probably heard that The Network is embarking on a Business Intelligence Initiative. I’m leading this effort with the community to understand overall needs and gaps, then design and develop functionality to address those needs.
This thread is very timely because we're beginning the development of standard reporting views which should make this sort of thing easier. The use cases in this thread are really helpful. I would also appreciate the opportunity to take a look at the views you’ve developed, as they will give us valuable context.
If you don’t mind sharing, please send them to me at jjakovich@tessituranetwork.com and I’ll follow-up with each of you. I can also give you a sneak-peak at what we're working on, I'd appreciate your feedback.
Thank you!John
P.S. I’m posting from 30,000 feet over Kansas!