Пређи на главни садржај
Ambient Systems
Sign in
Request validation

Software (SaaS)

Pack file: catalog/industries/software_saas in ambient-core.

Workspace demo (screenshots) · Catalog consumption

Industry summary​

Industry code

ISIC Rev.4 5820

59 metrics · 8 data options

NAICS 2022
511210
NACE Rev.2
58.29
GICS 2023
451030

Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.

Data options (8)

Accounting Software​

Catalog key software_saas.core.accounting_software

Fields

date
date
period_start_date
date
period_end_date
date
revenue
decimal
cogs
decimal
cost_of_goods
decimal
operating_expenses
decimal
net_income
decimal
produce_revenue
decimal
total_production_cost
decimal
total_operational_cost
decimal

Financial statements​

Catalog key software_saas.core.financial_statements

Fields

date
date
statement_type
enum
period_start_date
date
period_end_date
date

HR records​

Catalog key software_saas.core.hr_records

Fields

date
date
headcount
decimal

Payroll records​

Catalog key software_saas.core.payroll_records

Fields

date
date
period_start_date
date
period_end_date
date
headcount
decimal
gross_pay
decimal
net_pay
decimal
employer_taxes
decimal
labor_cost
decimal
revenue
decimal
net_income
decimal
total_labor_costs
decimal
total_harvested_kg
decimal
total_production_cost
decimal
total_operational_cost
decimal
drivers_left
decimal
total_drivers
decimal
total_maintenance_costs
decimal
total_miles
decimal

CRM / Sales pipeline​

Catalog key software_saas.subscription.crm_pipeline

Fields

date
date
opportunity_id
id
account_name
decimal
stage
enum
amount
decimal
close_date
date
owner
string
probability
string
active_subscriptions
string
avg_monthly_price
decimal
sales_marketing_spend
string
new_customers
string

Marketing spend records​

Catalog key software_saas.subscription.marketing_spend

Fields

date
date
channel
enum
campaign
string
spend
string
leads
string
new_customers
string
currency
currency
sales_marketing_spend
string
avg_revenue_per_account
decimal
churn_rate
decimal

Product usage logs​

Catalog key software_saas.subscription.product_usage

Fields

date
date
customer_id
id
active_users
string
sessions
string
feature_adoption
string
usage_minutes
string
starting_mrr
string
expansion_mrr
string
contraction_mrr
string
churned_mrr
string

Subscription billing records​

Catalog key software_saas.subscription.subscription_billing

Fields

date
date
customer_id
id
plan_name
string
mrr
string
billing_period
enum
status
enum
start_date
date
end_date
date
active_subscriptions
string
avg_monthly_price
decimal
starting_mrr
string
expansion_mrr
string
contraction_mrr
string
churned_mrr
string

Metrics (59)

Accounts Payable Days​

  • ID: 3422
  • Type: Financial
  • Unit: Days
  • Description: Payables expressed as days of COGS; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DPO.
  • Inputs: cogs, accounts_payable
  • Methodology: Accounts Payable Days
  • Calculation: accounts_payable * 365 / max(cogs, 0)
  • Catalog key: software_saas.core.accounts_payable_days

Accounts Payable Turnover​

  • ID: 3421
  • Type: Financial
  • Unit: x
  • Description: COGS divided by accounts payable
  • Inputs: cogs, accounts_payable
  • Methodology: Accounts Payable Turnover
  • Calculation: cogs / max(accounts_payable, 0)
  • Catalog key: software_saas.core.accounts_payable_turnover

Accounts Receivable Days​

  • ID: 3418
  • Type: Financial
  • Unit: Days
  • Description: Receivable balance in days of revenue; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DSO.
  • Inputs: revenue, accounts_receivable
  • Methodology: Accounts Receivable Days
  • Calculation: accounts_receivable * 365 / max(revenue, 0)
  • Catalog key: software_saas.core.accounts_receivable_days

Accounts Receivable Turnover​

  • ID: 3417
  • Type: Financial
  • Unit: x
  • Description: Revenue divided by accounts receivable Not parameterized DSO.
  • Inputs: revenue, accounts_receivable
  • Methodology: Accounts Receivable Turnover
  • Calculation: revenue / max(accounts_receivable, 0)
  • Catalog key: software_saas.core.accounts_receivable_turnover

