Product Dashboard User Guide
Guide to the Product Power BI dashboard; monitor rankings, pricing, ratings, listing quality, and estimated sales for your tracked products.
The Product dashboard lets you monitor performance across your tracked products on Amazon and Walmart. Use it to track rankings, pricing, ratings, listing quality, and estimated sales; for your own products and the top products in your tracked categories.
Questions this dashboard helps answer
- Which of my products have the best and worst Best Sellers Rank (BSR) right now?
- How are my product ratings and review counts trending over time?
- What is my Buy Box win rate, and which sellers are winning it instead of me?
- How does my average listing quality score compare across my catalog?
- Which products have had price changes, and by how much?
- How are estimated monthly sales and units trending for my products?
- Which products have seen changes in their listing details (title, images, badges)?
Before you start
What you need:
- Products tracked in DataHawk (Amazon and/or Walmart)
- Optionally: tracked categories, to also see the top 100 products within those categories
Set up: Download and configure the Power BI template. See Connect to Power BI.
Dashboard tabs at a glance
| Tab | What it shows |
|---|---|
| Dashboard | A high-level overview of key product metrics for the selected period |
| Overview | A detailed snapshot of your full product portfolio at a point in time |
| History | How metrics have changed over time (BSR, price, ratings, estimated sales) |
| Changes | A log of specific changes detected in product details |
Time periods and comparisons
All tabs share a Dates filter that sets the date range for analysis. The Dashboard tab aggregates metrics across the entire selected period, Overview provides a point-in-time snapshot, and History plots the time series across that range.
Dashboard filters
All tabs share the same set of filters. Key filters to know:
| Filter | What it does |
|---|---|
| Dates | Set the date range for analysis |
| Marketplace | Filter to one or more Amazon/Walmart marketplaces |
| Seller | Filter to a specific seller account |
| Brand | Filter by brand name |
| Product Name | Filter by product name |
| Product ID | Filter by ASIN (Amazon) or equivalent ID (Walmart) |
| Product Tag | Filter to products assigned a specific tag in DataHawk |
| Category | Filter by product category |
| Price | Set a price range |
| Ratings | Filter by total number of ratings |
| Rating | Filter by average star rating |
| Sales Rank | Filter by BSR range |
Dashboard reports tab by tab
Metrics
Formulas used in this dashboard. Concept-level definitions for acronyms live in the Glossary.
Buy Box
| Metric | Formula / definition | Notes |
|---|---|---|
| Buy Box % (Active) | Time the listing was Buy Box-eligible ÷ Total observation time × 100 | Tracks Buy Box enabled rate |
| Buy Box % (Public) | Time your offer was the Featured Offer (publicly observed) ÷ Total observation time × 100 | Visibility to customers |
| Buy Box % (Private) | Page views with your offer as Featured Offer ÷ Total page views × 100 | Requires Seller Central connection |
Rankings and engagement
| Metric | Formula / definition | Notes |
|---|---|---|
| BSR (Best / Avg / Worst) | Minimum / average / maximum BSR observed across the period | Lower is better |
| Rating (Avg) | Sum of star ratings ÷ Count | |
| Sessions CVR (Avg) | Orders ÷ Sessions × 100 | Average across the period |
| Sales % (E) | Your products' estimated sales ÷ Total estimated market sales × 100 | Share of estimated market |
| Units % (E) | Your products' estimated units ÷ Total estimated market units × 100 | Share of estimated market |
For analysts: data sources & methodology
Source tables and datasets
The Product dashboard pulls from two data models:
Product data comes from your tracked products. Category data covers the top 100 products within each of your tracked categories. For a full column reference, see the Exhaustive Column Referential.
Dashboard-specific fields
- Sales Score: DataHawk-computed estimated demand score, used for ranking products by relative sales potential.
- LQS (Listing Quality Score): DataHawk-computed score that summarizes listing completeness and quality (images, content, A+, video, etc.) on a 0–100 scale.
- Sellers (Winners): Count of distinct Buy Box winners observed during the period.
- Seller (Latest): Most recent Buy Box winner.
- Price (Distinct): Count of distinct price points observed during the period.
- Badges: Count of badges (e.g. Amazon's Choice, Best Seller) observed on the listing.
Buy Box variants
The dashboard exposes three distinct Buy Box rates, each measuring a different aspect of competitive positioning.
- Buy Box % (Active): Share of observation time the listing was Buy Box-eligible. Measures whether your listing qualifies to compete for the Buy Box at all, independent of which seller wins it.
- Buy Box % (Public): Share of observation time your offer was the publicly Featured Offer (visible to shoppers). Computed from DataHawk's polling of the public product page.
- Buy Box % (Private): Share of page views where your offer was the Featured Offer, computed from Seller Central session-level data. Requires a Seller Central connection. Reflects actual shopper-facing Buy Box ownership rather than polled snapshots.
The three variants can disagree; a listing can be Buy Box-eligible most of the time (Active high), publicly win the Buy Box less often (Public lower), and still convert most of its real traffic with the Buy Box (Private higher than Public).
BSR Min / Avg / Max
BSR is observed multiple times per period. The dashboard reports the minimum (best rank achieved), average (mean across observations), and maximum (worst rank). For BSR, lower is better, so "Best" refers to the minimum value and "Worst" refers to the maximum.
Attribution and methodology
Sales and units shown in this dashboard are DataHawk estimates derived from BSR-to-sales modeling for the marketplace and category. Estimated values appear with (E) and Low / High suffixes to indicate they are ranges, not measured values. Sessions, Pageviews, and Sessions CVR are measured (not estimated) but require a Seller Central connection.
Ads DSP Dashboard Documentation
Complete guide to DataHawk's Ads DSP Power BI Dashboard; visibility into programmatic Amazon DSP campaigns from advertiser level down to individual creatives.
Looker Studio Templates
DataHawk's Looker Studio template; analytics Essentials covers products, keywords, ads, sales, finance, traffic, and inventory in one dashboard.