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. |