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

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.

How to connect

1

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.

2

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.

3

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

4

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.

5

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.

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