Hi,
I'm trying to measure loyalty using New vs Existing bookers in Analytics.
Has anyone got any idea's on how to do this?
I'm trying to create a formula using the Constituent > First Performance Date and the current date, but it's not working for me.
I'm trying to do it in my Year on Year dashboard so that's making it a bit more complicated.
What I'd like is something like the following (in a stacked column chart):
Year New Bookers Existing Booker s
2019 55% 45%
2018 57% 43%
2017 58& 42%
If anyone has any suggestions or other ideas on measuring loyalty it would be much appreciated.
I'm also thinking about a measure for 'Years since first performance', so measure more in depth, but one step at a time!
thanks,
Dara