There are different ways to measure events in Interana. The measures you can use when building a query in the query builder (in the Visual Explorer) and when creating named expressions include basic counts (Count Events, Count Unique <column values>) and pre-built aggregators (sum, average, median). And once you create your own metrics you can use those, too.
Default aggregators and measures
The default aggregators and measures that you can use with queries and named expressions include:
|Count Events||A simple count of events matching the query.|
|Count Unique||A count of unique values within a column matching the query.|
|Sum||The sum of the numeric values of all results returned for a query. This aggregator is valid only for numeric data.|
|Average||The average (mean) value of a given parameter over the specified time period.|
|Median||The median value (50th percentile) of a given parameter over the specified time period.|
|Minimum||The lowest value that matched the query at any time over the specified time period.|
|Maximum||The highest value that matched the query at any time over the specified time period.|
|Percentile||The value at the selected percentile for a given parameter over the specified time period.|
|Ratios||Ratios divide the result of one measurement by the result of another.|
|First / Last||
The First and Last aggregators return the value of a given column with the smallest (First) or largest (Last) event timestamp.
You can use the First and Last aggregators to build queries and create named expressions. The First/Last aggregators are included in the Measure list for the following views:
For string columns, you can use the aggregators as measures with the Table view. You can also use decimal (float) data types with First/Last aggregators.
There are three types of metrics you can create, per-actor, ratio, and custom session metrics, and a fourth type of metric that is automatically created when you build sessions and funnels.
Per-actor metrics let you define and name a measurement for each actor, such as the number of times they performed an action. You can use these in the Query Builder under Measure to understand characteristics of different actors or under Filter to compare different subsets of actors based on ad-hoc criteria. You can create per-actor metrics in the Metrics tab.
Per-actor metrics calculate how many times an event occurs during a specified period of time. For example:
- How many times per day callers hang up while waiting on hold
- Number of users active out of a 7 day period
- Number of unique products a user has viewed over the last year
Interana displays per-actor metrics as
metric <metric name> in lists.
A ratio metric divides the result of one measurement by the result of another measurement. You can define ratio metrics for events occurring during a specified period time; when the numerator represents a subset of the denominator, the result is a percentage. You can create ratio metrics in the Metrics tab.
- New users who signed up this week versus those who signed up last week
- Emails opened versus emails sent per month, on a rolling basis
- Users who consumed a particular resource after viewing a webpage, compared to all users who viewed the page
Interana displays ratio metrics as an aggregation similar to Count Events in the Measure tab.
Custom session metrics
Custom session metrics are metrics you can create to apply to events which occur during a particular session.
- Number of purchases users made within their first login session.
- Unique webpages users went to in sessions which last more than 1 hour.
- How many error messages the user saw during their second attempted registration session.
Interana displays session metrics as
session <metric name> in lists.
These metrics are created automatically when you build sessions and funnels.
Automatic per-session metrics
Interana automatically creates two metrics for every session: a duration metric and an event_count metric. The duration metric is session_name.duration, and the event_count metric session_name.event_count
Interana displays auto session metrics as
session <session_name>.duration and
session <session_name>.event_count in lists.
Interana creates five metrics for each funnel.
- <funnel name>.current_state: This represents the most recent step that was reached within a funnel. This is calculated on a per-funnel instance basis. For example, if I had a funnel named myFunnel, where Step1 was Register, Step2 was Purchase, and Step3 was Log Off, events with myFunnel.current_state=1 would be all events that happened between Register and Purchase, including register and excluding Purchase.
- <funnel name>.terminal_state: This represents the furthest step reached within a particular pass through a funnel. This is calculated on a per-funnel instance basis. For example, if I had a funnel named myFunnel, where Step1 was Register, Step2 was Purchase, and Step3 was Log Off, and today I registered, purchased, and logged off, then all of my events from Register to Log Off would have myFunnel.terminal_state=3 since the furthest step I reached through this pass of the funnel was 3.
- <shard key>.max.<funnel name>.terminal_state: For each actor, if the actor passed through a funnel multiple times during the time range that you selected this metric shows you the furthest step that they reached in all of their passes through the funnel.
- <shard key>.<funnel name>.time_between.<step>.<step>: This is the time each actor took between steps, for any pair of steps in the funnel. If the actor made multiple passes through the funnel, this computes the average of those times.
- <funnel name>_transition_time_to_current_state: This is the amount of time it took to reach the step representing the current_state in the funnel pass from the step representing the previous state in the funnel pass. This is calculated on a per-funnel instance basis.
Interana labels these metrics as
funnel <metric name> in lists.
See Build funnels and funnel metrics and for detailed descriptions and examples.