# Workflows – Adding New Columns

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 

<figure><img src="/files/XXnNgc8PP5V14q2ZlcQA" alt=""><figcaption></figcaption></figure>

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'&#x20;

<figure><img src="/files/vGCSleJOYQ3Zhx883a4l" alt=""><figcaption></figcaption></figure>

Run the workflow and check the results. You should the TotalClicks column in the output sheet&#x20;

<figure><img src="/files/bt8oca3o0FphqsnIZTKk" alt=""><figcaption></figcaption></figure>

#### 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.&#x20;

<figure><img src="/files/GDG6FOojhC65ONBSjdvU" alt=""><figcaption></figcaption></figure>

#### 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.&#x20;

<figure><img src="/files/cmlteXx2K1kGWyfsQ3qd" alt=""><figcaption></figcaption></figure>

#### 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.getconduit.app/workflows/workflows-adding-new-columns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.