• Replies 1 reply
  • Subscribers 962 subscribers
  • Views 56 views
  • Users 0 members are here
Related

Exporting NTF widget to list

Anh Le
$organization
Hi everyone,
 
I am looking for some help on how to save a number indicator of unique constituent IDs to a list.
 
I frequently use the following formula to determine NTF buyers for any given production/season/year:
 
COUNT ( [Constituent ID] ,
  IF (
    MIN( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0
    , MAX ( [Constituent ID] )
    , NULL
    )
)
 
However, when I enable the “jump to constituent” drill level, it is impossible for me to save the NTF segment as a list for future re-targeting. Instead, it shows all constituents in the entire production/season/year regardless of NTF/returning status. For example, if I had 2,000 NTF buyers in a season but 4,000 total buyers, the “jump to” shows me all 4,000.
 
Does anyone have a workaround for this from within Analytics? (I’m hoping not to have to recreate this work in an extraction.)
 
Thanks!
 
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 
 
  • $organization

    I believe it's the case that jump-to's don't filter constituents from formulas, only widget filters. In other words, the formula will display the correct numbers, but the jump-to won't reflect the formula list, but only the filters on the widget list. 

    My first thought is to filter the widget by that formula you created (set it to > than 0, or something), then try again.