Customer Loyalty. New vs Existing Bookers in Analytics

Dara Hogan $organization over 6 years ago

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

Parents

Gary Halliday $organization over 6 years ago

Hey Dara,

I have made an analytics customisation for this, if you’re self-hosted I can share it with you?

Cheers,

Gary

Halliday

Head of Business Systems

020 3973 5200 (Ext 200)

The Roundhouse is a hub of inspiration where artists and emerging talent create extraordinary work and where young people can grow
creatively as individuals. We believe in the power of creativity to change lives. By giving young people the chance to engage with the arts through our
music, media and performance projects, we inspire them to reach further, dream bigger, and achieve more.

Roundhouse Trust registered office: Roundhouse, Chalk Farm Road, London NW1 8EH. A company limited by guarantee. Registered in England and Wales. Company number 3572184. Charity number 1071487. This message is private and confidential. If you've received it in error, please notify us and remove it from your system.

Reply