Industries/CPG/Use Case

Real-Time Margin by SKU, Across Every Retailer — Consumer Brands

Tera Bullion builds retail analytics for CPG brands: SKU-level margin analysis, promotional lift measurement, and velocity tracking powered by your POS and distributor data. The answers buried in retailer portals and EDI exports — which SKUs actually make money where, and which promotions actually lifted — become a live view your team reads every morning.

ScaleReal-time margin by SKU, across every retailer

What is unread POS data actually costing you?

Your retailers already tell you almost everything: what sold, where, when, at what price. It arrives as portal downloads and EDI feeds — and at most brands it piles up unread, because turning a dozen retailers' exports into an answer is hours of spreadsheet work with a shelf life of a week.

So the expensive questions go unanswered. Which SKUs are actually profitable at which retailers, after freight, deductions, and trade spend? Did the promotion you funded lift velocity enough to pay for itself, or did it just discount product that would have sold anyway? Which account's beautiful volume is quietly margin-negative? The data that answers all three is already in your possession — sitting in exports nobody has time to join. Flying half-blind on your own retail performance isn't a data problem. It's a plumbing problem.

Why don't the obvious fixes work?

The quarterly spreadsheet deep-dive produces real answers at analyst cost, months late. Line review prep gets done, the deck gets built — and the insight is already stale, unrepeatable, and gone from institutional memory by the next cycle. Analysis as an event, when the business needs it as a utility.

Relying on distributor and broker summaries means reading your business through an intermediary's lens — aggregated, delayed, and shaped by what the intermediary wants to discuss. Deductions and chargebacks, where margin quietly dies, rarely headline someone else's report.

Retailer portal dashboards, checked one at a time, each show one account's slice with no costs attached. Twelve portals don't add up to a picture of the business — and none of them will ever tell you an account is unprofitable for you.

The common failure: every fix analyzes a fragment on someone else's schedule. Margin truth is a join — every retailer's sales data met by your actual costs, continuously — and joins are what warehouses do.

What do we actually build?

  • A retail data pipeline: POS exports, retailer portals, and distributor EDI feeds unified automatically in one warehouse — the pile of unread exports becomes a live asset.
  • SKU-level margin, joined to your real costs: freight, deductions, trade spend, and promotional allowances against every SKU at every retailer — the view that ends cross-subsidy blindness.
  • Promotional lift measurement: promoted velocity against honest baselines, netted against promotion cost — so the next trade-spend dollar goes where lift actually happened.
  • Velocity and distribution tracking at the store or regional grain your feeds allow: the SKU thriving in one region and dying in another, visible instead of averaged away.
  • A morning view, not a quarterly event: the whole picture live for your team — and line-review-ready evidence when you sit across from a buyer.

What changes operationally?

Before: POS exports pile up unread → margin by SKU is a quarterly guess → promotions get renewed on gut and buyer pressure → an unprofitable account ships happily for another year — and line reviews run on the retailer's data instead of yours.

After: every feed lands in the warehouse automatically → margin by SKU and retailer reads live → the promotion that didn't pay is visible before its renewal, with the lift math attached → and you walk into line reviews with store-level velocity evidence the buyer hasn't seen. The precedent: real-time margin by SKU across every retailer paid for one client's engagement in its first month.

Who is this not for?

  • Brands in a handful of doors. If you're in twelve stores and know the owners, a spreadsheet honestly covers it. This pays off when retailer count and SKU count multiply past what attention can hold.
  • Brands with no POS or distributor data access. The build reads data that must exist somewhere retrievable. If no retailer or distributor provides feeds or portal access, the first fix is commercial, not technical — we'll tell you which conversation to have.
  • Teams that won't act on margin truth. If a money-losing SKU stays in the line and an underperforming promotion gets renewed anyway, the dashboard just documents the bleeding. The value is in the decisions it changes.

If you're in real retail distribution and your POS data goes unread, this build turns that backlog into your sharpest commercial weapon — your own sales data, joined to your own costs, finally answering the question every brand asks: where do we actually make money?

Buyer Questions

Asked Before Every Engagement

What data does retail analytics run on?

Data you already have or can already get: retailer POS exports and portal data, distributor EDI feeds and reports, your own cost and trade-spend records. Most brands are sitting on years of it, unopened or skimmed once — the build turns that standing archive into a live view.

What does SKU-level margin show that our P&L doesn't?

Your P&L shows that retail is profitable in total. SKU-level margin shows which items at which retailers create that profit and which quietly consume it — the hero SKU subsidizing three money-losers, the account where freight and deductions eat the spread. Totals hide cross-subsidies; SKU-level views end them.

How does promotional lift measurement actually work?

By comparing promoted-period velocity against properly chosen baselines in the POS data — same SKU, same account, seasonality respected — and netting the result against what the promotion cost. The question isn't 'did we sell more during the promo?' It's 'did we sell enough more to pay for it?' Most brands have never seen that second number.

Can it track velocity by store or region?

To whatever grain your retailers' data provides — many POS feeds go store-level. That's where distribution decisions sharpen: the SKU dying in one region and thriving in another is invisible in a national average and obvious on a map.

How is this different from the category data retailers offer us?

Retailer-provided category reports serve the retailer's buying conversation, arrive on their schedule, and cover their stores only. Your own warehouse reads every retailer continuously, joined to your actual costs — which retailer reports never include. One is a periodic courtesy; the other is your margin, live.

We already saw one client story about SKU margin — is that this build?

Yes. The client who was flying blind on wholesale — and whose real-time margin by SKU across every retailer paid for the engagement in the first month — is this exact class of build: POS and distributor data unified, costs joined, margin made visible.

What does it cost?

Scoped to your retailer count and data landscape, which is why we start with a free build plan rather than a rate card. Tell us which retailers you're in and what your POS access looks like, and we'll map the build.

See What Your POS Data Is Hiding

Tell us how this works in your operation today. We'll send back a build plan — no pitch deck, no fluff, just engineering.

Get My Free Build Plan