I just had an AI agent build this Stripe free trial revenue forecasting dashboard in about 5 minutes for the chief of staff at a startup
it takes stripe data and projects their new MRR two weeks out in advance
It has a table with when users should convert, the cumulative new MRR, and which days free trials are ending
and I'm going to tell you how I did this so you can too
but the best part is you can ask this dashboard questions like
"how many people in free trial right now are on business domain emails?"
and it answers
All the data in this dashboard is live and updates in real time
and if you don't want to build this yourself the AI app is called Graphed .com
just start your free trial, and give Graphed this prompt and it will make this exact dashboard
Create a dashboard called "Free Trial Forecasting" with the following:
1. **Table chart** called "Updated List (Still Active)" showing:
- All customers currently on free trials that end within the next 14 days
- Columns: trial end date, email address, status (show as "✅ Active"), and expected value (the subscription plan amount)
- Exclude any emails containing "EXAMPLE .com"
- Exclude customers who have cancelled their subscriptions
- Sort by trial end date ascending
2. **Area chart** called "Expected Value Forecast" showing:
- The total expected value (sum of subscription amounts) by day
- For the same group of trial users (trials ending in next 14 days, not cancelled)
- Over time to show the forecast
3. **Bar chart** called "Trial Ends Over Time" showing:
- Count of trials ending by date
- For the same filtered group of active trial users
Data source: Stripe
- Use subscription_history table to find trials with trial_end dates in the future
- Join with subscription_item and plan tables to get the plan amount
- Join with customer table to get email addresses
- Use subscription_history to identify cancelled customers and exclude them
English