Monthly Burn Rate​

  • ID: 2052
  • Type: Financial
  • Unit: Currency/month
  • Description: Net cash consumed per month (negative net operating cash flow).
  • Inputs: cash_out, cash_in
  • Methodology: Net Burn = Cash Out − Cash In (per month)
  • Calculation: cash_out - cash_in
  • Catalog key: software_saas.core.burn_rate

Cash Days​

  • ID: 3416
  • Type: Financial
  • Unit: Days
  • Description: Cash balance expressed as days of revenue at a 365-day year (Ambient corporate ratio pack).
  • Inputs: revenue, cash
  • Methodology: Cash Days
  • Calculation: cash * 365 / max(revenue, 0)
  • Catalog key: software_saas.core.cash_days

Cash Turnover​

  • ID: 3415
  • Type: Financial
  • Unit: x
  • Description: Revenue divided by cash
  • Inputs: revenue, cash
  • Methodology: Cash Turnover
  • Calculation: revenue / max(cash, 0)
  • Catalog key: software_saas.core.cash_turnover

Cash Conversion Cycle​

  • ID: 2050
  • Type: Financial
  • Unit: Days
  • Description: Days to convert investments in inventory and receivables back into cash.
  • Inputs: days_inventory_outstanding
  • Methodology: CCC = DSO + Days Inventory Outstanding − DPO
  • Calculation: dso + days_inventory_outstanding - dpo
  • Catalog key: software_saas.core.ccc

Current Ratio​

  • ID: 2040
  • Type: Financial
  • Unit: Ratio
  • Description: Short-term liquidity: ability to cover current liabilities with current assets.
  • Inputs: current_assets, current_liabilities
  • Methodology: Current Ratio = Current Assets / Current Liabilities
  • Calculation: current_assets / current_liabilities
  • Catalog key: software_saas.core.current_ratio

Debt to EBITDA​

  • ID: 3426
  • Type: Financial
  • Unit: x
  • Description: Gross interest-bearing debt divided by EBITDA
  • Inputs: interest_bearing_liabilities
  • Methodology: Debt to EBITDA
  • Calculation: interest_bearing_liabilities / max(ebitda_derived, 0)
  • Catalog key: software_saas.core.debt_to_ebitda

Debt to Equity​

  • ID: 3424
  • Type: Financial
  • Unit: x
  • Description: Interest-bearing liabilities divided by equity
  • Inputs: interest_bearing_liabilities, total_shareholders_equity
  • Methodology: Debt to Equity
  • Calculation: interest_bearing_liabilities / max(total_shareholders_equity, 0)
  • Catalog key: software_saas.core.debt_to_equity

Debt to Tangible Net Worth​

  • ID: 3425
  • Type: Financial
  • Unit: x
  • Description: Interest-bearing debt divided by tangible net worth (Ambient corporate ratio pack).
  • Inputs: interest_bearing_liabilities
  • Methodology: Debt to Tangible Net Worth
  • Calculation: interest_bearing_liabilities / max(tangible_net_worth, 0)
  • Catalog key: software_saas.core.debt_to_tangible_net_worth

EBITDA (derived)​

  • ID: 3398
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: EBIT plus depreciation and amortization
  • Inputs: operating_income, depreciation, amortization
  • Methodology: EBITDA (derived)
  • Calculation: operating_income + depreciation + amortization
  • Catalog key: software_saas.core.derived_ebitda

Effective Tax Rate​

  • ID: 3399
  • Type: Financial
  • Unit: %
  • Description: Tax expense divided by earnings before tax
  • Inputs: tax_expense, earnings_before_tax
  • Methodology: Effective Tax Rate = Tax Expense / Earnings Before Tax
  • Calculation: tax_expense / max(earnings_before_tax, 0)
  • Catalog key: software_saas.core.derived_effective_tax_rate

Gross Profit (derived)​

  • ID: 3397
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Revenue minus COGS; building block for margins
  • Inputs: revenue, cogs
  • Methodology: Gross Profit (derived)
  • Calculation: revenue - cogs
  • Catalog key: software_saas.core.derived_gross_profit

Invested Capital​

  • ID: 3402
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Net debt plus total shareholders' equity
  • Inputs: total_shareholders_equity
  • Methodology: Invested Capital
  • Calculation: net_debt + total_shareholders_equity
  • Catalog key: software_saas.core.derived_invested_capital

