• Replies 17 replies
  • Subscribers 966 subscribers
  • Views 1335 views
  • Users 0 members are here
Related

Booking churn Subscribers in Analytics?

Josefin Johansson
$organization

Hi, 

We are looking into the booking churn for our subscribers at Malmo Opera.

Parameters we want to look into on a seasonal level:

  • How many are returning subscribers season after season?

             In what packages? Other patterns?

  • How many are new subsribers per season?

             In what packages? Other patterns?

  • How many drop offs per season?

             In what packages? Other patterns for drop offs?

Anyone got any tips and tricks on how get started with this in Analytics, reports or in List Manager/ Extraction Manager?

We dont know if Analytics is the right place for this since there is no Data set for Subscribers?

 

Thanks a lot for your help!

Josefin

Parents
  • $organization

    - this has been a huge help for my organization - thank you for providing both the dashboard and chart.
    I was wondering if you know how I can get the same new/returned/lapsed/churn information, but instead for the total number of subscription packages, instead of constituents? I've tried different formula options, but I can't seem to find one that works. Thanks in advance!

  • $organization in reply to Amy Culliford

    So this is great!  One more question:  i am trying to find which subs from 2020 and 2021 didnt renew in 2022 but bought single tickets to performances in the 2022 season.  Which dashboard would be best for that?   I have imported all the dashboards and they all have great info but not sure I am seeing exactly what i need quite yet.  This might be just a simple adjustment of a formula.  Unfortunately, I am pretty darn new at this so thanks for all the help!  

  • $organization in reply to Robert Bass

    Hi Robert,

    I think we'd just add a couple of conditions to the Returned formula above...

    IF ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2020] ) > 0
     AND ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2021] ) > 0
     AND ISNULL ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2022] ) )
     AND ( [Total Ticket Count] , [Season Fiscal Year=2022] ) > 0
    )

    ...if they have packages in 20 and in 21, and not in 22, and otherwise have tickets in 22... Does that sound right?

  • $organization in reply to Chris Wallingford

    That sounds exactly right!!!!

  • $organization in reply to Chris Wallingford

    I am getting a syntax error when I replace the formula in the returned 

  • $organization in reply to Robert Bass

    Yes Robert, sorry, I used some shorthand in my reply... the full formula would be

    SUM ( [Constituent ID] ,
      IF ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2020] ) > 0
    AND ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2021] ) > 0
    AND ISNULL ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2022] ) )
    AND ( [Total Ticket Count] , [Season Fiscal Year=2022] ) > 0
  )
  , 1
  , NULL )
)

    And unfortunately copy / paste from the text here into the formula editor will not work. A valid formula in the text editor is much more than the text that's visible, and pasting this text into the formula editor doesn't include that additional information. Instead it needs to be recreated in the formula editor. 

  • $organization in reply to Chris Wallingford

    So Ive tried to recreate this a number of times.   I always get an error.  First, if i add that last ) after the NULL line, I get "Function Syntax Error:  End of formula expected.  ')' found instead.   If i delete that last ')' , I get a different error that I will attach below.   I am not sure if i need to type the [Season Fiscal Year =2020] or if editing the filter and selecting 2020 and so on works.   Same with the Package ID >0.   I just used the filters.  Thanks for your help!  I am sure this is something i am simply doing wrong.   

Reply
  • $organization in reply to Chris Wallingford

    So Ive tried to recreate this a number of times.   I always get an error.  First, if i add that last ) after the NULL line, I get "Function Syntax Error:  End of formula expected.  ')' found instead.   If i delete that last ')' , I get a different error that I will attach below.   I am not sure if i need to type the [Season Fiscal Year =2020] or if editing the filter and selecting 2020 and so on works.   Same with the Package ID >0.   I just used the filters.  Thanks for your help!  I am sure this is something i am simply doing wrong.   

Children