The situation

Bridgepoint's portfolio included a legal process outsourcing firm, two technology staffing agencies, a management consulting boutique, and two HR advisory firms. Each had been acquired independently, each had their own operating practices, and the GP's team was receiving monthly reports that were structurally incompatible. One company reported on active contracts, another on pipeline stages, a third on billable hours forecasted. Comparing them required a manual reconciliation that took the portfolio operations team two weeks every quarter.

The GP's investment thesis depended on being able to identify underperformance quickly and intervene before it became a value problem. The current reporting lag made that impossible. By the time a trend was visible in the quarterly reconciliation, it had been running for six months.

What we found

The six companies were using four different CRMs (two on Salesforce, two on HubSpot, one on Pipedrive, one on a custom system) and tracking revenue across three different models: project-based, retainer, and time-and-materials. Building a consolidated view required standardizing the revenue model first, then the data extraction, then the reporting layer.

When we ran the initial analysis on each company independently, two findings stood out. The legal process outsourcing firm had a client concentration problem that wasn't visible in its reported metrics: the top three clients represented 71% of revenue, and engagement data showed all three had reduced their monthly activity in the preceding quarter. The firm's reported pipeline looked healthy but was masking a retention risk that would materialize at renewal.

One of the staffing agencies had a margin problem driven by rep performance variance: the bottom quartile of account managers was generating negative margin on their accounts when fully-loaded costs were included. The firm was reporting headcount revenue but not the profitability distribution. The portfolio operations team had no visibility into this.

What changed

We built a standardized revenue data model that all six companies could map into regardless of their CRM. The model captured pipeline value, weighted forecast, retention risk score, and margin by account. Each company extracted to the standard format monthly; the consolidated view was assembled automatically rather than manually.

The legal services firm's client concentration risk was flagged and the GP initiated relationship meetings with the three at-risk clients six months before renewal rather than waiting for the renewal conversation. Two of the three expanded. One reduced scope by 20% rather than the full exit the engagement data had suggested was likely.

The staffing agency's margin problem was addressed through a rep restructuring that moved the negative-margin accounts to senior account managers whose service model was more efficient for those account types. Margin on the affected accounts improved from negative 8% to positive 14% over two quarters.

Portfolio forecast accuracy reached 77% within three quarters of the unified reporting model being live — compared to the previous state where forecast accuracy was effectively unmeasurable because the inputs were incompatible.