Grant KPI Dashboard in Looker Studio (Google Data Studio) 2025

Visualise grant performance in real-time. Follow this workflow to build a Looker Studio dashboard that combines pipeline, finance, and impact data synced with Crafty.

TL;DR

Map KPIs to your leading indicators dashboard.
Pull data from CRM, finance, and Crafty exports via Google Sheets or BigQuery.
Embed dashboards in the oversight pack and reporting calendar.

Build the dashboard

Define KPIs across finance (spend vs budget), delivery (milestones), impact (outcomes), and compliance.
Set up data sources: Google Sheets exports, CRM connectors, Crafty CSV downloads.
Design the layout with filters for programme, funder, timeframe.
Set refresh schedules and alert thresholds.
Embed dashboard links in Crafty notes and internal comms.

Key takeaways

Looker Studio offers free, flexible dashboards for grant KPIs.
Integrate data sources early to avoid manual updates.
Share dashboards with trustees and funders to boost transparency.