ChartMogul

Tracking subscription revenue across multiple sources is exhausting when you're manually exporting data. Connect ChartMogul to Klipfolio Klips and your subscription analytics update automatically, so you always know where your MRR stands.

How to connect ChartMogul to Klipfolio

You'll need your ChartMogul Account Token and Secret Key before you begin.

Find your ChartMogul credentials:

1. Log in to your ChartMogul account.
2. Click the Settings icon in the left menu.
3. Select API.
4. Copy your Account Token and Secret Key.

Connect and build your data source:

1. Go to the Service Connectors page in Klipfolio and select ChartMogul.
2. Choose a pre-built data source, or click Create a custom ChartMogul data source to build your own.
3. Enter your Account Token and Secret Key, then click Continue.
4. Adjust the Query URL to replace any placeholder values with your own data. For custom sources, refer to the ChartMogul API documentation to refine your query.
5. Click Get data and confirm the results look correct.
6. Optionally, select Model your data to shape the data before saving. Learn more about modelling data sources.
7. Click Continue, then name your data source, set a refresh schedule, and optionally share it with your team.
8. Click Save.

Note: To use a static date range instead of a rolling window, format your query as:

start-date=yyyy-MM-dd&end-date=yyyy-MM-dd

View the step-by-step setup guide

Why use Klipfolio for ChartMogul dashboards

• Subscription metrics in one place: Pull MRR, ARR, churn, and customer count into a single dashboard — no more switching between reports or exporting CSVs.

• Automated data refresh: Klipfolio retrieves your ChartMogul data on a schedule, so your dashboard reflects current numbers without manual effort.

• Custom visualizations: Use 30+ chart types and Excel-like formulas to present subscription data the way your team actually needs to see it.

• Flexible distribution: Share dashboards via public links, embed them in other tools, display them on a TV in your office, or send scheduled PDF reports.

• Combine data sources: Blend ChartMogul data with CRM, marketing, or financial data to build a complete picture of revenue performance.

ChartMogul vs. Klipfolio: What each does

Stop exporting data manually. Start tracking subscription revenue in real time with Klipfolio.

View the step-by-step setup guide

ChartMogul API reference

Klipfolio connects to any service with a REST API. The more familiar you are with ChartMogul's API, the more you can customize what appears on your dashboard.

Sample queries:

• ARR for the past 12 months:

  https://api.chartmogul.com/v1/metrics/arr?start-date={date.addMonths(-12).format()}&end-date={date.today}

• Daily MRR for the past 30 days:

  https://api.chartmogul.com/v1/metrics/mrr?start-date={date.add(-29).format()}&end-date={date.today}&interval=day

For more query options, refer to the ChartMogul API documentation.