Original target format no longer supported

As of October 1st, 2026, all workspaces use the upgraded version of targets. If your targets table is still in the original format, your targets may show errors, be missing from charts or show incorrect values. Follow this guide to create a new targets table in the updated format and connect it to Steep.

Targets overview

The upgraded targets in Steep are smarter and more dynamic to analyze and edit. You can:

  • Add a combination of multiple dimensions to a single target, like iOS users and US.
  • Break down and compare ratio targets seamlessly.
  • Add more consistency to your targets thanks to unique metric identifiers, assigned to each metric.

Learn more about the benefits of the upgrade in our release notes.

Migration steps

  1. Create a new target table in the updated format.
  2. Select your new target table in Steep.

1. Create a new target table in the updated format

If your targets table was created before March 2025, it is likely in the original format. See how to recognize the original format below. Create a new table in the updated format rather than editing your existing one in place.

Compared to the original format, the updated format requires these changes:

  1. Replace metric name to the metric identifier. You can find the metric identifier on the about tab for your metric.
  2. Add dimension columns (optional) If your targets include dimensions, create one column per dimension, with the column header being the dimension identifier and the dimension values populating the rows.
  3. Add numerator and denominator columns (optional). They allow you to make dynamic analyses and break down your targets seamlessly.

Example: New target table format

SeriesTimeMetricChannelCountryValueNumeratorDenominator
Budget 20252025-01-01Registrations1000
Budget 20252025-02-01Registrations1000
........................
Budget 20252025-01-01RegistrationsiOS800
........................
Budget 20252025-01-01RegistrationsAndroid100
........................
Budget 20252025-01-01RegistrationsUS500
........................
Budget 20252025-01-01RegistrationsJP100
........................
Budget 20252025-01-01RegistrationsiOSUS300
........................
Budget 20252025-01-01RegistrationsiOSJP50
........................
Budget 20252025-01-01Activation5100
........................

Target table components:

ColumnDescription
SeriesThe series column can be used to set up multiple targets per metric, e.g. ”Budget”, ”Budget v2”, ”Stretch budget”, that users can switch between.
TimeThe time column specifies the start date of each period based on the time grain (for example 2025-04-01 for April on a monthly time grain, or 2025-04-04 for Week of Apr 4 on a weekly time grain). Steep automatically detects the time grain of your target series, which you can verify in the target settings page.
MetricThe metric column is used to specify the metric and corresponds to the unique metric identifier, which can be found under the About tab in a metric, or when editing the metric. Using the metric identifier in the target setup ensures it stay consistent, even if metric names are changed.
DimensionThe dimension column(s) is used to specify the dimension and dimension values. A metric can have multiple dimensions, and the column name must match the column name of the dimension in your database. Add the corresponding dimension values in the table. If targets are not set at the dimension level, you can exclude the dimension columns. Specify the dimension value for a metric, or a combination of dimension values. Note that you must add target values for all combinations of dimension values to get aggregations of targets in visualizations. See the example table above.
ValueThe value column represents the target value for the specific metric and applied dimensions for the specified time.
Ratio metricsIf you are adding a target to a ratio metric you need to include numerator and denominator columns. Add the numerator and denominator that is used to generate the target value. The target ratio will automatically appear as either a number or percentage, depending on how the metric is defined.

Ratio metrics

If you do not include a numerator and denominator column for ratio metrics, the value column will be read instead. This will limit Steep’s ability to aggregate ratio targets when filters are applied.

2. Select your new target table in Steep

Go to Model → Targets and select your new target table from your database. Steep reads targets from the new table straight away, and they show up in charts, tables and widgets for all metrics with a matching metric identifier.

Target overview page

For the full target table reference, see Targets.

Original target table format

The original format used a single dimension column and a dimension_value column, and referred to metrics by name. If your targets table looks like the example below, it needs to be recreated in the updated format.

Example:

seriesmetrictimevaluedimensiondimension_value
Budget 2024registrations2024-01-0110000
Budget 2024registrations2024-04-0112000
Budget 2024registrations2024-07-0115000
Budget 2024registrations2024-10-0120000
Budget 2024registrations2024-01-011500countryUS
Budget 2024registrations2024-04-011500countryUS
Budget 2024registrations2024-07-011500countryUS
Budget 2024registrations2024-10-011400countryUS
Budget 2024registrations2024-01-012000countryDE
Budget 2024registrations2024-04-012000countryDE
Budget 2024registrations2024-07-012500countryDE
Budget 2024registrations2024-10-012500countryDE
Budget 2024registrations2024-01-011000segmentWomen 25-40
Budget 2024registrations2024-04-011100segmentWomen 25-40
Budget 2024registrations2024-07-011200segmentWomen 25-40
Budget 2024registrations2024-10-011300segmentWomen 25-40