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) link located above a customer list

ChartMogul gives you the following export options:

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.

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!