How to Create Custom SaaS Charts and Reports with ChartsyAI

ChartsyAI allows SaaS founders and teams to create custom charts and reports for key SaaS metrics - such as MRR, churn, ARPU, LTV, and revenue growth - using natural-language questions. No SQL, no spreadsheets, and no predefined dashboards required.

Create Custom SaaS Reports Without SQL or Spreadsheets

ChartsyAI for SaaS metrics helps you understand your business performance by letting you ask questions directly about your payment and subscription data from Stripe or Paddle.

Instead of exporting data or relying on rigid dashboards, you can generate charts and reports instantly by typing what you want to see.

ChartsyAI helps you analyze:

Monthly Recurring Revenue (MRR)
Churn and cancellations
Customer Lifetime Value (LTV / CLV)
ARPU and revenue per customer
Subscription growth and retention
Refunds, discounts, and revenue trends

1. What Are Prompts in ChartsyAI?

Prompts are natural-language questions or instructions you give to ChartsyAI to analyze your SaaS data.

Think of ChartsyAI as a virtual SaaS data analyst - you ask the question, it builds the report.

Example SaaS Prompts

"Show my MRR by month for the last 12 months."
"What is my churn rate by month this year?"
"Who are my top 10 customers by lifetime value?"
"Show new vs canceled subscriptions by month."
"Display ARPU by plan for last quarter."

ChartsyAI understands the intent behind your question and generates an interactive chart automatically.

2. Start by Typing Your Prompt

In the field labeled: "Ask me anything about your data...", type your question.

You can also start with ready-made prompts, such as:

Show MRR by month for the current year
Show churn rate for the last 6 months
Who are my top customers by revenue?
Show subscription growth by plan
What discounts generated the most revenue?

These examples help you learn how to structure effective SaaS analytics questions.

3. Good Prompt Formula for SaaS Metrics

Clear prompts produce clearer insights.

Prompt Formula

Show [SaaS metric] [time period] [breakdown or filter]

Example

Show my churn rate by month for the last 12 months as a line chart

More SaaS Examples

Show MRR growth by plan this year
Show customer lifetime value by cohort
Show net revenue retention by month
Show canceled subscriptions by reason
Show trial-to-paid conversion rate last quarter

4. Click "Visualize"

Once your prompt is ready, click Visualize.

ChartsyAI will:

Interpret the SaaS metric you're asking for
Apply the correct calculations automatically
Generate a chart, table, or KPI visualization

This replaces manual metric calculations and complex reporting workflows.

5. Explore Suggested Visualizations

After your chart is created, ChartsyAI suggests the most suitable visualization types based on your data:

Line charts for trends (MRR, churn)
Bar charts for comparisons (plans, cohorts)
Tables for detailed breakdowns
KPI cards for high-level SaaS metrics
Treemaps and bubble charts for advanced analysis

You can switch visualization types instantly without rewriting your prompt.

6. Save SaaS Reports to Your Dashboard

Click Save to add the chart to your dashboard.

Saved charts:

Update automatically as new Stripe or Paddle data syncs
Help you track SaaS performance over time
Can be combined into custom SaaS dashboards

Your dashboards evolve as your business grows - no predefined limits.

7. What If No Data Appears?

If ChartsyAI returns No Data Found, the query usually needs refinement.

Issue	Example	Fix	Why
Time range too narrow	Show MRR for Jan 2025	Show MRR for Q4 2024	Data may not exist
Too many filters	Show enterprise annual churn in December	Show churn by quarter	Query is too restrictive
Vague metric	Show churn	Show cancellations by month	Be more specific

8. "Fuzzy Prompt" Message Explained

If your question is unclear, ChartsyAI may say:

"This prompt's a bit fuzzy - try these quick improvements."

Improve	Before	After	Examples
Add dates	Show MRR	Show MRR last 6 months	Q1 2024, last 30 days
Be specific	Show customers	Show new customers by month	new, active, churned
Use metrics	Show subscriptions	Show subscriptions by revenue	MRR, ARPU, LTV
Specify chart	Show churn last year	Show churn last year as a line chart	line, bar, KPI

9. Popular SaaS Questions You Can Ask ChartsyAI

These reflect real SaaS founder and finance team questions:

How is my MRR growing month over month?
What is my churn rate this quarter?
Which customers have the highest lifetime value?
How does ARPU change by pricing plan?
What is my net revenue retention?
How many subscriptions were canceled last month?
Which plans drive the most revenue?
How do discounts affect MRR?

Why Use ChartsyAI for SaaS Metrics?

No predefined dashboards
No manual metric calculations
No SQL or spreadsheets
Ask new questions anytime
Built specifically for SaaS analytics

ChartsyAI lets you communicate directly with your SaaS data, instead of being limited by static reports.