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.

## Comments

0 comments

Article is closed for comments.