Commerce Intelligence

Know the true profit behind every order, product, customer, and channel.

Commerce Intelligence turns ecommerce orders, order lines, product catalog, COGS, payment fees, refunds, returns, shipping, fulfillment, inventory, marketing context, and currency policy into governed profit datasets. The result is not another revenue dashboard. It is a traceable commerce model that shows where margin is created, where it leaks, and which outputs are safe to use.

1

Bring commerce inputs together

Metric Hive keeps orders, products, payments, costs, refunds, returns, inventory, web events, marketing touchpoints, and source provenance scoped to the correct account, shop, currency, and date grain.

2

Derive explainable profit

The modeled layer applies cost rules, product identity, payment bridges, validation checks, and currency policy so gross revenue can become net revenue, gross profit, and contribution margin without unsafe joins.

3

Unlock governed decisions

Dashboards, Explore, exports, BI, and other intelligence modules use the same approved datasets, and later modules remain gated when evidence is stale, missing, zero-row, or not launch-ready.

What teams can decide

Commerce Intelligence is the profit truth layer for Metric Hive. It gives marketing, finance, ecommerce, and data teams a shared model for decisions that should not be made from revenue or platform ROAS alone.

Which products actually make moneyContribution margin can be reviewed by product, SKU, channel, country, currency, and date where the underlying profit rows and product identity are ready.
Where margin leaksCost waterfalls keep discounts, refunds, COGS, payment fees, merchant shipping cost, fulfillment, duties, customs, returns, and other costs visible instead of blending them away.
Which customers are valuableLifecycle and LTV views can use modeled revenue, refunds, returns, costs, and acquisition context when backend readiness proves the dataset for that scope.
Which channels deserve spendMarketing attribution and creative performance can read from modeled commerce outcomes so growth decisions can consider contribution profit, not just attributed revenue.
What inventory and demand signals implyInventory health, forecasts, and recommendations stay tied to product identity, sales behavior, margin, freshness, and source coverage instead of isolated stock snapshots.
What can be exported safelyApproved modeled exports expose governed Commerce Intelligence datasets without letting frontend inputs choose raw table names, SQL fragments, tenant scope, or unsafe joins.