Pre-Seed to Series C: Tracking Portfolio Stage Distribution

Understanding Portfolio Stage Distribution in Venture Capital

Venture capital firms manage portfolios spanning multiple funding stages simultaneously. A typical fund holds pre-seed investments alongside Series B companies, each with distinct financial profiles, risk characteristics, and reporting requirements. Understanding where your portfolio sits across the funding spectrum—and how companies progress through stages—is foundational to LP reporting, value creation planning, and follow-on investment strategy.

Portfolio stage distribution isn’t just a reporting checkbox. It tells you whether your fund is concentrating risk in early-stage bets, whether you’re capturing follow-on opportunities, and whether your realized returns are coming from the right cohorts. When you can see stage distribution in real time, you make faster decisions about reserve allocation, follow-on check sizing, and portfolio balance.

This explainer walks through why stage distribution matters, what metrics to track, and how to build dashboards that give you and your LPs clarity on portfolio composition, progression velocity, and the dynamics that drive follow-on returns. We’ll cover the mechanics of each stage, the data structure you need to track progression, and how modern analytics platforms like D23’s managed Apache Superset deployment can surface these insights without the operational overhead of building custom reporting infrastructure.

The Funding Stage Spectrum: Pre-Seed Through Series C

Each funding stage represents a distinct inflection point in a startup’s journey. Understanding the characteristics of each stage—and what investors expect at each level—is critical to building meaningful tracking dashboards.

Pre-Seed: Founder-Led Proof of Concept

Pre-seed funding typically ranges from $50,000 to $500,000 and focuses on validating the core problem and initial product-market fit signals. At this stage, companies are usually founder-led, have minimal revenue, and are proving that customers care about their solution. Pre-seed investors—often angels, micro-VCs, and accelerators—are betting on founder quality and market opportunity rather than traction.

For portfolio tracking, pre-seed companies require different metrics than later-stage businesses. You’re watching for product engagement, early customer acquisition, and founder execution velocity. Churn, unit economics, and profitability are premature concerns; instead, you care about whether the team can iterate quickly and whether market signals are strengthening.

Seed: Establishing Product-Market Fit

Seed rounds typically range from $500,000 to $2 million and mark the transition from idea validation to early product-market fit. Seed-stage startups have demonstrated initial customer traction, repeatable acquisition channels, and proof that their solution solves a real problem. The team has grown slightly, and the company has begun to optimize go-to-market.

At the seed stage, you’re tracking revenue growth trajectory, customer acquisition cost, and early retention signals. The company should be showing month-over-month growth in users, customers, or ARR. You’re also watching for founder-market fit signals: Is the team learning? Are they pivoting intelligently based on customer feedback?

Series A: Scaling Product and Go-to-Market

Series A funding typically ranges from $2 million to $15 million and signals that a company has achieved repeatable product-market fit and is ready to scale. The company has demonstrated clear product adoption, positive unit economics (or a clear path to them), and a scalable go-to-market engine.

Series A investors expect to see strong revenue growth (typically 100%+ YoY), improving unit economics, and a clear path to profitability or dominance in a large market. At this stage, your dashboard should track revenue growth rates, CAC payback period, retention cohorts, and cash runway. You’re also beginning to monitor burn rate and assessing whether the company will need Series B capital.

Series B: Expanding Market Reach

Series B rounds typically range from $10 million to $50 million and represent the transition from scaling a single product or market to expanding horizontally—either into new customer segments, geographies, or product lines. Series B companies have strong unit economics, proven retention, and are now focused on capturing market share at scale.

At Series B, you’re tracking gross margin expansion, sales efficiency (magic number), and whether the company is maintaining growth rates as it scales. You’re also monitoring team expansion, particularly in sales and operations, and whether the company is building repeatable processes that will support continued scaling.

Series C: Scaling to Dominance

