Customers

Calculated customers. Calculated customers are what you see on customer lists. Each calculated customer contains one or more source customers. When customers are merged, multiple source customers become part of one calculated customer.

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

Field name Field type Description
MRR Float The current monthly recurring revenue for this customer, expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
ARR Float The current annual run rate for this customer, also expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
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.
BILLING_CYCLE String The frequency with which a subscription for this plan is billed. For example, if you bill your customer every three months for a subscription with this plan, then interval_count would be 3 and interval would be month. When the customer has multiple subscriptions, this is a pipe-separated list of billing cycles.
NET_PAYMENTS Float The sum of all payments this customer has made.
COUNTRY String The country code from this customer’s address as per the ISO-3166 alpha-2 standard.
STATE String The state from this customer’s address.
CITY String The city from this customer’s address.
ADDRESS_ZIP String The zip code from this customer’s address.
SUBSCRIBER_SINCE Timestamp An RFC 3339-formatted datetime attribute indicating when the customer first started paying for a subscription.
STATUS String The status of this customer. One of New Lead, Working Lead, Qualified Lead, Unqualified Lead, Active, Past Due or Cancelled.
UUID String The UUID of the calculated customer object generated by ChartMogul.
EXTERNAL_ID String A pipe-separated list of the external IDs of all source customers associated with this calculated customer.
COMPANY_NAME String This customer’s company name.
CUSTOMERS_NAME String The name of this customer. This is a legacy field.
EMAIL String The customer’s email address. This is a legacy field.
CURRENCY String The currency of the MRR readings for this customer.
SUBSCRIPTION_QUANTITY Integer The number of subscription seats or licenses this customer has. When the customer has multiple subscriptions, this is the sum of all subscription seats or licenses.
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. When the customer has multiple subscriptions, this is a pipe-separated list of IDs.
LEAD_CREATED_AT Timestamp The time when this customer was established as a lead.
DATA_SOURCE_NAME String A pipe-separated list of source names. These are the sources of all source customers associated with this calculated customer.
FREE_TRIAL_STARTED_AT Timestamp The time when this customer started a free trial of your product or service.
CUSTOMER_CREATED_AT Timestamp The time when the calculated customer was created in ChartMogul.
WEBSITE_URL Timestamp The URL of the customer’s website.
CUSTOMER_CHURNING_AT String For customers canceling their last subscription, the time they are going to churn.
LAST_EMAIL_SENT_TO_CUSTOMER_AT Timestamp The most recent time when you sent an email to one of the customer’s contacts. The email must be sent from an account synced to ChartMogul.
LAST_EMAIL_RECEIVED_FROM_CUSTOMER_AT Timestamp The most recent time when one of the customer’s contacts sent you an email. The email must be sent to an account synced to ChartMogul.
LAST_COMMUNICATION_AT Timestamp The date and time of your most recent communication with one of the customer’s contacts (email or logged call). The email must be sent to or from an account synced to ChartMogul.
OWNER String The email address of the user who is responsible for the customer relationship.