Dashboard
all countries · oct 2025 – feb 2026
Monthly Orders (Total)
4,800
All regions · pure sale
Top SKU (Monthly)
WFC1
2,200 units/month
Top Region
🇺🇸 US
1,950 units/month
Active Markets
7
US CA UK DE FR IT ES
Monthly Volume — All Markets
Transactions by Country (Total)
Quick Links — Google Sheets
Monthly Transactions by Model
actual data from CSV files · oct 2025 – feb 2026
| Model | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Total |
|---|
Transactions per Model — Monthly Trend
Transactions by Country
monthly breakdown · oct 2025 – feb 2026
| Month | 🇺🇸 US | 🇬🇧 UK | 🇨🇦 CA | 🇩🇪 DE | 🇫🇷 FR | 🇮🇹 IT | 🇪🇸 ES | Total |
|---|
Monthly Transactions — Multi-Country
Daily Transactions
day-by-day volume estimate
From:
To:
Country:
Model:
| Date | Day | Est. Orders | Top Model | Status |
|---|
Returns Analysis
all transactions in files are refunds · oct 2025 – feb 2026
Refunds by Country
Monthly Refund Trend
Refunds by Country
| Country | Refunds | Oct | Nov | Dec | Jan | Feb |
|---|
Refunds by Model
| Model | Oct | Nov | Dec | Jan | Feb | Total |
|---|
🔐 Access Control
manage who can sign in · super admins are always allowed
★
Super Admins — always have access
Add User
Google Email
Role
Allowed Users (0)
Super admins cannot be removed
| Role | Added by | Added at | Remove |
|---|
🔒 Password Login Management
Set or reset password for any allowed user. They can then sign in via the Password tab.
User Email
New Password
Users with password set:
—
🔄 Sync & Data Preview
fetch live data from all google sheets · preview raw rows
Data Synchronization
Pulls live data from all 7 marketplace sheets and all report sheets via Google Sheets API
No data cached
Raw Data Preview
—
Sync data first to preview raw sheet contents
📈 PPC Analytics
us marketplace · oct–dec 2025 · ppc vs organic · cpc · acos
Market:
Total Orders — PPC vs Organic
Total Sales ($)
CPC Trend by Model
ACOS / TACOS %
PPC Spend by Model
Full PPC Data Table
📆 Daily Orders
all markets · oct 2025 – present · auto-loads on country select
Select country to load
Daily Orders — US
7-day MA shown in lighter shade
By Model (stacked area)
Top Models — Totals
Daily Table (last 60 days)
Select a country above to load data (Google sign-in required)
📦 Inventory & Stock Analysis
stockout days · days of supply · inbound tracking ·
↗ Inventory Sheet
Not loaded
Stock by Model (all countries)
Stock distribution by Country
Days of Supply (DoS) Calculator
Avg daily sales (units/day) — override or auto from last 30d:
Load inventory to calculate
Stockout & Zero-Sales Days Analysis
Counts days with 0 orders per model per month — requires daily data sync
Sync daily orders data to see stockout analysis
Current Stock Counts
Click "Load Inventory" to fetch latest stock counts
🌐 All Markets Total
aggregated · 7 markets · oct 2025 – present
Total Orders by Market
Revenue by Model
Monthly Trend — All Markets
Market Share %
All Markets Summary Table
💰 SKU Profitability
contribution profit · margin · ROI · per model per market
Contribution Profit by SKU
Margin % by SKU
ROI % by SKU
Revenue vs Ads Spend
Update SKU Costs
SKU Profitability Table
🔮 12-Month Forecast
base · aggressive · risk scenarios · inventory required · cash impact
Revenue Forecast
Net Profit Forecast
Inventory Required ($)
Cumulative Cash Impact
Forecast Table
💵 Cash Flow & Conversion Cycle
monthly P&L · reinvestment · cash cycle · loan + VAT planning
Monthly P&L Waterfall
Cumulative Net Profit
Cash Conversion Cycle (days)
Reinvestment vs Net Profit
Monthly Summary Inputs
Cash Conversion Cycle Planner
Reinvestment Overview
📊 Inventory Dashboard
real-time stock levels · days of supply · stockout alerts · reorder triggers
Inventory by SKU (units)
Days of Supply by SKU
Inventory Trend (snapshots)
Stock by Region
Inventory Status Table
🗺️ Inventory World Map
choropleth — stock levels by country · click country for details
Country Ranking
Days of Supply by Country
Country Detail
👆 Click a country on the map
Country Summary Table
🧮 Inventory Planning Calculator
days of stock · stockout date · reorder point · safety stock · reorder quantity
Calculator Inputs
Stock Projection (90 days)
Detailed Results by SKU × Region
🚢 Shipment Planning Simulator
modify quantities · arrival dates · see live stockout impact
Shipment Configuration
Simulation Parameters
Inventory Curve — 9 Months
Stockout Risk Timeline
Payment Schedule
Stockout Analysis by SKU × Region
💡 Price Strategy to Extend Stock Runway
Higher price → fewer sales → longer DoS
📦 Units Sold Between Orders (by delivery dates)
🔮 Sales & Inventory Forecast
demand forecast · inventory needs · reorder timing · cash planning
Demand Forecast (units/month)
Inventory Level Projection
Reorder Timeline
Inventory Required ($)
Forecast Table
🧮 Calculator
acos target · break-even · margin · price analysis
Target ACOS Calculator
Find max ACOS to stay profitable
RESULTS
PPC Break-Even Calculator
Orders needed to break even on PPC spend
CPC → ROAS Required
Model Price & Margin Comparison
| Model | Price US ($) | Est COGS ($) | Gross Margin | Break-Even ACOS | Oct Orders | Nov Orders | Dec Orders |
|---|
⚗️ A/B Test Calculator
statistical significance · conversion rates · sample size
Significance Test
CONTROL (A)
VARIANT (B)
Sample Size Calculator
How long to run your A/B test
PPC Campaign Comparison — US (All 5 Months)
| Model | Month | CPC | CPC Δ | ACOS% | ACOS Δ | Orders | Orders Δ | PPC Spend |
|---|
Report Sheets
all analysis spreadsheets · open inline or in google drive
Select a sheet below to preview it here
↩ Returns Analysis
📦 Monthly Orders
📅 Daily Sales / Orders
📦 Other Tools
🎯 Inventory Forecast & Risk
stockout dates · order sufficiency · price scenarios · all SKUs × all markets
💳 Cash Flow Planner
orders 7–12 · V1 / V2 / V3 scenarios · monthly payments vs Amazon receivables · running balance
Scenario:
Start Cash:
Debt James:
Debt Ship:
📦 Order Timeline Calculator
orders 7–12 · v1 optimistic vs v2 conservative · payments · units sold · cash flow
📅 Order Gantt — Lead Time → Sell Period → Payment
📦 Units Sold Per Delivery Window
💰 Cumulative Cash Flow — Payments Timeline