Series C funding typically ranges from $25 million to $100+ million and often signals preparation for either acquisition or IPO. Series C companies are market leaders with strong revenue bases, expanding margins, and clear paths to $100M+ ARR. They’re focused on market consolidation, international expansion, or adjacent product launches.

Series C tracking emphasizes profitability timelines, market share metrics, and competitive positioning. You’re also watching for signs of management depth, organizational maturity, and whether the company can execute a growth plan at scale without founder execution risk.

Why Stage Distribution Matters: The Portfolio Lens

Portfolio stage distribution reveals structural characteristics of your fund and its performance trajectory. A fund with too much capital concentrated in early stages faces higher failure risk but potentially higher returns on successful exits. A fund overweighted toward Series B and C has lower failure risk but slower capital deployment and potentially lower multiples.

Risk and Return Profile

Early-stage companies (pre-seed and seed) have failure rates of 50-70%, but successful exits often return 20-100x. Series A and B companies have lower failure rates (20-40%) but more modest return multiples (5-20x). Series C companies have even lower failure rates but are often acquired at lower multiples relative to their funding.

Your stage distribution determines your fund’s risk profile. A portfolio weighted toward pre-seed and seed is higher-risk, higher-potential-reward. A portfolio weighted toward Series B and C is lower-risk but requires larger exits to generate fund-level returns.

Follow-On Dynamics

Stage distribution also reveals whether you’re capturing follow-on opportunities. If your pre-seed and seed companies are progressing to Series A and B, your follow-on participation rate should be high—typically 40-60% for successful early-stage investors. If stage distribution is static (no companies moving from seed to Series A), you’re either missing follow-on opportunities or your early-stage bets aren’t performing.

Follow-on participation directly impacts fund returns. A $500K pre-seed investment that you follow in at Series A (with a $2M check) and Series B (with a $5M check) can generate 3-5x the exposure to a successful outcome compared to a single initial investment.

LP Communication and Reporting

LPs care deeply about stage distribution because it signals fund strategy execution. A fund that targets early-stage investing but has 60% of capital in Series B and C is either not executing its strategy or is adapting to market conditions. Clear stage distribution reporting—with trend analysis showing how companies progress—demonstrates that you’re actively managing the portfolio and making informed follow-on decisions.

Building Your Data Foundation: What to Track

To build meaningful stage distribution dashboards, you need a clean, normalized data model that captures both point-in-time stage information and historical progression.

Core Company Attributes

Start with a companies table that includes:

• Company ID: Unique identifier for each portfolio company
• Company Name: Official legal name
• Industry/Vertical: Sector classification (SaaS, fintech, climate tech, etc.)
• Geography: Primary operating region
• Founding Date: When the company was founded
• Current Stage: The company’s most recent funding stage (pre-seed, seed, Series A, etc.)
• Stage as of Date: The date the company entered its current stage
• Current Valuation: Most recent post-money valuation
• Total Funding Raised: Cumulative capital raised across all rounds
• Status: Active, exited (acquired/IPO), defunct, on hold

This foundation allows you to slice stage distribution by industry, geography, and time period.

Investment and Follow-On Data

You’ll also need an investments table that tracks each check your fund has written:

• Investment ID: Unique identifier for each investment
• Company ID: Link to the company
• Investment Date: When the check was written
• Check Size: Amount invested in this round
• Round Stage: The stage of the round (pre-seed, seed, Series A, etc.)
• Ownership %: Your fund’s post-money ownership stake
• Lead/Follow: Whether your fund led or followed
• Pro-Rata Rights: Whether you have pro-rata rights to follow-on rounds

This data structure lets you calculate follow-on participation rates, ownership dilution across rounds, and whether you’re maintaining your position in successful companies.

Progression Tracking

To understand how companies move through stages, you need historical stage records:

• Stage History ID: Unique identifier
• Company ID: Link to the company
• Previous Stage: The stage before this one
• Current Stage: The new stage
• Transition Date: When the company moved stages
• Months in Previous Stage: Time spent in the prior stage
• Reason for Transition: Funding round, internal milestone, etc.

