• Replies 10 replies
  • Subscribers 703 subscribers
  • Views 468 views
  • Users 0 members are here
Options
Related

Percentage of First Time Buyers

Jean Leonard
$organization

Hello! I know there are a lot of questions about analyzing first-time buyers... what I'm trying to figure out is how I would build a dashboard to analyze the makeup of a particular performance or season: how many first-time buyers vs. returning visitors. Does anyone currently do something like this? And if so could you share your dashboard or setup? Thank you!!

Edited to add I'm hoping there's a non-SQL way to get there :)

Parents
  • $organization
    I have a bar chart for this that operates as follows (screenshot below) with these formulas – I hope this helps!
     
    NTF:
    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
        )
    )
     
    Chart, bar chart Description automatically generated
     
    Anh Le (she/hers/hers)
    Director of Marketing & PR
    OPERA THEATRE OF SAINT LOUIS
    email: ale@opera-stl.org
    phone: 314.963.4294 | mobile: 760.834.5926
    210 Hazel Ave St. Louis, MO 63119
     
     
Reply
  • $organization
    I have a bar chart for this that operates as follows (screenshot below) with these formulas – I hope this helps!
     
    NTF:
    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
        )
    )
     
    Chart, bar chart Description automatically generated
     
    Anh Le (she/hers/hers)
    Director of Marketing & PR
    OPERA THEATRE OF SAINT LOUIS
    email: ale@opera-stl.org
    phone: 314.963.4294 | mobile: 760.834.5926
    210 Hazel Ave St. Louis, MO 63119
     
     
Children
  • $organization in reply to Anh Le

    I was curious if anyone might have a formula for lapsed buyers that are returning?  An example would be patrons who were active through 2019, skipped over a few years with no purchases, but came back and purchased this year.

     helped me get going with a formula going like below where it was dependent on the fiscal year offset (where in the fiscal year offsets you need to change the filters).  

    SUM ( [Constituent ID] ,
    IF (
    (
    ISNULL( ( [Total Ticket Count] , [Season Fiscal Current Year Offset between -4 and -1] ))
    OR ( [Total Ticket Count] , [Season Fiscal Current Year Offset between -4 and -1]) = 0
    )
    AND ( [Total Ticket Count] , [Season Fiscal Current Year Offset < -4]) > 0
    , 1
    , NULL
    )
    )

    I am wondering if anyone uses something similar for re-engaged buyers or something different from the above.  I've noticed this doesn't always work in returning data for me.

    Thanks