Hello:
We are interested in tracking first-time buyers/attendees/donors to the Symphony. In List Manager I am able to make blunt lists per production that exclude any record with ticket history prior to the current concert.
However, I have not figured out how to get ticket/dollar amounts for first-time buyers in Analytics. I think I can fake it using Lists to filter, but is there a way to do it formulaically?
-- Mike
Hi,
This formula doesn't seem to do anything -
What am I doing wrong?
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].
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.
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!
Curious what the fix was for the 1900 issue? Would you be able to share that with us?
Alan