
Marketplace Data for Brand Partners: Complete visibility
from signal to action
CPGIO
2026
CPGIO treats marketplace operations as a fully instrumented, data-driven trading desk. This framework describes how we consolidate operational, commercial, and media data into a single reporting layer, and how brands use that layer to drive decisions on pricing, inventory, media, and workflow.
Our goal is to make every material signal from Amazon and adjacent channels measurable, comparable, and actionable—down to the ASIN, task, and operator—while preserving a clean brand-level narrative for executive stakeholders.
We centralize first-party and partner data into a common model built for attribution and time-series analysis.
All signals captured at daily, weekly, monthly, quarterly, and annual granularity across Company → Brand → Sub-brand → UPC → ASIN → SKU → Channel hierarchy
Standardized identifiers, normalized P&L schema, consistent tagging for departments, teams, and campaigns
Amazon Seller Central: Orders, units, sales, fees, returns, sessions, conversion metrics
SellerCloud: Multi-channel orders, catalog, inventory status
SmartScout: Listing discovery and assessment, brand revenue estimates, category analysis, search term relevance
Repricers: Min/max prices, Buy Box win/loss, price deltas
Keepa: Historic pricing and rank curves
Amazon Ads / PacVue: Spend, sales, ROAS, ACOS, impressions, clicks, keyword performance, share of voice and category tracking, day-parting, budget management
HyperQue: Tasks by brand, ASIN, department, cycle times, revenue attribution, alerts, triggers, machine learning, diagnostics and reasoning agents
Domo: Custom dashboards, analytics, email reports
IBP/S&OP: Demand and inventory plans, capacity views, scenario modeling
Upstream systems feed into DOMO/HyperQue for ETL, transformation, and cleanup. Outputs are delivered through dashboards, forecasts, and alerts to brand partners. Temporal and LangGraph systems graph and structure data for AI and machine readability.
We distinguish between raw system outputs and the derived metrics brands actually use to make decisions.
AI-generated narrative summaries, trend and anomaly detection, recommendation engine for pricing adjustments, inventory actions, and content/media plays
| Metric | Q2 '25 | Q3 '25 | Q4 '25 Proj. |
|---|---|---|---|
| Sales Total | $2.08M ↑ | $2.65M ↑ | $2.71M |
| Units | 167.8K ↓ | 176.5K ↑ | 171.9K |
| Revenue/Unit | $12.39 ↑ | $15.03 ↑ | $13.55 |
| Profit | $235K ↑ | $280K ↑ | $287K |
| Profit % | 11.29% ↑ | 10.55% ↓ | 10.75% |
| Gross Margin | 12% ↓ | 13% ↑ | 12% |
| AMS Spend | $53.4K ↑ | $62.4K ↓ | $45.3K |
| ROAS | 6.7 ↓ | 7.3 ↑ | 10.2 |
| ACOS | 15% ↑ | 14% ↓ | 15% |
| Buy Box % | 70.3% ↑ | 70.7% ↑ | 59.2% |
| Conversion Rate | 11.0% ↑ | 11.2% ↑ | 9.4% |
| Total Inventory | $359K ↑ | $440K ↑ | $355K |
| Cases Received | 41.2K ↓ | 41.7K ↑ | 41.3K |
Performance Highlights
Strong revenue growth: Q3 sales reached $2.65M (+28% QoQ), driven by improved revenue per unit ($15.03, +21% QoQ)
Profit trajectory positive: Profit grew to $280K in Q3 (+19% QoQ), with Q4 projected at $287K
Marketing efficiency improving: ROAS trending upward (7.3 in Q3, projected 10.2 in Q4) despite increased spend
Key Concerns
Buy Box erosion: Projected to drop to 59.2% in Q4 (from 70.7% in Q3) - requires pricing/inventory action
Conversion risk: Expected decline to 9.4% in Q4 suggests listing or competitive pressure
Recommended Actions
Pricing optimization: Defend Buy Box share through dynamic repricing
Content: Improve listing quality to stabilize conversion rate
Inventory planning: Align Q4 receipts with demand to avoid stockouts
Track financial performance across brands, channels, and individual SKUs with full P&L visibility.
Revenue flows through product cost, packaging, fulfillment, platform fees, operations, and returns to net profit (CM3) in dollars and margin %.
Track cost components (COGS, shipping, FBA, commission, labor, freight) by dollar, per-unit cost, and % of revenue with trends.
View profitability at Company, Brand, UPC, or ASIN level across any time interval (daily, weekly, monthly, quarterly, annual) for full P&L visibility.
Track inventory position, coverage, aging, and procurement across all channels and SKUs.
| UPC | Product | 8/24 OH $ | 8/24 Qty | 8/31 OH $ | 8/31 Qty | 9/7 OH $ | 9/7 Qty | Weeks OH |
|---|---|---|---|---|---|---|---|---|
| 00123456789012 | Shampoo Variety Pack - 3ct | $3,655 | 583 | $4,386 | 700 | $4,449 | 710 | 1 |
| 00234567890123 | Conditioner Multipack - 2ct | $1,218 | 42 | $1,218 | 42 | $1,218 | 42 | 52 |
| 00345678901234 | Hair Mask Variety Pack - 3ct | $490 | 78 | $451 | 72 | $425 | 68 | 1 |
| 00456789012345 | Leave-In Spray - Each | $456 | 9 | $424 | 8 | $406 | 8 | 2 |
| 00567890123456 | Hair Oil Full Case | $378 | 90 | $343 | 82 | $306 | 73 | 2 |
| UPC | Product | Inventory OH $ | Qty | Sell Through Weekly | Weeks OH | Status |
|---|---|---|---|---|---|---|
| 00234567890123 | Conditioner Multipack - 2ct | $1,218 | 42 | 0.8 | 52 | ⚠ Excess |
| 00678901234567 | Hair Serum Multipack - 2ct | $636 | 64 | 8 | 8 | ✓ OK |
| 00789012345678 | Dry Shampoo Variety Pack - 3ct | $3,360 | 120 | 30 | 4 | ⚠ Replenish |
| 00890123456789 | Scalp Treatment - Each | $1,080 | 18 | 6 | 3 | ⚠ Replenish |
| 00901234567890 | Hair Gel Full Case | $2,450 | 280 | 16 | 17.5 | ⚠ Excess |
| UPC | Product | Cases Ordered | Cases Received | Cases Shorted | Value Ordered | Value Received | Value Shorted |
|---|---|---|---|---|---|---|---|
| 00123456789012 | Shampoo Variety Pack - 3ct | 1,947 | 1,877 | 96 | $117,817 | $116,249 | $2,030 |
| 00234567890123 | Conditioner Multipack - 2ct | 2,055 | 2,014 | 41 | $92,741 | $90,837 | $1,904 |
| 00345678901234 | Hair Mask Variety Pack - 3ct | 670 | 508 | 205 | $28,859 | $22,117 | $7,950 |
| 00456789012345 | Leave-In Spray - Each | 718 | 635 | 91 | $24,170 | $21,241 | $3,155 |
| 00567890123456 | Hair Oil Full Case | 294 | 289 | 5 | $23,186 | $22,837 | $349 |
Monitor buy box win rates, price competitiveness, and competitor intelligence across all channels and SKUs.
| SKU | My Price | BB Price | BB Winner |
|---|---|---|---|
| 00111222333444 | $22.74 | $22.74 | You |
| 00222333444555 | $31.26 | $31.26 | You |
| 00333444555666 | $41.04 | $41.04 | You |
| 00444555666777 | $31.96 | $31.96 | You |
| 00555666777888 | $25.50 | $24.61 | Competitor |
| 00666777888999 | $17.05 | $17.05 | You |
| 00777888999000 | $18.69 | $0.00 | No One |
| 00888999000111 | $32.96 | $32.62 | Competitor |
| 00999000111222 | $17.14 | $0.00 | No One |
| 00987654321098 | $22.56 | $0.00 | No One |
| SKU | 00555666777888 |
| Fulfillment Method | FBM |
| ASIN | B0B29MCW4Y |
| Price Min | $25.50 |
| Price Max | $27.97 |
| Repricer Name | Manual Min/Max Compete |
| Sales Rule | Margin Volume Rule |
| Seller Count | 8 |
| Buy Box Price | $24.61 |
| Buy Box Winner | Competitor, FBA |
| Reduction Needed | -$0.89 |
| My Price | $25.50 |
| Current Margin | 14.5%, Trade Needed: 11.4% (-3.1%) |
| Last Sale | 2025-08-20 21:23:32 |
| Quantity | 771 |
| Last Sales Rank | 59,684 |
For each UPC/ASIN:
Before/after windows around content changes:
| Stage | Count | Rate | Drop-off | Metric |
|---|---|---|---|---|
| Impressions | 133,172 | 100% | – | Search/Browse Views |
| Clicks (Sessions) | 14,318 | 10.75% | 89.25% | CTR |
| Add to Cart | 1,575 | 11.0% | 89.0% | ATC Rate |
| Purchases | 87 | 0.608% | 94.5% | CVR (Sessions → Purchase) |
Test: Hair Treatment Main Image
Duration: 4 weeks (06/10/2021 - 07/08/2021)
86% probability Version B is better
Considerable evidence that Version B is better
| Version | Product Title | Units/Visitor | Conversion | Units Sold | Sales | Sample Size |
|---|---|---|---|---|---|---|
| Version A | Deep Moisture Hair Treatment - Original Image | 0.001 | 0.0511% | 71 | $1,965 | 132,993 |
| Version B ✓ | Deep Moisture Hair Treatment - Lifestyle Image | 0.001 | 0.0608% | 87 | $2,407 | 133,172 |
| Difference | +19% conversion improvement | + 0 | + 0.0097% | + 16 | + $442 | + 179 |
Result: Lifestyle image showing product benefits outperformed white background product shot by 19% in conversion rate, generating +$442 in sales over 4 weeks.
Key Insight: The A/B test above demonstrates a 19% conversion lift from a simple main image change—from white background to lifestyle imagery. These reports identify which content changes drive measurable results, enabling faster iteration and higher ROI on creative investments.
Track spend, sales, ROAS, and ACOS by brand and channel. Monitor ad cost per unit and quarterly efficiency ratings.
Media performance by ASIN/UPC with organic vs paid sales split. Classify SKUs as Hero, Over-spend, or Under-funded.
Top search terms by performance with branded vs non-branded splits. Competitive bidding and impression share analysis.
| Search Term | Spend | Sales | ROAS | ACOS | Type |
|---|---|---|---|---|---|
| brand name | $5,832 | $46,656 | 8.0 | 12.5% | Branded |
| brand name hair treatment | $3,421 | $25,657 | 7.5 | 13.3% | Branded |
| hair treatment deep moisture | $4,521 | $29,387 | 6.5 | 15.4% | Non-branded |
| brand name deep conditioner | $2,764 | $19,348 | 7.0 | 14.3% | Branded |
| moisturizing hair mask | $3,812 | $20,965 | 5.5 | 18.2% | Non-branded |
| keratin treatment for hair | $3,456 | $15,552 | 4.5 | 22.2% | Non-branded |
| brand name hair mask | $1,987 | $13,909 | 7.0 | 14.3% | Branded |
| argan oil hair treatment | $2,634 | $10,536 | 4.0 | 25.0% | Non-branded |
| Campaign | NTB Product Sales | NTB Users | NTB % | Purchasers | Impressions | Clicks | Total Cost | Product Sales | ACOS |
|---|---|---|---|---|---|---|---|---|---|
| SP - Hair Treatment - Brand Defense | $15,234 | 482 | 38.4% | 1,254 | 124,562 | 3,821 | $4,921 | $39,667 | 12.4% |
| SP - Hair Mask - Category Growth | $8,921 | 327 | 41.2% | 794 | 86,432 | 2,567 | $3,124 | $21,654 | 14.4% |
| SP - Deep Conditioner - Competitor Conquest | $6,543 | 234 | 35.7% | 656 | 72,891 | 1,932 | $2,987 | $18,321 | 16.3% |
| SP - Moisture Repair - Seasonal Push | $4,876 | 189 | 39.1% | 483 | 58,234 | 1,456 | $2,134 | $12,467 | 17.1% |
| SP - Premium Hair Care Bundle | $3,621 | 145 | 42.8% | 339 | 41,567 | 987 | $1,532 | $8,456 | 18.1% |
Compare actual vs baseline sales to identify lost revenue and units. Track zero-sales days and Buy Box loss impact.
Week-over-week revenue changes with net gains and declines. Ranked lists of top declining and growing ASINs.
Automated checks for inventory issues, pricing changes, Buy Box shifts, and media disruptions to diagnose revenue losses.
| Date | Actual Sales | Expected | Lost $ | Lost % | Root Cause Flag |
|---|---|---|---|---|---|
| 2024-12-02 | $4,234 | $7,450 | -$3,216 | -43.2% | Out of Stock |
| 2024-12-01 | $5,621 | $7,320 | -$1,699 | -23.2% | Buy Box Lost |
| 2024-11-30 | $7,234 | $7,280 | -$46 | -0.6% | Normal Variance |
| 2024-11-29 | $0 | $7,150 | -$7,150 | -100% | Zero Sales Day |
| 2024-11-28 | $6,432 | $7,100 | -$668 | -9.4% | Price Increase |
| 2024-11-27 | $7,089 | $7,050 | +$39 | +0.6% | — |
| 2024-11-26 | $5,821 | $7,000 | -$1,179 | -16.8% | Listing Suppressed |
| 2024-11-25 | $7,654 | $6,950 | +$704 | +10.1% | — |
| 2024-11-24 | $6,987 | $6,900 | +$87 | +1.3% | — |
| 2024-11-23 | $6,321 | $6,850 | -$529 | -7.7% | Media Paused |
Baseline trends plus gradient boosting models forecast sales, profit, units, and media metrics with pace indicators.
IBP's with rolling 12-24 month views and scenario for base, upside, and downside.
Safety stock calculations and MRP dashboards showing forecast accuracy and plan vs actual variances by SKU.
| Metric | Forecast | Actual | Variance | Status |
|---|---|---|---|---|
| Units Sold | 185,000 | 192,450 | +7,450 (+4.0%) | On Track |
| Sales Revenue | $4,625,000 | $4,811,250 | +$186,250 (+4.0%) | On Track |
| Inventory Required | 52,000 | 48,500 | -3,500 (-6.7%) | Below Plan |
| Safety Stock | 15,600 | 16,200 | +600 (+3.8%) | Healthy |
| AMS Spend | $138,750 | $144,337 | +$5,587 (+4.0%) | On Track |
| Gross Margin % | 21.5% | 22.1% | +0.6pp | Exceeding |
Track revenue spikes/dips, margin compression, Buy Box drops, conversion shifts, and inventory risks with configurable thresholds.
Cross-check pricing, inventory, media changes, and competitive movements to generate hypothesis cards with confidence ratings.
One-click task creation linking to brands and ASINs. Resolved alerts train better thresholds and improve detection accuracy.
| METRIC | OCTOBER | NOVEMBER | JANUARY | FEBRUARY |
|---|---|---|---|---|
| Total Sales | ▼ $121 | ▼ $240 | ▲ $181 | $156 |
| Average AOV | ▼ $30 | ▲ $40 | $36 | $31 |
| Total Orders | ▼ 4 | ▼ 6 | ▲ 5 | 5 |
| Average BB% | ▼ 3% | ▲ 34% | 25% | 13% |
| Total Units | ▼ 16 | ▼ 18 | ▲ 15 | 15 |
| Total AMS Spend | ▲ $1,845 | ▲ $1,854 | ▲ $2,940 | $1,940 |
| Total AMS Sales | ▲ $1,620 | ▲ $1,854 | ▲ $2,940 | $1,556 |
| AMS Sales % | ▼ 78% | ▼ 75% | 75% | ▼ 64% |
Closed-Loop Intelligence: The system learns from every resolved alert. When teams take action and document outcomes, those patterns train better thresholds and smarter root-cause detection—making the next alert more accurate and actionable.
Track tasks aligned to revenue by ASIN/UPC with time windows. Growth attributed to catalog, optimization, marketing, and pricing efforts.
Compare task volume and revenue across departments. Identify top contributors, highest growth teams, and declining areas.
Monitor tasks completed, cycle time, and throughput by operator and responsibility type for capacity planning.
| Operator Name | Tasks Completed | Avg Cycle Time (hrs) | Tasks/Day | Revenue Impact |
|---|---|---|---|---|
| Haley | 342 | 2.3 | 8.5 | $127,450 |
| Arth | 298 | 1.8 | 7.4 | $94,320 |
| Harkeerat | 276 | 2.1 | 6.9 | $112,890 |
| Sarah | 254 | 2.5 | 6.3 | $88,760 |
| Marcus | 241 | 1.9 | 6.0 | $76,540 |
| Priya | 228 | 2.7 | 5.7 | $81,230 |
| Jordan | 215 | 2.0 | 5.4 | $68,900 |
| Alex | 203 | 2.4 | 5.1 | $59,870 |
| Responsibility Type | Count | Avg Cycle Time | Max Cycle Time |
|---|---|---|---|
| Listing Update | 1,245 | 1.5 hrs | 8.2 hrs |
| Content Audit | 687 | 3.2 hrs | 12.5 hrs |
| Campaign Add | 423 | 0.8 hrs | 3.1 hrs |
| Listing Create | 398 | 2.7 hrs | 11.8 hrs |
| Price Update | 356 | 0.5 hrs | 2.3 hrs |
| Image Update | 312 | 1.9 hrs | 7.6 hrs |
| ASIN Merge | 187 | 4.1 hrs | 16.3 hrs |
| Keyword Research | 154 | 2.3 hrs | 9.4 hrs |
Reports are delivered through flexible dashboards, automated exports, and seamless integrations—ensuring every stakeholder gets the right data, in the right format, at the right time.
Cloud-native dashboards with instant access, real-time refresh, and mobile-first design for executives on the move.
Automated cadences and self-service query tools deliver insights without manual intervention or data team bottlenecks.
Open architecture with API access, flat-file drops, and direct connections into enterprise data ecosystems and planning systems.
Flexible Access Philosophy: Different stakeholders need different views. Executives want mobile-friendly summaries. Analysts need raw data exports. Operations teams need real-time alerts. We deliver all three without forcing everyone into the same interface.
The framework is designed to evolve as data sources and AI capabilities expand.
Auto-generated QBR decks and executive memos from live data
Agentic playbooks that:
The future of marketplace intelligence isn't just better dashboards—it's autonomous systems that detect, recommend, execute, and learn. CPGIO is building toward that future while delivering measurable value today.
Ready to transform your marketplace data into actionable intelligence?
Contact us to see how CPGIO's reporting framework drives results.
Email: [email protected]
Web: cpg.io
CPGIO
Intelligence & Reporting Framework • 2026