I'm having a block. I was trying to find First Time Buyers or those folks who have not attended in the last 5 years. So I did a simple list looking at the Ticket History Perf Date (and I've done with unique perf =>1 and another without).
I then take that list and create another list of this FY performances and ask for those that does not have the list of prior ticket buyers.
However, when I run it in T-stats, I'm still finding folks in the list that have prior ticket purchases in the 5 years I thought I was suppressing.
What am I missing? Is it because history doesn't have the future performance dates yet? Thanks
Leslie McKinley said:consistency also a problem
No kidding.
Finding FTBs can almost be considered an impossible task, imho, E.g. the topic always reminds me of my mother, a Guthrie theater patron since 1963, who didn't have the equivalent of a constituent record here until 1997. If she had received some sort of FTB acknowledgement at the time she would have laughed.
Not to mention dupes: how sure are you that this "new" patron doesn't already exist in your database in some form?
Food for thought...
Exactly! The dupes are where we always get tripped up. We do have some semblance of a "first time buyers" report- my notes on it read: "For given season and performance date, returns a list of customers who are new ticket buyers to the organization as of that performance date. " But, of course, someone who created a new account on our website to buy tickets will be considered an FTB by this report, unless our auto-merge procedure catches them first.