Customer Id Customer Id |
| ||||||
Customer Email Customer Email |
| ||||||
Customer First Name Customer First Name |
| ||||||
Customer Last Name Customer Last Name |
| ||||||
Customer MRR Customer MRR |
| ||||||
Customer Status Customer Status |
| ||||||
Customer Created On Customer Created On |
| ||||||
Customer Activated On Customer Activated On |
| ||||||
Customer Churned On Customer Churned On |
| ||||||
Customer Updated On Customer Updated On |
| ||||||
Customer Total Spend Customer Total Spend |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Metrics Date Date of the metric |
| ||||||
Active Customers Number of paying customers |
| ||||||
Active Trialing Customers Number of trialing customers |
| ||||||
ARPU Average Revenue Per User |
| ||||||
Churned Customers Number of paying customers who churned |
| ||||||
Churned Customers Cancellations Number of customers who churned by cancelling their subscription(s) |
| ||||||
Churned Trialing Customers Number of trialling customers who churned |
| ||||||
Churned Customers Delinquent Number of customers who churned because they failed to pay you |
| ||||||
Churned Recurring Revenue Revenue lost to churn (voluntary and delinquent) |
| ||||||
Churned Recurring Revenue Cancellations RRevenue lost to customers who churned by cancelling their subscription(s) |
| ||||||
Revenue lost to customers who churned delinquent Revenue lost to customers who churned because they failed to pay you |
| ||||||
Cumulative Net New MRR New + Upgrades - Downgrades - Churn MRR, cumulative for the month |
| ||||||
Cumulative New Trialing Customers Number of new trialing customers, cumulative for the month up through the given day |
| ||||||
Downgraded Customers Number of existing customers who net downgraded |
| ||||||
Downgraded Recurring Revenue Revenue lost due to downgrades |
| ||||||
Future Churn MRR MRR that will be lost when users who are currently cancelled actually churn |
| ||||||
New Customers Number of new, paying customers |
| ||||||
Converted Customers Number of customers who converted from trialing to active |
| ||||||
Converted Recurring Revenue How much MRR comes from users who converted from trialing to active |
| ||||||
Customer Conversion Rate Percent of trialing customers who converted |
| ||||||
Customer Retention Rate Percent of customers active last month who are still active this month |
| ||||||
Downgrade Rate Downgrade revenue as a percent of existing revenue |
| ||||||
Existing Customers Number of paying customers you had at the start of the given month |
| ||||||
Existing Recurring Revenue Your company's MRR at the start of the given month |
| ||||||
Growth Rate Growth in MRR as a percentage of existing revenue |
| ||||||
Lifetime Value Total revenue from a customer over their lifetime |
| ||||||
New Trialing Customers Number of new trialing customers |
| ||||||
Customer Churn Cancellations Rate Percentage of paying customers who churned by cancelling their subscription(s) |
| ||||||
Customer Churn Delinquent Rate Percentage of paying customers who churned because they failed to pay you |
| ||||||
Revenue Churn Cancellations Rate Voluntary churn revenue as a percent of the month's starting revenue |
| ||||||
Revenue Churn Delinquent Rate Revenue lost to customers who churned because they failed to pay you |
| ||||||
Upgrade Rate Upgrade revenue as a percent of existing revenue |
| ||||||
Existing Trialing Customers Number of trialing customers who existed at the start of the month |
| ||||||
New Recurring Revenue MRR from new users |
| ||||||
Reactivated Customers Number of customers who have reactivated |
| ||||||
Reactivated Recurring Revenue How much MRR comes from reactivated customers |
| ||||||
Recurring Revenue Your company's MRR |
| ||||||
Customer Churn Rate Percentage of paying customers who churned |
| ||||||
Revenue Churn Rate Revenue lost to churn as a percentage of existing revenue |
| ||||||
Revenue Retention Rate Percent of revenue coming from existing customers that was retained by the end of the month |
| ||||||
Upgraded Customers Number of existing customers who net upgraded |
| ||||||
Upgraded Recurring Revenue Revenue increase due to upgrades |
| ||||||
Plan Changed Recurring Revenue Net change in revenue for this plan |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|