Skip to main content

Metrics, measures, and aggregators


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:

Measure Description
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:

  • Time
  • Table
  • Number
  • Bar
  • Pie
  • Stacked Area Time

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-actorratio, and custom session metrics, and a fourth type of metric that is automatically created when you build sessions and funnels. 

Per-actor metrics

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.

Ratio metrics

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.

For example:

  • 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. 

For example:

  • 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.

Auto-generated metrics

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. 

Funnel metrics

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.

  • Was this article helpful?