Hello! I know there are a lot of questions about analyzing first-time buyers... what I'm trying to figure out is how I would build a dashboard to analyze the makeup of a particular performance or season: how many first-time buyers vs. returning visitors. Does anyone currently do something like this? And if so could you share your dashboard or setup? Thank you!!
Edited to add I'm hoping there's a non-SQL way to get there :)
Anh Le I've just used your formulas which are great to get a season by season breakdown of new/ returning bookers, thank you! If I wanted to then convert this into number of tickets bought by these cohorts / amount of ticket income from these cohorts, how would I do this?
Hi Melanie,
I tried to set that up but I'm way far from an expert in complicated formulas...I'll share what I use below, but if anyone sees errors in this, please help correct me!
Ticket Count from NTF audiences:
SUM ( [Constituent ID] ,IF (MIN( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0, [Total Ticket Count], NULL))
Revenue from NTF audiences:
same as above, I believe, but replacing ticket count with paid amount
Again, this might be way off! I'm enthusiastic about Analytics but still learning a lot.
Thanks Anh Le, I'll give that a try! Ditto enthusiastic about what Analytics can do but still learning on the go!