This historical view lets you calculate stage duration (how long companies typically spend in each stage), progression velocity (how quickly companies move through stages), and cohort performance (how do 2020 seed cohorts compare to 2021 seed cohorts).

Performance Metrics by Stage

As companies progress, you’ll want to track stage-specific metrics:

• Pre-seed/Seed: Monthly active users, customer count, product engagement, burn rate
• Series A: Monthly recurring revenue (MRR), annual recurring revenue (ARR), YoY growth rate, CAC, LTV, retention rate
• Series B: Revenue, gross margin, magic number (revenue growth / sales & marketing spend), payback period, cash runway
• Series C: Revenue, EBITDA/operating margin, market share, competitive positioning, exit readiness signals

Different stages require different metrics because the business dynamics are fundamentally different. Tracking the same metrics across all stages creates noise rather than signal.

Dashboard Architecture: From Data to Insights

Once you have clean data, you can build dashboards that surface portfolio stage dynamics. A comprehensive portfolio dashboard should answer several key questions:

1. What’s Our Current Stage Distribution?

Start with a simple but powerful visualization: a breakdown of portfolio companies by stage. This can be displayed as:

• Pie chart or donut chart: Shows the percentage of companies at each stage
• Bar chart: Shows the count of companies at each stage
• Waterfall or sankey diagram: Shows how many companies are at each stage and how they flow between stages

You might also weight this by capital deployed: What percentage of your fund’s capital is at pre-seed vs. Series C? This reveals whether your capital is concentrated in high-risk or low-risk bets.

When you use D23’s embedded analytics capabilities, you can make these visualizations interactive—allowing LPs to filter by industry, geography, or investment year, and see how stage distribution evolves across different cohorts.

2. How Fast Are Companies Progressing Through Stages?

A critical but often-overlooked metric is stage duration. How long do companies typically spend in seed before raising Series A? How does this compare across cohorts or industries?

Build a histogram or box plot showing:

• X-axis: Months in stage
• Y-axis: Number of companies
• Filters: By stage, by cohort year, by industry

This visualization reveals whether your portfolio is progressing at a healthy pace. If seed companies are spending 24+ months before Series A, that signals either strong validation (they’re proving themselves) or weak execution (they’re struggling to raise). Context matters, but the metric surfaces the conversation.

3. What’s Our Follow-On Participation Rate?

A follow-on participation dashboard should show:

• Total companies that have progressed: How many seed companies have raised Series A?
• How many you participated in: Of those Series A rounds, how many did you invest in?
• Your ownership before and after: Did you maintain your stake or get diluted?
• Follow-on check size: How much did you invest in follow-on rounds?

This might be displayed as a waterfall or sankey diagram showing the flow of companies from one stage to the next, with a separate visualization showing your participation at each transition.

4. Where Are We Concentrated? (Risk Assessment)

A concentration dashboard should show:

• Stage concentration: What percentage of capital is in pre-seed vs. Series C?
• Industry concentration: Are you overweighted in fintech? Climate tech?
• Geography concentration: Are you concentrated in San Francisco or diversified?
• Cohort concentration: Do you have a concentrated vintage year?

Concentration isn’t inherently bad, but it’s a risk factor that should be visible and intentional. If you have 40% of capital in a single industry at a single stage, that’s a structural bet that should be explicit in your strategy.

5. How Are We Tracking Against Our Fund Strategy?

If your fund strategy specifies a target stage distribution (e.g., “40% pre-seed, 35% seed, 25% Series A”), build a dashboard that shows actual vs. target:

• Target allocation: Your stated fund strategy
• Actual allocation: Current portfolio composition
• Variance: Are you over or under on each stage?
• Trajectory: Based on your pipeline, where will you be in 12 months?

This dashboard directly connects portfolio composition to fund strategy execution and helps you make capital allocation decisions.

Advanced Tracking: Cohort Analysis and Progression Dynamics

