Skip to main content
Interania

Column reference

0votes
1updates
2views

 

Column Description Can be used as Aggregator behavior How it's calculated
<column name> Numeric data column (int, long, decimal)
  • Measure
  • Compare group
  • Filter
  • Count Events: Count Events aggregator doesn't take a column
  • Count Unique: Count unique values of the column over the time range
  • Sum: Sum all values of the column over the time range
  • Average: Average all values of the column over the time range
  • Median: Take median of all values of the column over the time range
  • Minimum: Take minimum of all values of the column over the time range
  • Maximum: Take maximum of all values of the column over the time range
  • First: Return first value of the column over the time range
  • Last: Return last value of the column over the time range
  • Percentile: Return last value of the column over the time range
  • Ratios: You can use them in ratio metrics
  • Custom:
When data is added to Interana
<column name> String data column
  • Measure (Count Unique only)
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
When data is added to Interana
<column name> Lookup table
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
When data is added to Interana
<column name> Derived column created by users. See Derived column syntax reference.
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
At read time, according to the derived column definition.
__day__, __hour__, __minute__, __week__

Automatically generated time columns. These return the first second of the selected time period (minute, hour, day, week) in which the event occurred. 

See Time query syntax for more information.

  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
Interana automatically derives these from your event data.
 <metric name> Per-actor metric
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:

User-created per-actor metrics

   <metric name> Ratio metric
  • Measure
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:

User-created ratio metric

<session name>.<metric name> User-created session metrics
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<session name>.duration Virtual column auto-generated by sessions. Use to query the duration of the session.
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<session name>.event_count Virtual column auto-generated by sessions. Use to query the number of events that occurred during the session. 
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
 <funnel name>.current_state The most recent step that was reached within a funnel. This is calculated on a per-funnel instance basis. 
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<funnel name>.terminal_state The furthest step reached within a particular pass through a funnel. This is calculated on a per-funnel instance basis. 
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<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.
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<shard key>.<funnel name>.time_between.<step>.<step> 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.
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
<funnel name>_transition_time_to_current_state 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.
  • Measure
  • Compare group
  • Filter
  • Count Events: 
  • Count Unique:
  • Sum:
  • Average: 
  • Median:
  • Minimum:
  • Maximum:
  • First: 
  • Last: 
  • Percentile: 
  • Ratios:
  • Custom:
 
  • Was this article helpful?