Hi,
I'm trying to provide an estimate of how many tickets we printed last season so we can re-order ticket stock. I see there's a tickets printed report. Do any of you know if that report includes print at home and/or null printed tickets? The documentation for that report does not specify. Alternatively, do you have a SQL query or some other method you use for estimating tickets printed?
Thanks!
Kanani
My first thought is to SUM the number of unique ticket IDs in Analytics.
You could sort that by whatever season or time frame you'd like. It believe it looks at re-prints as well, because the re-printed ticket would get a new ID #. There'll be edge cases, but it should give you a reasonable estimate.
If you want the low-tech solution, there is always the good old single sale order listing (reports > Ticketing Box Office folder). You can filter by, seated, paid and Method of delivery etc. It may take a bit to run with a large date range, but it will give you a total number of tickets.
Try with a small range to see if that's what you are after.
Would this method count all unpaid tickets? For example, if 1,000 subscribers did not renew their 25 ticket package (and were deleted), wouldn't this show 25,000 tickets that weren't actually printed?
The Tickets Printed report does include ALL delivery methods unfortunately...
We normally just pull a query in SQL of the number of tickets and the number of orders (to count the header - we don't print receipts) in our delivery methods that require a physical ticket with an sli_status in a valid status.
You could filter out the SLI status if you needed to, or by 'Paid Amount' > 0.
No. I just did this and it doesn't generate a ticket id number unless a ticket was printed. It does however include null prints and PAH tickets.
Thank you both for the input!
Hi Kanani,
See if the table dbo.TX_SLI_TICKET for your date range is of help to you as this table contains printed_date, printed_by, printed_loc as well as reprint_ind.
Warren