First-Time Buyers in Analytics?

Hi Mike,

If the default or configured definition for the CONSTITUENT element [First Performance Date] is an accurate enough reflection for your definition of First in this case, then we can compare that to the ticketed performance dates to determine who is a first-timer. 

The formula varies a bit based on the desired output, but if you're in a Pivot widget with Constituent ID on Rows, then a formula like this will flag up first timers:

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

One could then filter the widget on that Value where it equals 1 to see only the first-timers in the results.

If that needs to be aggregated up to a higher level, like the [Performance Date and Time] or [Production Season], then the formula needs to be couched in Multi-Pass Aggregation. 

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

In this case it's a unique count of constituents, but that COUNT could be swapped with a SUM and the MAX ( [Constituent ID] ) replaced with [Total Ticket Paid Amount] to instead show the amount attributable to first-timers.

There are not currently corollary [First Gift Date] and [First Order Date] CONSTITUENT elements in Analytics, but one could add them using the available [Custom Date 01-10] fields.

This is the help page that references CONSTITUENT element configuration: Tessitura v15.1 Help System - TX_ANALYTICS_DIVISION_ELEMENT

And Part 2 starting around 14:00 has some further details with a specific example starting around 20:00: Tessitura Analytics Technical Overview

Thank you, Chris!

Hi,

This formula doesn't seem to do anything -

What am I doing wrong? 

Phillip,

Are you clicking into and filtering the Days in Date & Days in First Performance Date?

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

To get the amount attributable to first-timers:

sum ( [Constituent ID] ,
if ( MIN ( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0
, MAX ( [Total Ticket Paid Amount] )
, NULL
)
)

To take this below one step further, how would I get it to show as a percent?

In this case it's a unique count of constituents, but that COUNT could be swapped with a SUM and the MAX ( [Constituent ID] ) replaced with [Total Ticket Paid Amount] to instead show the amount attributable to first-timers.

Hi Phillip,

The IF statement by itself only works when evaluated per constituent (grouped by Constituent ID). To use it at a Season level requires doing the constituent level evaluation within the formula via Multi-Pass Aggregation. So you will need to implement the second formula from my previous post...

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

Cheers.

Hi Chris.

I'm receiving an error 'function IF does not accept 2 parameters'

Also, I can't seem to find [Days in Performance Date]

If I select performance date, then change from years to days it changes to [Days in Date].

Hi Phillip,

The formula in your screenshot is missing this line:

    , MAX ( [Constituent ID] )

[Days in Date] is correct if it is the [Date] field from the [PERFORMANCE DATE] dimension. I renamed it [Days in Performance Date] to try an clarify which [Days in Date] I was using, but I confused matters. That to say, you have that right.

Cheers.

Hi Chris, the formula was correct... you can't expand the window to show the whole query.

It turns out that TX_ANALYTICS_DIVISION_ELEMENTS hadn't been configured correctly and was showing all data as 1900. We've now corrected this and my first timer data is correct.

Thanks,

Phillip 

Hi again,

Is there an easy way to see percentage of new bookers?

I've tried this:

But get this:

It looks like maybe this is just an order-of-operations issue? Move the final ")" to before the division "/".  

That's worked!

Thanks Chris

Hello Phillip, 

What did you have to change in the TX_ANALYTICS_DIVISION_ELEMENTS table? I think I could be experiencing the same issue.

Thanks! 

Hi Phillip, 

Curious what the fix was for the 1900 issue? Would you be able to share that with us? 

Thanks, 

Alan 

Hey Chris,

I've popped in the below formula to try and get an overall number of new to file constituents:

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

My dashboard filters are production season, price type to not include comps, and a price type category filter as I only wish to look at non-subscribers.

I've then done a sense check on the returned constituents, and looking at some of their ticket histories, they have performance dates prior to the production season they are listed as a new to file for. Any idea where I might be going wrong?

Thanks,

JH.

Hi Jerry,

To confirm, these constituents have performance dates in ticket histories that are not comps and not subscription tickets?