Get valuable insights into your subscription business by connecting your ChartMogul account to Power My Analytics. This guide will walk you through setting up ChartMogul as a data source and creating reports to track MRR movements, churn, retention, and customer growth.

Prerequisites

Before connecting ChartMogul to Power My Analytics, ensure you have:

• A ChartMogul account
• An API key for your ChartMogul account

Find Your ChartMogul API Key

You will need to enter your API key in Power My Analytics when connecting your ChartMogul account as a data source. To create or copy an API key, see ChartMogul's guide: Creating and Managing API Keys.

ChartMogul uses your API key as your Basic Auth username. If you are asked for a password, it can be left empty or set to the same value as the API key. When connecting in Power My Analytics, you only need to enter the API key itself.

Adding ChartMogul as a Data Source

1. Go to your Power My Analytics hub and select Sources from the main menu.
2. Click + Add new source and choose ChartMogul from the gallery of data sources.
3. Enter the API key that you obtained from ChartMogul.
4. Click Connect to authenticate and finish adding your ChartMogul account as a data source.

For step-by-step connection instructions, see How to Connect to ChartMogul.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your ChartMogul data:

1. In the PMA hub, navigate to Reports > Data Studio
2. Select ChartMogul under Create Data Studio Report (this will open the official Data Studio application in a new window)
   • Step 1:
     • Name your data source (e.g., "ChartMogul - Business Name")
     • Power My Analytics Hub: Choose your PMA hub from the dropdown
     • Optional: Leave "Use report template for new reports" checked to use the PMA demo template
     • Click Next
   • Step 2:
     • User Account: Select your ChartMogul account (for real data) or "Sample Account" (for sample data)
     • Click Next
   • Step 3:
     • Click Connect (top right) to complete the data source configuration
   • Step 4:
     • Click Create Report (top right)

Key Reports and Fields

The ChartMogul connector provides access to your subscription analytics and customer data through the Activities and Customers tables, including:

• Key Performance Metrics: MRR, ARR, Customer ID by Paid Subscriber Status, and Activity MRR Movement by Date and Type
• MRR Movements Metrics: Activity MRR and Activity MRR Movement by Date, Description, Type, Customer External ID, and Plan External ID
• Churn and Retention Metrics: Activity MRR Movement by Date, Type, Customer External ID, and Subscription External ID
• Customer Metrics: MRR and ARR by Name, Company, Email, Status, Customer Since, Country, Tags, and ChartMogul URL, plus MRR by Billing System Type
• Leads and Trials Metrics: Name, Company, Lead Status, Trial Subscriber Status, Lead Created At, Free Trial Started At, and Last Seen
• Geography Metrics: Customer ID, MRR, and ARR by Address Country, Address State, and Address City
• Attribution Metrics: Customer ID and MRR by UTM attributes (Source, Medium, Campaign, Content, and Term) and HubSpot attributes (Original Source and Lifecycle Stage)

For a full list of available ChartMogul fields in Power My Analytics, visit the Schema Explorer.

Limitations and Important Considerations

• Backfilling: Up to 2 years. PMA performs an initial backfill of 24 months of historical data when you first connect your ChartMogul account as a data source.
• Monetary values in cents: ChartMogul provides monetary metrics (such as MRR, ARR, Activity MRR, Activity ARR, and Activity MRR Movement) as whole numbers of cents in your account currency. Divide these values by 100 to obtain the actual amount.
• Supported tables: The ChartMogul connector currently provides the Activities and Customers tables; other ChartMogul reports are not yet available.

Unavailable Data

If there are additional ChartMogul fields or reports you would like to see in Power My Analytics, let us know at beta@powermyanalytics.com.

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the ChartMogul connector.