Hi,
I'm trying to find out how long time passes between visits on average, if it´s for example 3 years that lapse between visists for our average constituent. The background is that I wan't to set a definition for when we count a constituent as a lost customer. Preferably I'd like to do this in Analytics, but I can't figure out how. Does anyone have a solution to my problem?
Thanks,
Sofia
Returns this:
I updated my comment above. I had MIN and MAX reversed, subtracting MAX from MIN rather then the other way around.
With the MIN/MAX reversed, I get this:
The only filters I have on the widget are for 'Performance Year '= 2019, 2021, and 2022, and 'Title' = GA, but those don't affect the numbers much.
Would you add a filter on the widget for Attended Date as well, or for Attend Flag = Y please? I think we're seeing some Attended Date = 1900-01-01 slipping into the widget. This is the date on the attendance when they did not attend. So if they attended last year, and a ticket this year that has not been marked as attended, then it'll take the attended date from last year and subtract the 1900-01-01 date as the MIN attended date.
A good point!
That does drop the numbers considerably, which is good. I'll keep poking at this one, but as it stands, the numbers seem viable- 2021 is an outlier here, but the formulas look good.
Thank you, sir!
Hi Chris Wallingford if I wanted to break down fiscal year by artform would each row show me the days between visits for that artform specifically ie for Visual Arts would the results give me the days between a constituent's visits for that artform only?
Yes Ogo,
The formula would still take the MIN/MAX date for each constituent, but within each artform within each fiscal year.
Cheers
Thanks!
Chris Wallingford Hi Chris - If I'm looking to see the average time between orders and or attended performances would you still recommend using the .dash that is in this thread? Also, something I want to look at closely, is the time between orders for our more popular productions vs our less popular productions. Would you recommend filtering by production season or a list id of constituents for that? If I do filter by list or production season, would I need to ALL() any of the formulas?Thanks,
Mike
Hi Michael,
A quick review and that dashboard still works as expected. You can also check out (+) Repeat Cycle - Reporting & Analytics - Forums - Tessitura Network.
If I'm remembering correctly, this is about repeat buyers, so just double checking that you'd be looking for repeat buyers within your most/least popular productions. If so, Production probably, rather than Production Season, as the latter is usually restricted by Season. If the Production Seasons are named identically across seasons, then it's probably okay so long as either Season is not included in the filters, or includes many Seasons-worth of the given Production Season, or ALL([Season]) is used in the appropriate place of a formula to override a higher level instance.
Generally, if it can be done without a Lists filter in Analytics, I avoid using Lists due to the lag between Tessitura and Analytics on their refresh, and that the Lists have to be refreshed via scheduled list generation in order to be updated in Analytics.