Master product rankings to identify winners, spot underperformers, and make data-driven inventory decisions
Knowing which products drive traffic—and which ones languish unseen—is essential for store optimization. WhoKnew Views™ Pro provides multiple ways to identify both your star performers and products that need attention, from automated weekly email rankings to interactive analytics dashboards.
🔒 PRO FEATURE — Requires WhoKnew Views™ Pro
🏆 Performance Data Sources
WhoKnew Views™ Pro surfaces product performance data in multiple locations, each designed for different use cases:
📧
Weekly Email
Top 5 performers
Auto-delivered to inbox
7-day window
🔟
Email Leaderboard
Top 10 with medals
Appended to all emails
Optional toggle
📊
Analytics Dashboard
All products sortable
Views, growth, conversions
Flexible time windows
📈
Growth Trends Chart
Visual trajectory
Compare products
Spot declining trends
🥇 How Top Performers Are Calculated
The ranking algorithm is straightforward: products are sorted by real view count within a specific time window, with the highest-viewed products at the top.
📐 Ranking Formula
For Each Product:
views_in_window = COUNT(product_views WHERE timestamp >= week_start AND timestamp <= week_end)
Ranking:
ORDER BY views_in_window DESC → Top performers first
Selection:
LIMIT 5 → Weekly summary email
LIMIT 10 → Email leaderboard (if enabled)
🔍 Key Details:
| Metric | Details |
|---|---|
| 📊 Data Source | product_views meta key (real view timestamps only) |
| 🎯 View Type | Real views only—padding is excluded from rankings |
| 📅 Time Window | 7 days from your scheduled send time (not rolling) |
| 🏷️ Product Status | Only published WooCommerce products |
ℹ️ Why Real Views Only? Rankings use real (organic) views to give you an accurate picture of genuine customer interest. Padding helps with social proof on the storefront, but business decisions should be based on actual traffic patterns.
🥇🥈🥉 Medal System
Top 3 products receive special visual treatment in emails with Olympic-style medals:
🥇
#1 Gold
Top performer of the week
Golden gradient background
Amber border accent
🥈
#2 Silver
Second highest views
Silver gradient background
Gray border accent
🥉
#3 Bronze
Third place finisher
Bronze gradient background
Orange border accent
Products ranked #4–#10 display with neutral styling and a rank badge (e.g., #4, #5).
📉 Identifying Bottom Performers
While weekly emails highlight winners, identifying underperformers requires the Analytics Dashboard at WhoKnew → Insights:
⚠️ Finding Underperformers
1
Sort by Views (Ascending)
In the Product Rankings table, click the Total Views column header to toggle sort order. Products with the fewest views appear first.
2
Sort by Growth % (Ascending)
Click Growth % to see products with negative growth (declining traffic) at the top. These need immediate attention.
🎯 Sortable Ranking Table Columns:
| Column | Click to Sort | Bottom = Products With… |
|---|---|---|
| Total Views ▼ | ✅ Yes | Lowest traffic (unseen products) |
| Conversions | ✅ Yes | Fewest sales (poor converters) |
| Growth % | ✅ Yes | Negative growth (declining interest) |
| Achievements | ✅ Yes | No milestones (stagnant products) |
📈 Growth Rate Indicator
The Growth % column shows week-over-week change, making it easy to spot trends at a glance:
+23%
📈 Strong Growth
Green indicator
+2%
➡️ Stable
Neutral indicator
-15%
📉 Declining
Red indicator
⚠️ Growth Calculation: Growth is calculated as ((current_week - previous_week) / previous_week) × 100. A product with 0 views last week but views this week shows as +100%. Products with no change show 0%.
🎯 Strategic Uses
🏆
Top Performers
- Feature prominently on homepage/email
- Stock up to prevent stockouts
- Test price increases (demand is strong)
- Create bundles around them
- Increase ad spend to ride momentum
⚠️
Bottom Performers
- Investigate SEO/visibility issues
- Improve photography or descriptions
- Adjust pricing or run promotions
- Consider discontinuing if chronic
- Check category placement
⏱️ Time Window Options
The Analytics Dashboard supports multiple time windows for flexible analysis:
| Period | Best For | Use Case |
|---|---|---|
| 24 Hours | Real-time monitoring | Flash sales, campaign launches |
| 7 Days | Weekly patterns | Weekly email alignment |
| 30 Days | Monthly trends | Inventory planning |
| 90 Days | Seasonal analysis | Long-term strategy |
💡 Pro Tips
🔄
Compare Time Periods
Switch between 7-day and 30-day views to distinguish between temporary dips and sustained declines.
📊
Use Growth Trends Chart
Select multiple products and switch to “Growth Trends” view to visually compare trajectories side by side.
🔍
Search for Specific Products
Use the search box above the ranking table to find specific products and check their relative performance.