• Replies 10 replies
  • Subscribers 701 subscribers
  • Views 365 views
  • Users 0 members are here
Options
Related

First time vs returning ticket buyers

Anne M Robichaux
$organization

I'm trying to look at first time vs. returning ticket buyers. I can't remember where I got these formulas from, but they seem like they should work. However, people who are most definitely not first time ticket buyers are being counted in that list. And some are showing up on both lists! Do I need to add filters to the forumulas?

First Time:

COUNT ( [Constituent ID],
IF (
MIN ( DDIFF ([Days in Date], [Days in First Performance Date] )) =0
, MAX ([Constituent ID])
, NULL
)
)

Returning:

(Count ([Constituent ID])) - (COUNT ( [Constituent ID],
IF (
MIN ( DDIFF ([Days in Date], [Days in First Performance Date] )) =0
, MAX ([Constituent ID])
, NULL
)
))

I have the widget filtered to the specific performance. 

Anne

Parents Reply
  • $organization in reply to Anne M Robichaux

    Hi Anne,
    I think you might have already done this, but have you tried looking at a performance and then selecting for your dimension, constituent ID, and then using the formula below to indicate if they are considered new by generating a flag of '1' if they are new?  This might help troubleshooting and finding the constituent records that are being problematic: 

    IF (
    MIN( DDIFF ([Days in Date] , [Days in First Performance Date]) ) = 0
    , MAX ( 1 )
    , NULL
    )

    Where [Days in Date] is looking at performance date above. You could probably also copy the same formula and use a >0 to indicate those that are returning. 

    This here is my bookmarked thread on new vs returning as there are some great insights from Chris W on this topic.

    First-Time Buyers in Analytics? - Reporting & Analytics - Forums - Tessitura Network

Children