Add static value

Problem:

Let’s assume we have two different accounts with different credentials and you need to map which campaigns were run from which account and what was the associated cost. We need a separate column that would tell us which account the data belongs to. By default, Conduit has that column, but let’s suppose you are working with a lot of spreadsheets that don’t have that column hence you need to create one.

Resolution:

The “Add static value” building block allows us to create a new column containing certain values. We will be using this building block to map the accounts, campaigns and their costs following a few simple steps below.

Step 1

Firstly we need to add two Pull Data building blocks to give Conduit the data sources to work with. Then, in order to format our initial data source we add the “Create Report” building blocks to the canvas and connect them to each of our datasets. 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. As for the metrics, we want to see only the Cost.

Step 2

Now we pull the “Union” building block to tie our datasets together. Now we will see all the campaigns from both accounts and their associated costs, however it is not clear which account those campaigns belong to.

Step 3

Now let’s go back to our canvas and add the “Add static value” building blocks under each of our reports. In the column field for both building blocks we write “SRC” as it will be the common column name and in the value field we will indicate different accounts. For the first “Add static value” building block we write “Source 1” and for the second “Source 2”. Now if we look at the final result it would be much clearer to observe different accounts or data sources, the associated campaign names and their relevant costs.