Embedded Files
Compare performance of your customer sources across various online platforms.
Frequently Sold Items Report
Frequently Sold Items Report
Description
The Frequently Sold Items report lists products most often included in customer orders within the selected period
The table provides:
Product Title – Name of the product sold.
Orders with this Item – Number of distinct orders that contained the product.
Sales Quantity – Total units of the product sold.
Net Sales – Revenue generated from the product (excluding tax/discount adjustments).
Sales Profit – Net profit contribution from the product.
How to use
How to use
Product Popularity:
Items with the highest Orders with this Item reflect broad customer demand.
These are candidates for continued stocking and promotional focus.
Sales vs. Profitability:
Compare Net Sales with Sales Profit to detect margin performance.
Some items may sell often but contribute little profit (or even losses).
Others may sell fewer units but provide high profit, indicating premium positioning.
Portfolio Diversification:
Identifies whether sales are concentrated in a few items or spread across many.
Heavy dependence on a small group of products increases business risk.
Demand Forecasting:
Use sales quantity as an input to replenishment planning.
Products consistently appearing at the top suggest stable demand patterns.
Stock Management:
Ensure frequently sold items are adequately stocked to avoid stockouts.
Pricing & Promotion:
For high-sales, low-profit items, review pricing or sourcing costs.
For high-profit items, consider upsell campaigns or bundling.
Assortment Planning:
Use the data to refine product mix — focus on products with both volume and profitability.
Cross-Analysis:
Combine with Top Earners (from the sales dashboard) to see overlap between frequent sellers and revenue drivers. If they differ, this indicates that frequency and profitability are not always aligned.
Sales Comparison Reports
Sales Comparison Reports
Description
The Sales Comparison reports evaluate performance across three grouping dimensions:
Product Type (categories)
Vendor (suppliers)
Location (sales channels / stores)
They provide a year-over-year view, showing how sales and profitability evolve within each grouping.
Key Metrics Included
Net Sales (TY / LY): Total revenue generated this year vs. last year.
Sales Profit (TY / LY): Net contribution after costs.
Sales Units (TY): Number of items sold.
Orders with Items of this Group (TY / LY): Number of orders that included products from this group.
Unique Products within Group (TY / LY): Count of distinct SKUs sold. (planned addition)
Unique Variants within Group (TY / LY): Count of distinct product variants sold. (planned addition)
What to watch out
What to watch out
Growth & Decline:
Compare TY vs LY to spot fast-growing categories, vendors, or locations.
Groups showing strong sales growth but declining orders may signal higher basket sizes or price increases.
Profitability Check:
Growth in net sales does not guarantee healthy profit.
Cross-check margins to ensure sales expansion isn’t offset by higher costs, discounts, or returns.
Assortment Depth:
Unique product and variant counts provide insight into catalog breadth.
More SKUs sold may indicate diversification; fewer SKUs with higher sales may point to hero products dominating demand.
Demand Distribution:
Orders vs. units shows if demand is broad-based (many customers, small quantities) or concentrated (few customers, bulk purchases).
Strategic Dimension Focus:
By Product Type: Guides assortment planning and category investment.
By Vendor: Highlights supplier dependence, negotiation leverage, and vendor mix risk.
By Location: Identifies geographic strengths/weaknesses for resource allocation and local marketing.
How to use
How to use
Start with YoY Performance:
Look for categories, vendors, or locations with the strongest or weakest growth.
Identify outliers that drive overall sales trends.
Check Profitability Alignment:
Validate that top-line sales growth translates into profit.
If not, drill into pricing, cost structure, or discounting practices.
Review Assortment Breadth:
Use unique products/variants to understand whether growth comes from expanding assortment or deeper sales of existing items.
Helps plan whether to broaden catalog or optimize existing lines.
Cross-Compare Dimensions:
Category vs Vendor: See which suppliers dominate profitable categories.
Location vs Category: Spot regional category preferences.
Vendor vs Location: Identify geographic vendor strengths or weaknesses.
Turn Insight into Action:
Promote or expand strong performers.
Reevaluate or phase out underperforming groups.
Use findings to guide purchasing, pricing, and local marketing strategies.
Page updated
Google Sites
Report abuse