# CommerceIQ Financial Model

SaaS platform that aggregates, analyzes, and automates e-commerce operations for enterprise CPG/consumer brands selling through indirect retailers (primarily Amazon, Walmart, Target).

- Canonical: https://finamodel.com/startups/commerceiq
- Excel download: https://finamodel.com/startup-models/commerceiq.xlsx
- Category: Consumer/DTC
- Model type: SaaS ARR / Valuation
- Funding round: Series C
- Funding: $60M
- Founded: 2021
- Geography: United States (primary); deck focused on U.S. e-commerce market.
- Customer: B2C

## About the company

CommerceIQ is an e-commerce operations platform for enterprise consumer brands selling through retailers such as Amazon, Walmart, and Target. It aggregates retail data, identifies operational opportunities, and automates actions across digital shelf, supply, sales, and marketing workflows.

The product is enterprise subscription SaaS, likely with implementation or managed-service revenue. It helps brands manage large SKU catalogs and retailer relationships where availability, content, advertising, and pricing directly affect online sales performance.

The model is enterprise ARR. Brands, modules, managed SKUs, ACV, expansion, renewal, and churn build revenue. Data infrastructure, customer success, sales capacity, and measured customer ROI determine retention and margin.

## What's included

- 5-year monthly revenue build with stage-appropriate growth assumptions
- Full P&L, headcount plan, and operating-expense schedule
- Cash-flow statement, runway, and burn-rate tracking
- Valuation via exit multiple with a DCF cross-check
- Returns analysis with MOIC and IRR
- Unit economics including CAC, LTV, payback, and cohort retention

## Product & value proposition

Three core capabilities:
1. **Aggregates** - single source of truth across sales, marketing, supply chain, and competitive data.
2. **Analyzes** - ML/analytics layer generating insights and recommendations (management by exception).
3. **Automates** - executes thousands of actions in near-real time across the e-commerce flywheel.

Flywheel modules:
- Sales: assortment optimization, digital shelf (fill, organize, monitor).
- Operations: supply chain orchestration, ARAP (automated replenishment), pricing and promotional strategy.
- Advertising: profit-aware, inventory-aware, competition-aware retail media (AMS/DSP).

Value claims:
- 40% increase in Sales
- 20% increase in Profitability
- 20% increase in Share of Voice
- 50% faster Execution

## Market

- U.S. e-commerce market size:
  - 2018: $524B (10% of total retail)
  - 2020: $795B (14%)
  - 2022E: $953B (16%)
  - 2024E: $1.2T (19%)
- COVID acceleration:
  - E-commerce as % of adj. retail sales: 7.9% (2012) → 19.5% (2020) - pulled forward 2+ years in one year.
  - Projected to reach 34.8% by 2026E.
- Channel structure:
  - 85% of $1.2T retail is indirect-to-consumer; 15% DTC.
  - Amazon alone = 38% of U.S. e-commerce; Walmart 6%; Target 2%; Others 35%; DTC 15%.
  - Top 10 retailers = 60% of total U.S. e-commerce sales.

## Revenue model

Not explicitly stated in deck. Inferred from positioning:
- Subscription SaaS: annual contracts with enterprise CPG brands; per-module or platform-tier pricing. Rationale: deck references "E-commerce Management Platform," managed-function replacement of agencies and point tools.
- Managed services / implementation fee on top of SaaS. Rationale: deck mentions "CommerceIQ platform and experts," suggesting a services layer alongside software.
- Retail media spend optimization could carry a % of managed-spend fee. Rationale: advertising automation (AMS) is a core module; common monetization in this category.
- Target customer: Fortune 1000 CPG brands with $1B+ revenue and large Amazon catalogs (10,000+ ASINs shown as reference).

## Traction & metrics

Customer example:
- Named (anonymized) client: Fortune 1000 CPG brand, $3.8B revenue (2019), 100+ brands, 10,000+ ASINs on Amazon.

Outcome case studies (all from same client or representative clients):
- Out-of-stock recovery: $315K in revenue recovered for a single SKU in 4 days (Sept 2020).
- 3P variant removal: $1.3M in recaptured revenue over ~18-month period (Aug 2019 – Feb 2021); ASINs with variants reduced from 1,200 to 0.
- Digital shelf / Share of Voice: SOV +15.09%, Sales +30.09%; keyword coverage improved from 10–12% to 28–35% of top keywords; 3X SOV achieved; "millions incremental sales" driven across 850 category keywords.