Net Debt​

  • ID: 3401
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Interest-bearing liabilities minus cash
  • Inputs: interest_bearing_liabilities, cash
  • Methodology: Net Debt
  • Calculation: interest_bearing_liabilities - cash
  • Catalog key: software_saas.core.derived_net_debt

Net Operating Profit After Tax (NOPAT)​

  • ID: 3400
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: EBIT adjusted for cash taxes using the effective tax rate (Ambient corporate ratio pack).
  • Inputs: operating_income
  • Methodology: Net Operating Profit After Tax (NOPAT)
  • Calculation: operating_income * (1 - effective_tax_rate)
  • Catalog key: software_saas.core.derived_nopat

Quick Assets (strict)​

  • ID: 3404
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Cash, marketable securities, and accounts receivable (Ambient corporate ratio pack).
  • Inputs: cash, marketable_securities, accounts_receivable
  • Methodology: Quick Assets (strict)
  • Calculation: cash + marketable_securities + accounts_receivable
  • Catalog key: software_saas.core.derived_quick_assets

Tangible Net Worth​

  • ID: 3403
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Shareholders' equity minus intangible assets
  • Inputs: total_shareholders_equity, intangible_assets
  • Methodology: Tangible Net Worth
  • Calculation: total_shareholders_equity - intangible_assets
  • Catalog key: software_saas.core.derived_tangible_net_worth

Days Payable Outstanding (DPO)​

  • ID: 2049
  • Type: Financial
  • Unit: Days
  • Description: Average number of days the business takes to pay its suppliers.
  • Inputs: accounts_payable, cogs, days
  • Methodology: DPO = (Accounts Payable / COGS) × Number of Days
  • Calculation: accounts_payable / cogs * days
  • Catalog key: software_saas.core.dpo

Days Sales Outstanding (DSO)​

  • ID: 2048
  • Type: Financial
  • Unit: Days
  • Description: Average number of days to collect cash after a sale.
  • Inputs: accounts_receivable, total_credit_sales, days
  • Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
  • Calculation: accounts_receivable / total_credit_sales * days
  • Catalog key: software_saas.core.dso

EBIT to Interest​

  • ID: 3430
  • Type: Financial
  • Unit: x
  • Description: EBIT divided by gross interest expense
  • Inputs: operating_income, interest_expense
  • Methodology: EBIT to Interest
  • Calculation: operating_income / max(interest_expense, 0)
  • Catalog key: software_saas.core.ebit_to_interest

EBITDA Less Capex to Interest​

  • ID: 3431
  • Type: Financial
  • Unit: x
  • Description: Capex-adjusted EBITDA coverage
  • Inputs: capital_expenditures, interest_expense
  • Methodology: EBITDA Less Capex to Interest
  • Calculation: (ebitda_derived - capital_expenditures) / max(interest_expense, 0)
  • Catalog key: software_saas.core.ebitda_less_capex_to_interest

EBITDA Margin​

  • ID: 2044
  • Type: Financial
  • Unit: %
  • Description: Core operating cash profitability before interest, tax, depreciation and amortization.
  • Inputs: ebitda, revenue
  • Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
  • Calculation: ebitda / revenue * 100
  • Catalog key: software_saas.core.ebitda_margin

EBITDA to Interest (Interest Coverage)​

  • ID: 3429
  • Type: Financial
  • Unit: x
  • Description: EBITDA divided by gross interest expense
  • Inputs: interest_expense
  • Methodology: EBITDA to Interest (Interest Coverage)
  • Calculation: ebitda_derived / max(interest_expense, 0)
  • Catalog key: software_saas.core.ebitda_to_interest

Effective Interest Rate​

  • ID: 3410
  • Type: Financial
  • Unit: %
  • Description: Gross interest expense divided by interest-bearing liabilities (Ambient corporate ratio pack).
  • Inputs: interest_expense, interest_bearing_liabilities
  • Methodology: Effective Interest Rate
  • Calculation: interest_expense / max(interest_bearing_liabilities, 0)
  • Catalog key: software_saas.core.effective_interest_rate

