Add Metric

The Add metric building block allows to create custom metrics and formulas.

Use Case

Problem:

We have a dataset that contains different metrics, in our example “Number of clicks” and “Number of Link clicks”. After the ad campaign we want to see the sum or the total number of clicks to understand the conversion rate.

Resolution:

By adding the “Add metric” building block we are able to add another column that would summarize the selected metrics (Clicks & Link Clicks) and show us the total number of clicks per each campaign.

Step 1

Firstly we need to add the Pull Data building block to give Conduit the datasource to work with. Then, in order to format our initial data source we add the “Create Report” building block to the canvas and connect it to our dataset.

Step 2
At this point we need to remove everything that would not be needed. Click on breakdowns and unselect all those columns and data you don’t want to display. Suppose we would like to display the data only by campaign and date. As for the metrics, we want to see only the clicks and Link Clicks.

Step 3

In order to add another column that would summarize our clicks we add a metric building block to the canvas and name it Total Clicks. In the formula field let’s write Clicks + Link Clicks since we want to see the sum of clicks . Now let’s check our result. We see that the system displays a new column with the sum of clicks.