Skip to main content

Features

  • Define metrics in one place and use them across a variety of use-cases without the need to maintain defintions.
  • Track historical results, see automated projections and compare them to business goals.
  • Use pre-built calculations to quickly explore how metrics change over time.

Defining Metrics

Our metric builder allows teams to easily input metric definitions and dynamically generate the yml used to store them in dbt. We also include some best practice metadata so that Push.ai and other systems can better organize and deliver value using metrics. Below is the complete list of properties that are needed to make metrics.

Definition Types

  • Metric Builder - The easiest way to define a metric. Select a table and the fields used to configure a metric.
  • Custom SQL - A flexible solution with the ability to join tables, edit and paste in SQL from other sources.
  • Derived Metric - Use existing metrics to define metrics with parent-child relationships, like average order value.

Definition Configuration

FieldDescriptionExampleRequired?
TableThe table used to calculate this metricdim_customersyes (no for derived metrics)
Calculation TypeThe method of calculation that is applied to the expressioncount_distinctyes
Calculation FieldThe expression to aggregate/calculate overuser_idyes
Date FieldThe time-based component of the metricsignup_dateyes
DimensionsA list of dimensions to group or filter the metric by[plan, country]no
FiltersA list of filters to apply before calculating the metricstatus = ‘active’no

Properties

Metric properties define how a metric is calculated in Push.
FieldDescription
Goal DirectionDefines whether the business goal is to increase or decrease the metric.
Aggregation PropertiesConfigures whether this metric can be aggregated across the date dimension.
Metric FormatConfigures whether a metric will display as a number, percent or currency when displayed.

Derived Metrics

Derived metrics use existing metric definitions to calculate a new metric with a parent-child relationship. For example, Profit is a derived metric that can be calculating using the parent metrics of Revenue and Cost (profit = revenue - costs). Using derived metrics makes maintaining metric definitions easier by defining the supporting metrics in one definition and then having the derived metrics inherit any metric changes. With derived metrics, dimensions are inherited. The dimensions available for derived metrics are the ones shared by all related metrics

Calculations

Calculations help us explore how metrics change over time. You are likely already familiar with them if you’ve used traditional Business Intellignece tools. In Push.ai, calculations are used to compare metrics across time periods. Each calculation in Push.ai is associated with two time periods, a current period and a previous period. Individual calculations will be relevant depending on the use-case (e.g., you want to track something on a daily v. monthly cadence) or the nature of the business (e.g., you run an ecommerce business and order volume has a strong day-of-week seasonality).
CalculationCurrent PeriodPrevious Period
Previous DayApr 23Apr 22
Previous WeekApr 17-23Apr 10-16
Previous MonthApr 1-30Mar 1-31
Previous QuarterQ1 2023Q2 2023
Previous Year20212022
CalculationCurrent PeriodPrevious Period
Week to dateApr 16: Sun - ThursApr 9: Sun - Thurs
Month to dateApr 1-23Mar 1-23
Quarter to dateQ2 Days 1-23Q1 Days 1-23
Year to dateY 2023 Days 1-156Y 2022 Days 1-156
Week on WeekPrior Full WeekCurrent Week to Date
Month on MonthPrior Full MonthCurrent Week to Date
CalculationCurrent PeriodPrevious Period
Trailing 7 DayApr 15 - 22Apr 7 - 14
Trailing 30 DayMar 24 - Apr 23Feb 21 - Mar 23
CalculationCurrent PeriodPrevious Period
Same Day Previous WeekW15: MonW14: Mon
Same Day Previous MonthJanuary 15February 15
Same Day Previous QuarterQ2 W1 MondayQ1 W2 Monday
Same Day Previous YearY2023 W15 MondayY2022 W15 Monday
CalculationCurrent PeriodPrevious Period
Week to Date, Prev. YearW2 2023: Sun - ThursW2 2024: Sun - Thurs
Month to Date, Prev. YearApr 1-16 2023Apr 1-16 2024
Quarter to Date, Prev. YearQ2 Days 1-23, 2023Q2 Days 1-23, 2024
Prev. Week, Prev. YearY 2023 W2Y 2022 W2
Prev. Month, Prev. YearApr 2023Apr 2024
Prev. Quarter, Prev. YearQ1 2023Q1 2024
CalculationCurrent PeriodPrevious Period
End of Week ProgressApr 16-23Goal EOW W15
End of Month ProgressApr 1-23Goal EOM Apr
End of Quarter ProgressApr 1-23Goal EOQ Q2
End of Year ProgressJan 1 - Apr 23Goal EOY 2023
CalculationCurrent PeriodPrevious Period
End of Week PacingProjection EOW W15Goal EOW W14
End of Month PacingProjection EOM AprGoal EOM Apr
End of Quarter PacingProjection Q2Goal Q2
End of Year PacingProjection 2023Goal 2023
I