Before you begin: This guide shows you how to create calculations in TapClicks. The data extracted from connectors are limited. 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
To create a new calculation, you'll first have to navigate to the Calculations page.
1} Login to TapClicks. If you're not already in the New TapClicks interface, navigate there by first clicking your name on the left side menu and then clicking Go to New TapClicks.
2] In the new TapClicks interface, on the left side menu click Data.
3] At the bottom of the Data menu click Calculations. The Calculations page appears.
4] In the upper right, click the Add New Calculation button. The New Calculation page appears.
Define the Calculation and Data Source
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 type of data the output of 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 building 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 like this:
15] Click the Verify button below the Calculations Builder.
16] If there are no errors, a notification indicating as such will briefly appear in green below the Verify button.
17] Click Save. If the calculation was successfully saved, a notification indicating as 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.