Once you have basic stage distribution tracked, you can layer on more sophisticated analyses that reveal deeper portfolio dynamics.

Cohort Performance: Vintage Year Analysis

Companies raised at different times have different performance characteristics. A 2018 seed cohort has had years to progress and should mostly be at Series B, C, or exited. A 2023 seed cohort is still early. By tracking cohort performance, you can see whether recent investments are progressing at a healthy pace.

Build a cohort analysis table showing:

• Vintage Year: The year companies were first invested in (2018, 2019, 2020, etc.)
• Count at Each Stage: How many companies from that cohort are at pre-seed, seed, Series A, etc.
• Progression Rate: What percentage have progressed to the next stage?
• Time to Next Stage: Average months between stage transitions
• Exit Rate: What percentage have exited (acquired or IPO)?

This reveals whether your investment strategy is working. If your 2018 cohort has 60% exit rate and your 2023 cohort is progressing at a similar pace, that’s a positive signal. If your 2023 cohort is stalled, that’s a warning flag.

Stage Duration Trends

Over time, the venture market changes. Five years ago, companies might have spent 18 months in seed before Series A. Today, hot markets might compress that to 12 months. By tracking stage duration trends, you can see whether your portfolio is progressing faster or slower than historical norms.

Build a line chart showing:

• X-axis: Vintage year
• Y-axis: Average months in stage
• Lines: One line per stage (seed, Series A, Series B, etc.)

This reveals whether your recent investments are progressing faster (a positive signal in hot markets) or slower (a warning in cooling markets).

Follow-On Capture Rate by Cohort

Not all investors participate in follow-on rounds. By tracking follow-on capture rate by cohort, you can see whether your early-stage investments are progressing to stages where follow-on is possible, and whether you’re capturing those opportunities.

Build a table showing:

• Cohort: Vintage year
• Companies Raised Series A: Count of companies from this cohort that raised Series A
• Series A Participations: Count you participated in
• Capture Rate: Percentage you participated in
• Capital Deployed in Follow-Ons: Total follow-on capital from this cohort

A strong early-stage investor should have 40-60% follow-on capture rates. If you’re below 30%, you’re either missing opportunities or your companies aren’t progressing. If you’re above 70%, you might be over-concentrating in winners or not diversifying enough.

Real-World Example: Building a VC Portfolio Dashboard

Let’s walk through a concrete example of how to structure a portfolio stage distribution dashboard for a mid-market VC fund.

The Scenario

Imagine you’re a $200M fund that invests in seed and Series A rounds. Your fund strategy targets:

• 50% of capital in seed-stage companies
• 30% in Series A
• 20% in follow-on rounds to seed companies that raise Series A

You have 45 portfolio companies across these stages. You want to track whether you’re executing this strategy, whether your companies are progressing at a healthy pace, and where your follow-on opportunities are.

The Data Model

You’d structure your data with:

1. Companies table (45 rows): One row per portfolio company with current stage, founding date, industry, geography
2. Investments table (60 rows): One row per check written, with investment date, check size, round stage, company ID
3. Stage history table (80 rows): Historical record of stage transitions, showing when each company moved from one stage to the next
4. Performance metrics table: Key metrics (ARR, growth rate, churn, etc.) for each company, updated quarterly

The Dashboards

Dashboard 1: Portfolio Composition

• Pie chart: Current stage distribution (count and capital deployed)
• Table: All companies, sortable by stage, industry, geography, with key metrics
• KPI cards: % at seed, % at Series A, % in follow-ons, average time in stage

Dashboard 2: Progression & Follow-On Dynamics

• Sankey diagram: Flow of companies from seed to Series A, with follow-on participation highlighted
• Cohort table: Vintage year analysis showing progression rates and exit rates
• Line chart: Stage duration trends over time

Dashboard 3: Strategy Execution

• Variance chart: Target vs. actual capital allocation by stage
• Pipeline forecast: Based on companies in funding process, projected stage distribution in 12 months
• Follow-on capture rate: By cohort, showing where you’re capturing opportunities

