Natural Language Queries: Exploring Stripe Data in Plain English
Learn how to analyze your Stripe data using simple, conversational questions instead of complex queries.
What you'll learn:
- Query Structure & Patterns
- Common Query Examples
- Advanced Query Techniques
- Best Practices & Tips
Understanding Natural Language Queries
Natural language queries allow you to interact with your Stripe data using everyday language instead of technical query syntax. Hunchbank's AI understands context, intent, and common business terminology to deliver accurate insights from your questions.
Basic Query Patterns
Revenue Queries
- "What was my total revenue last month?"
- "Show me MRR growth trend this year"
- "Compare revenue between Q1 and Q2"
Common Query Categories
Customer Analysis
- • "Who are my top 10 customers by spend?"
- • "Show me customers at risk of churning"
- • "List customers who upgraded this month"
Subscription Metrics
- • "What's my current MRR?"
- • "Show churn rate over last 6 months"
- • "List all canceled subscriptions"
Advanced Query Techniques
Hunchbank's natural language processing can handle complex queries that combine multiple metrics, timeframes, and conditions.
Advanced Query Examples
Comparative Analysis
"Compare revenue from enterprise customers vs SMBs in Q1"
Multi-metric Analysis
"Show me customers with high LTV but declining usage in last 3 months"
Trend Analysis
"Analyze payment failure patterns by card type and region"
Query Tips & Best Practices
Be Specific with Time Periods
Instead of "recent sales", use "sales in the last 30 days" or "Q1 2024 sales"
Use Business Metrics
Reference common metrics like MRR, ARR, churn rate, and LTV in your queries
Include Context
Add relevant segmentation (e.g., by plan type, region, or customer segment)
Query Templates
Growth Analysis
"Show [metric] growth [timeframe] by [segment]"
Customer Behavior
"Find customers who [action] in [timeframe] with [condition]"
Comparative Analysis
"Compare [metric] between [segment1] and [segment2] in [timeframe]"
Automating Insights
Hunchbank allows you to save and schedule your most important queries for regular monitoring.
Saved Queries
Save frequently used queries for quick access and consistency
Scheduled Reports
Set up automated reports to run at regular intervals
Smart Alerts
Get notified when metrics cross specified thresholds