ReddRadar
Agent skill
kpi-aggregator
Aggregates KPIs from portfolio companies, normalizes metrics
Install this agent skill to your Project
npx add-skill https://github.com/a5c-ai/babysitter/tree/main/library/specializations/domains/business/venture-capital/skills/kpi-aggregator
Metadata
Additional technical details for this skill
- domain
- business
- skill id
- vc-skill-033
- specialization
- venture-capital
SKILL.md
KPI Aggregator
Overview
The KPI Aggregator skill collects and normalizes key performance indicators from portfolio companies for consolidated reporting. It enables standardized portfolio analysis despite varying reporting formats and metrics definitions across companies.
Capabilities
Data Collection
- Collect KPIs from multiple sources
- Support various input formats (spreadsheets, APIs, emails)
- Handle periodic collection schedules
- Track submission compliance
Metric Normalization
- Standardize metric definitions
- Normalize time periods and currencies
- Handle different accounting treatments
- Reconcile varying calculation methods
Portfolio Aggregation
- Aggregate across portfolio companies
- Calculate portfolio-level metrics
- Track sector and stage segments
- Compare to benchmarks
Trend Analysis
- Track metrics over time
- Calculate growth rates and trends
- Identify anomalies and concerns
- Generate trend visualizations
Usage
Collect Portfolio KPIs
Input: Collection period, company list
Process: Gather data from sources
Output: Raw KPI data, submission status
Normalize Metrics
Input: Raw KPI data, normalization rules
Process: Standardize definitions and formats
Output: Normalized metric dataset
Aggregate Portfolio View
Input: Normalized data, aggregation parameters
Process: Calculate portfolio metrics
Output: Portfolio summary, segment analysis
Analyze Trends
Input: Historical KPI data
Process: Calculate trends, identify patterns
Output: Trend analysis, anomaly flags
Core KPI Categories
| Category | Key Metrics |
|---|---|
| Revenue | ARR, MRR, revenue growth, NRR |
| Unit Economics | LTV, CAC, LTV/CAC, payback |
| Growth | Logo growth, expansion rate |
| Engagement | DAU/MAU, retention, NPS |
| Financial | Burn rate, runway, gross margin |
Integration Points
- Quarterly Portfolio Reporting: Core data collection
- Portfolio Dashboard Builder: Feed dashboard data
- Cohort Analyzer: Connect to cohort analysis
- Portfolio Reporter (Agent): Support reporting
Data Sources
- Portfolio company reporting systems
- Email-based report collection
- Carta and cap table systems
- Accounting system integrations
- Manual data entry portals
Best Practices
- Establish clear metric definitions
- Enforce consistent reporting periods
- Validate data before aggregation
- Track reporting compliance
- Document normalization adjustments
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
a5c-ai/babysitter
gsd-tools
Central utility skill for GSD operations. Provides config parsing, slug generation, timestamps, path operations, and orchestrates calls to other specialized skills. Acts as the unified entry point that the original gsd-tools.cjs provided via its lib/ modules (commands, config, core, init).
a5c-ai/babysitter
model-profile-resolution
Resolve model profile (quality/balanced/budget) at orchestration start and map agents to specific models. Enables cost/quality tradeoffs by selecting appropriate AI models for each agent role.
a5c-ai/babysitter
verification-suite
Plan structure validation, phase completeness checks, reference integrity verification, and artifact existence confirmation. Provides the structured verification layer ensuring GSD artifacts are well-formed and complete.
a5c-ai/babysitter
state-management
STATE.md reading, writing, and field-level updates. Provides cross-session state persistence via .planning/STATE.md with structured fields for current task, completed phases, blockers, decisions, and quick tasks.
a5c-ai/babysitter
git-integration
Git commit patterns, formats, and conventions for GSD methodology. Provides atomic commits per task, structured commit messages, planning file commits, branch management, and milestone tag operations.
a5c-ai/babysitter
frontmatter-parsing
YAML frontmatter parsing and manipulation for .planning/ documents. Provides read, write, update, query, and validation operations on frontmatter blocks in GSD markdown artifacts.
Didn't find tool you were looking for?