• Replies 9 replies
  • Subscribers 962 subscribers
  • Views 478 views
  • Users 0 members are here
Related

New subscribers widget

Anh Le
$organization
Hi everyone,
 
I’m sure there is a simple way to do this that my brain just isn’t thinking of at the moment… If I want to build an indicator widget that shows how many of my current season subscribers are new subscribers (but not necessarily new to file), has anyone done that and might have recommendations?
 
Thanks for your help!
Anh
 
signature_1078652768
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
facebook icon twitter icon youtube icon linkedin icon instagram icon 
 
Parents
  • $organization
    Hi Christine and Kathleen,
     
    Thank you both for these ideas! I have tried both but the data is super different.
     
    From Christine’s idea, I changed package seat key to constituent ID since I am looking for the number of households, not the number of packages purchased, and using that method I got 133 new subscribers.
     
    ( [# of unique Constituent ID], [Solicitor Display Name] )
     
    Then using Kathleen’s idea, I tried the following formula and only got 2 new subscribers…but maybe my formula is wrong?
     
    COUNT ( [Constituent ID] ,
      IF (
        [# of unique Package Season] = 1 , 1 , 0
        )
    )
     
    The last thing I tried to double check these numbers was to pull a list in List Manager of anyone with package history in this current season, and “does not have” history in any previous package season. The number List Manager gave me is 20.
     
    Do either of you (or any others) have any ideas on where I should go from here? Many thanks in advance for your help!
     
    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
    Hi Christine and Kathleen,
     
    Thank you both for these ideas! I have tried both but the data is super different.
     
    From Christine’s idea, I changed package seat key to constituent ID since I am looking for the number of households, not the number of packages purchased, and using that method I got 133 new subscribers.
     
    ( [# of unique Constituent ID], [Solicitor Display Name] )
     
    Then using Kathleen’s idea, I tried the following formula and only got 2 new subscribers…but maybe my formula is wrong?
     
    COUNT ( [Constituent ID] ,
      IF (
        [# of unique Package Season] = 1 , 1 , 0
        )
    )
     
    The last thing I tried to double check these numbers was to pull a list in List Manager of anyone with package history in this current season, and “does not have” history in any previous package season. The number List Manager gave me is 20.
     
    Do either of you (or any others) have any ideas on where I should go from here? Many thanks in advance for your help!
     
    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

    Hi Anh,

    The formula I shared would also included lapsed - essentially anyone who is not a renewal in the current season.

    Kathleen's formula would get you more towards first time buying a subscription ever. Try changing your "Count" to a "Sum"? Looking at my notes for multi-pass aggregations it seems to usually use a sum.

    ~ Christine