Filter

Problem:

We have the raw dataset with multiple campaigns, and we want to build a report that would show us the results just for a specific campaign.

Solution:

We will be using the “Filter” building block in order to filter our dataset and instruct Conduit to process just the value (campaign) we are interested in.

Step 1

Let’s open Conduit’s Workflows and add the “Pull Data” building block to the canvas and select our dataset.

Step 2

Let’s add the “Create Report/Aggregate” building block to the canvas and connect it to our dataset. At this point we are getting rid of all the columns we won’t be using to proceed with our task. In the breakdowns field we uncheck all the columns except “Campaign Name” and “Date” columns. In the metrics field we will leave only the “Cost” column.

Step 3

Since it is not yet our final output, we add the “Filter” building block right under the “Create Report/Aggregate” building block. We instruct the building block to filter the Campaign Name by the value “Remarketing 1”.

Step 4

Now, if we look at our final output we will see only the results relevant to the specific campaign we are interested in.