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:

  1. Navigate to Customers.
  2. Filter or segment your report, or select a customer list. To export all data, go to step 3.
  3. Click Export (CSV).

Screenshot of the Export (CSV) option located above a customer list.

ChartMogul gives you the following export options:

Screenshot of the Export list dialog with the option to export customers, subscriptions, or MRR per customer per month and include visible columns only or all data. The dialog has two buttons: Cancel and Export.

Customers

Customer exports can include custom attributes. Learn more about adding custom attributes.

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)

Subscriptions

Subscriptions exports do not include custom attributes or customers with a lead status.

ChartMogul always includes a fixed set of attributes when exporting subscriptions:

  • customer_id
  • customer_name
  • customer_email
  • customer_country
  • customer_subscription_id
  • billing_connector_name
  • billing_system
  • plan_id
  • plan_name
  • quantity
  • mrr
  • currency
  • billing_currency
  • billing_cycle
  • subscription_start_date
  • discount
  • status
  • cancellation_date
  • customer_net_payments

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:

  • customer UUID
  • customer name
  • columns for months

If your account has multiple currencies, the export displays data in the account’s primary currency.

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.

Screenshot of an email from ChartMogul with a link to download a generated CSV file.

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.

Was this article helpful?

We’re sorry to hear that. Would you like to share more feedback?


Thanks for your feedback!