Before you begin: This guide shows you how to create calculations in TapClicks. Calculations enable you to create new metrics for use in reporting based on existing connector data. For example, if you want to average two numbers together, you can use calculations to calculate that average and then use it in your reports.
Calculations also work with categories. You are able to combine multiple services and then create a calculation spanning across all services. For example, suppose you want to create a category that combines call tracking services. You can do this by creating a new metric called Category Metrics that is produced by dividing Total Cost by Total Calls.
How to Create a New Calculation
1] On the left side menu, under Data, click Calculations.
2] The Calculations page appears.
3] In the upper right, click the Add New Calculation button.
4] The New Calculation page appears.
Define the Calculation and Data Source
| NOTE: To define the calculation, first you'll have to give it a name, then you'll have to specify the data type, data source, and data view. |
5] Enter a name for the calculation in the Name textbox.
6] From the Data Type dropdown menu, choose a data type. The data type is the intended output your calculation is meant to produce.
7] From the Data Category dropdown, choose a data source (i.e., connector) from which to provide inputs to your calculation.
| NOTE: You will only see the metrics that are currently active in your data source. So, if something isn't there in the drop-down to choose from, double-check your data source! |
8] From the Data View dropdown, choose which view of the data source (i.e., channel) you want to use in your calculation.
| NOTE: The options available on the Data View dropdown depend on which Data Category you choose. |
Build a Calculation
This section describes the different ways to build calculations, the components of a calculation, and typing guidelines for creating a calculation.
NOTE: You build the calculation in the Calculation Builder. There are two ways to build a calculation:
|
NOTE: Calculations are comprised of four components:
|
NOTE: Use the following guidelines when typing directing in the Calculation Builder:
|
Build a Calculation Example
In this build calculation example, we'll calculate the click-through rate (CTR) which uses the following formula: clicks / impressions * 1000.
9] Start by clicking the Clicks metric.
10] The Clicks metric appears in the Calculations Builder.
11] Click the division operator.
12] Click the Impressions metric.
13] Click the multiplication operator.
14] Enter the number 1000. The Calculation Builder should look like this:
15] Click the Verify button below the Calculations Builder.
16] If there are no errors, a notification indicating such will briefly appear in green below the Verify button.
17] Click Save. If the calculation was successfully saved, a notification indicating such will briefly appear beneath the Save button.
18] When you return to the Calculations pages, you'll see the calculation you just created.
To see a complete list of calculation functions, see the Calculations Function Reference.