Targets are typically used for Budgets and Forecasts, and tied to specific metrics. You may add more than one target to your workspace.

Everyone

View targets

Admins

Set up targets

Set up targets

Prepare your targets data

You can set up targets by registering a target table from your database. Steep will read targets from this table and match them to the corresponding metrics by name. The target table needs to follow a certain format for it to work.

Target table format

ColumnExample valueTypeDescriptionRequirement
seriesBudget 2022StringTarget series namerequired
metricregistrationsStringMetric identifierrequired
time2022-04-01Date or TimestampTarget daterequired
value20000NumericTarget valuerequired
dimensionCountryStringDimension nameoptional
dimension_valueUKStringDimension valueoptional

The target table needs to match the format above to be read correctly. Each row in the table corresponds to a target data point for a specific metric.

The series name can be used to set up parallell target series, e.g. ”Budget”, ”Budget v2”, ”Stretch goals”, that users can switch between.

The metric identifier is used to specify the metric and corresponds to a lower-case-and-hyphens version of the metric name, e.g. a metric named ”Organic Regs” has the identifier ”organic-regs”.

The time column is used to specify dates that represents the start date of each period depending on the time grain. For example 2022-04-01 for April on a monthly time grain or 2022-04-04 for Week of Apr 4 on a weekly time grain.

Targets can optionally be defined for one or more dimension values. Include dimension and dimension_value in your table to define targets for a specific dimension value. It is possible to define targets for metric total in parallel with multiple dimensions and dimension values for the same target series and metric.

Time grain

Steep will automatically interpret the time grain of your target series. This is done by looking at the difference between the first two dates in each series. You can always double check that the correct time grain was interpreted by looking at the target settings page.

Note: Steep does its best to aggregate/average the defined target data between time grains dynamically so that the user always gets a target line on their chart regardless of time grain. However, this is currently not possible for Custom value and Unique count metrics. For those metric types, we recommend defining the target data in the time grain in which the metrics will be most commonly viewed.

Registering the table

Start by going to Settings / Targets

Settings → Targets

Pick a table with the format described above.

Caching

Target data fetched from your targets table will be cached by Steep for 1 hour. In the rare case that you want to clear the cache after a major change to the source data, you can do that manually by changing your targets table setting eg. by removing it and adding it back.

Add targets to widgets

Once you have your targets table registered you can choose to add your target to a widget on your home screen. Learn how to add a Target to a widget.

Add targets to metrics

Targets automatically show up for all metrics with a matching name

View targets

Once set up everyone can see how your metrics perform against a target while exploring a metric...

Targets over a metric

...and for widgets when the target is toggled on.

Target in a widget