First Time Buyers from Previous Year Returning in 2023

Hello!

I know there are a number of resources for ascertaining the number of first-time buyers. I'm wondering if anyone has anything that gives the accurate number first time buyers from a specified year that returned this year? 

So, of the number of first-time buyers in <insert previous year here>, I want to know how many came in 2023. It doesn't necessarily matter if they came in another year between <previous year> and this year, just that their first time coming to the Festival was <previous year>. That said, if you have a way to get that number (# of first timers from <previous year> coming back for first time this year), I would not turn it down.

I've tried a couple ways to get at it, but I don't feel like the numbers are accurate. When I use the formula in a jump-to constituent dashboard, it just gives me all ticket buyers for the season, so it's not helping me verify. 

Any insight from this crowd is always greatly appreciated. Thanks!

-Michael

Parents Reply
  • Thanks, Kanani! Agreed that extractions are a great way to verify the accuracy of the number. My hope is to create a season recap dashboard, as there has been a long list of data requests for our 2023 season. I suppose I could create an extraction for first timers from each season, save those extractions to lists, then use the lists as filters? There's definitely more than one solution here. I appreciate you taking the time to respond.

Children
No Data