Introduction

Datasources and destinations

Fields listing for Profitwell

Customer Id
Customer Id
Field IDcustomers/customer_id
TypeTEXT
Data Typedimension
Customer Email
Customer Email
Field IDcustomers/email
TypeTEXT
Data Typedimension
Customer First Name
Customer First Name
Field IDcustomers/first_name
TypeTEXT
Data Typedimension
Customer Last Name
Customer Last Name
Field IDcustomers/last_name
TypeTEXT
Data Typedimension
Customer MRR
Customer MRR
Field IDcustomers/mrr_cents
TypeNUMBER
Data Typemetric
Customer Status
Customer Status
Field IDcustomers/status
TypeTEXT
Data Typedimension
Customer Created On
Customer Created On
Field IDcustomers/created_on
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Activated On
Customer Activated On
Field IDcustomers/activated_on
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Churned On
Customer Churned On
Field IDcustomers/churned_on
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Updated On
Customer Updated On
Field IDcustomers/updated_on
TypeYEAR_MONTH_DAY
Data Typedimension
Customer Total Spend
Customer Total Spend
Field IDcustomers/total_spend_cents
TypeNUMBER
Data Typemetric
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Metrics Date
Date of the metric
Field IDdate
TypeYEAR_MONTH_DAY
Data Typemetric
Active Customers
Number of paying customers
Field IDactive_customers
TypeNUMBER
Data Typemetric
Active Trialing Customers
Number of trialing customers
Field IDactive_trialing_customers
TypeNUMBER
Data Typemetric
ARPU
Average Revenue Per User
Field IDaverage_revenue_per_user
TypeNUMBER
Data Typemetric
Churned Customers
Number of paying customers who churned
Field IDchurned_customers
TypeNUMBER
Data Typemetric
Churned Customers Cancellations
Number of customers who churned by cancelling their subscription(s)
Field IDchurned_customers_cancellations
TypeNUMBER
Data Typemetric
Churned Trialing Customers
Number of trialling customers who churned
Field IDchurned_trialing_customers
TypeNUMBER
Data Typemetric
Churned Customers Delinquent
Number of customers who churned because they failed to pay you
Field IDchurned_customers_delinquent
TypeNUMBER
Data Typemetric
Churned Recurring Revenue
Revenue lost to churn (voluntary and delinquent)
Field IDchurned_recurring_revenue
TypeNUMBER
Data Typemetric
Churned Recurring Revenue Cancellations
RRevenue lost to customers who churned by cancelling their subscription(s)
Field IDchurned_recurring_revenue_cancellations
TypeNUMBER
Data Typemetric
Revenue lost to customers who churned delinquent
Revenue lost to customers who churned because they failed to pay you
Field IDchurned_recurring_revenue_delinquent
TypeNUMBER
Data Typemetric
Cumulative Net New MRR
New + Upgrades - Downgrades - Churn MRR, cumulative for the month
Field IDcumulative_net_new_mrr
TypeNUMBER
Data Typemetric
Cumulative New Trialing Customers
Number of new trialing customers, cumulative for the month up through the given day
Field IDcumulative_new_trialing_customers
TypeNUMBER
Data Typemetric
Downgraded Customers
Number of existing customers who net downgraded
Field IDdowngraded_customers
TypeNUMBER
Data Typemetric
Downgraded Recurring Revenue
Revenue lost due to downgrades
Field IDdowngraded_recurring_revenue
TypeNUMBER
Data Typemetric
Future Churn MRR
MRR that will be lost when users who are currently cancelled actually churn
Field IDfuture_churn_mrr
TypeNUMBER
Data Typemetric
New Customers
Number of new, paying customers
Field IDnew_customers
TypeNUMBER
Data Typemetric
Converted Customers
Number of customers who converted from trialing to active
Field IDconverted_customers
TypeNUMBER
Data Typemetric
Converted Recurring Revenue
How much MRR comes from users who converted from trialing to active
Field IDconverted_recurring_revenue
TypeNUMBER
Data Typemetric
Customer Conversion Rate
Percent of trialing customers who converted
Field IDcustomer_conversion_rate
TypeNUMBER
Data Typemetric
Customer Retention Rate
Percent of customers active last month who are still active this month
Field IDcustomers_retention_rate
TypeNUMBER
Data Typemetric
Downgrade Rate
Downgrade revenue as a percent of existing revenue
Field IDdowngrade_rate
TypeNUMBER
Data Typemetric
Existing Customers
Number of paying customers you had at the start of the given month
Field IDexisting_customers
TypeNUMBER
Data Typemetric
Existing Recurring Revenue
Your company's MRR at the start of the given month
Field IDexisting_recurring_revenue
TypeNUMBER
Data Typemetric
Growth Rate
Growth in MRR as a percentage of existing revenue
Field IDgrowth_rate
TypeNUMBER
Data Typemetric
Lifetime Value
Total revenue from a customer over their lifetime
Field IDlifetime_value
TypeNUMBER
Data Typemetric
New Trialing Customers
Number of new trialing customers
Field IDnew_trialing_customers
TypeNUMBER
Data Typemetric
Customer Churn Cancellations Rate
Percentage of paying customers who churned by cancelling their subscription(s)
Field IDcustomers_churn_cancellations_rate
TypeNUMBER
Data Typemetric
Customer Churn Delinquent Rate
Percentage of paying customers who churned because they failed to pay you
Field IDcustomers_churn_delinquent_rate
TypeNUMBER
Data Typemetric
Revenue Churn Cancellations Rate
Voluntary churn revenue as a percent of the month's starting revenue
Field IDrevenue_churn_cancellations_rate
TypeNUMBER
Data Typemetric
Revenue Churn Delinquent Rate
Revenue lost to customers who churned because they failed to pay you
Field IDrevenue_churn_delinquent_rate
TypeNUMBER
Data Typemetric
Upgrade Rate
Upgrade revenue as a percent of existing revenue
Field IDupgrade_rate
TypeNUMBER
Data Typemetric
Existing Trialing Customers
Number of trialing customers who existed at the start of the month
Field IDexisting_trialing_customers
TypeNUMBER
Data Typemetric
New Recurring Revenue
MRR from new users
Field IDnew_recurring_revenue
TypeNUMBER
Data Typemetric
Reactivated Customers
Number of customers who have reactivated
Field IDreactivated_customers
TypeNUMBER
Data Typemetric
Reactivated Recurring Revenue
How much MRR comes from reactivated customers
Field IDreactivated_recurring_revenue
TypeNUMBER
Data Typemetric
Recurring Revenue
Your company's MRR
Field IDrecurring_revenue
TypeNUMBER
Data Typemetric
Customer Churn Rate
Percentage of paying customers who churned
Field IDcustomers_churn_rate
TypePERCENT
Data Typemetric
Revenue Churn Rate
Revenue lost to churn as a percentage of existing revenue
Field IDrevenue_churn_rate
TypePERCENT
Data Typemetric
Revenue Retention Rate
Percent of revenue coming from existing customers that was retained by the end of the month
Field IDrevenue_retention_rate
TypePERCENT
Data Typemetric
Upgraded Customers
Number of existing customers who net upgraded
Field IDupgraded_customers
TypeNUMBER
Data Typemetric
Upgraded Recurring Revenue
Revenue increase due to upgrades
Field IDupgraded_recurring_revenue
TypeNUMBER
Data Typemetric
Plan Changed Recurring Revenue
Net change in revenue for this plan
Field IDplan_changed_recurring_revenue
TypeNUMBER
Data Typemetric
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension