• Replies 17 replies
  • Subscribers 964 subscribers
  • Views 1748 views
  • Users 0 members are here
Related

First-Time Buyers in Analytics?

Mike Mariano
$organization

Hello:

We are interested in tracking first-time buyers/attendees/donors to the Symphony. In List Manager I am able to make blunt lists per production that exclude any record with ticket history prior to the current concert.

However, I have not figured out how to get ticket/dollar amounts for first-time buyers in Analytics. I think I can fake it using Lists to filter, but is there a way to do it formulaically?

-- Mike

Parents
  • $organization

    Hi,

    This formula doesn't seem to do anything -

    What am I doing wrong? 

  • $organization in reply to Phillip Mapes

    Phillip,

    Are you clicking into and filtering the Days in Date & Days in First Performance Date?

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

    To get the amount attributable to first-timers:

    sum ( [Constituent ID] ,
    if ( MIN ( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0
    , MAX ( [Total Ticket Paid Amount] )
    , NULL
    )
    )

    To take this below one step further, how would I get it to show as a percent?

    In this case it's a unique count of constituents, but that COUNT could be swapped with a SUM and the MAX ( [Constituent ID] ) replaced with [Total Ticket Paid Amount] to instead show the amount attributable to first-timers.

Reply
  • $organization in reply to Phillip Mapes

    Phillip,

    Are you clicking into and filtering the Days in Date & Days in First Performance Date?

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

    To get the amount attributable to first-timers:

    sum ( [Constituent ID] ,
    if ( MIN ( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0
    , MAX ( [Total Ticket Paid Amount] )
    , NULL
    )
    )

    To take this below one step further, how would I get it to show as a percent?

    In this case it's a unique count of constituents, but that COUNT could be swapped with a SUM and the MAX ( [Constituent ID] ) replaced with [Total Ticket Paid Amount] to instead show the amount attributable to first-timers.

Children
No Data