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?
Order date would work perfectly! My stumbling block there is getting the season curves to stack and setting the first order date to "day 1" for each year. Do you know if that's possible? Basically I want to see "we did $$ in sales last year vs this year on day 1" etc and see how they all grow on the same scale.