I'm curious what other organizations use for analyzing the effectiveness of their promo codes. There doesn't seem to be one canned report that has all the info we would want that I can limit to just ticket buyers with a specific promo code. Looking to get: # of tickets purchased and the total cost, organized by the promo code, for multiple promos/shows at a time.
Let me know if you have come up with any solutions for this.
Thanks,Maia
Hi Maia,
Have you tried this in TStats? I do promo ROIs there fairly quick. On the right; measures like #tickets and paid amount. On the bottom source code, production, etc
I can walk you through it if you need.
Thanks, Heath. We actually don't have TStats anymore since we upgraded to V14.1, but thank you for the advice!
In that case I often use the Performance by Appeal to keep marketing at bay. You can output individual Perfs or Perf Season to Excel and Pivot it.At the moment though (because I'm having troubles with Facebook Login stripping Source Codes at the Order Level) I'm going into SSMS and doing Source Code Analysis joining T_ORDER and T_LINEITEM. It's much easier than it sounds and is essentially what T-Stats is doing It'd be a simple report to write if I wasn't so lazy.
I just took the Performance by Appeal report and modified it slightly to look at Lineitem source number rather than order source number. Took me almost no time at all and works like a charm.
Challenge accepted! ;-)
Thanks John great idea