Hello,
I need to provide results of a Partner offer that ran Feb 2023 to May 2023 to our Development dept.
I ran Appeal Response in Reports/Utilities. It yielded 39 orders, 111 tickets for a total of $3,729.
Next, I created a List to pull which performances, # of tickets, price paid, and base price where the offer was used. The box office set it up as a pricing rule. It yielded 95 tickets for $3,915.65 which was short 16 tickets and was over by $186.65.
Next I went into Analytics to see if I would get any different results. Every way I filtered and drilled down in the widget I got the same results of 95 tickets.
I've tried every way I could think of but never get the totals that were on the Appeal Response.
Would anyone have any thoughts on this?
Thanks for your time.
Donna
A quick thought...
I've noticed that a lot of out-of-the-box reports in Tessitura will report on GROSS numbers. For example, I think that Appeal Response report will still count a patron if the order was cancelled or refunded (the source was technically still used even if the order was returned). It would also count any test orders that may have been processed/returned. When I see something like this I usually ask our SQL guy to run some code and the results usually match more closely to what I see in Analytics (which I believe would be the NET results). Makes sense that the tickets may have been lower...but strange that the revenue went up.
May also be worthwhile to ask Tessitura for a full load of Analytics on the next nightly update.
Jason
Ah... thanks for your thoughts! I'm finding more and more that I am unsure what data to trust due to things like this. Analytics and List Manager were very close with the totals. Yes, odd that the money went up in the Analytics.
I really need to learn SQL. That would be so helpful for me.
I will reach out the Tessitura regarding the nightly updates.
Thanks so much! I really appreciate it.
One other thing to note about the appeal response report is that it reports on the total order, not just the value for the tickets related to the partner offer. So, for example, if you had a partner offer for SHOW A, and a patron ordered both SHOW A (with the partner offer) and SHOW D on the same order, it will count the value of both in the appeal response report.