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?
They'd normally be the data points in isolation but I've used the piece of Java from the forums to connect the blanks. I think it was Ragan's code.
Custom Catagories are easier than you might think. Similar to output set elements IMHO. I've got 3 constituencies in Custom Category 1 and it lets me select some/all/none for a Break By or Filter or what have you. It's great for looking at what NEW buyers are purchasing by Discount Price Type Category/Source vs Returning folks.