Exporting customers, subscriptions and MRR per customer per month
Export your customers, subscriptions and MRR per customer per month to a CSV file to use the data on other platforms or perform custom data analysis using in-house tools.
To export your data:
- Navigate to Customers.
- Filter or segment your report or select a customer list. To export all data, go to step 3.
- Click the Export as CSV icon.
ChartMogul gives you the following export options:
Customers
If you choose to export customers, you can choose between:
- Visible columns only: Exports just the visible columns in the customer list table
- All data: Exports all available attributes for the customer (including custom attributes)
Once you’ve exported your customers using CSV, update them using flexible CSV import.
Subscriptions
ChartMogul always includes a fixed set of attributes when exporting subscriptions:
| Column | Description |
|---|---|
| customer_id | The customer’s unique identifier, imported by ChartMogul from an integration or which you’ve added manually using a custom source |
| customer_uuid | A unique identifier automatically generated by ChartMogul |
| customer_name | The customer’s name displayed in ChartMogul as per the preferred customer name setting |
| customer_email | The Contact info (legacy) email address. This field is blank for customer records that do not contain this field. |
| primary_contact_email | The email address for the first contact listed on the customer’s record or specified using the API. |
| customer_country | The customer’s country |
| customer_subscription_id | A unique identifier for the subscription automatically generated by ChartMogul or which you’ve added manually using CSV or data tables |
| billing_connector_name | The unique name for your source in your account |
| billing_system | The system you use to bill customers or track subscriptions. This could be an integration or a custom source. |
| plan_id | The unique identifier for the plan |
| plan_name | The name of the plan |
| quantity | The quantity of subscriptions |
| mrr | The customer’s current monthly recurring revenue for active and past due subscriptions. |
| currency | The account’s primary currency |
| billing_currency | The currency a subscription is billed in |
| billing_cycle | The frequency at which the customer is billed for a subscription, as per their plan |
| subscription_start_date | The date and time a subscription began |
| discount | The discount amount applied to a subscription, in the account’s primary currency |
| status | The subscription status |
| cancellation_date | The date and time a subscription ended |
| customer_net_payments | Sum of all of the customer’s successful transactions |
MRR per customer per month
MRR per customer per month includes the following data for customers who are active or past due at the end of a calendar month:
| Column | Description |
|---|---|
| customer_uuid | A unique identifier automatically generated by ChartMogul |
| customer_external_ids | The customer’s unique identifier, imported by ChartMogul from an integration or which you’ve added manually using a custom source |
| customer_name | The customer’s name displayed in ChartMogul as per the preferred customer name setting |
| company_name | The name when the customer is an organization and not an individual |
| columns for months | The final MRR amount at the end of each month |
If your account has multiple currencies, the export displays data in the account’s primary currency.
MRR per customer per month per plan
MRR per customer per month per plan contains multiple rows for customers who have switched plans or are subscribed to more than one plan. Each row reflects that customer’s MRR contribution for the specific plan.
This is an extended version of the MRR per customer per month export, containing the following additional columns:
| Column | Description |
|---|---|
| plan_name | The plan’s name |
| plan_external_id | The plan’s external ID |
| plan_group_names | A comma-separated list of the names of all plan groups the plan belongs to |
| plan_group_uuids | A comma-separated list of the UUIDs of all plan groups the plan belongs to |
Export the data
Click Export to have ChartMogul prepare a CSV file and email you a download link. The time it takes to do this varies depending on the size of the dataset you’re exporting.
This link is valid for seven days. Click the link to download a ZIP file containing your exported data. Then, uncompress the ZIP and open the CSV file in your desired application.