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
Hello - we use a slightly different method if it is of use to anyone.
We figure out new to file constituents through extractions once we complete a dedupe of all ticket buyers at the end of a production, and for constituents who purchase non-subscriptions tickets only. We use extractions because analytics won't pick up orders unless the role of the order contains an owner role, and some of our subscription and single ticket orders are classified as recipients only.
Once we've done that, those constituents are given a unique attribute and we have used one of our custom categories to bring this attribute into analytics.
We've then got a very simple formula:
(sum([Ticket Count]), [Custom Category 03], [Days in Date])
Sum of the ticket count is self explanatory. This formula then narrows down to those constituents just with the unique attribute, and the days in date filter is formatted to be after the last date of the production season they purchased for. This formula is essence shows how many tickets customers who were new to file for a specific production have purchased subsequent to their initial purchase.
We can replace ticket count with value to look at the $$ value of these new to file constituents after their subsequent purchase. We then plot this visually:
We then use these same formula's to plot what production season constituents have purchased:
We also look at what price type groups and categories they have gone onto purchase. The price type category is particularly useful to us as it shows if new to file constituents who purchase single tickets have gone onto purchase a subscription.
There is a limit of 50 pieces of criteria that you can use in Sisense as a value, which we came across when trying to create a dashboard that plotted all new to file constituents back to 2014. We're now creating a dashboard per season to see what people are buying after their initial purchase.
JH.