Edit

Create measures from templates

  • Article

Use predefined templates of commonly used measures to create them. Templates build on mapped data from the Unified Activity table. So make sure you have configured customer activities before you create a measure from a template.

Available measure templates:

  • Average transaction value (ATV)
  • Total transaction value
  • Average daily revenue
  • Average monthly revenue
  • Average yearly revenue
  • Transaction count
  • Loyalty points earned
  • Loyalty points redeemed
  • Loyalty points balance
  • Active customer lifespan
  • Loyalty membership duration
  • Time since last purchase

Build a new measure using a template

  1. Go to Insights > Measures.

  2. Select New and select Choose a template.

  3. Find the template that fits your need and select Choose template.

  4. Review the required data and select Get started if you have all the data in place.

  5. Select Edit details next to Measure name. Provide a name for the measure. Optionally, add tags to the measure.

    Edit details dialog box.

  6. Select Done.

  7. In the Set time period section, define the time frame of the data. Choose if you want the new measure to cover the entire dataset by selecting All time, or if you want the measure to focus on a Specific time period.

    Screenshot showing the time period section when configuring a measure from a template.

  8. In the next section, select Add data to choose the activities and map the corresponding data from your Unified Activity table.

    1. Step 1 of 2: Under Activity type, choose the table type you want to use. For Activities, select the tables you want to map, and then select Next.
    2. Step 2 of 2: Choose the attribute from the Unified Activity table for the component required by the formula. For example, for Average transaction value, it's the attribute representing the Transaction value. For Activity timestamp, choose the attribute from the Unified Activity table that represents the date and time of the activity.
    3. Select Save.

    When the data mapping is successful, the status shows Complete and the name of the mapped activities and attributes display.

  9. Select Run to calculate the results of the measure. Select Save draft if you want to keep the current configuration and run the measure later. The Measures page displays.

Next steps