Add Week/Month/Year

Problem:

We have a raw dataset with the Date column, however we would like to create a column which will tell us the months in text format.

Resolution:

We will be using the “Add Week/Month/Year” building block in order to insert a column that would display the months in text format for each specific row. Please be aware that this building block can be used only with the “Create Report/Aggregate” building block. In order to achieve our goal we will be taking the following steps.

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

In order to create a new “Month” column, we will include the “Add Week/Month/Year” building block. At this point we just need to properly name it and select that the information should be taken from the “Date” column, and it needs to display the values as “Month”. Of course, if in your case you will need a week or a year, you can select that from the dropdown selection menu. Now we are all set up, and we can view our final result.