Marketplace Liquidity Analysis Framework
Measure supply-demand balance, fill rates, time to match, and regional performance to understand whether your marketplace is liquid enough to grow.
Prompt Template
You are a marketplace analytics lead. Analyze the liquidity of my two-sided marketplace and identify where growth is being blocked. Marketplace type: [services / rentals / jobs / delivery / other] Geography or segments: [cities, categories, verticals] Time period: [last 30 days / quarter / year] Demand-side inputs: - Buyer requests or searches: [number] - Conversion to booked/completed transaction: [%] - Average time to first response: [minutes/hours] Supply-side inputs: - Active suppliers/providers: [number] - Supplier acceptance rate: [%] - Supplier utilization rate: [%] - Average response time: [minutes/hours] Marketplace outputs: - Fill rate: [%] - Time to match: [minutes/hours/days] - Cancellation rate: [%] - Repeat purchase or repeat booking rate: [%] - Take rate: [%] - Any regional/category breakdowns: [paste data] Provide: 1. Liquidity scorecard by region or category 2. Where supply or demand is the constraint 3. Early-warning signals of poor marketplace health 4. Which segments are ready to scale paid acquisition 5. Operational fixes to improve liquidity in weak segments 6. Metrics to track weekly in an executive dashboard
Example Output
Marketplace Liquidity Analysis
Segment Scorecard
| Segment | Fill Rate | Time to Match | Cancellation Rate | Diagnosis |
|---------|-----------|---------------|-------------------|-----------|
| London, Cleaning | 82% | 2.1 hrs | 6% | Healthy, can scale demand |
| Manchester, Cleaning | 54% | 9.4 hrs | 18% | Supply constrained |
| London, Handyman | 61% | 6.3 hrs | 14% | Matching friction |
| Bristol, Cleaning | 77% | 3.0 hrs | 8% | Stable |
Core Insight
Manchester demand is arriving faster than providers can accept jobs. Paid acquisition here will likely worsen customer experience until provider density improves.
Recommended Actions
1. Recruit 25 more active providers in Manchester before increasing spend
2. Introduce response-time incentives for handyman suppliers in London
3. Pause low-quality leads that create unfilled demand and inflate acquisition costs
4. Track fill rate and time-to-match daily, not monthly, in constrained regions
Tips for Best Results
- 💡Always analyze liquidity by region or category, because marketplace averages hide local breakdowns
- 💡Separate acquisition problems from matching problems, they need completely different fixes
- 💡Ask for a threshold-based scorecard so you know exactly when a market is healthy enough to scale
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.