Hi everyone, hoping I can describe what I'm looking for and someone has a reporting solution for this -
Like many performing arts orgs, we have a couple of artist partners that we book regularly, if not every season maybe every other season. I would like to figure out which of those recurring engagements create the most return buyers - whose audiences are most likely to come back again? I've been playing around a bit with the First Performance Date and Name parameters in Analytics and for a current performance I've been able to report on which past shows those ticketbuyers first came to, and I'm sort of trying to turn that on its head and look at it as a future question - which events now are likeliest to have their audiences come back, based on the previous times those ensembles have been with us. Is there a way to do this in Analytics? Anyone have a custom report to share? We also have JCA's RMA if that would be relevant.
Thanks in advance for your help with my thought experiment!
I expect there are a lot of lists in your future. Just remember that Analytics lists are not regenerated, even if dynamic, by being used in an Analytics load.
Hi Erin,
For a set of such partners, I'm envisioning their productions (spanning FY, so not what would typically be a production season) on rows of a pivot, and values that bin constituents by the unique count of season FY in which they attended that partner's event. The values would have formulas similar to the following. Here's the formula for a count of constituents who attended in only one FY, followed by those attending in 2 or 3.
SUM ( [Constituent ID] , IF ( [# unique Season Fiscal Year] = 1 , 1 , 0 ) )SUM ( [Constituent ID] , IF ( [# unique Season Fiscal Year] >= 2 AND [# unique Season Fiscal Year] <= 3 , 1 , 0 ) )
Thanks for the reminder!