Dashboard 4: Risk & Concentration

• Heatmap: Capital concentration by stage, industry, and geography
• Waterfall: Capital deployed by stage over time
• Cohort survival: What percentage of companies from each cohort are still active?

Bringing It Together with D23

Building these dashboards from scratch requires significant engineering effort. You need to normalize messy data from multiple sources (CRM, cap table software, financial models), build ETL pipelines, and maintain the infrastructure as your portfolio grows.

D23’s managed Apache Superset platform eliminates this overhead. You connect your data sources (whether that’s Airtable, Salesforce, Carta, or a data warehouse), and D23 handles the hosting, performance optimization, and security. You can build these dashboards in hours rather than weeks, and you get embedded analytics capabilities that let you share insights with LPs without exposing raw data.

With D23’s text-to-SQL and AI-powered analytics, you can also ask natural-language questions about your portfolio—“Which seed companies are taking longer than 18 months to Series A?” or “What’s our follow-on capture rate for 2022 cohorts?”—and get instant answers without writing SQL.

Metrics That Matter: KPIs for Each Stage

Beyond stage distribution itself, you should track stage-specific KPIs that signal health and progression likelihood.

Pre-Seed KPIs

• Monthly active users (MAU): Are users engaging with the product?
• Customer count: How many paying customers or beta users?
• Product engagement: Daily active users (DAU), session frequency, feature adoption
• Burn rate: Monthly cash burn and runway
• Founder velocity: Is the team shipping quickly? Are they learning from customer feedback?

Seed KPIs

• Monthly recurring revenue (MRR): Predictable revenue
• MRR growth rate: Month-over-month or quarter-over-quarter growth
• Customer acquisition cost (CAC): How much does it cost to acquire a customer?
• Lifetime value (LTV): Total revenue you expect from a customer
• Churn rate: What percentage of customers leave each month?
• LTV:CAC ratio: Should be at least 3:1 for Series A readiness

Series A KPIs

• Annual recurring revenue (ARR): Total recurring revenue
• YoY growth rate: Typically 100%+ for Series A companies
• Gross margin: Revenue minus cost of goods sold
• CAC payback period: Months to recover acquisition cost (should be <12 months)
• Retention cohorts: What percentage of customers from each cohort are retained after 6, 12, 24 months?
• Cash runway: Months of operating capital remaining

Series B KPIs

• Revenue: Absolute revenue, typically $1M+ ARR
• Gross margin: Should be improving, ideally 60%+
• Magic number: (Current quarter ARR - Previous quarter ARR) / Previous quarter sales & marketing spend. Should be >0.75
• CAC payback period: Should be improving toward <12 months
• Net revenue retention (NRR): Expansion revenue from existing customers minus churn. >110% is strong
• Burn rate and runway: When will the company need Series C?

Series C KPIs

• Revenue: Typically $5M+ ARR
• Operating margin: Path to profitability or strong unit economics
• Market share: Position relative to competitors
• Customer concentration: Is revenue too dependent on a few large customers?
• Management depth: Can the company execute without founder involvement?
• Exit readiness: Acquisition targets, IPO readiness, strategic value

Common Pitfalls in Portfolio Stage Tracking

1. Stale Data

The most common mistake is building dashboards with data that’s updated quarterly or annually. Portfolio dynamics change monthly. Companies raise rounds, pivot, or shut down. If your stage distribution dashboard shows data from three months ago, you’re making capital allocation decisions on outdated information.

Solution: Implement monthly data updates from your cap table software (Carta, Pulley, Ledgy) or CRM (Salesforce, Pipedrive). D23’s API-first architecture makes it easy to automate these updates.

2. Inconsistent Stage Definitions

Different investors define stages differently. One investor’s “Series A-ready” is another’s “pre-Series A.” If your data has inconsistent stage labels, your dashboard becomes meaningless.

Solution: Define stage criteria explicitly based on funding amounts, revenue, and company maturity. Document these definitions and apply them consistently across your portfolio.

