Stripe SQL templates

6 ready-to-run SQL models for Stripe data in your own warehouse. Each one runs as-is against your synced tables, in Weld SQL or dbt.

• Get all subscriptions

  Extracts a comprehensive overview of Stripe subscriptions. This helps in understanding the status and duration of various subscriptions tied to different customers.

  Intermediate

• Get subscription plans

  Pulls an exhaustive view of Stripe subscriptions, diving into associated items, the specifics of plans, discounts applied through coupons, and additional metrics like the amount discounted and subscription intervals.

  Advanced

• Normalize to monthly revenue

  This SQL model fetches the monthly subscription amounts, converts them to EUR using average monthly forex rates, and provides insights into revenue streams in a standardized currency.

  Intermediate

• Identify active subscriptions and sum revenue

  This SQL model fetches the monthly revenue per subscription and applies discounts to provide a net monthly amount. It then identifies if a subscription is active or canceled based on the status.

  Advanced

• Create time series for each customer

  This SQL model captures the monthly recurring revenue (MRR) trend for each customer, including the change in MRR, and provides a rank based on the MRR. It also considers the customer's subscription status and cancellation date.

  Advanced

• Summarize Monthly Recurring Revenue (MRR)

  This SQL model provides a comprehensive view of the Monthly Recurring Revenue (MRR) by categorizing the revenue into new MRR, contraction MRR, churn MRR, and expansion MRR. It also computes the net new MRR and total MRR over time.

  Intermediate

Or browse templates for every connector.