Fixed Charge Coverage​

  • ID: 3432
  • Type: Financial
  • Unit: x
  • Description: Capex-adjusted EBITDA over interest plus current debt maturities (Ambient corporate ratio pack).
  • Inputs: capital_expenditures, interest_expense, current_portion_long_term_debt
  • Methodology: Fixed Charge Coverage
  • Calculation: (ebitda_derived - capital_expenditures) / max(interest_expense + current_portion_long_term_debt, 0)
  • Catalog key: software_saas.core.fixed_charge_coverage

Gross Profit Margin​

  • ID: 2042
  • Type: Financial
  • Unit: %
  • Description: Share of revenue retained after the direct cost of goods sold.
  • Inputs: revenue, cogs
  • Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
  • Calculation: (revenue - cogs) / revenue * 100
  • Catalog key: software_saas.core.gross_margin

Headcount (FTE)​

  • ID: 2054
  • Type: Operational
  • Unit: Count
  • Description: Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.
  • Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: software_saas.core.headcount

Interest Burden​

  • ID: 3411
  • Type: Financial
  • Unit: %
  • Description: EBT relative to EBIT; DuPont lever
  • Inputs: earnings_before_tax, operating_income
  • Methodology: Interest Burden
  • Calculation: earnings_before_tax / max(operating_income, 0)
  • Catalog key: software_saas.core.interest_burden

Inventory Days​

  • ID: 3420
  • Type: Financial
  • Unit: Days
  • Description: Inventory held in days of COGS; 365-day convention (Ambient corporate ratio pack).
  • Inputs: cogs, inventory
  • Methodology: Inventory Days
  • Calculation: inventory * 365 / max(cogs, 0)
  • Catalog key: software_saas.core.inventory_days

Inventory Turnover (ending balance)​

  • ID: 3419
  • Type: Financial
  • Unit: x
  • Description: COGS divided by ending inventory Distinct from average-inventory variants.
  • Inputs: cogs, inventory
  • Methodology: Inventory Turnover (ending balance)
  • Calculation: cogs / max(inventory, 0)
  • Catalog key: software_saas.core.inventory_turnover

Net Debt to EBITDA​

  • ID: 3427
  • Type: Financial
  • Unit: x
  • Description: Net debt divided by EBITDA
  • Methodology: Net Debt to EBITDA
  • Calculation: net_debt / max(ebitda_derived, 0)
  • Catalog key: software_saas.core.net_debt_to_ebitda

Net Profit Margin​

  • ID: 2045
  • Type: Financial
  • Unit: %
  • Description: Bottom-line profitability after all costs, interest and tax.
  • Inputs: net_income, revenue
  • Methodology: Net Profit Margin = (Net Income / Revenue) × 100
  • Calculation: net_income / revenue * 100
  • Catalog key: software_saas.core.net_margin

Net Profit Margin (decimal quotient)​

  • ID: 3409
  • Type: Financial
  • Unit: %
  • Description: Net income divided by revenue as a decimal quotient. Alias of net_margin at percent scale; see docs/ratios/corporate-ratios.md.
  • Inputs: net_income, revenue
  • Methodology: Net Profit Margin = Net Income / Revenue
  • Calculation: net_income / max(revenue, 0)
  • Catalog key: software_saas.core.net_profit_margin

Operating Cash Flow​

  • ID: 2051
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Cash generated by core operations during the period.
  • Inputs: net_income, non_cash_charges, increase_in_working_capital
  • Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
  • Calculation: net_income + non_cash_charges - increase_in_working_capital
  • Catalog key: software_saas.core.operating_cash_flow

Operating Margin (EBIT)​

  • ID: 2043
  • Type: Financial
  • Unit: %
  • Description: Operating profitability after operating expenses (EBIT margin).
  • Inputs: operating_income, revenue
  • Methodology: Operating Margin = (Operating Income / Revenue) × 100
  • Calculation: operating_income / revenue * 100
  • Catalog key: software_saas.core.operating_margin

Operating Profit Margin (EBIT)​

  • ID: 3408
  • Type: Financial
  • Unit: %
  • Description: EBIT divided by revenue as a decimal quotient. Alias of operating_margin at percent scale; see docs/ratios/corporate-ratios.md. Alias of operating_margin at percent scale.
  • Inputs: operating_income, revenue
  • Methodology: Operating Profit Margin = EBIT / Revenue
  • Calculation: operating_income / max(revenue, 0)
  • Catalog key: software_saas.core.operating_profit_margin

