Sales by Day of Week Report

Why Sales by Day of Week report is important

This summary incorporates several data indicators beyond the number of deals made each day of the week. These additional indicators can be relevant for tracking the store's business performance.

Easily track sales growth by comparing current data with earlier time ranges. Utilize the reporting tool's functionality to identify progressions in key sales indicators.

The default version of this report provides data on general patterns of store financial operation by displaying columns such as the number of orders, gross sales, total sales, tax, discounts, and returns.

The executive manager can make the data more representative of their needs by using filters. For example, they can identify the day of the week with the highest sales for the current month. They can also track the day with the lowest sales for the last year. Such information can be useful for inventory planning and marketing purposes.

What questions summary on Sales by Day of Week can answer

This type of summary lists all orders placed in a store within a specified date range and splits them by days of the week. Use it to obtain a high-level overview of daily sales trends.

The data displayed in it can be used to answer questions such as:

• Which payment gateways do customers prefer to use day to day within specific dates?
• What day of the week is best for launching a promotional campaign?
• Which day of the week is the busiest for store staff?
• Which day of the week brings the highest number of orders each month, year, or any chosen time period?
• How do key sales indicators (gross, net, and total sales) change day to day within a specific time range?
• How can we view the tax, refunds, and discounts the store had on orders each day of the week?
• What is the total number of orders and items purchased for each day of the week?
• What are the gross profit and gross margin for each day of the week?

Expand this list of answers by using additional data columns and data filters.

Key Sales Indicators in a Sales by Day of Week Report

Use the data summary provided by the Advanced Reports app to gain insights into key sales statistics split by days of the week.

Expand it with additional columns to get a detailed view of the business performance of the store. For example, you can see the customers from what countries mostly buy from you on a certain day of the week within the given month or other time range.

Track order volume, gross and total sales within the chosen time period. For each day of the week, the summary displays data such as:

• Number of orders
• Taxes
• Discounts
• Refunds
• Shipping costs
• Gross, net, and total sales

Use these columns to quickly assess the current financial and fulfillment statuses for each order within the selected dates.

Reports Similar to Sales by Day of Week

Sales summary can be tracked with another pivoting point if necessary. The reporting tool allows switching for a day, week, an hour of the day, year, quarter, or any other specific period of time.

However, you are not limited to splitting sales by the time periods mentioned above. Generate the report on sales based on other factors, like sales by customer group.

In conjunction with the day of week sales report, a store manager can often use such summaries:

• Sales by Day. Use it to see the sales information that occurred every day within the specified time range.
• Sales by Hour. Conveniently identify the busiest hours for your store. See the sales that occurred every hour.
• Sales by Year. Use it for a yearly summary of sales and compare it with data from previous years.
• Sales by Channel. Identify the channels bringing sales to your store. Learn whether it's offline POS or online sales.
• Sales by Customer. Get more information on customer types driving your sales.
• Sales by Discount. Analyze the success of different marketing campaigns in your store.
• Sales by Product. View purchase information for each product name or SKU.
• Average Order Value Over Time. Track changes in average order value over a specific period, e.g., a month.
• Sales by Product Type/Variant/Collection. Explore which types of products/variants/collections drive your sales.

A store manager can add the day of the week data column to these reports to gain additional insights.

Key Columns for Sales by Date of Week

By default, the table containing purchase data and their sales for each day of the week includes columns such as:

• SALES Date – Day of week
• ORDERS Number of orders
• ORDERS Gross Sales
• ORDERS Discounts
• REFUNDS Returns
• ORDERS Net Sales
• ORDERS Shipping
• ORDERS Tax
• ORDERS Total Sales

When using this generated summary, you are free to exclude any existing columns from its default configuration or add several additional ones. Simply choose available columns from the list.

Here's how some of the key columns in the default report are calculated:

• REFUNDS Returns. Calculated through the difference between Refunds Total Gross Amount and Order Adjustments Total Amount data columns.

  [REFUNDS Returns] = [REFUNDS Total Gross Amount] – [ORDER ADJUSTMENTS Total Amount]

• ORDERS Net Sales. Displays what remains after deducting discounts and refunds from gross sales.

  [ORDERS Net Sales] = [ORDERS Gross Sales] – [ORDERS Discounts] – [REFUNDS Returns]

• ORDERS Shipping. Tracks sums of order shipping costs.

  [ORDERS Shipping] = [ORDERS Shipping amount] – [ORDER ADJUSTMENTS Total Shipping Amount]

• ORDERS Tax. Shows the sum of taxes, excluding taxes on refunded items.

  [ORDERS Tax] = [ORDERS Taxes] – [REFUND ITEMS Total Tax Amount]

• ORDERS Total Sales. The final default column of the report, which sums net sales, shipping, and tax.

  [ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

Variations of the Sales Overview Report

You can gain a different view of sales beyond the daily overview with default sales metrics. Using variations of the basic report, you can gain a clearer insight into your store's business performance.

One of the easiest ways to assess business success is to compare a specific date range to a previous period.

Using filters and sorting options, you can answer other questions regarding sales. Here are some examples of report variations.

How to see sales by location

You can easily view sales data for each sale day along with data on the geographical distribution of customers.

See which provinces, cities, and countries have the most or least purchases for each day of the week.

Customer’s Lifetime Value

It is well known that existing customers cost less than acquiring new ones for a store. Each customer sets their individual value for a store based on their purchases.

View the customer lifetime value with the CUSTOMERS CLV data column. Use it to monitor signs of customer attrition in your store.

[ORDERS Gross Margin, %] = ([ORDERS Net Sales] - [ORDERS COGS]) ÷ [ORDERS Net Sales] × 100

How to get details on sales transactions

The sales overview can be extended with data columns on transactions. You can obtain information such as:

• Gateway the operation was made from
• Source name of the transaction
• Current status of the transaction
• The type of the transaction (sales, refund)
• Creation timestamp
• Transaction total amount for each sale day

[ORDER ITEMS Total Cost] = [ORDER ITEMS Quantity] × [INVENTORY ITEMS Cost] 

[ORDER ITEMS  Total Shipping Price] = [ORDERS Shipping Price] ÷ [ORDER FACTS Quantity] × [ORDER ITEMS Quantity]

[ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

[ORDERS Net Sales] = [ORDERS Gross Amount] - [ORDERS Discounts] - [REFUNDS Returns]

[ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]

[ORDERS Tax] = [ORDERS Taxes] – [REFUND ITEMS Total Tax Amount]