Consultancy
Ford Family - Social Value Tracker
Ford Family - Social Value Tracker
Custom Airtable build to help collect and measure social value data.
Custom Airtable build to help collect and measure social value data.
Year
2025
Year
2025
Year
2025
Client
Ford Family Foundation
Client
Ford Family Foundation
Client
Ford Family Foundation
Industry
VCSE Support
Industry
VCSE Support
Industry
VCSE Support
Project Duration
6 weeks
Project Duration
6 weeks
Project Duration
6 weeks
About Ford Family Foundation
Through working in partnership with the major universities in the UK they identify ‘social entrepreneurs’ who have established up Community Interest Companies (CIC’s) or Not for profit companies (NFP’s).
They have donated £3m+ to FFF to enable it to make grants of between £100k- £250k each to over 20 CICs in the next four years. As well as mentoring, they will look to offer support services such as finance and marketing.

Objective
FFF approached us alongside Profit for Purpose Consultancy who were working together to reevaluate the way they collect social value data to measure and improve their services. We were engaged to build a digital system to support the collection of data and enable automation of workflow to reduce load on operations.


Challenge
The client had many different intervention types to track all running at different intervals so the system would have to be flexible enough to enable this. The platform would need to be low maintenance and trusted by the VCSE sector.

Result
We opted for an Airtable custom build. The system tracks interventions, grants etc and schedules social value questionnaires to be sent out at regular intervals with all data being retained in a database for measurement. The system has massively reduced the admin burden on the team and allowed FFF to more accurately measure their impact.
Latest Projects
Consultancy
Ford Family - Social Value Tracker
Ford Family - Social Value Tracker
Custom Airtable build to help collect and measure social value data.
Custom Airtable build to help collect and measure social value data.
Year
2025
Year
2025
Year
2025
Client
Ford Family Foundation
Client
Ford Family Foundation
Client
Ford Family Foundation
Industry
VCSE Support
Industry
VCSE Support
Industry
VCSE Support
Project Duration
6 weeks
Project Duration
6 weeks
Project Duration
6 weeks
About Ford Family Foundation
Through working in partnership with the major universities in the UK they identify ‘social entrepreneurs’ who have established up Community Interest Companies (CIC’s) or Not for profit companies (NFP’s).
They have donated £3m+ to FFF to enable it to make grants of between £100k- £250k each to over 20 CICs in the next four years. As well as mentoring, they will look to offer support services such as finance and marketing.

Objective
FFF approached us alongside Profit for Purpose Consultancy who were working together to reevaluate the way they collect social value data to measure and improve their services. We were engaged to build a digital system to support the collection of data and enable automation of workflow to reduce load on operations.


Challenge
The client had many different intervention types to track all running at different intervals so the system would have to be flexible enough to enable this. The platform would need to be low maintenance and trusted by the VCSE sector.

Result
We opted for an Airtable custom build. The system tracks interventions, grants etc and schedules social value questionnaires to be sent out at regular intervals with all data being retained in a database for measurement. The system has massively reduced the admin burden on the team and allowed FFF to more accurately measure their impact.
Latest Projects
Consultancy
Ford Family - Social Value Tracker
Ford Family - Social Value Tracker
Custom Airtable build to help collect and measure social value data.
Custom Airtable build to help collect and measure social value data.
Year
2025
Year
2025
Year
2025
Client
Ford Family Foundation
Client
Ford Family Foundation
Client
Ford Family Foundation
Industry
VCSE Support
Industry
VCSE Support
Industry
VCSE Support
Project Duration
6 weeks
Project Duration
6 weeks
Project Duration
6 weeks
About Ford Family Foundation
Through working in partnership with the major universities in the UK they identify ‘social entrepreneurs’ who have established up Community Interest Companies (CIC’s) or Not for profit companies (NFP’s).
They have donated £3m+ to FFF to enable it to make grants of between £100k- £250k each to over 20 CICs in the next four years. As well as mentoring, they will look to offer support services such as finance and marketing.

Objective
FFF approached us alongside Profit for Purpose Consultancy who were working together to reevaluate the way they collect social value data to measure and improve their services. We were engaged to build a digital system to support the collection of data and enable automation of workflow to reduce load on operations.


Challenge
The client had many different intervention types to track all running at different intervals so the system would have to be flexible enough to enable this. The platform would need to be low maintenance and trusted by the VCSE sector.

Result
We opted for an Airtable custom build. The system tracks interventions, grants etc and schedules social value questionnaires to be sent out at regular intervals with all data being retained in a database for measurement. The system has massively reduced the admin burden on the team and allowed FFF to more accurately measure their impact.


