Rollup
Product Revenue
-
Contribution Margin $
-
CM %
-
Gross Margin %
-
MER
-
Total Ad Spend
-
Orders
-
COGS
-
Contribution Margin formula Polar custom_59257
CM = Product Revenue minus COGS, ad spend, merchant fees (Amazon = actual FBA/referral fees; iHR/ITAM = 2.9% processing), and fixed costs ($0.40/order from Polar custom_59062 + custom_59063). Other Marketing Expenses bucket placeholder = 0 (gsheets bucket not yet ingested).
Per-brand contribution
iHR Shopify direct
ITAM Shopify direct
Amazon Polar bridge
Daily trend
Media spend & ROAS by brand & channel
| Brand | Channel | Spend | Conversion Value | ROAS |
|---|
Daily breakdown
| Date | Brand | Orders | Product Revenue | COGS | Ad Spend | Merch Fees | Fixed | CM $ | CM % | MER |
|---|
Source: fct_orders + fct_ad_spend (iHR, ITAM) and raw.amazon_sp_orders + raw.amazon_ads_campaigns (Amazon, via Polar bridge). COGS for iHR pulled from stg_gsheets__cogs (deduplicated via AVG; 9-row dup bug pending fix). ITAM + Amazon COGS estimated at 35% of gross sales pending direct ingestion.