Open Source

Profitwell DBT Package

Transform raw Profitwell data into actionable subscription metrics with our open-source DBT models. Get instant insights into revenue, customers, and growth metrics.

View on GitHub
Production Ready
MIT Licensed

Key Features

  • Pre-built subscription metrics
  • Revenue & customer analytics
  • Enterprise-ready models
  • Open-source flexibility
Standardized Metrics

Pre-built models for all essential subscription metrics. Deploy in minutes with DBT.

Common Challenges

Why working with raw Profitwell data is challenging

Complex Raw Data

Profitwell data is nested and hard to query directly

Impact: Hours spent writing and debugging SQL queries

Solution: Pre-built models with tested SQL logic

Manual Calculations

Teams waste time calculating key metrics manually

Impact: Delayed insights and potential errors

Solution: Automated metrics calculation

Inconsistent Metrics

Different teams calculate metrics differently

Impact: Conflicting reports and confusion

Solution: Standardized metric definitions

Maintenance Burden

Keeping up with schema changes is time-consuming

Impact: Broken queries and outdated metrics

Solution: Maintained models that adapt to changes

Key Benefits

Transform Profitwell data into actionable insights faster

Instant Value

Start analyzing subscription metrics in minutes, not weeks

  • Pre-built metrics
  • Ready-to-use models
  • Tested SQL logic
  • Immediate insights

Time Savings

Focus on insights instead of data preparation

  • Automated processing
  • Optimized queries
  • Efficient transforms
  • Quick deployment

Enterprise Ready

Production-grade data models for any scale

  • Performance tested
  • Modular design
  • Easy customization
  • Scalable architecture

Available Metrics

Pre-built metrics to analyze your subscription business

Revenue Metrics

  • Monthly Recurring Revenue (MRR)
  • Annual Recurring Revenue (ARR)
  • Revenue Growth Rate
  • Revenue Churn Rate
  • Net Revenue Retention
  • Gross Revenue Retention

Customer Metrics

  • Customer Lifetime Value
  • Customer Churn Rate
  • Customer Acquisition Cost
  • Active Customers
  • New Customers
  • Churned Customers

Growth Metrics

  • Expansion Revenue
  • Contraction Revenue
  • Quick Ratio
  • Growth Efficiency
  • Upgrade Rate
  • Downgrade Rate

Installation Guide

Get up and running in minutes with these simple steps

1. Install the Package

packages:
  - package: Datomni/profitwell_metrics
    version: ">=0.1.1"

Add this to your packages.yml and run dbt deps

2. Configure Variables

vars:
    profitwell_schema: profitwell
    profitwell_database: your_database_name

Optional: Add these variables to your dbt_project.yml to customize the schema and database

3. Run the Models

dbt run --select profitwell_metrics

Execute this command to build all Profitwell metrics models