ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
🏠 PROFIT MARGIN TRACKING DASHBOARD — Shopify Dropshipping
2
Research-backed by Gemini Deep Research • 6-Layer Cost Waterfall • Break-Even ROAS • SKU Tiering
3
4
TOTAL NET REVENUETOTAL AD SPENDBLENDED ROASTOTAL CM3NET PROFIT
5
$2,786$3887.39x$1,059$270
6
From Daily Data Input TabMeta + TikTok + GoogleGross Revenue ÷ Total Ad SpendTrue Contribution MarginCM3 minus Monthly Fixed Costs
7
8
9
📊 STORE HEALTH SUMMARY
10
MetricValueTargetStatus
11
CM3 % (Blended)38.0%>20%
12
Gross Margin % (Blended)72.3%>50%
13
Ad Spend % of Revenue13.5%<30%
14
Avg Transaction Fee %4.0%<4%
15
Blended ROAS7.39x>3.0x
16
Total Orders (Period)5—
17
Fixed Cost Coverage1.3x>1.5x
18
19
20
🏷️ SKU TIER SUMMARY
21
TierCountAvg CM3 %Strategy
22
⭐ Star00.0%Scale ad spend aggressively on these
23
🐴 Workhorse00.0%Optimize supply chain, hold ad spend
24
❓ Puzzle443.4%Fix creatives & marketing funnel
25
🐕 Dog121.9%Review pricing or discontinue
26
27
28
💡 THE 6-LAYER COST WATERFALL (Gemini Deep Research Verified)
29
1Gross RevenueYour raw Shopify sales figure before deductions
30
2 − RefundsLost revenue from returned orders
31
▶NET REVENUEWhat Shopify actually deposits (starting point)
32
3 − Landed COGSFactory Cost + Inbound Freight + Customs Duty + Insurance + Overhead
33
▶CM1 / GROSS PROFITDoes your markup work? Healthy DS: >50%
34
4 − Outbound ShippingLabel costs + 3PL/fulfillment handling fees
35
5 − Transaction Fees2.9% + $0.30/order (Basic). $0.30 fixed fee kills low-AOV products!
36
6a − Returns Allowance2–5% of revenue reserved for returns (industry benchmark)
37
▶CM2 / FULFILLMENT-ADJ PROFITWhat you make BEFORE ads. Break-Even ROAS = Price ÷ CM2
38
6b − Ad SpendMeta + TikTok + Google (SKU-attributed)
39
▶CM3 / CONTRIBUTION MARGINTRUE net profit per unit. Target: 15–30% for optimized stores
40
7 − Fixed Cost AllocationApps + VA + Domain amortized per order
41
▶NET INCOMEReal bottom-line profitability
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100