Most internal communications teams are measuring plenty and reporting almost none of it. The open rate lives in the mail platform, intranet numbers live in analytics, town-hall attendance is in a spreadsheet somebody keeps on their desktop, and the engagement index arrives once a month as a PDF from the survey vendor. By the time it is all pasted into a deck, the month is over and nobody can tell whether a number is genuinely bad or just normal for August.
The Internal Communications KPI Dashboard in Google Sheets is a scorecard that solves the assembly problem. It holds 14 internal communications KPIs in four groups, shows each one at MTD and YTD against Target and Prior Year, and drives the entire pack from a single month dropdown. It is built entirely on native Google Sheets formulas – no add-on, no Apps Script, no connector and no refresh step – so you can be reading your own numbers within an hour of downloading it.
Two things to be clear about before we go further. First, this is the KPI scorecard family – month picker, traffic lights, a KPI Trend page and a KPI Analysis page – not the analytical, pivot-and-slicer style dashboard that slices raw message-level records. Near-identically-named templates exist in both families, and they are different products. Second, the template does not collect anything. You type the monthly totals in. That is the trade: no IT review, no admin consent, and your raw numbers never leave your own Google Drive.
Key Features of the Internal Communications KPI Dashboard
- 14 KPIs across four groups. Reach & Engagement (Email Open Rate, Newsletter Click-Through Rate, Message Reach Rate, Town-Hall Attendance Rate), Channel Performance (Intranet Monthly Active Users, Intranet Page Views, Channel Adoption Rate, Video Completion Rate), Employee Sentiment (Employee Engagement Score,Internal Communications KPI Dashboard in Google Sheets Comms Satisfaction Score, Employee Net Promoter Score (eNPS), Feedback Response Rate) and Content & Operations (Average Response Time, Content Published).Internal Communications KPI Dashboard in Google Sheets
- One dropdown drives everything. Change Select Month on the KPI Dashboard sheet and the seven header cards, all 14 rows, the KPI Trend page and the KPI Analysis page move with it.
- MTD and YTD, side by side. Each period gets its own six columns: Actual, Target, Ach %, Status, Prior Yr and vs PY.
- Traffic lights you control. On Target from 100%, At Risk 95% to 99%, Missed below 95% – and the thresholds sit in the Status formulas, so you can move them.
- Upper-the-better and lower-the-better both handled. Achievement is Actual over Target for UTB KPIs and Target over Actual for LTB ones, so beating a response-time target scores above 100% rather than below it.
- YTD that matches the metric. Rates average across the months; counts such as Content Published and Intranet Page Views sum.Internal Communications KPI Dashboard in Google Sheets
- Owner, priority and frequency per KPI, so a review meeting goes straight to the person accountable.Internal Communications KPI Dashboard in Google Sheets
- A KPI Definition master list that every other sheet reads, so adding or renaming a KPI needs no formula edits.Internal Communications KPI Dashboard in Google Sheets
Dashboard Pages Explanation
1. Home
The index. It links out to the three dashboard pages (KPI Dashboard, KPI Trend, KPI Analysis), the three input sheets (KPI Input – Actual, Target, PY), the KPI Definition sheet, a Read Me and Get More Templates. The header cards summarise the build: 14 KPIs, MTD + YTD in every view, and 100% formula-driven. A Get Started In Three Steps strip spells out the workflow – enter your data, pick a month, read the scorecard.
2. KPI Dashboard
The page you screenshot for the monthly review. Seven cards run along the top – Total KPIs Tracked, On Target (YTD), At Risk (YTD), Missed (YTD), Improving vs PY (MTD), Avg Achievement (MTD) and Avg Achievement (YTD). Below them, Select Month sets the reporting month (the sample ships on September 2025) and the 14 rows follow: KPI Group, KPI Name, Unit and Type, then the Month-to-Date block and the Year-to-Date block, each with Actual, Target, Ach %, Status, Prior Yr and a vs PY figure carrying an up or down arrow. A footnote at the bottom restates the UTB/LTB rule and the three status thresholds, so a first-time reader does not have to ask what 98.2% in amber means.
3. KPI Trend
One KPI, twelve months. Pick a KPI from the Select KPI dropdown and the header fills in its group, unit, type, owner, priority, frequency, formula and definition – so the person reading the chart also gets the definition that produced it. The table underneath lists every month with its prior-year month, the MTD block, the YTD block and vs Prior Year for both. Two charts sit below: MTD Trend for Email Open Rate and YTD Trend for Email Open Rate in the shipped sample, each plotting Actual as bars with Target and PY as lines. This is the page that answers the only question that matters when a KPI turns red – is this one bad month, or four months of drift?
4. KPI Analysis
The roll-up. Performance by KPI Group counts the KPIs in each group and how many are On Target, At Risk and Missed, then averages MTD and YTD achievement per group. Beside it, Top 5 and Bottom 5 Performing KPIs are ranked on YTD achievement with their group and status. The Average YTD Achievement by KPI Group bar chart sits underneath, and a How To Read This Page box explains that the group rows are generated from the KPI Definition sheet, that the ranking is on YTD achievement so an LTB KPI beating its target ranks near the top, and where to change the thresholds. Everything on this page follows the month selected on the KPI Dashboard.
5-7. The three input sheets
KPI Input – Actual, KPI Input – Target and KPI Input – PY share one layout: a row per KPI, a column per month, with a calculated YTD column beside each MTD column. Only the yellow cells take typing. Cell E3 on the Actual sheet holds the first month of the reporting year, so an April-to-March financial year is a single edit and the whole workbook re-bases around it.
8. KPI Definition
The master list, and the sheet that makes the template yours rather than ours. Each row holds KPI Number, KPI Group, KPI Name, Unit, Formula, Definition, Type (UTB or LTB), Owner, Priority and Frequency. Add a row, rename one, delete one – every other sheet follows automatically, with no formula editing anywhere.
Google Sheets vs. Excel vs. Paid Comms Platforms – Feature Comparison
| This template (Google Sheets) | Excel KPI dashboard | Paid comms platform (Staffbase, Poppulo) | |
|---|---|---|---|
| Cost | $8.99 one time | $12.99 one time | Per-employee annual licence, quoted on request |
| Platform | Browser, any device with Google Sheets | Microsoft Excel desktop | Vendor web app plus mobile app |
| Setup time | Under an hour once you have the numbers | Under an hour | Weeks – IT review, SSO, directory sync |
| Real-time team collaboration | Yes, native multi-user editing | Only via OneDrive co-authoring | Yes |
| Mobile access | Yes, Google Sheets app | Limited | Yes |
| Customisable KPIs | Yes – edit the KPI Definition list | Yes | Fixed to the vendor’s metric set |
| Share with a link | Yes | File must be sent or synced | Yes, inside the platform |
| Year-1 cost at 5 users | $8.99 | $12.99 | Typically five figures |
| Month picker recalculates the whole pack | Yes | Yes | Date range filters |
| Who holds the raw numbers | You, in your own Drive | You, on your machine | The vendor |
| Collects the data for you | No – you type it in | No | Yes, it instruments the channels |
Who Should Use This Template
It suits an internal communications manager or a comms team of one to ten who already have the numbers scattered across three or four tools and need one monthly pack. It suits an HR or People & Culture lead who has to report engagement, comms satisfaction and eNPS to a leadership meeting. It suits a digital workplace lead proving adoption of a new intranet or channel. And it suits any organisation that would rather keep its own employee numbers in its own Drive than in a vendor’s platform.
It is the wrong tool if you expect it to gather data. It does not connect to Outlook, Gmail, SharePoint, Viva Engage, Slack or your intranet. It is also wrong if you need daily or per-message reporting, message-level drill-down, or far more than about 30 KPIs.
One honest note. This is a manual tracking and visualisation template over numbers you enter yourself. It is not an employment-law or HR-compliance system and makes no compliance guarantee. The Employee Engagement Score, Comms Satisfaction Score and eNPS rows are places to record whatever figure your own survey produced – they are not validated psychometric instruments, the template neither runs nor scores a survey, and no benchmark is implied. Every number in the screenshots is illustrative sample data.
Real-World Use Cases
The monthly leadership pack. On the first Tuesday, an internal comms manager at a 900-person insurer pastes last month’s open and click rates from the mail platform, intranet MAU and page views from analytics, and the pulse survey index. She sets Select Month, screenshots the KPI Dashboard and walks into the stand-up with it. When Town-Hall Attendance Rate is red she opens KPI Trend and shows whether it is a blip or a slide.
Proving a channel migration. A digital workplace lead rolling out a new intranet tracks Channel Adoption Rate and Intranet Monthly Active Users as the two board metrics, keeps a stretch number in KPI Input – Target, and uses the vs PY columns to show the steering group the gain over last year’s platform.
Splitting ownership across teams. A People & Culture lead owns four rows – engagement, comms satisfaction, eNPS and feedback response. Because Owner is stored per KPI, those four rows are visibly hers inside the same workbook the comms team uses, and she stops maintaining a separate deck.
Advantages of the Internal Communications KPI Dashboard
- Nothing to install or approve. Native formulas and built-in charts only. It runs on a free personal Google account.
- One place, one month, one truth. Everyone reads the same 14 rows for the same month instead of three different exports.
- Definitions travel with the numbers. The formula and the definition sit next to the KPI, so “open rate” means the same thing in January and in November.
- It bends to your programme. Swap the shipped KPIs for your own on one sheet; the rest of the workbook follows.
- Real collaboration. Share it like any Google Sheet – comms, HR and digital workplace can each own their input rows. Google’s own guide to sharing and permissions in Google Sheets covers restricting edit access to specific ranges if you need it.
- One-time cost. No per-seat licence, no renewal.
Opportunities for Improvement
Being straight about the limits: data entry is manual, and for a large organisation with many channels that is real monthly effort. There is no automatic import from mail platforms or intranet analytics. Reporting is monthly – there is no weekly or daily grain, and no per-campaign or per-message breakdown. The workbook is comfortable up to roughly 30 KPIs; well beyond that, the formula load starts to tell in a browser. And because everything is formula-driven, an overwritten formula in a calculated column is the one thing that can quietly break a page, which is why protecting the non-yellow ranges is worth ten minutes.
Best Practices
- Fix the definitions before the first month. Agree what Message Reach Rate counts, write it into the KPI Definition sheet, and stop re-litigating it later.
- Set targets for the whole year up front. A target invented after the actual is known is not a target.
- Enter the prior year once. The vs PY columns are what turn a number into a story, and they cost you one afternoon.
- Protect the calculated ranges. Leave only the yellow input cells unprotected.
- Read the Bottom 5 first. Open KPI Trend on each of them before drawing any conclusion from a single month.
- Keep one workbook per year. Copy the file each January, clear the actuals, and keep last year’s numbers as the PY input.
- Give each KPI a real owner. An unowned KPI is a number nobody fixes.
Explore Relevant Templates
- Diversity & Inclusion Dashboard in Google Sheets – the analytical companion for representation reporting.
- Corporate Governance KPI Dashboard in Google Sheets – the same scorecard build for board and policy metrics.
- Public Relations (PR) Dashboard in Google Sheets – the outward-facing half of the comms picture.
- Waste Reduction KPI Dashboard in Google Sheets – another scorecard from the same family.
- On the store: Conflict Resolution KPI Dashboard, Employee Benefits Utilization KPI Dashboard and Leadership Development KPI Dashboard, all in Google Sheets.
Frequently Asked Questions
Does it connect to Outlook, Gmail, Slack or my intranet?
No. It is a manual-entry template – you type or paste the monthly totals. That is deliberate: no admin consent, no API keys, no IT review before you can start using it.
Can I replace the 14 KPIs with my own?
Yes, and most buyers do. Edit the KPI Definition sheet; the dashboard, trend page, analysis page and all three input sheets follow automatically without any formula editing.
My financial year starts in April. Will that work?
Yes. Cell E3 on KPI Input – Actual holds the first month of the reporting year. Change it and every month column, the YTD roll-up and the prior-year comparison re-base.
What exactly do On Target, At Risk and Missed mean?
On Target is 100% achievement and above, At Risk is 95% to 99%, Missed is below 95%. Achievement is Actual over Target for UTB KPIs and Target over Actual for LTB ones. All three thresholds live in the Status formulas and can be changed.
Do I need an add-on, Apps Script or a paid Google Workspace plan?
No. Built-in Google Sheets formulas and charts only, and it works on a free personal account.
Is this the same as the Internal Communications KPI Dashboard in Excel or Power BI?
Same KPI thinking, different build for a different platform. If your team is on Microsoft, the Excel and Power BI versions cover the same ground.
How is it delivered?
As a PDF that carries the Make a copy link. Open it, click the link, and an editable copy of the workbook is created in your own Google Drive.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
Internal communications has never had a measurement problem so much as an assembly problem. The numbers exist; they just live in four places and arrive too late to act on. This template does the assembly once, in a tool your whole organisation already has, and then gets out of the way: one month dropdown, 14 rows, MTD and YTD, and two supporting pages that answer “is this a trend?” and “which group is dragging?” in about a minute each.Internal Communications KPI Dashboard in Google Sheets
Get the Internal Communications KPI Dashboard in Google Sheets for $8.99 (regular $13.99) – instant download, one-time payment, lifetime access.Internal Communications KPI Dashboard in Google Sheets
For walkthroughs of this and other Google Sheets templates, subscribe on YouTube: @NeoTechNavigators.Internal Communications KPI Dashboard in Google Sheets
