CMRR Movements

Here are the fields included in the CMRR Movements calculated dataset you can export using destinations:

Field name Field type Description
CUSTOMER_UUID String The ChartMogul UUID of the customer associated with the CMRR movement, with the "cus_" prefix.
CUSTOMER_NAME String The name of the customer associated with the CMRR movement.
CMRR_MOVEMENT_UUID UUID The UUID of the CMRR movement.
ACTIVE_SUBSCRIPTION_QUANTITY Integer The number of seats or licenses of the subscription associated with the CMRR movement. Can be any non-zero integer.
CMRR_MOVEMENT Integer The change in MRR as a result of the activity. May be a positive or negative number. All amounts are expressed in cents (or pence for GBP, etc.) in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
CURRENT_CMRR Float The total value of new revenue resulting from scheduled subscription events in the month.
CURRENT_CARR Float The sum of total committed MRR (cumulative) × 12.
DESCRIPTION String The description of the CMRR movement.
EFFECTIVE_DATE Timestamp The timestamp for when a subscription change is implemented.
EVENT_DATE Timestamp The timestamp for when a subscription change was requested.
MOVEMENT_TYPE String The type of activity. One of new_biz, churn, expansion, contraction or reactivation.
ORDERING_KEY Integer An integer specifying the order of CMRR movements per customer.
PLAN_UUID UUID The ChartMogul UUID of the plan.
SUBSCRIPTION_UUID UUID The ChartMogul UUID of the subscription.