Hi everyone -
Our subscription dashboards are currently built to pull in revenue based on Ticket Original Paid Amount, in order to take exchanges into consideration. However, in the wake of COVID-19 and cancellations, using that data point could technically overstate our subscription revenue now. Using Ticket Paid Amount might understate our revenue because not all subscribers have requested refunds or a different type of return request.
Has anyone else started puzzling through this?
Thanks!
Hi Kari,
We don't use subscriptions here, but I am wondering if you can utilize the SLI status for the filtering. You may have to do two separate widgets and then add up what it is your are looking for? There is also the transaction type that may help filter down too.
Would it work to filter out whole performance or production season cancellations? Or if the status of these events has been set to Cancelled, adding a dashboard filter to exclude that status?
Alternatively, as Joe has suggested, one could deduct from the Total Original Paid Amount, the Original Paid Amount associated with Void in This/Other Order SLI Statuses within those cancelled performances using a filtered value formula. This SLI Status approach implies an assumption that all VTO/VOO for those package performance tickets within cancelled performances are returns and not exchanges.