MRR Movements

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

Field name Field type Description
DATE Timestamp The time when the activity occurred.
CUSTOMER_NAME String The name of the customer associated with the activity.
MRR_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 in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
MRR Integer The new MRR after the activity has occurred.
DESCRIPTION String A description of the activity.
MOVEMENT_TYPE String The type of the activity. One of new_biz, churn, expansion, contraction or reactivation.
CURRENCY_CODE String The code representing your the invoice currency, e.g. USD or EUR.
BILLING_CONNECTOR_UUID String ChartMogul-generated UUID for the billing system in use.
CUSTOMER_EXTERNAL_ID String The unique external identifier for the customer who was responsible for the activity, if any.
CUSTOMER_UUID String ChartMogul-generated UUID for the customer who was responsible for the activity.
SUBSCRIPTION_EXTERNAL_ID String The unique external identifier for the activity’s subscription on the activity date. This is usually the subscription identifier from your billing system.
PLAN_EXTERNAL_ID String External identifier of the plan related to the activity.
ACTIVE_SUBSCRIPTION_QUANTITY Integer The number of seats or licenses of the subscription being billed by this line item. Can be any non-zero integer.
UUID String The UUID of the activity object generated by ChartMogul.
RANK Integer This field can help order activities with the same date value.
PREVIOUS_PLAN_EXTERNAL_ID String The external ID of the plan before a movement happened, which can help you track the plans before and after a change.