Subscriptions

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

Field name Field type Description
CUSTOMER_UUID String The ChartMogul UUID of the customer associated with the subscription, 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, separated by |.
CUSTOMER_NAME String The name of the customer associated with the subscription.
CUSTOMER_EMAIL String This customer’s email address.
PRIMARY_CONTACT_EMAIL String The email address of the customer’s primary contact.
CUSTOMER_COUNTRY String The customer’s country.
CUSTOMER_SUBSCRIPTION_ID String The subscription’s external IDs.
BILLING_CONNECTOR_NAME String The name of the data source, e.g., My data source.
BILLING_SYSTEM String The name of the billing system (e.g., Stripe, Recurly, GoCardless) or Custom for custom sources.
PLAN_UUID UUID The ChartMogul UUID of the plan.
PLAN_NAME String The name of the plan or plans the customer has been subscribed to (including active and canceled plans). When the customer has been subscribed to multiple plans, this is a pipe-separated list of plan names.
QUANTITY Integer The quantity of plans purchased by the customer.
MRR Float The monthly recurring revenue for the subscription, 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. This represents the subscription value independent of the subscription status. For cancelled subscriptions, the value reflects the last captured MRR amount. Combine the value with STATUS to determine if it contributes to the customer’s MRR.
ARR Float The annual run rate for the subscription, 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. This represents the subscription value independent of the subscription status. For cancelled subscriptions, the value reflects the last captured ARR amount. Combine the value with STATUS to determine if it contributes to the customer’s ARR.
CURRENCY String The currency of the MRR readings for this customer.
BILLING_CURRENCY String The currency that the subscription is billed in.
INTERVAL_UNIT String The unit of time used for billing cycles. One of day, month or year.
INTERVAL_COUNT Integer The number of interval units between subsequent billing dates.
SUBSCRIPTION_UUID UUID The ChartMogul UUID of the subscription.
SUBSCRIPTION_START_DATE Timestamp The timestamp for when this subscription started.
DISCOUNT Float The discount amount in cents (or pence for GBP, etc.).
STATUS String The current status of the subscription. Either active or inactive.
CANCELLATION_DATE Timestamp The timestamp for when the subscription was canceled.
CANCELLATION_SCHEDULED_FOR Timestamp The timestamp for when the subscription was scheduled for cancellation.
CUSTOMER_NET_PAYMENTS Float The sum of all payments the customer has made.