• Replies 10 replies
  • Subscribers 703 subscribers
  • Views 470 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
    Hi Hannah,
     
    I could be wrong, but my understanding is that in your proposed scenario, someone who attended first in 2019 would not show up as a new household within the 2022 season. I think this just looks at the first record of attendance, regardless of lapsed history in between seasons.
     
    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
     
     
  • $organization in reply to Anh Le

    I initially thought so too, however our 22 season is pulling more returning buyers than the NTF within one season. 

    Formulas are as follows

    # NTF

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

    # of Returning

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

Reply
  • $organization in reply to Anh Le

    I initially thought so too, however our 22 season is pulling more returning buyers than the NTF within one season. 

    Formulas are as follows

    # NTF

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

    # of Returning

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

Children
  • $organization in reply to Hannah Wright

    Hi Hanna,

    The best way to audit this might be to create a pivot widget filtered to that season, with Constituent ID on rows, and a value for:

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

    Then from that value, hover and filter the widget to just the 1s and see how many rows (constituents) you have. Spot check some constituents in Tessitura. Then flip the filter to just the 0s and see how many rows you have, and spot check again.