How to Create a Reusable Conditional Metric for Event Counts in Your Analytics Platform
hi! I’m trying to create a reusable, shareable metric that applies conditional logic to an event count. Specifically, I want something like: IF(Count of "CREATED", Last 90 days > 3, 1, 0) Here’s what I’ve found so far:
- 1.
From theUsers tab, I can create aBehavioral Propertywith the event condition I need (event count over last 90 days), but this only has an “Apply” option — it doesn’t seem to save as a reusable/shareable entity, it only applies locally to that report.
- 2.
I was able to save the event count as a simpleMetric/Behavior, which does appear in Lexicon and can be reused across reports.
- 3.
However, when creating aCustom Property(which supportsIF()formulas), the component picker only lets me selectuser/profile properties— not saved metrics or event-based behaviors — so I can’t build the IF condition on top of my event count there.
Is there a way to:
Save a Behavioral Property (from Users tab) as a reusable/shareable entity, and/or
Apply an IF/conditional formula to a saved event-count metric or behavior, so the result (0/1) can be reused across multiple reports (Insights, Funnels, filters, etc.)?
