PR #138 includes the following updates:
Schema/Data Change
3 total change • 0 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
stripe__subscription_item_mrr_report
| New End Model | Each record represents a subscription item for a given month with MRR metrics for both contract and billed/net mrr, movement classification, and monthly discounts applied. Tracks MRR changes over time, classifying each month as new, expansion, contraction, churned, reactivation, or unchanged. If you notice any discrepencies in MRR calculations with this new model, please open up a support ticket. | ||
stg_stripe__coupon
| New Staging Model | Staging model for Stripe coupon data. | ||
stg_stripe__coupon_tmp
| New Temp Model | |||
stg_stripe__price_plan
| Datatype casts | recurring_interval field as stringrecurring_interval_count field as integerprice_plan_id field as string
| Avoids datatype errors. | |
stg_stripe__subscription_item
| Datatype casts | plan_id field as string
| Avoids datatype errors. |
Feature Update
- Adds new analyses folder with advanced revenue reporting:
stripe__arr_snapshot_analysis: Generates a high-level ARR snapshot report for the entire business for revenue forecasting.stripe__customer_mrr_analysis: Generates an MRR report at the customer level for retention reporting and cohort analysis.- These analysis files reference the
stripe__subscription_item_mrr_reportmodel and can be compiled usingdbt compileand executed directly in your data warehouse.
Documentation
- Adds comprehensive column documentation for
stripe__subscription_item_mrr_reportinstripe.yml. - Adds README in the analysis folder with instructions on how to compile and use the analysis SQL.
Under the Hood
- Adds consistency test for
stripe__subscription_item_mrr_reportmodel. - Updates
integration_tests/seeds/price_data.csvwith additional test data. - Adds
stripe__subscription_item_mrr_reportmodel to quickstart.yml public models list.
Full Changelog: v1.3.0...v1.4.0