PP&E Turnover​

  • ID: 3414
  • Type: Financial
  • Unit: x
  • Description: Revenue divided by net PP&E
  • Inputs: revenue, ppe_net
  • Methodology: PP&E Turnover
  • Calculation: revenue / max(ppe_net, 0)
  • Catalog key: software_saas.core.ppe_turnover

Quick Ratio (Acid Test)​

  • ID: 2041
  • Type: Financial
  • Unit: Ratio
  • Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view. Default formula: current assets minus inventory. See quick_ratio_quick_assets for the alternate convention (cash + marketable securities + receivables).
  • Inputs: current_assets, inventory, current_liabilities
  • Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
  • Calculation: (current_assets - inventory) / current_liabilities
  • Catalog key: software_saas.core.quick_ratio

Quick Ratio (Quick Assets)​

  • ID: 3428
  • Type: Financial
  • Unit: x
  • Description: Strict quick assets over current liabilities Formula-box quick_ratio remains default.
  • Inputs: current_liabilities
  • Methodology: Quick Ratio = (Cash + Marketable Securities + A/R) / Current Liabilities
  • Calculation: quick_assets / max(current_liabilities, 0)
  • Catalog key: software_saas.core.quick_ratio_quick_assets

Return on Assets (ROA)​

  • ID: 3406
  • Type: Financial
  • Unit: %
  • Description: Net income divided by total assets
  • Inputs: net_income, total_assets
  • Methodology: ROA = Net Income / Total Assets
  • Calculation: net_income / max(total_assets, 0)
  • Catalog key: software_saas.core.return_on_assets

Return on Equity (ROE)​

  • ID: 3405
  • Type: Financial
  • Unit: %
  • Description: Net income divided by shareholders' equity
  • Inputs: net_income, total_shareholders_equity
  • Methodology: ROE = Net Income / Total Shareholders' Equity
  • Calculation: net_income / max(total_shareholders_equity, 0)
  • Catalog key: software_saas.core.return_on_equity

Return on Invested Capital (ROIC)​

  • ID: 3407
  • Type: Financial
  • Unit: %
  • Description: NOPAT divided by invested capital
  • Methodology: ROIC = NOPAT / (Net Debt + Equity)
  • Calculation: nopat / max(invested_capital, 0)
  • Catalog key: software_saas.core.return_on_invested_capital

Revenue Growth Rate​

  • ID: 2046
  • Type: Financial
  • Unit: %
  • Description: Period-over-period revenue growth rate.
  • Inputs: revenue, revenue_prior
  • Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
  • Calculation: (revenue - revenue_prior) / revenue_prior * 100
  • Catalog key: software_saas.core.revenue_growth

Cash Runway​

  • ID: 2053
  • Type: Financial
  • Unit: Months
  • Description: Number of months of cash remaining at the current net burn rate.
  • Inputs: current_cash_balance
  • Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
  • Calculation: current_cash_balance / burn_rate
  • Catalog key: software_saas.core.runway

Tax Burden​

  • ID: 3412
  • Type: Financial
  • Unit: %
  • Description: Net income relative to EBT; DuPont lever
  • Inputs: net_income, earnings_before_tax
  • Methodology: Tax Burden
  • Calculation: net_income / max(earnings_before_tax, 0)
  • Catalog key: software_saas.core.tax_burden

Total Asset Turnover​

  • ID: 3413
  • Type: Financial
  • Unit: x
  • Description: Revenue divided by total assets
  • Inputs: revenue, total_assets
  • Methodology: Total Asset Turnover
  • Calculation: revenue / max(total_assets, 0)
  • Catalog key: software_saas.core.total_asset_turnover

Total Assets to Equity (Equity Multiplier)​

  • ID: 3423
  • Type: Financial
  • Unit: x
  • Description: Financial leverage lever in DuPont
  • Inputs: total_assets, total_shareholders_equity
  • Methodology: Total Assets to Equity (Equity Multiplier)
  • Calculation: total_assets / max(total_shareholders_equity, 0)
  • Catalog key: software_saas.core.total_assets_to_equity

