Ecommerce Merchandising Dashboard

Ecommerce Merchandising Dashboard

Paste your product data and get instant merchandising insights, scores, and actionable recommendations.

New here? Load sample data to see how the dashboard works before pasting your own.

Paste rows with columns: Product, Category, Revenue, Units Sold, Views, Conversion Rate (%), Return Rate (%). Use commas or tabs as separators. First row can be a header.

Understanding Merchandising Analytics

📊

What Is Merchandising Analytics?

Merchandising analytics combines product performance data with customer behavior to decide what to promote, reposition, or phase out. Instead of guessing which products deserve homepage real estate, you let the numbers decide. It covers everything from category-level trends to individual SKU profitability.

👁

Revenue Per View (RPV)

Revenue per view tells you how much money each product page visit generates on average. A product with 50,000 views but only $2,000 in revenue (RPV = $0.04) is underperforming compared to one with 5,000 views and $5,000 revenue (RPV = $1.00). Use RPV to identify products that deserve more visibility.

📦

Category Management

Category management means treating each product category as its own business unit. You analyze revenue, margin, and conversion rate at the category level to spot which categories are carrying the store and which are dragging it down. Smart allocation of marketing spend and shelf space follows from this analysis.

💰

The Pareto Principle in E-commerce

In most stores, roughly 20% of products generate 80% of revenue. Identifying your top performers lets you double down on what works. Equally important: understanding which products in the long tail might be costing you money in warehousing and maintenance without contributing meaningfully to the bottom line.

Merchandising Best Practices

✓ DO

  • Review merchandising data weekly, not just monthly
  • Compare conversion rates within the same category (not across all products)
  • Factor in return rates when calculating true product profitability
  • Use revenue per view to allocate homepage and category page placement
  • Test promotional placement changes with A/B tests before going all-in
  • Segment by traffic source — paid traffic converts differently than organic

✗ DON’T

  • Judge products solely by revenue — high revenue with high returns is a trap
  • Ignore low-traffic products — they might convert well if given more visibility
  • Compare seasonal products against evergreen ones without adjusting for timing
  • Remove underperformers without checking if they drive cross-sells
  • Optimize for conversion rate alone — a 10% rate on $5 products matters less than 1% on $500 items
  • Set and forget your merchandising — product performance changes over time

Frequently Asked Questions

At minimum, you need product name, revenue, and units sold. For deeper analysis, add views or sessions (to calculate conversion rate), return rates, and category labels. Most e-commerce platforms like Shopify, WooCommerce, and BigCommerce let you export this data as CSV from your admin panel. The more data points you include, the more precise your merchandising scores and recommendations will be.
The merchandising score is a composite metric from 0 to 100. It weighs four factors: revenue share (how much the product contributes to total revenue), conversion rate relative to the average, views relative to the average (demand signal), and return rate relative to the average (inverted, since lower is better). Products scoring 80 or above are strong performers. Those below 50 need attention — either optimization or reconsideration of their place in your catalog.
Weekly reviews catch trends before they become problems. A quick 15-minute weekly check on your top and bottom performers is usually enough. Do a deeper monthly analysis where you review category-level trends, update your merchandising scores, and adjust product placement. During high-traffic periods like holiday seasons or sales events, consider checking daily.
Revenue concentration measures how dependent your store is on a small number of products. If your top 10% of products account for 90% of revenue, your business is highly concentrated and vulnerable — one stockout or trend shift could tank your revenue. A healthier distribution might see 60-70% of revenue from the top 20%. Understanding this helps you diversify strategically and manage inventory risk.
Yes. This dashboard works with any data you can format as CSV or paste as tab-separated values. Shopify, WooCommerce, Magento, BigCommerce, and Squarespace all allow product performance exports. You can also pull data from Google Analytics 4 by combining product performance reports. Just make sure your columns follow the expected format: Product, Category, Revenue, Units, Views, Conversion Rate, Return Rate.
Low-scoring products need investigation, not automatic removal. First, check if the product has low views — it might perform well if given more visibility. Second, look at the conversion rate: a decent rate with low traffic suggests a promotion opportunity. Third, check return rates: high returns might indicate a product description or sizing issue rather than a bad product. Only consider discontinuing a product if it has adequate traffic, poor conversion, and high returns simultaneously.