Skip to main content
Comparison Report Explained

This article explains the power of the comparison report and outlines some filter options you can use to customize the comparison report.

C
Written by Chava Teller
Updated over a week ago

The ConnectBooks comparison report is a powerful tool that provides valuable insights into the performance of your products and business over time. By analyzing sales trends, you can make informed decisions to boost profits and manage inventory more effectively.

Key Benefits

  • 1. Track Sales Trends: The comparison report reveals sales fluctuations over time. For example, sales increased by 20% to $1,200 from May 22-28, then rose by 25% to $1,500 from May 29-June 4. In the following weeks, sales dropped by 7% to $1,400 and then by another 3%.

  • Understand Influencing Factors: Analyze data to identify sales impacts. Adjusting prices may increase units sold but lower your profit margins, and higher ad spend might boost sales initially but reduce profits. Track and analyze these changes to optimize your strategy.

Understanding Your Report

Item Name: The first column lists the item name.


Data Description: The second column contains the data description, by default its the gross sales. Click the + sign near the product name to view detailed product data.

Date Range: The remaining columns display the date ranges you are comparing.

Customization Options

Date range:

By default, the report will run on the last 4 weeks, but you can run the report to compare years, months, or specific days.

For example; to compare your performance over the last three Black Fridays:

  • Input the date of Black Friday.

  • Check "Compare to another date range."

  • Input the Black Friday dates for other years.

  • Press "Run Report."

    Your Black Friday data will be clearly displayed.

Filter transactions:

By default, the report will include only orders and returns.

To include other transaction types, select the transaction filter and choose the desired transaction types from the dropdown.

Customize Data:

You can tailor your data view by clicking "Customize Data" and selecting or deselecting your desired options. To set a piece of data as the default, click the star next to its description.


For example, if you star "profit per item," your report will display "profit per item" as the default, as shown in the image below.

Total:

To view your company's overall performance, and not per item, select the Total button. You will then see the totals of all your data.


Click here to learn how to save your customized filters as a template.

Click here to learn how to customize the report further with the Customize Report option.

Did this answer your question?