3. Missing Historical Data

You can’t track progression if you don’t have historical stage records. Many VCs only track the current stage, not when companies transitioned between stages.

Solution: Reconstruct historical stage data from your cap table, emails, and investment memos. Going forward, record stage transitions as they happen.

4. Ignoring Follow-On Dynamics

Some VCs track stage distribution but not follow-on participation. This misses a critical driver of returns. Follow-on participation is often the difference between 3x and 10x returns.

Solution: Build follow-on participation into your data model and track it explicitly. Know your capture rate by cohort and stage transition.

5. Not Contextualizing With Performance

Stage distribution alone doesn’t tell you whether your portfolio is healthy. A portfolio weighted toward Series B looks good until you realize those companies are burning cash and won’t reach Series C.

Solution: Combine stage distribution with performance metrics. Track both where companies are and how they’re performing at each stage.

Embedding Portfolio Analytics: From Dashboard to Product

If you’re a larger fund or platform (like a fund-of-funds or multi-stage platform), you might want to embed portfolio analytics into a product that your LPs can access directly.

D23’s embedded analytics and MCP server for analytics capabilities allow you to build white-label dashboards that you can embed in your own web application or LP portal. Your LPs see your branding, not D23’s, and they can explore portfolio data without leaving your platform.

This is particularly valuable for:

• Fund-of-funds: Tracking stage distribution across multiple underlying funds
• Multi-stage platforms: Showing how companies flow through different fund vehicles
• Syndicates: Giving syndicate members visibility into portfolio composition and progression
• Large LPs: Providing consolidated reporting across multiple fund investments

Building Your Dashboard: Technical Considerations

Data Sources

Your portfolio data likely lives in multiple systems:

• Cap table: Carta, Pulley, Ledgy, or custom spreadsheet
• CRM: Salesforce, Pipedrive, or Hubspot for pipeline tracking
• Financial models: Google Sheets or Excel for revenue projections
• Communications: Email, Slack, or Notion for qualitative updates

You’ll need to extract data from these sources and normalize it into a consistent schema. D23’s API-first approach makes this easier—you can connect to multiple data sources and let D23 handle the integration.

Metrics Calculation

Some metrics are simple (count of companies at each stage). Others require calculation:

• Follow-on capture rate: Count of Series A companies you invested in / Count of Series A companies in your portfolio
• Stage duration: Date company reached current stage - Date company reached previous stage
• Cohort survival rate: Count of companies from cohort still active / Total companies in cohort

Build these calculations into your data model or dashboard layer, and document them clearly so everyone interprets them the same way.

Performance and Scalability

If you have hundreds of companies and years of historical data, dashboard performance matters. Queries that take 30 seconds to load frustrate users. D23’s managed infrastructure handles performance optimization automatically—you don’t need to worry about query optimization or database tuning.

Communicating With LPs: Narrative Around Numbers

A dashboard is only useful if people understand what it means. When you share portfolio stage distribution with LPs, provide narrative context:

The Story Your Data Should Tell

• Current state: What’s our stage distribution? How does it compare to our fund strategy?
• Progression: Are companies moving through stages at a healthy pace? How does this compare to historical norms?
• Follow-on: Are we capturing follow-on opportunities? What’s our participation rate by cohort?
• Risk: Where are we concentrated? What are the tail risks in our portfolio?
• Outlook: Based on our pipeline, where will we be in 12 months? What actions should we take?

The best dashboards tell a story. They don’t just show numbers; they guide the viewer to insights and decisions.

Frequency and Format

Most funds share portfolio updates with LPs quarterly. Include:

• Executive summary: 1-2 page overview of portfolio health, stage distribution, and key metrics
• Detailed dashboards: 5-10 pages of visualizations with narrative explanation
• Cohort analysis: How are different vintage years performing?
• Risk assessment: Where are we concentrated? What’s our downside scenario?
• Outlook: Pipeline and capital deployment forecast

