Unit Economics

Within the Ternary Reporting Engine, users can create and report on unit costs leveraging time series data from multiple sources, including DataDog integrations and .csv import of time series data.

When leveraging Ternary to view and report unit cost metrics, imported time series measurements can be used in combination with the existing cost reporting information in Ternary to allocate costs to a specific unit relevant to your organization. Commonly produced unit cost include things like cost per user, cost per visit, cost per unit delivered.

Preparing and Importing Time Series With a CSV input file

A valid CSV schema should include one measure and timestamp with optional dimensions. Currently, only one measure can be defined at a time with an unrestricted number of dimensions. Dimensions will appear in the metric filters list.

Valid time series CSV imports should adhere to the following formatting requirements:

• RFC 3339 Timestamp syntax (e.g. "2006-01-02T15:04:05Z07:00")
• IMPORTANT NOTE: You can provide a Z or a Time Zone offset in your RFC3339 timestamped field, but NOT both. See below for example valid RFC3339 timestamps:
  • "2015-09-15T14:00:12-00:00"
  • "2015-09-15T14:00:13Z07:00"

Uploading CSV Time Series Data

The process to upload your CSV time series data is managed within the Reporting Engine feature. Start by selecting Reports within the Reporting Engine section of the primary navigation and select the option to create a new report

Select the Unit Econ tab

View your custom metrics by pressing “Show Custom Metrics”
Create or manage your custom metrics using the table controls
Create a name for your new metric, upload a CSV and build your schema. Please refer to the CSV requirements in order to ensure successful data ingestion.
NOTE: Metrics must contain only one Timestamp and one Measure. Dimensions are optional fields that allow you to apply filters to your metric selection in TRE.
Allow a few minutes for data ingestion in order to query the data. The status in the management table will indicate ingestion progress.

CSV Requirements
Timestamp
RFC 3339 Timestamp
Examples:
“2024-01-01T00:00:00Z”
“2006-01-02T15:04:05Z07:00”
https://pkg.go.dev/time#pkg-constants

Building Reports

Select a measure from the “Params” tab. Take note of the character to the left of the measure for formula creation.

Query your newly created custom metric by selecting it in the unit econ measure drop down.

Query your custom metric and create a formula using the drop downs.