Hi there!
I was wondering if anyone has delved into the realm of calculating cumulative spending for patrons and had any success at it?
The reason I ask is that we rolled out a patron loyalty program three years ago that is based on cumulative spending (tickets, donations, etc) but we've only been able to do it manually thus far (which takes a while and will take longer in the future if we want the program to grow).
Any tips or tricks would be greatly appreciated!
Kari Litteer
Database Manager
Phoenix Theatre