Hi everyone,
I'm trying to build a sales curve that compares our subscription sales season over season, and I've hit a roadblock trying to figure out the right way to get the date I want for the x axis. The goal is for "day 0" (the start date) to be the day we put packages on sale, which we store as appeal start date, and end on appeal end date. Here's an example of what we've been building in Excel, based on pulling data manually from T-Stats:
Sorry it's so small! Basically the y axis is cumulative package sales $$ (blacked out), the x axis is days from appeal date, and each colored curve is a different package season. Since appeal date isn't an accessible option in Analytics, I've been wracking my brain trying to find somewhere else to store this date. Our finance dept uses campaign date for fiscal year stuff, so that's not an option, and otherwise I'm kind of out of ideas. Does anyone have any thoughts or creative solutions?
Could you use order date instead? Would there be a big discrepancy between the date you put them on sale and the date of the first order?
Have you looked at Order Days Prior to Performance or Order Day Since Onsale?
As long as the Order Day Since Onsale is set with the day your packages go on sale the reporting should work I'd guess.
Is "order day since onsale" an option in the Seats and Tickets cube in Analytics? That sounds like exactly what I need, but it's a metric I'm not familiar with.
It is. If you put onsale in the search box it pops up. Would you mind sharing the whole screen shot so I can see how you built this curve? I'm interested in trying to replicate it (for use here and to help with your issue) and I can't figure out how to make it cumulative.
Here is my attempt to do something like this.
The sales curve for yesterday's Sales.
7128.HockyStickSalesChart.dash