Zuora: Monthly Recurring Revenue

Description

• Each record is an account and a month in that account, with details about its monthly recurring and non-recurring revenue in these time periods.

Supported Data Sources

• Zuora

Columns

Type	Name	Description
STRING	account_monthly_id	The unique identifier for the account id and month.
STRING	account_id	Unique identifier of the account.
DATE	account_month	Month of the account where MRR is being generated.
DECIMAL	gross_current_month_mrr	Total recurring charges in the current month for the account, resulting in gross monthly recurring revenue.
DECIMAL	discount_current_month_mrr	Total recurring discounts in the current month for the account, resulting in discount monthly recurring revenue.
DECIMAL	net_current_month_mrr	The difference between gross monthly recurring revenue and net monthly recurring revenue in the current month.
DECIMAL	gross_current_month_non_mrr	Total non-recurring charges in the current month for the account, resulting in gross monthly non-recurring revenue.
DECIMAL	discount_current_month_non_mrr	Total non-recurring discounts in the current month for the account, resulting in discount monthly non-recurring revenue.
DECIMAL	net_current_month_non_mrr	The difference between gross monthly non-recurring revenue and net monthly non-recurring revenue in that month.
DECIMAL	mrr_expected_current_month	Expected monthly recurring revenue based on the rate plan charges for the account.
DECIMAL	mrr_expected_previous_month	Expected previous month's monthly recurring revenue based on the rate plan charges for the account.
DECIMAL	gross_previous_month_mrr	Total recurring charges in the previous month for the account, resulting in gross monthly recurring revenue.
DECIMAL	gross_previous_month_non_mrr	Total non-recurring charges in the previous month for the account, resulting in gross monthly non-recurring revenue.
DECIMAL	discount_previous_month_mrr	Total recurring discounts in the previous month for the account, resulting in discount monthly recurring revenue.
DECIMAL	discount_previous_month_non_mrr	Total non-recurring discounts in the previous month for the account, resulting in discount monthly non-recurring revenue.
DECIMAL	net_previous_month_mrr	The difference between gross monthly recurring revenue and net monthly recurring revenue in the previous month.
DECIMAL	net_previous_month_non_mrr	The difference between gross monthly non-recurring revenue and net monthly non-recurring revenue in the previous month.
INTEGER	account_month_number	The number of the month of the account, 1 being the first month the account receives revenue and the number increases with each subsequent month.
STRING	net_mrr_type	The net monthly recurring revenue type, defined by best-known MRR type terminology.