Calculated KPIs are metrics that represent a ratio/sum/formula that is based on other metrics. Common examples are CPM, CPC or Conversion Rate.
- Calculated KPIs should not be imported. Instead, only their components are imported, e.g. Costs and Clicks in order to produce a CPC. This is necessary as (e.g.) the total CPC of several data sets does not equal the sum of the CPCs
- Example: You have three data sets with a CPC of €1. The total CPC is still €1 and not €3
CREATING CALCULATED KPIs
You can create KPIs with the KPI Creator.
E.g. Cost per Booking = Costs / Bookings
- Navigate to Manage → KPIs and Dimensions → Create calculated KPI
- Define the KPI formula
Add Metrics by choosing them from the dropdown menu and clicking Add Metric. They will then appear in the formula field below.
You can build formulas by using standard mathematical operators such as + - / *
Formula for the example above would be: (costs)/(bookings)
It's also possible to conditions (if-then) for metrics. If you'd like to do so, please contact our support team
- Validate the formula
Click on Validate to verify whether or not the operation can be performed.
- Define the new KPI
Check whether the new KPI should be displayed as a currency or a percentage.
This is important, because it will help adverity to visualize the KPI in the appropriate format.
For the example above, is Currency should be selected and an appropriate name for the new KPI could be "Cost per Booking".
NB: If you check the is percentage box adverity will automatically multiply the KPI by 100 to display a percentage, therefore you do not need to include *100 in the KPI formula.
- Define visibility
Select the entities (Hubs, Tenants) which should have access to the new Calculated KPI.