Amplify Capital is an impact investor that backs technical founders in critical industries, including climate, health, and the future of work. As its portfolio grew, combining diverse company-level metrics into a clear fund-level report became complex and manual.
To solve this, Amplify Capital worked with Common Approach to apply the Common Framework methodology, migrating data to Airtable and structuring metrics across five clear steps.
Key results
- Expanded portfolio reporting from 6 to 12 headline indicators
- Aggregated 61% of portfolio metrics—up from 43%—without forcing startups to change what they measure
- Built transparent dashboards, audit trails, and verifiable aggregation policies
By applying flexible harmonization techniques—ranging from direct equivalence to proxy-value transformations—Amplify was able to convert diverse metrics into standardized common units. This means they were able to use more of the data received from portfolio companies, while preserving valuable context and establishing transparent exclusion rules, clear audit trails, and verifiable aggregation policies in Airtable.
