A multi-channel e-commerce brand selling across Amazon, Shopify DTC, Wholesale, TikTok Shop, and Retail had no unified view of revenue, margins, or channel profitability. We built the entire data pipeline from scratch — from 5 disconnected platforms to a single automated financial dashboard.
The brand was doing $14.2M in annual revenue across five channels — but the founder couldn't answer a simple question: "Which channel is actually the most profitable?" Amazon looked like the biggest revenue driver at $5.8M, but after marketplace fees, FBA costs, and ad spend, the margin picture was completely different. Shopify DTC was smaller in revenue but had 3× the margin rate.
Each channel exported data in a different format. Amazon had Seller Central reports. Shopify had its own analytics. Wholesale lived in QuickBooks. TikTok Shop had a CSV export. Retail partners sent Excel files monthly. The bookkeeper spent 8–10 hours every week reconciling these into a single P&L spreadsheet — and still couldn't produce a channel-level margin analysis.
We built an automated pipeline that extracts, transforms, and unifies data from all 5 channels daily — and feeds it into a real-time financial dashboard with revenue trending, margin waterfall decomposition, channel comparison, and product-level profitability.
Five disparate data sources, each with different schemas, refresh cadences, and formats — unified into a single clean data model that updates daily at 6 AM before the team arrives:
The revenue breakdown shows Amazon at $5.8M (41% of total), followed by Shopify DTC at $3.4M (24%), Wholesale at $2.6M (18%), TikTok Shop at $1.4M (10%), and Retail at $1.0M (7%). At first glance, Amazon is the clear leader.
But the margin story inverts the picture entirely. Shopify DTC operates at a 62% gross margin — nearly double Amazon's 34%. After marketplace fees, FBA costs, and advertising spend, Amazon's contribution margin drops to just 18%. Meanwhile, Shopify's owned-channel economics (no marketplace commission, lower ad dependency) make it by far the most profitable dollar-for-dollar.
Key insight: Every $1 shifted from Amazon to Shopify DTC generates $0.28 more in gross profit. The brand's growth strategy should prioritize DTC customer acquisition — even at higher marketing cost — because the lifetime margin economics are dramatically better.
The margin waterfall decomposes every dollar of revenue into its cost components. Starting from $14.2M in gross revenue: COGS consumes $5.7M (40%), leaving $8.5M in gross profit. From there, marketplace fees take $1.5M, shipping costs $1.2M, advertising $1.1M, returns and refunds $0.8M, and operating overhead $0.8M — landing at $3.1M in operating profit (22% operating margin).
The waterfall reveals that marketplace fees and advertising together consume $2.6M — more than COGS for the DTC channels. This "hidden tax" of selling on third-party platforms was invisible when each channel reported separately.
The business has extreme seasonality. November and December alone account for 28% of annual revenue. But the rush to capture holiday demand compresses margins: ad costs spike 40% as CPMs rise, return rates nearly double, and the channel mix shifts toward Amazon (lower margin) as shoppers default to Prime for fast delivery.
The result: Q4 revenue is 2.4× Q1, but Q4 operating margin is actually 3 percentage points lower than Q2 (the most profitable quarter). The unified financial dashboard made this pattern visible for the first time — previously hidden across five disconnected reports.
Product-level profitability analysis revealed that the brand's 200+ SKU catalog is heavily concentrated: the top 12 SKUs generate 68% of total gross profit. But buried in the top 20 by revenue are 4 SKUs that are actually margin-negative once you allocate channel fees, shipping, and advertising at the SKU level.
These "zombie SKUs" looked profitable in the old spreadsheet because fees were allocated at the channel level, not the product level. The new pipeline allocates every cost to its specific SKU, revealing the true winners and losers.
Key insight: Discontinuing the 4 margin-negative SKUs would save approximately $180K in annual losses while freeing up warehouse space and operational bandwidth. Two of the four were high-volume Amazon listings — they looked like "top sellers" but were actually destroying value after fully-loaded costs.
Return rates vary dramatically by channel. Amazon averages 14.2% returns (driven by free-return policy and impulse purchasing), while Shopify DTC is at 5.8%, Wholesale at 2.1%, TikTok Shop at 8.4%, and Retail at 3.2%. The dollar impact of Amazon's return rate — $420K annually in returned product, restocking, and write-offs — exceeds the combined return cost of all other channels.
Select a channel and time period to explore revenue, margins, and unit economics. All metrics recalculate instantly.
Daily extraction from Amazon, Shopify, QuickBooks, TikTok Shop, and Retail EDI — all normalized into a unified star schema by 6 AM every morning.
Revenue → COGS → gross profit → fees → shipping → ads → returns → operating profit. Every cost allocated at the channel and SKU level.
True product-level P&L with fully-loaded costs. Identified 4 margin-negative "zombie SKUs" that looked profitable at the channel level.
Side-by-side comparison of all 5 channels across 12 financial metrics: revenue, margin, AOV, return rate, CAC, LTV, and more.
Monthly and quarterly views reveal how channel mix, margins, and return rates shift with demand cycles — critical for inventory and ad budget planning.
Built as a self-contained web dashboard with Chart.js. No Power BI or Looker subscription needed. Updates via JSON data feed from the Python pipeline.
Bookkeeper time reclaimed from manual reconciliation
From discontinuing margin-negative SKUs
Real-time financial view — was monthly at best