Sales Comparison Summary

Sales Comparison Summary

Overview

In this article, you will learn about Sellercloud’s Sales Comparison Summary report. It allows you to compare sales from different periods based on the channel, company, manufacturer, product type, or vendor. The Sales Comparison Detail report is similar, but it compares sales for specific products. It also allows you to generate the report based on additional criteria such as brand, vendor, product group, and SKU.

You can run this report automatically on a regular basis with Scheduled Tasks.

For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the Sales Comparison Summary report:

  1. Go to Reports > Sales > Sales Comparison Summary.

  2. You can set up the filters according to your preference or use the ones selected by default. For more information, see the Filter Definitions section.

  3. Click Search. Each filter you apply gets highlighted and displays the selected value.

Filter Definitions

Below is a list of the available filters and their general definitions. Some combinations are incompatible and will not pull any results. Additionally, the section below provides some examples.

Example Combinations

Below are some examples of how you can customize the report results to view and compare specific sales information.

Example 1
You can combine the Company and Channel filters to compare sales totals for specific accounts. For example, if you have multiple Amazon accounts, only selecting the Channel: Amazon filter and value will combine the sales from all the accounts. However, if you add a specific company, you will only see sales from the selected one. Additionally, if you have 2 US and several international accounts, this combination allows you to compare just your domestic data or only international sales.

Example 2
The Sales Comparison Summary report allows you to compare the current Month or Quarter sales each year. If you select Compare Interval: Month and Compare Method: Year Over Year, you will see the sales performance of the current month in each year.

Example 3
You can view and compare sales data for a specific date throughout the years. For example, if you have a regular promotion that happens on the same weekend every year, select:

This combination will show you the total sales made during your promotion dates for each year. Similarly, you can view specific dates throughout months or quarters.

Incompatible Filters

Some filters in the report are incompatible. Usually, this is the case when your selection in the Compare Method filter is shorter than the Compare Interval. For example, you can't compare quarter over quarter when your interval is a year. The following filter combinations are incompatible and will not be available to be selected together:

Report Data

The report data is based on the selected filters. It is available as a graph, a results grid, and an export in Excel, CSV, and PDF formats. Each one provides specific insights into the same data. The example report seen in the screenshots goes back 4 intervals, Year Over Year, and has the following filters:

Report Graphs

The Sales Comparison Summary report offers two data visualization options: Bar Chart and Line Chart. You can toggle between them by selecting options in the Chart Type dropdown. The graphs are based on the filters you have selected and display additional information, such as dollar and percentage change of the totals from each interval. The visualization also allows you to easily compare not just performance across intervals but also the performance of different operators (e.g., channels or companies) within one interval.

When comparing more than 10 intervals, you can use the slider below the graph to zoom in from either side to view specific periods.

If you are comparing multiple operators from the Compare By filter (e.g., multiple channels), you can click on the operator name below the graph to exclude it from the visualization.

Report Grid

The report grid is based on the selected filters. The column headers are the compare intervals (year, quarter, month, week, dates), and the Intervals To Go Back determine the number of columns. The rows are based on which and how many comparison operators you have selected in the Compare By, Channel, and Company filters. The grid shows the total dollar amount of sales for each interval. Clicking on a value opens a new tab to the Sales By Date Range report with the relevant filters pre-selected. Click search to view a breakdown of orders within the range.

Export Data

To export a Sales Comparison Summary report:

  1. Configure your filters.

  2. Click Search to load the results.

  3. Click Actions in the top right corner and select:

    1. Export To Excel
    2. Export To CSV
    3. Export To PDF

  4. The file will download to your device.

The export will contain a combination of Grid and Graph information. The first column is the comparison operator (Channel, Company, etc.), and the second is the operator's ID. Subsequent columns are based on the selected filters. You will see the total dollar amount for each interval, as well as the percentage and/or dollar change from the previous one.