Workflows – adding new columns

close

Conduit's Workflows functionality enables users to integrate additional columns into their existing datasets, by several different ways

Add Metric



The first way is to add a new column with a new metric with a custom formula to the existing dataset. To do so, just drag the Add Metric block on your workflow's canvas


Now, let's apply a custom formula to the block and add the 'Save to Google Sheet block'. In our case, the formula would be the sum of Clicks and Link Clicks parameters and we'll also name the metric as 'TotalClicks'

Run the workflow and check the results. You should the TotalClicks column in the output sheet


Add Column



The second method involves adding of a new column with a fixed value, whether it be an integer, string, decimal, or other data type.


If Then



Third method of adding a new column is using the If Then block. This block allows adding a new column to the dataset if certain specified conditions are met.


Applying Macros



You can apply macros to the 'Add Metric' and 'Add Column' blocks and then use them in your custom formulas. Currently, there are two types of macros available:

  1. Workflow's date range start
  2. Workflows date range end


Use-case example:

The macros could be used for calculating the average ad spend over the date range of interest. Let's say, you can create the two columns, that would stand for the date range and apply the Add Metric block to calculate the number of days. Then, you can apply the additional Add Metric block and have it to divide the overall ad spend to the number of days