Working Capital​

  • ID: 2047
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Operating liquidity available to fund day-to-day operations.
  • Inputs: current_assets, current_liabilities
  • Methodology: Working Capital = Current Assets − Current Liabilities
  • Calculation: current_assets - current_liabilities
  • Catalog key: software_saas.core.working_capital

Annual Recurring Revenue (ARR)​

  • ID: 1581
  • Type: Financial
  • Unit: Currency/year
  • Description: Annualized run-rate of recurring subscription revenue.
  • Methodology: ARR = MRR × 12
  • Calculation: mrr * 12
  • Catalog key: software_saas.subscription.arr

Customer Acquisition Cost (CAC)​

  • ID: 1584
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Fully-loaded sales and marketing cost to acquire one new customer.
  • Inputs: sales_marketing_spend, new_customers
  • Methodology: CAC = Total Sales & Marketing Spend / New Customers Acquired
  • Calculation: sales_marketing_spend / new_customers
  • Catalog key: software_saas.subscription.cac

Gross Revenue Churn Rate​

  • ID: 1583
  • Type: Operational
  • Unit: %
  • Description: Percentage of recurring revenue lost to cancellations and downgrades.
  • Inputs: churned_mrr, starting_mrr
  • Methodology: Gross Churn = (Churned MRR / Starting MRR) × 100
  • Calculation: churned_mrr / starting_mrr * 100
  • Catalog key: software_saas.subscription.gross_churn

Customer Lifetime Value (LTV)​

  • ID: 1585
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Expected gross-margin revenue from a customer over their lifetime.
  • Inputs: avg_revenue_per_account, gross_margin_pct, churn_rate
  • Methodology: LTV = (Average Revenue per Account × Gross Margin %) / Churn Rate
  • Calculation: (avg_revenue_per_account * gross_margin_pct / 100) / churn_rate
  • Catalog key: software_saas.subscription.ltv

LTV : CAC Ratio​

  • ID: 1586
  • Type: Financial
  • Unit: Ratio
  • Description: Ratio of customer lifetime value to acquisition cost.
  • Methodology: LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost
  • Calculation: ltv / cac
  • Catalog key: software_saas.subscription.ltv_cac

Monthly Recurring Revenue (MRR)​

  • ID: 1580
  • Type: Financial
  • Unit: Currency/month
  • Description: Normalized recurring subscription revenue billed in a month.
  • Inputs: active_subscriptions, avg_monthly_price
  • Methodology: MRR = Σ (Active Subscriptions × Monthly Subscription Price)
  • Calculation: active_subscriptions * avg_monthly_price
  • Catalog key: software_saas.subscription.mrr

Net Revenue Retention (NRR)​

  • ID: 1582
  • Type: Financial
  • Unit: %
  • Description: Revenue retained and expanded from existing customers, net of churn and contraction.
  • Inputs: starting_mrr, expansion_mrr, contraction_mrr, churned_mrr
  • Methodology: NRR = ((Starting MRR + Expansion − Contraction − Churn) / Starting MRR) × 100
  • Calculation: (starting_mrr + expansion_mrr - contraction_mrr - churned_mrr) / starting_mrr * 100
  • Catalog key: software_saas.subscription.nrr

Rule of 40​

  • ID: 1587
  • Type: Financial
  • Unit: %
  • Description: Balance of growth and profitability for recurring-revenue businesses.
  • Inputs: revenue_growth_pct, profit_margin_pct
  • Methodology: Rule of 40 = Revenue Growth % + Profit Margin %
  • Calculation: revenue_growth_pct + profit_margin_pct
  • Catalog key: software_saas.subscription.rule_of_40

Data engineering pipeline​

Ambient Core ships the catalog (typed data options and metrics) and ambient_pipeline helpers. Lakehouse jobs and schedules live in the application repository that pins a core tag.

Bronze CSV upload

Pack data option fields

Silver tenant-metrics

ambient_calc

Gold products

Canonical order: map columns → coerce types → unpivot → stamp lineage → (optional Silver validate) → contract assert → write. Gold vertical products evaluate catalog formulas with ambient_calc after Silver.

How this pack feeds the pipeline​

Further reading: Catalog consumption · Pipeline governance helpers

Generated from ambient-core ref cc3d169 (digest a0e8f2dc8aa708fd). Regenerate: npm run sync:catalog-wiki.