Unlocking £100M Revenue Opportunity for a Major Franchisor with Data Strategy
QuantSpark partnered with a major franchisor to identify and resolve data pain points, uncovering a £100M revenue opportunity by addressing 10% annual sales leakage through a new data strategy.
20 April 20268 min read
Headline result
£100M
Revenue Opportunity
At a glance
£100M
Revenue Opportunity
01
01 · Challenge
What was the problem?
The Challenge: Fragmented Data & Revenue Leakage
For a major multi-site franchise network with over 2000 franchises, maintaining visibility into franchisees' operations was mission-critical but challenging. The client, having recently transitioned to institutional ownership, faced significant issues due to a previously light-touch data strategy. This led to a highly fragmented data landscape and substantial revenue leakage.
Key challenges included:
Unrecognised Job-Level Data: An estimated 60% of job-level data was not recognised in company systems, leading to vital financial information being lost or inaccessible to head office. Inconsistent uptake of in-house tools meant data was often not captured centrally.
Disparate Software Ecosystem: Without clear direction, an ecosystem of varied software solutions had grown across franchises, ranging from industry-standard job management software to legacy systems, Google Sheets, or Excel. This lack of standardisation hindered consolidated reporting.
Inconsistent Business Processes: The nature of the client's industry meant there was no single point of sale. Jobs were logged via mobile apps, or even by hand, making it difficult to define what constituted a 'job' or how a lead converted.
Impact on Central Marketing Strategy: The lack of visibility into franchise capacity meant head office could not effectively deploy marketing spend to the regions that needed it most.
Significant Revenue Leakage: Head office strongly suspected money was being left on the table. Analysis revealed that poor job-level visibility, disparate processes for capturing leads, and varying tool usage contributed to 10-20% revenue leakage per franchise's annual sales. This was caused by:
Leads not formally recorded unless they converted, missing new business opportunities.
Leads recorded in spreadsheets, not a central CRM, increasing the risk of overlooked fees.
Lack of training leading to teams using manual methods (pen and paper) instead of software tools.
Accounting software (QuickBooks) limiting visibility to the franchise level, losing job-level granularity.
02
02 · Approach
What did QuantSpark do?
Our Approach: Comprehensive Data Discovery & Strategic Roadmap
QuantSpark partnered with the client to develop granular visibility into franchise performance at a job level, enabling accurate reporting and insight. Our approach focused on a first-stage Discovery project, designed to assess current systems, identify opportunities, and build a compelling business case for a new data strategy.
Our straightforward methodology involved:
Assessing Current Systems and Capabilities: We analysed how franchises and head office utilised data for decision-making.
Identifying Quick Wins and Developing a Roadmap: We pinpointed immediate improvements and outlined a strategic path for achieving desired data visibility.
Sizing the Prize: Crucially, we quantified the potential return on investment for the proposed data strategy.
Key steps in our Discovery project included:
Extensive Stakeholder Engagement: We facilitated access to a cross-section of 52 franchise owners, conducting in-depth interviews to understand their data processes, systems usage, and pain points.
Data Maturity Segmentation: We grouped franchises into distinct archetypes based on their size and data maturity, identifying common challenges and needs. This involved understanding their interaction with the client's in-house tech platform, alongside third-party and off-the-shelf solutions.
Data Dictionary Development: A key deliverable was a data dictionary, vital for standardisation and future revenue recognition, resolving long-standing confusion over definitions like 'job' versus 'lead'.
Designing a Hub & Spoke Data Architecture: We recommended a data platform architecture utilising Amazon Redshift as a central integration platform. This 'hub' would seamlessly integrate data from various 'spokes' – including existing in-house tools, third-party applications (like Quickbase), and future sources – to create end-to-end visibility.
Strategic Recommendations: We provided a roadmap for both Systems Transformation and Cultural Transformation, including quick wins (e.g., standardising financial definitions, focusing investment on high-benefit in-house tools, seeing third-party providers as complimentary) and strategic initiatives (e.g., integrating data, not functionality; prioritising platform integration; educating franchises on data benefits; incorporating training into onboarding programmes).
03
03 · Results
What changed?
The Results: Unlocking a £100M Revenue Opportunity
QuantSpark's Discovery project provided the client with a clear understanding of their data landscape and a compelling business case for a new data strategy, revealing a significant financial opportunity.
Key outcomes and results included:
Quantified Revenue Opportunity: We identified a £100M revenue opportunity by addressing the 10-20% annual sales leakage per franchise, demonstrating the substantial return on investment for a new data strategy.
Improved Performance Visibility: The project didn't just fix a reporting pain point; it laid the groundwork for end-to-end line of sight through the job process, enabling better strategic business decisions.
Identified Growth Opportunities: Beyond addressing leakage, we identified two further revenue growth opportunities:
Payment Processing Interchange Fees: 36% of franchises absorbed credit card fees; a clear strategy to pass these on could unlock additional revenue.
Price Elasticity: Implementing systematic price variation, informed by data, presents a major opportunity to optimise profit margins and customer satisfaction.
Increased Data Adoption Appetite: Our interviews revealed that 80% of franchises were eager to adopt more data-driven strategies, indicating a strong appetite for the proposed changes and a positive outlook for cultural transformation.
Strategic Roadmap for Implementation: We presented a detailed roadmap for improvement, outlining a new data strategy and approach, complete with quick wins and long-term strategic initiatives for both systems and cultural transformation.
Figures are drawn from completed QuantSpark engagements. Clients are anonymised by agreement; on a call we will walk you through how each number was measured and, where the client has agreed, put you in touch with a reference.
Effective Data Integration: The £100M Opportunity
QuantSpark's Data Discovery Methodology
1
Assess Current Systems
Understand how franchises and head office use data to drive decisions.
2
Identify Quick Wins
Develop a roadmap to deliver desired visibility.
3
Size the Prize
Quantify the investment's worth to the business.
Revenue Leakage & Opportunity
Before
10%
Estimated Revenue Leakage
£100M opportunity identified
After
£100M
Potential Revenue Opportunity
QuantSpark partnered with a major multi-site franchise network to identify and solve critical data pain points. Our engagement uncovered revenue leakage amounting to 10% of annual sales, leading to a proposed strategy to capture a £100M opportunity. Through our expertise and methodologies, we presented a comprehensive roadmap for improvement, detailing a compelling business case for a new data strategy and approach.
The Challenge: A Fragmented Data Landscape Hindering Growth
For corporate franchisors, maintaining visibility into franchisees' operations is paramount but often challenging, given the independent nature of franchise owners. While brand standards and reporting metrics ensure some harmonised insight, the picture becomes fragmented when using franchise data for strategic business decisions. In QuantSpark's experience, franchises typically employ disparate systems and processes, limiting a franchisor's ability to derive strategic value from empirical performance data.
The client, a formerly family-run business that had grown into an American success story with over 2000 franchises, faced significant issues after transitioning to institutional ownership. The previous light-touch data strategy presented challenges for both the board and senior management. The core problems included:
Data Loss: An estimated 60% of job-level data was not recognised in company systems due to inconsistent uptake of in-house tools, leading to vital financial information being lost or inaccessible.
Software Sprawl: A lack of clear direction resulted in an ecosystem of varied software solutions across franchises, from industry-standard tools to legacy systems and basic spreadsheets.
Process Inconsistency: The industry's nature meant no single point of sale. Jobs were logged via mobile apps or manually, making it difficult to define and track 'jobs' and 'leads' consistently.
Ineffective Marketing: Lack of visibility into franchise capacity meant head office couldn't optimally deploy marketing spend.
Collectively, these issues meant money was being left on the table. Disparate data sources and myriad reporting processes were a recipe for lost revenue, with poor job-level visibility contributing to 10-20% revenue leakage per franchise's annual sales.
QuantSpark's Approach: Data Discovery and Strategic Blueprint
Our objective was clear: to develop granular visibility into franchise performance at a job level to enable accurate reporting and insight. QuantSpark's approach is straightforward:
Assess Current Systems: Understand how franchises and head office use data to drive decisions.
Identify Quick Wins: Develop a roadmap to deliver desired visibility.
Size the Prize: Quantify the investment's worth to the business.
We initiated a first-stage Discovery project, partnering with the client to gain access to 52 franchise owners. This allowed us to comprehensively assess franchise data and infrastructure, identify opportunities for improvement, and present a compelling business case for sign-off. A key deliverable was a data dictionary, essential for standardisation and future revenue recognition, resolving long-standing confusion over definitions.
We segmented franchises by Data Maturity, grouping them into distinct archetypes based on size, data processes, and system usage. This revealed common pain points and helped tailor solutions. For example:
Small, Early Data Maturity: Full reliance on in-house tools, less need for visibility, pain points in KPI transparency and data collection.
Medium-Large, Growing Data Maturity: Recent growth, work-arounds needed for in-house tools, pain points in tool flexibility.
Large Data Maturity: In-house tool used for compliance only, high volume data handling burden, lacking visibility of some business areas.
The Results: A £100M Opportunity and a Clear Path Forward
Our Discovery project confirmed the scale of the opportunity. Analysis of financial and royalties data, alongside franchise-commissioned audits, revealed that poor job-level visibility contributed to approximately 10% revenue leakage per franchise. This was caused by unrecorded leads, spreadsheet-based tracking, lack of software training, and limited job-level granularity from accounting software.
Beyond addressing leakage, QuantSpark identified two further revenue growth opportunities:
Payment Processing Interchange Fees: 36% of franchises absorbed credit card fees; a clear strategy could unlock additional revenue.
Price Elasticity: Implementing systematic price variation, informed by data, presents a major opportunity to optimise profit margins and customer satisfaction.
Crucially, 80% of interviewed franchises expressed eagerness to adopt more data-driven strategies, demonstrating a clear appetite for change.
We recommended a Hub & Spoke data platform architecture, utilising Amazon Redshift as a central integration platform. This platform would augment existing systems by seamlessly integrating data from various sources – client applications, third-party tools (like Quickbase), and future sources – feeding into a preferred visualisation tool for powerful strategic change.
Key Takeaways for Other Franchisors
QuantSpark identified key takeaways for other franchisors facing similar problems:
Quick Wins:
Create a data dictionary to standardise financial definitions.
Identify and invest in in-house tools that provide the biggest benefit to franchises.
See third-party providers as complimentary, not in competition.
Educate franchises on the benefits of data reporting, connecting KPIs to business improvement.
Strategic Roadmap:
Systems Transformation: Integrate data (straightforward), not functionality (expensive, political). Identify and prioritise integration efforts for the most commonly used software tools.
Cultural Transformation: Agree on a preferred suite of software tools and incorporate training into franchise onboarding and continual development programmes.
This project provided the client with a robust business case and a clear strategic roadmap to unlock significant revenue opportunities and drive data-led decision-making across their extensive franchise network.
