# Chartmogul

ChartMogul is a subscription analytics platform that helps SaaS and subscription businesses track revenue metrics like MRR, churn, LTV, and customer growth. It pulls billing data from payment processors and subscription platforms into a single analytics layer. Connecting ChartMogul to Coupler.io lets you export that data into spreadsheets, data warehouses, or AI tools without manual exports.

**Why connect ChartMogul to Coupler.io?**

* Sync customer records, subscription activities, and growth counts to Google Sheets, Excel, BigQuery, or Looker Studio
* Send ChartMogul metrics to AI destinations like ChatGPT, Claude, or Gemini for automated analysis and commentary
* Combine customer counts with activity data using Append or Join transformations to build richer revenue dashboards
* Schedule recurring syncs so your reports always reflect the latest subscription data

## Prerequisites

* A ChartMogul account with at least one connected data source
* A ChartMogul API key (available from your account settings)
* A Coupler.io account

## Quick start

{% hint style="success" %}
If you want a high-level revenue snapshot, start with the **Customer monthly counts** entity — it gives you a clean time series of customer growth without the noise of individual records.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Create a new data flow in Coupler.io.** From your Coupler.io dashboard, click **Add data flow**, then search for and select **ChartMogul** as the source.
{% endstep %}

{% step %}
**Enter your ChartMogul API key.** In ChartMogul, go to **Profile → API Keys** and copy your secret key. Paste it into the API key field in Coupler.io.
{% endstep %}

{% step %}
**Select an entity.** Choose what data you want to export — Customers, Activities, or one of the customer count cadences (daily, weekly, monthly, quarterly).
{% endstep %}

{% step %}
**Set a start date.** Use the date picker to choose how far back to pull historical data. This filters the data returned for the selected entity.
{% endstep %}

{% step %}
**Choose a destination and run the data flow.** Select your destination — Google Sheets, Excel, BigQuery, Looker Studio, or an AI tool like ChatGPT or Claude — then click **Run** to execute your first manual sync.
{% endstep %}
{% endstepper %}

## Entities overview

| Entity                    | What it contains                                                         |
| ------------------------- | ------------------------------------------------------------------------ |
| Customers                 | Individual customer records with subscription status, plan, and metadata |
| Activities                | Subscription events — new, expansion, contraction, churn, reactivation   |
| Customer daily counts     | Count of active customers per day                                        |
| Customer weekly counts    | Count of active customers per week                                       |
| Customer monthly counts   | Count of active customers per month                                      |
| Customer quarterly counts | Count of active customers per quarter                                    |