• Replies 9 replies
  • Subscribers 700 subscribers
  • Views 157 views
  • Users 0 members are here
Options
Related

Is there a way to make "order weeks since onsale" dynamic?

Erik Dohner
$organization

Hi there! 

Preparing a subscription dash to compare YoY sub sales. 

Quick question for folks: do we know if there is a way to for the "order weeks since onsale" datapoint in the Ticketing Cube to be dynamic using a custom filter? Since it's not coded as an official date field, I don't know if this is possible. Alternatively, are there any other date fields used to dynamically track the number of days since the start of a subscription's sales to be used in a YoY comparison? 

Thanks a bunch for any advice the community may have!

-- Erik

Parents
  • $organization

    Those data points do have the 'custom' tab for them, so you could move beyond the default array of options. How would you describe your ideal setup for such a widget/dashboard? Maybe we can work backward from there.

  • $organization in reply to Nathanael Pearson

    Hey Nathanael -- thanks for the quick reply. 


    Ideally, I'd like to be able to use the field dynamically to compare current FY package metrics to previous FY package metrics at the same point since packages went on sale. E.G. how date fields can use the relational filter of "timeframe" to compare specific segments of time YoY. 

    I think we'd want a field + filter combo that does two things
    1. starts counting days or weeks at a specific start point in time YoY -- e.g when packages go on sale
    2. dynamically increases the inclusion of the field to count more days/weeks as we move forward in time from that specific start point.  

  • $organization in reply to Erik Dohner

    If the Performance setup is consistent, I know you can use 'Order Days Prior to Performance' as a metric- I've used that in the past.

    You also can use custom formulas to create "AND" conditions within those metrics. For instance, I've used "Show me dates from 1.1.24 - 12.31.24 that are ALSO WITHIN the last 365 dates, offset 1". In other words "Show me all the dates from Jan 1st of this year, that are also up through yesterday".

    This helps me keep a dynamic "This year, up through yesterday" filter going for Performance Dates.


    My thought is that you could set up something like that, to say "For X and Y Perf Seasons (a filter on the dashboard), show me all sales that happened between 2 and 10 weeks out from the performance (a filter using 'prior' metrics)".

Reply
  • $organization in reply to Erik Dohner

    If the Performance setup is consistent, I know you can use 'Order Days Prior to Performance' as a metric- I've used that in the past.

    You also can use custom formulas to create "AND" conditions within those metrics. For instance, I've used "Show me dates from 1.1.24 - 12.31.24 that are ALSO WITHIN the last 365 dates, offset 1". In other words "Show me all the dates from Jan 1st of this year, that are also up through yesterday".

    This helps me keep a dynamic "This year, up through yesterday" filter going for Performance Dates.


    My thought is that you could set up something like that, to say "For X and Y Perf Seasons (a filter on the dashboard), show me all sales that happened between 2 and 10 weeks out from the performance (a filter using 'prior' metrics)".

Children
No Data