How Do I Add, Change, or Remove Columns from a Report?

The first article in our new 'basics' series, this one looks at how to add/change/remove columns from a report in Report Toaster. 

Adding Columns

First, choose the report you want to modify.

In this example, we'll use the Sales - '30 Day Summary' report:

Step 1 - Click on the Columns button (top right).

This opens the columns pop-up like so: 

Step 2 -  The fields listed on the left-hand side are already on the report 
The fields on the right-hand side are those that we can add. 

These are searchable - so let's say I was looking for 'Transaction Fees', I could type that in (where it says 'type to filter') ...

Step 3 - ... and transaction fees appears!

You can drag/drop this field to include it on a report. 

Alternatively, you can use the + and X buttons to add/remove columns respectively. Once added, you should see it appear on the left-hand side like so: 

You can also change the order the columns appear on the report by 

Changing the Order 

Step 1 -  The order the fields appear in on the left (ascending) is the order they will appear on the report.

So if I want Transaction fees to appear last, I can follow the same drag/drop procedure and move it to the bottom like so: 

Step 2 - Notice that now, Transaction Fees appears as the last column on the main report. 

Metric Columns

Sometimes you will be presented with column fields that have more than one option available to choose from. 

For instance, if we look at the field for Net Profit, you'll notice a little arrow next to it.

Clicking on that provides options for Net Profit, Net Profit (avg), Net Profit (max), and Net Profit (min). 

These can be understood as follows: 

1. Sum, e.g. Net Profit. This would be the total or sum for the defined period. In my example above, with one row per day, this would be the total Net Profit for each day. 
   
2. Average, e.g. Net Profit (avg). This would be the average for the defined period. In my example above, with one row per day, this would be the mean average Net Profit per order for each day. 
   
3. Max, e.g. Net Profit (max). This would be the largest value for the defined period. In my example above, with one row per day, this would be the order that had the highest Net Profit value for each day.
   
4. Min, e.g. Net Profit (min). This would be the smallest value for the defined period. In my example above, with one row per day, this would be the order that had the lowest Net Profit value for each day.

Clicking on any of these options will replace the original 'Net Profit' field selection with the one you chose, then you can add to the report as normal.

Bear in mind that if you have already included one of the options on the report, only the remaining options will be available from the dropdown.

Removing Columns 

Simply follow the same procedure as Adding columns above, only in reverse.

For example, if I want to remove Returns from this report, I would open up the columns menu again and then drag Returns over to the right-hand side. 

Once again, hit 'Ok' when you're done, and there you have it. 

For other articles in our Basic Guides series, check out our main section here.

• Related Articles

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...

• What Do I Get In Report Toaster (that I don't get in Shopify?)

  What do I get out of Report Toaster that I don't get in Shopify? I already get reports in Shopify - why do I need Report Toaster? Why should I upgrade my Report Toaster Account? If you find yourself reading the above and having similar thoughts, then ...

• Premium Report - Aged Receivables

  Aged Receivables This report is used to identify customers with outstanding balances. This is determined by comparing the Order Date and the Paid at date and including any orders where either The order is unpaid. The order is only partially paid and ...

• Premium Report - Winback Customers

  Winback Customers This report shows you a list of Customers who have not made a purchase for some time (default - last 60 days). This is often useful for merchants who are looking to target them for future campaigns so they'll return and make a ...

• Premium Report - Product Cleanup

  Product Cleanup This report is for merchants who are looking to update and cleanup their products in Shopify. Using this report, you can see exactly which products are missing which values, navigate directly to them in Shopify (click the hyperlink ...