## Competition / moat

Comparison framing:
- Manual/fragmented state: siloed sales, marketing, ops teams using disconnected tools (DSM, ARAP, PIM/DAM, Content, AMS, 3P tools, AVC, Analytics, agencies).
- CommerceIQ replaces this with an end-to-end integrated managed function under a VP E-commerce.
- Moat language: "first technology-driven platform" for e-commerce management; flywheel network effect claim; single source of truth across all data streams.
- Named competitors: not mentioned. Implicit competitive set = point tools (agency-run AMS, DSM vendors, manual analytics).

## Team & funding ask / use of funds

---

## Recommended financial model

- **Archetype + why:** B2B SaaS ARR model with a services/managed-spend revenue line. CommerceIQ sells annual platform subscriptions to large enterprises; revenue is recurring and contract-based. A pure ARR waterfall (new logos, expansion, churn → ending ARR → recognized revenue) is the correct spine. A secondary services revenue line should run alongside.

- **Forecast horizon & granularity:** 5 years (2021–2025), monthly for Years 1–2, annual for Years 3–5. Monthly granularity needed to model sales cycles, onboarding lags, and cohort-level expansion.

- **Key drivers & assumptions:**

| Driver | Seed value | Tag + rationale |
| -- | -- | -- |
| Starting customer count | Unknown | ~20–50 enterprise logos at Series B/C stage; deck implies early-but-growing adoption |
| New logos per year | Unknown | 10–20/yr for Year 1 scaling; enterprise sales cycle ~6–12 months |
| Average ACV (Annual Contract Value) | Unknown | $300K–$800K per logo; enterprise CPG brands with $1B+ revenue and complex Amazon catalogs; comparable SaaS peers (e.g., Salsify, Perpetua) suggest $200K–$1M+ range |
| Net Revenue Retention (NRR) | Unknown | 110–130%; platform drives measurable ROI (deck shows $315K/SKU recovery), expansion via module upsell |
| Gross churn rate | Unknown | 5–10% annually; enterprise stickiness high once integrated |
| Services revenue as % of SaaS ARR | Unknown | 15–25%; managed-services layer for implementation and ongoing optimization |
| Gross margin - SaaS | Unknown | 70–75%; cloud infrastructure + data costs; typical for ML-heavy SaaS |
| Gross margin - Services | Unknown | 30–40%; human-in-the-loop expert layer |
| S&M as % of revenue | Unknown | 40–60% in early years; enterprise field sales + long cycles |
| R&D as % of revenue | Unknown | 20–30%; ML platform is core differentiation |
| G&A as % of revenue | Unknown | 10–15% |
| U.S. e-commerce market growth | $1.2T by 2024 | supports macro tailwind assumption |
| % indirect vs DTC | 85% indirect | - |

- **Scenarios (Base / Bull / Bear - which variables flex):**
  - **Base:** ACV ~$400K, 15 new logos/yr by Year 2, NRR 115%, gross margin 72%.
  - **Bull:** ACV ~$600K, 25 new logos/yr by Year 2, NRR 125%, faster expansion into non-Amazon channels (Walmart, Target) as platform coverage widens.
  - **Bear:** ACV ~$250K, 8 new logos/yr, NRR 105%, higher churn if ROI proof points require longer to materialize or if Amazon itself expands its own analytics tooling.

- **Required sheets / outputs:**
  1. **Assumptions** - all drivers in one tab, color-coded inputs.
  2. **ARR Waterfall** - beginning ARR, new logo ARR, expansion ARR, churn ARR, ending ARR by period.
  3. **Revenue Build** - SaaS subscription revenue + services revenue (recognized from ARR).
  4. **P&L** - gross profit by segment, S&M, R&D, G&A, EBITDA, EBIT.
  5. **Cohort Model** - optional but valuable: logo cohorts by year with expansion curves.
  6. **Unit Economics Summary** - CAC (estimated), LTV, LTV/CAC, payback period (all until real data provided).
  7. **Scenario Toggle** - dropdown or named range to switch Base/Bull/Bear across all outputs.
  8. **Dashboard** - ARR, revenue, gross margin %, EBITDA margin, logo count, NRR - with waterfall chart and ARR bridge.

## Frequently asked questions

### Is the CommerceIQ financial model free?

Yes. The CommerceIQ model is a free Excel download with live formulas.

### Can I change the assumptions?

Yes. The workbook is editable and its live formulas recalculate when assumptions change.