SaaS Metrics

Overview

A production-grade SaaS Metrics analysis blueprint built on Omora Labs components. This system demonstrates how semantic layers, facts, transformations, and reporting work together to deliver automated SaaS Metrics.

Assets

• Source code: GitHub
• Live report: Hex

Live Report

Dependencies

• Semantic Layers: Dates, Value Types, Revenue Types, GL Accounts, and GL Accounts Types
• Facts: Revenue Changes, Revenue Starting Balance, Customer Count, MRR View, PnL
• Workers: Customer Count, and MRR View
• Transformations: ARR Aggregated, Customer Count View, Customer Value, Customer Value Drivers, MRR Aggregated, Retention, PnL Metrics, PnL Rollup, Cost to Serve, GTM Efficiency, GTM Efficiency Drivers, LTV, and LTV Drivers

How to Use

1. Run the following command from your terminal or clone or fork the GitHub repository.

npx omoralabs@latest add saas_metrics

2. Replace the CSVs with your own data.
3. Create a local or remote database and load sample data:

# Create a local database and load sample data
  uv run omora-local

  # Create a remote database and load sample data
  uv run omora-remote

4. Run dbt to materialize the analytics models:

cd src/saas_metrics/saas_metrics_dbt
uv run dbt run

5. Connect to your favorite BI tool directly to the analytics layer. Example consumption on BI Tool:

select * from analytics.arr_aggregated
select * from analytics.ltv