Metrics are how you measure your data and are used to assess the performance of your marketing or business activity.
There are two types of metrics a user can make: Definitions from Template and Custom Definition.
Creating Definition from Template Metrics:
Within the Data Model module navigate to the 'Metrics' tab.
Click on the ellipsis (3 vertical dots) beside any folder and select 'Create Metric'
You will be instructed to name your metric.
Select Definition from Template
'Definition from template'
The templated definition allows you to pick from a number of aggregate functions including:
SUM | The arithmetic total of all values in the column |
COUNT | The total number of elements in the column |
Count Distinct | the number of distinct values across the column |
Numerical Average | the mean average of the elements in the column |
Numerical Min | the smallest-value element in the column |
Numerical Max | the largest-value element in the column |
Select the aggregate function from the list and choose the specific fields in your data source that you are interested in. Then click 'Save changes'.
This metric for example is getting the total number of impressions from CM360.
Creating Custom Definition Metrics:
Within the Data Model module navigate to the 'Metrics' tab.
Click on the ellipsis (3 vertical dots) beside any folder and select 'Create Metric'
You will be instructed to name your metric.
Select Custom Definition
Custom definition allows you to input basic SQL queries directly into the new definition template i.e. SUM(IF(query))
Selecting the '+' will allow you to add either fields to the query or metrics to create a composite metric
