It can be difficult to collate progress towards metrics from different partner organisations. Spreadsheets are the de-facto solution but 4 of the top challenges are:
Low quantity: let’s face it, most people consider spreadsheets to be a necessary evil. As such you often need to chase people to add their information and when they do add their updates, they often put in the minimum information they can get away with entering as they would rather spend their time on other tasks.
Low quality: people often enter data in the wrong format which means it can’t be summed automatically without further checking and cleaning which take time.
Low context: when spreadsheets only contain numbers that are entered over time, narrative gets lost or at best is demoted to the comments on each cell.
Low comprehension: there’s usually only one person on each programme who understands how the spreadsheet works, who knows the formulas and who can make each tab talk to each other. This is a risk because if that person is unavailable, your information becomes unmanageable.
Thankfully there is a better way
We’ve designed an alternative solution with user experience at its core; Makerble Boards are easy-to-use interactive shareable dashboards.
Create metrics and assign them to partners
Create a standard framework of metrics
Add those measures to different projects across your partnership programme
Keep track of which KPIs are being used by which partner organisations
Each partner sees their own progress and shares updates in seconds
Partners share updates that are numerical but they also include:
Pictures
Videos
Files
Audio clips
Location tags
