Workflows – adding new columns
Conduit's Workflows functionality enables users to integrate additional columns into their existing datasets, by several different ways
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
The second method involves adding of a new column with a fixed value, whether it be an integer, string, decimal, or other data type.
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.
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:
Workflow's date range start
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
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:
Workflow's date range start
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
Updated on: 15/03/2024
Thank you!