Export your ChartMogul customers and metrics to a Google Sheet using the ChartMogul Google Sheets app.

Here’s what we cover in this article:

• Before you begin
• Exporting customers
• Exporting metrics 

Before you begin

• Read our guide to getting started with the Google Sheets app.
• Learn more about customers and customer records in ChartMogul.

Exporting customers

To export your customers from ChartMogul to a Google Sheet:

1. From an empty Google Sheet, navigate to Extensions > ChartMogul Google Sheets integration > Open app.
2. Switch to the Metrics tab in the Google Sheets app.
   
3. Click Import customers to Google Sheet.
   

The export contains data and metrics for all customers, including custom attributes and tags. The Google Sheet app notifies you when the data transfer is complete.

Exporting metrics

To export your ChartMogul metrics to a Google Sheet:

1. From an empty Google Sheet, navigate to Extensions > ChartMogul Google Sheets integration > Open app.
2. Switch to the Metrics tab in the Google Sheets app.
3. Under Import metrics, enter the start and end dates for the export in the following format: YYYY-MM-DD. For example, 2023-01-01 and 2023-12-31.
4. Choose from the following metrics:
   • MRR (Monthly Recurring Revenue)
   • ARR (Annual Run Rate)
   • Active Customer Count
   • ARPA (Annual Revenue Per Account)
   • ASP (Average Sale Price)
   • LTV (Customer Lifetime Value)
   • Customer Churn Rate
   • MRR Churn Rate
5. Choose from the following time intervals:
   • Month
   • Week
   • Day
   • Quarter
6. Finally, click Import metrics to Google Sheet.

The export contains values of the chosen metric for selected intervals (days, weeks, months, or quarters) within the specified time range. The Google Sheet app notifies you when the data transfer is complete.

Next Steps

Use the Google Sheets app to:

• Import invoice data
• Import lead and trial data
• Import custom attributes and tags

To learn about common scenarios you may encounter when using the app, review our Google Sheets troubleshooting guide.