You check Shopify. Revenue is up 12% month-over-month. You check Google Ads. ROAS is 3.8x. You check Klaviyo. Email drove $30K this month.

Everything looks great — until you check your bank account. Profit is flat. Where did the growth go?

The answer is always the same: your tools are each telling you their own version of the story, and none of them are talking to each other.

Shopify counts gross revenue — before returns. Google Ads claims credit for sales that Klaviyo also claims. Your actual COGS aren't in any dashboard. And the 22% return rate on that viral product? Nobody flagged it because returns are tracked in a separate system.

This is the e-commerce data strategy problem. And it's costing DTC brands 15-30% of their potential profit.

The 5 Data Gaps Killing E-Commerce Profitability

Gap 1: Gross Revenue ≠ Net Revenue

Shopify shows order total. It doesn't show:

Returns (15-30% in apparel, 10-15% in electronics)
Chargebacks (0.5-1.5% of transactions)
Failed payments on subscriptions
Discounts and coupon code abuse

A brand doing $100K/month in gross Shopify revenue might only collect $72K after returns, chargebacks, and payment failures. That's a 28% gap that doesn't appear on any default dashboard.

Gap 2: Ad Platform ROAS Is Fiction

We covered this in depth in our real ROAS calculator guide, but the short version: Google and Meta both claim credit for the same sale, count revenue that later refunds, and attribute organic purchases to ads. The inflation averages 25-40%.

Gap 3: COGS Are Invisible

Most Shopify analytics tools show revenue and marketing spend. They don't show:

Product cost per unit
Shipping costs per order
Packaging and fulfillment costs
Payment processing fees (2.9% + 30¢ per transaction adds up fast)

Without COGS, you don't know your gross margin. Without gross margin, you can't calculate true CAC payback or real profitability by product.

Gap 4: Customer LTV Is Guessed, Not Calculated

Shopify shows "returning customer rate" but not true lifetime value. Real LTV requires:

Total collected revenue per customer (not gross — net of returns)
Total orders over time
Retention rate by cohort
Average time between purchases

Most brands guess LTV. The ones that calculate it realize their best customers are 10-20x more valuable than average — and they're not marketing to them differently.

Gap 5: Channel Attribution Is Broken

A customer sees a Meta ad Monday, gets a Klaviyo email Wednesday, clicks a Google Shopping ad Friday, and buys. Every platform claims the full $80 sale. Your total attributed revenue is $240 for a single $80 purchase.

The Connected E-Commerce Data Stack

Here's what you need connected and why:

| Tool | What It Tells You | Connects To | |------|-------------------|-------------| | Shopify | Orders, products, returns | Payment processor, ad platforms | | Stripe/Shopify Payments | Collected revenue, refunds, chargebacks | Accounting, analytics | | Google Ads | Paid search spend and clicks | Payment processor (for real ROAS) | | Meta Ads | Social ad spend and impressions | Payment processor (for real ROAS) | | Klaviyo | Email revenue attribution | Payment processor (for real email ROI) | | QuickBooks | COGS, expenses, true P&L | Bank account, payment processor |

The Single Number That Matters

Once connected, you can calculate the one number every e-commerce founder should obsess over:

Contribution Margin per Order = Net Revenue - COGS - Shipping - Payment Fees - Allocated Ad Spend

If this number is negative, you lose money on every order. No amount of scale fixes that. If it's positive, every optimization to increase it compounds.

Building Your Data Strategy

Phase 1: Connect Revenue Truth (Week 1)

Connect Shopify to your actual payment processor. Stop looking at Shopify gross revenue. Start tracking:

Collected revenue (what hit your bank)
Net revenue (collected minus returns and chargebacks)
Collection rate (net / gross)

Phase 2: Connect Ad Spend to Real Revenue (Week 2)

Connect Google Ads and Meta Ads to your payment processor. Calculate real ROAS per channel:

Real ROAS = (Net Revenue from Channel) / (Channel Ad Spend)

Phase 3: Add COGS (Week 3)

Set up product costs in Shopify or your accounting tool. Calculate per-product margin. Identify:

Products with highest margin (promote more)
Products with highest return rate (investigate why)
Products with negative contribution margin after ad spend (stop advertising them)

Phase 4: Build Customer Intelligence (Week 4)

Calculate actual LTV per customer and per acquisition channel. Which channels bring customers who:

Buy more than once?
Have lowest return rates?
Have highest LTV?

This is the data that transforms your marketing. Instead of optimizing for cheapest CPA, optimize for highest LTV — even if the upfront cost is higher.

How NuMoon Helps E-Commerce Brands

NuMoon connects Shopify, Stripe, Google Ads, Meta Ads, Klaviyo, and QuickBooks through one-click OAuth. It:

Calculates real ROAS daily (not platform-reported)
Tracks net revenue after returns and chargebacks
Identifies products with rising return rates
Predicts which customers are about to churn
Alerts when ad campaigns drop below your ROAS target
Generates weekly P&L from connected data

This is the data strategy described above — automated and running continuously.

Frequently Asked Questions

What's a good contribution margin for e-commerce?

30-50% is healthy for most DTC brands after COGS, shipping, payment fees, and allocated ad spend. Below 20% means you're likely losing money at scale. Above 50% gives you room to invest in growth.

How do I track returns by product?

Shopify tracks refund reasons if you configure them. Connect refund data to product data and calculate return rate per SKU monthly. Any product above 20% return rate needs investigation — it's either a quality issue, a sizing/description mismatch, or a targeting problem (wrong audience buying it).

Should I use Shopify analytics or a separate tool?

Shopify analytics is fine for basic metrics (revenue, orders, traffic sources). It falls short for cross-channel attribution, real ROAS, contribution margin, and customer LTV. If you're spending more than $5K/month on ads, you need connected analytics.

Your Dashboard Isn't Your Business

The numbers on your Shopify dashboard are a version of reality — a flattering one. Your business lives in the gap between what your tools report and what your bank account shows.

Close that gap. Connect your tools. Calculate the real numbers. Make decisions based on collected revenue, not reported revenue.

Take the free health scan to see how much revenue is falling through the cracks in your e-commerce stack.