Hello! I hope someone can help point me in the right direction. I've been asked to provide some historical stats about our patrons. It seems I should be able to accomplish this with a dashboard- but I'm honestly not sure where to start with each widget.
1 - How many single ticket buyers (not subscribers) saw more than 1 production last year? In 2018/19?
2- How many single ticket buyers (not subscribers) saw more than 1 repertory production in the same week last year? In 2018/19?
3 - Many of our patrons live here seasonally. How many of our patrons are here (or have an active address) in June? July? August? September? Also, these numbers should be broken down by subscribers vs single ticket buyers.
Here's a screenshot of my widget that would answer the first question. You would just need to add a filter of price type category to filter out subscribers (or perhaps another filter type if you have your subs flagged in some other way.)
Thank you! Can you talk me through the formula a bit? So, is a sum of people who saw 1 unique performance and another? I don't understand the "=1,1,0" part. Sorry-- this is all kind of Greek to me.
It is basically saying, if the number of unique performances = 1, then return a 1, if not return a 0. This is all wrapped up in a Sum function that groups by constituent id. It is a method to count how many of thing match a situation. The concept is called bucketing. In Kanani's example, the column that is 2, Kanani changed the one part to = 2 instead of = 1.
What Neil said. And so you would copy that formula for each value and edit to have one for 2,3,4 etc until you have the number of shows in your season.
Got it! Thank you!
OK - it's late in the day...and perhaps this is way easy. How do you find out WHO those people are. Who are the 30 Constituents who have been to 6 Perfs? Thanks!!
Mark, you can add in a name field (sort name perhaps) to the rows section but it's going to look funky because this is built to return a 1 or 0 in order to count up the different show quantities. I would recommend build out a different widget if you're wanting to identify names and how many shows each person attended. # of unique performance id would be the value. Sort name and constituent ids would be your rows.Usually when people want to know "who?" they're really wanting to send those people something, so I would recommend building an extraction instead.
Here's a peek out how to make a multibuyer segment
Looking at #3 on my list-- we collect this data on every mailing address because we have a number of "snow bird" patrons who only live in Florida part of the year. But I don't know how to extract this data for a list or report.
When you do an extraction, the header has a place for the mailing date. I believe that will tell it which address to pull based on those settings in the constituent record.