Hello friends-
I've got a widget for total tickets sold yesterday. I'm currently using an Order Date filter with Date=Yesterday, but I think I may need an adjustment because it includes things like a subscriber exchange. For example, if a subscriber exchanges a pair of tickets out of one performance and into another, then my widget says I sold 2 tickets. I'd like for the widget to say 0 because technically, I didn't sell any tickets yesterday. It was just an exchange.
I've played with ticket type, and that didn't do it. I was trying to do something with Order Value because maybe if the order value was greater than $1, it would include only the true sales. Have you faced this? Any advice?
Neil Cole | Customer Service Specialist Principal | neil.cole@state.mn.us
o: 952.431.9213 | MNZOO.ORG
13000 Zoo Boulevard Apple Valley MN 55124
Connecting people, animals and the natural world to save wildlife.
You're right about the Total Ticket Count part. My challenge seems to be getting an accurate number for the total ticket count. For example, if a subscriber exchanges a pair of tickets out of one performance and into another, then my widget says I sold 2 tickets. I'd like for the widget to say 0 because technically, I didn't sell any tickets yesterday. It was just an exchange.
When I do the same thing in the Finance cube trying to get to revenue, as you showed above, it's spot on. I would get $0 for daily revenue if a subscriber swapped out $100 worth of tickets from one show to another. What I'm trying to get is that exact same figure, just represented in actual tickets. The "Total Ticket Count" doesn't subtract out the tickets a subscriber returns when doing an exchange.
Do you use separate price types for subscriber tickets? Maybe even a separate price type category? Or maybe you use a particular promo source for exchanges? You could suppress those if you do. If not, and if we're talking about the wider issue of both subs and single ticket buyers being able to exchange, I've found that pairing "yesterday" numbers with "all time" numbers has helped paint a more accurate picture.
Hmm. Now that you mention it, I think I could actually live with just single tickets in my widget. After all, subs sales start to make up less and less of my daily sales once a season begins. But tell me more about pairing yesterday numbers with all time numbers. Do you have that set up in two different widgets?
We use separate widgets. In theory, you could also bucket the values in a single widget (eg tickets booked yesterday, revenue yesterday, total tickets booked, total revenue), and we do use that method for some things, but I find separate widgets easier for when we’re inevitably asked “well what about sales days ago?”