MRR and Quantity per Customer per Month per Plan
Here are the fields included in the MRR and Quantity per Customer per Month per Plan calculated dataset you can export using destinations:
| Field name | Field type | Description |
|---|---|---|
CUSTOMER_UUID |
String | The ChartMogul UUID of the customer associated with the activity, with the "cus_" prefix. |
CUSTOMER_EXTERNAL_IDS |
String | A string-concatenated list of external identifiers of all customer records that have been merged into this customer. |
CUSTOMER_NAME |
String | The name of the customer associated with the activity. |
PLAN_UUID |
UUID | The ChartMogul UUID of the plan. |
PLAN_NAME |
String | The name of the plan. |
PLAN_EXTERNAL_ID |
String | The unique external identifier for the plan, as specified by you. |
PLAN_GROUP_UUIDS |
String | A string-concatenated list of plan group UUIDs that the plan belongs to, separated by |. |
PLAN_GROUP_NAMES |
String | A string-concatenated list of plan group names that the plan belongs to, separated by |. |
SUBSCRIPTION_UUID |
UUID | The UUID for the subscription. |
MONTH |
Date | A date indicating the end of the month. |
MRR |
Float | The current monthly recurring revenue for this customer, 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. |
QUANTITY |
Integer | The subscription quantity. |