The Running Interval tool can be used to calculate custom running calculations. It can generate simple columns like 30 days running profit, but also other way cooler things like a delayed customer acquisition cost metric.

Configuration: Sum, Revenue column, offset -2, lookahead 3

If you’re looking for more advanced ways to do row-wise calculations check out the Compare, Multi Row, Cumulative or Difference tool

​
Configuration

The Running Interval tool has of five required input.

1

Input Column Name

The Running Interval tool will create a new column. Use this input to name it.

2

Select Column

Select the column you want to use for a running interval calculation.

3

Input Offet

Input where you want your calculation to begin. Think of this as the row from your current row that your calculation should being. If you input -1 your calculation will always be calculated from your current row - 1 (understood vertically in your dataset).

4

Input Lookahead from Offset

Input how many rows you want to lookahead (or down in your dataset) from your offset. You can understand this and the previous input as creating a rolling range of data that you consider relevant.

5

Select Aggregation

Select how you want to aggregate the range that you have created with your offset and lookahead input.

​
When To Use

The Running Interval tool is great when you have data this is aggregated by day, week, month or year. With that data structure you can create a range of useful analyses:

  • Remove daily sales spikes and variance by creating a 30-day rolling average
  • Creating custom windows for analysing marketing impact on present day sales, conversions, impression. Perhaps your top-funnel initiates have an influence on sales 2 months from now - the Running Interval tool can help you find it.
  • Rolling e-commerce customer engagement metrics (conversion, pages, cart abandonment rate) to track momentum in your customer engagements

​
Examples