Catalog audit dashboard

E-commerce merchandising and data-quality audit across category metrics and listing completeness flags

Catalog listings
2.0K
24 categories
Weighted avg price
$80.05
Catalog blended price
Missing descriptions
46.5%
Largest major gap: Amazon Home
Fully complete listings
51.5%
Desc + features present
Audit snapshot

This dashboard combines category-level merchandising metrics with row-level completeness flags to surface where assortment scale, price architecture, and listing quality diverge.

  • All Electronics is the largest category at 31.1% of the catalog.
  • Computers carries the highest average price among larger categories at $127.05.
  • Tools & Home Improvement has the strongest average rating among larger categories at 4.44.
Chart mix: G1 × 2 Chart mix: G2 × 3 Chart mix: G3 × 1 Sample size: 2,000 rows
Coverage priorities

Description coverage is the main quality gap: 46.5% of listings are missing descriptions versus only 3.4% missing feature bullets.

Among larger categories, Amazon Home has the weakest description coverage at 57.1%, while Car Electronics has the highest feature-bullet gap at 8.0%.

Interpretation note: completeness percentages are easier to compare across categories than raw counts because category volumes differ widely.

Catalog category mix
Treemap of category share by product count, grouped into top categories plus an Other bucket.
Price vs rating bubble summary
Average price, average rating, and category size combined into a single merchandising view.
Content completeness by major category
High-volume categories only, comparing missing-description and missing-feature rates side by side.
Average vs median price gap
Dumbbell chart showing where premium-tail items lift the average above the typical median listing price.
Missing-description heatmap by price and rating band
Quality-risk matrix using row-level sample products to show where description gaps cluster.
Completeness funnel
Executive rollup from total sampled listings to fully complete listings.
What stands out

The catalog is concentrated: a single category accounts for nearly a third of all listings, so quality issues inside the largest buckets have outsized downstream impact.

Price positioning is not tightly linked to rating. Higher-priced categories do not automatically earn better average ratings, which makes content quality and assortment clarity especially important for conversion support.

Computers shows the biggest average-to-median price spread among major categories, a sign that premium items are stretching the category upward beyond its typical listing price.

Major-category watchlist
Category Products Avg price Avg rating Missing desc Missing feat
Selected chart metadata
Requested metadata for each selected chart, including Commonality Scale group and fit rationale.
Chart name Group Score Why this chart fits Required columns Optional columns Suggested axes One-sentence insight