Scaling Your Approach: Multi-Fund and Multi-Stage Considerations

If you manage multiple funds or have multiple investment stages, your stage distribution tracking becomes more complex.

Multi-Fund Tracking

If you have a seed fund and a growth fund, you might want to track:

• Stage distribution by fund: How is each fund’s capital distributed?
• Cross-fund progression: How many seed fund companies graduate to your growth fund?
• Overlap and concentration: Are you over-concentrated in companies that operate across both funds?

Build separate dashboards for each fund, and a consolidated view showing cross-fund dynamics.

Multi-Stage Platforms

If you’re a platform like Andreessen Horowitz or Sequoia (investing across all stages), you might track:

• Stage distribution across all funds: What’s our overall exposure to early vs. late stage?
• Portfolio company flow: How do companies move between your different funds?
• Ownership trajectory: How does our ownership stake change as companies progress?
• Return attribution: Which stages are generating the best returns?

This requires a sophisticated data model that links investments across multiple funds and tracks ownership changes over time.

Advanced: Predictive Stage Distribution

Once you have historical stage distribution data, you can build predictive models:

Progression Probability

Given a company’s characteristics (industry, founding date, revenue, growth rate), what’s the probability it will reach Series A within 12 months? You can build a classification model using historical data to predict which companies are likely to progress.

This helps you:

• Identify at-risk companies: Which seed companies are unlikely to reach Series A?
• Plan reserve allocation: How much capital should you reserve for follow-ons?
• Adjust thesis: Are certain industries progressing faster than others?

Cohort Performance Forecasting

Based on how previous cohorts performed, can you forecast how your 2024 cohort will perform? You can build time-series models that predict:

• Exit rate by year: What percentage of 2024 companies will exit by 2030?
• Time to Series A: How long will 2024 seed companies take to raise Series A?
• Return distribution: What’s the expected return distribution for 2024 cohorts?

These forecasts help you set realistic expectations with LPs and identify when your recent investments are tracking ahead or behind historical norms.

Actionable Insights: From Dashboard to Decision

Ultimately, a stage distribution dashboard should drive decisions:

Capital Allocation

If your dashboard shows that you’re underweighted in seed (20% vs. 50% target), that’s a signal to deploy more capital into seed companies. If you’re overweighted in Series B (40% vs. 20% target), that’s a signal to slow Series B investments and redeploy into earlier stages.

Follow-On Strategy

If your dashboard shows that you’re capturing only 30% of Series A opportunities from your seed companies, that’s a signal to either improve your seed company selection (so more progress to Series A) or improve your follow-on execution (so you don’t miss opportunities).

Portfolio Rebalancing

If your dashboard shows that you’re concentrated in a single industry or geography, that’s a signal to diversify. If you’re concentrated in a single vintage year, that’s a signal to invest more consistently across years.

Risk Management

If your dashboard shows that companies are taking longer to progress through stages, that’s a signal to investigate whether market conditions are changing or whether your investments are underperforming. This might prompt conversations with founders about capital efficiency or strategic pivots.

Conclusion: Making Stage Distribution Actionable

Portfolio stage distribution is a foundational metric for venture capital funds. It reveals your fund’s risk profile, capital deployment strategy, and whether you’re executing your thesis. But raw numbers are only useful if they’re connected to decision-making.

Building a stage distribution dashboard requires clean data, thoughtful metrics, and clear communication. With D23’s managed Apache Superset platform, you can build these dashboards without the operational overhead of managing infrastructure. You get professional-grade dashboards, text-to-SQL for ad-hoc analysis, and the ability to embed analytics in your LP portal—all without hiring a data engineer.

Start with the basics: track current stage distribution, historical progression, and follow-on participation. Layer on cohort analysis and performance metrics. Then use these insights to make faster, more informed decisions about capital allocation, follow-on strategy, and portfolio management.

The funds that win aren’t the ones with the best data—they’re the ones that act on it fastest.