4830_SUB_BAS_subscription_churn_time_series Transformation

Target Database Table

drp.subscription_churn_tob.

Script Description and Logic

Pulls data from Recharge raw tables. Calculates the rate at which subscriptions are churning in 30 day chunks (TOB). TOB zero is the date of purchase and is that one day only.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

 4830_SUB_BAS_subscription_churn_time_series Transformation
Calculated and Derived Fields

Coming soon.

All content © Daasity 2021. Do not copy, share or distribute.