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.
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?
You could filter out the SLI status if you needed to, or by 'Paid Amount' > 0.