Envisioned Products — Executive Dashboard V2

Executive Overview All-time aggregated KPIs

Revenue by Category — click "Sales by Category" tab for details

Cinch Straps

71%

$1.09M

71.4%

Bumper Pads

10%

$146.3K

9.6%

Cable Organizers

8%

$119.4K

7.9%

Cable Ties

8%

$117.0K

7.7%

Hook & Loop

2%

$31.7K

2.1%

Cable Clips

1%

$17.8K

1.2%

Personal Care

0%

$2.4K

0.2%

Uncategorized

0%

$20

0.0%

Revenue Trend

Monthly total revenue split by D2C consumer and B2B wholesale sales.

Health Scorecard

At-a-glance performance indicators.

Category Revenue Trend

Gross Margin by Category

ℹ️ Cost data: 269 of 270 SKUs matched (100%).

Sales by Month Revenue, units, sessions, CVR, refunds

Monthly Revenue

Sessions (D2C vs B2B)

Sessions

Total listing visits by channel.

D2C sessions declining from mid-2024 peaks
B2B sessions steady at ~1.3-1.8K/mo
Action: Increase PPC + external traffic to recover D2C volume

CVR Trend

Conversion Rate

% of sessions resulting in a purchase.

CVR improving from ~15% to ~17% — listing optimization working
Higher CVR partially offsets session decline
Action: Continue listing optimization — focus PPC on volume recovery

Refund Rate

% of units refunded per month.

Average ~6-7% — acceptable for Amazon
Spikes above 8% warrant SKU-level investigation
Action: Identify top-refunded SKUs, improve listing accuracy

Year-over-Year Comparison

Month	Revenue	Prev Year	YoY	Units	Prev Units	YoY	Sessions	Sess YoY

Year-over-Year

Same-month comparison isolating seasonal effects.

Revenue declining YoY — structural, not seasonal
Session drops are the primary driver; CVR is improving
Action: Traffic recovery is the #1 priority

Sales by Category Revenue, margins, and profitability by product category

Revenue by Category

Cinch Straps

71%

$1.09M

71.4%

Bumper Pads

10%

$146.3K

9.6%

Cable Organizers

8%

$119.4K

7.9%

Cable Ties

8%

$117.0K

7.7%

Hook & Loop

2%

$31.7K

2.1%

Cable Clips

1%

$17.8K

1.2%

Personal Care

0%

$2.4K

0.2%

Uncategorized

0%

$20

0.0%

Category Revenue Trend (Monthly)

Gross Margin by Category

Category Summary

Category	Types	SKUs	Units	Revenue	Margin %	Est. Profit
Cinch Straps	8	164	64.5K	$1.09M	77.2%	$838.0K
Bumper Pads	1	23	10.6K	$146.3K	78.3%	$114.5K
Cable Organizers	1	16	7.4K	$119.4K	65.1%	$77.8K
Cable Ties	5	27	8.2K	$117.0K	77.2%	$89.0K
Hook & Loop	5	16	1.9K	$31.7K	71.7%	$22.7K
Cable Clips	1	21	1.1K	$17.8K	73.0%	$13.0K
Personal Care	1	2	56	$2.4K	81.4%	$2.0K
Uncategorized	1	1	1	$20	0.0%	$0

Category Analysis

Cinch Straps leads with $1.09M (71% of total).
Bumper Pads is second at $146.3K.
Weighted gross margin: 76.2% — estimated gross profit: $1.16M.
Action: Category concentration at 71% in Cinch Straps — diversify to reduce risk.
Highest margin category: Personal Care at 81.4%.

Sales by ASIN SKU rankings, concentration, trends

Top 15 SKUs by Revenue

Top SKUs by Revenue

All-time revenue ranking across all months.

CS-0240 (2"x40" Cinch 6-Pack) is the clear #1 revenue driver
Top 5 mix cinch straps, bump protectors, and cable organizers — good diversity
Action: Protect top 5 with aggressive PPC defense and review velocity

Revenue Concentration

How revenue is distributed across SKU tiers — shows dependency risk.

Inner ring: top 5 vs rest. Outer ring: tier breakdown.
Heavy concentration in top SKUs = risk if any one product drops
Action: Grow #6-15 SKUs to reduce concentration below 30%

Top 5 SKU Monthly Trends

SKU Trends

Monthly revenue trajectory for top 5 SKUs.

CS-0240 shows seasonal peaks but overall decline
EV-1518/BK (cable organizer) is relatively stable
Action: Investigate CS-0240 decline — traffic loss, competitors, or pricing?

Top SKU Performance Table

SKU	Title	Cat	Rev ▼	Units	ASP	CVR%	Margin%	Est Profit	B2B%	Sess

SKU Table

Click headers to sort. Use filters to search.

High CVR + Low Sessions = needs more traffic (PPC opportunity)
Low CVR + High Sessions = listing isn't converting (optimize)
Action: Sort by CVR to find hidden gems that lack traffic

