• Replies 9 replies
  • Subscribers 702 subscribers
  • Views 303 views
  • Users 0 members are here
Options
Related

Total number of first-time buyers for each perf?

Anne M Robichaux
$organization

Hello! I'm trying to set up a widget that will show each performance in a season and the number of constituents and/or tickets that came from first-time buyers. I found a post on the analytics forum with a formula from

that seems to work, but it shows each individual constituent. What I need is just a count per performance of first-time buyers -- I don't need to know who they are. Has anyone set something like this up?

Thanks!
Anne
The Historic New Orleans Collection

Parents
  • $organization

    Hi Anne,

    I believe the below formula is what you'd want to use is this below, for an aggregate count of new buyers by performance.

    Your dimension can be a performance id, season, or production.

    Formula to use for New Buyers:

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

    In my example, I have performance ID and code as my dimension. 

    My values are unique constituents and new buyers (formula above).

    Sounds like the formula that you were using might have been the IF clause only from the above formula.

    Hope this helps.

  • $organization in reply to Michael Moore

    My New Buyers column always shows zero (which I know not to be the case, testing against multiple perfs this season in multiple dashboards).  I clicked performance date and changed group by from years to days for Days in Date, and I got Days in First Perf Date from Constituent data and also changed group by from years to days. Days in Date seems like it could be ambiguous to this Analytics newbie, though I'm assuming I am comparing selected performance (first column label) date to constituent's first performance date, and if they are the same, the difference is zero, so they're New Buyers (so using performance date made sense to me)... Suggestions? 

     

  • $organization in reply to John Trimble

    Does First Performance Date populate for you correctly, when used outside of this formula? If not, you might need to tweak the code in the TX_ANALYTICS_DIVISON_ELEMENT system table. 

  • $organization in reply to Desiree La Vallee

    Desiree,

    Thanks for the suggestion.  Looks to me like it's pulling years fine, but maybe not days,  though TX_ANALYTICS_DIVISON_ELEMENT is pulling min perf_dt like I'd expect.    I'll run this by our consortium's Analytics whiz to find out if they get the same results. 

Reply Children
No Data