• 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
  • $organization

    Hey Anne,

    Was it  post here

    What's your First [Days In Date] represent? Performance Date?

    First Time:

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

    Because  [Days in First Performance Date] is a single value and lives in the constituent dimension it shouldn;t be being filtered.  So if you are getting odd results including people for whom this is not their first maybe throuw a row in there that is Customer ID &/or Performance Name and First Performance Name and track down some of the oddities. When I find a particularly odd specimen that is baffling me I usually try pulling parts of the formula into values or rows and seeing what unsuspecting results are coming out.

    I'm usually curious as to what people, including myself, mean by First Time Buyers. In this case is it that the difference in the performance date for this Production and the date of the first performance in their entire record is 0.  Just thinking about it in case this is their first purchase (ie: first and only order) with two performances (maybe the other is merch) and this is the performance with the latter date.  As this is their first and only purchase do they qualify?  In this case I'd want to know if this order date - their first order date is 0 days.

Reply
  • $organization

    Hey Anne,

    Was it  post here

    What's your First [Days In Date] represent? Performance Date?

    First Time:

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

    Because  [Days in First Performance Date] is a single value and lives in the constituent dimension it shouldn;t be being filtered.  So if you are getting odd results including people for whom this is not their first maybe throuw a row in there that is Customer ID &/or Performance Name and First Performance Name and track down some of the oddities. When I find a particularly odd specimen that is baffling me I usually try pulling parts of the formula into values or rows and seeing what unsuspecting results are coming out.

    I'm usually curious as to what people, including myself, mean by First Time Buyers. In this case is it that the difference in the performance date for this Production and the date of the first performance in their entire record is 0.  Just thinking about it in case this is their first purchase (ie: first and only order) with two performances (maybe the other is merch) and this is the performance with the latter date.  As this is their first and only purchase do they qualify?  In this case I'd want to know if this order date - their first order date is 0 days.

Children