Bottom 10 SKUs (Lowest Revenue)

SKU	Title	Revenue	Units	ASP	CVR%	Sessions

Bottom Performers

Lowest-revenue SKUs — candidates for review or discontinuation.

Low revenue may be acceptable for niche/long-tail SKUs
Zero-session SKUs may have listing or inventory issues
Action: Evaluate whether these SKUs justify catalog space and ad spend

Search Query Performance Brand keyword insights from Amazon Brand Analytics

Monthly Impressions & Clicks

Impressions & Clicks

Brand visibility in search results (impressions) and click-through volume.

Click growth outpacing impressions = improving listing appeal
Action: If impressions rise but clicks don't, test new thumbnails/titles

CTR & Purchase Rate

Click-through rate and purchase conversion from brand queries.

CTR = listing appeal in search. Purchase rate = conversion once they arrive
Action: CTR drops → test images/titles. Purchase drops → check reviews/pricing

High Performers

Keyword	Impr	Clicks	Purchases	CTR%	CVR%

High Performers

Keywords generating impressions, clicks, AND purchases.

These are your highest-value organic keywords — protect and scale
Action: Ensure exact-match PPC campaigns on every high performer

Opportunities (Clicks, No Purchases)

Keyword	Impr	Clicks	Purchases	CTR%	CVR%

Opportunities

Customers click but don't buy — a conversion gap.

Could be pricing, reviews, listing copy, or product-fit mismatch
Action: Review listings for these keywords — are you showing up for the right product?

PPC Advertising Sponsored Products — Last 30 Days

Portfolio Spend vs Sales

Ad spend vs attributed sales per product line. Green exceeding red = profitable.

Portfolio Table

Portfolio	Spend	Sales	ACOS	TACoS	ROAS	Orders	CVR%

Portfolio Table

ACOS = ad spend / sales. Below 25% = efficient. Above 40% = review needed.

Action: Portfolios over 40% ACOS need campaign audit

Top Search Terms by Sales

Term	Spend	Sales	Clicks	Orders	ACOS

Top Converting Terms

Customer searches generating the most ad revenue.

Wasted Spend (No Sales)

Term	Spend	Clicks	Impr

Wasted Spend

Terms with clicks but zero sales — pure waste.

Top Campaigns

Campaign	Spend	Sales	ACOS	ROAS	Orders

Campaign Table

Individual campaigns by spend.

Top-spend should have best ROAS. ACOS over 50% erodes margin.
Action: Shift budget from high-ACOS to proven performers below 25%

Seller Performance Daily operational metrics

Daily Revenue with 7-Day MA

Daily Revenue

Raw daily revenue smoothed with 7-day moving average to reveal the trend.

The 7-day MA is the signal — daily noise is normal
Sustained MA drops below $3K = investigate immediately
Action: Watch for 2+ week MA declines as early warnings

Daily Refund Rate (7-Day MA)

Daily Refund Rate

Daily % refunded, smoothed with 7-day MA.

Sustained spikes above 10% = product or listing issue
Action: Check Voice of Customer in Seller Central when MA spikes

Avg Revenue by Day of Week

Day of Week

Revenue patterns by weekday.

Weekdays typically outperform weekends (B2B buyer pattern)
Action: Consider higher PPC bids on your strongest weekdays

Top 10 Growth Moves Ranked by revenue impact

1

Margin Compression Alert HIGH

2 SKUs have gross margin below 40%. Examples: EV-1515/BK (1.0%), BM-1509 (32.0%). Review pricing or cost structure.

2

Recover Traffic Decline HIGH

Sessions dropped from peak levels. Revenue gap from peak: $-141.9K. Invest in PPC, external traffic, listing SEO.

3

Reduce Category Concentration HIGH

Cinch Straps accounts for 71% of revenue. Diversify into under-represented categories to reduce risk.

4

B2B Growth: Cable Organizers MEDIUM

Cable Organizers has only 7% B2B share. Target business buyers with bulk packs and Amazon Business pricing.

5

Cut PPC Waste HIGH

3896 search terms wasting $3.3K with zero sales. Add negative keywords.

6

Scale High-Margin Winners MEDIUM

Focus PPC budget on SKUs with margin above 50% to maximize profit per ad dollar.

7

ASP Optimization MEDIUM

ASP $16.21. Test small increases on high-margin SKUs. Even $0.50 lift adds significant margin.

8

Reduce Refund Rate MEDIUM

Overall 5.9%. Each 1% reduction saves ~$25.8K.

9

Seasonal Inventory Planning MEDIUM

Revenue peaks Jun-Aug, drops Dec-Jan. Plan PPC + inventory 6-8 weeks ahead.

10

Reduce SKU Concentration MEDIUM

Top 5 = 23% of revenue. Grow #6-15 SKUs to reduce single-product risk.