Google Analytics KPI Dashboard in Google Sheets

The Google Analytics KPI Dashboard in Google Sheets is a formula-driven KPI scorecard that reports 15 web-analytics KPIs across four KPI groups on one screen. Pick a month from a single dropdown and every Month-to-Date and Year-to-Date figure, achievement percentage, traffic light and prior-year comparison recalculates – no add-on, no script, no refresh step. It ships as ten tabs with twelve months of MTD and YTD input columns already wired, and the download is a PDF that carries the sheet link, so your own copy is a minute away. Built and tested by NextGenTemplates, whose YouTube channels reach 300K+ subscribers. Instant download, lifetime access, free minor updates.

Independent template – please read this first. This product is not affiliated with, endorsed by, or connected to Google. It does not connect to, import from, sync with, or authenticate against Google Analytics, GA4, Looker Studio or any Google API, and it installs nothing in your analytics account. It is a reporting spreadsheet: you type or paste your own monthly numbers into three input sheets and the scorecard calculates from those. Every KPI name, target, threshold and figure in the screenshots is demo data, supplied only so the template is not empty on first open. No claim is made that any metric here matches a GA4 metric definition.

Key Features of the Google Analytics KPI Dashboard in Google Sheets

• 15 KPIs in four groups – Audience & Traffic (4), Engagement (4), Acquisition (2) and Conversion & Revenue (5), all listed on one master sheet.
• One month picker drives everything – the Select Month dropdown on the KPI Dashboard sets the reporting month for the scorecard and the KPI Analysis page.
• MTD and YTD side by side – each KPI shows Actual, Target, Achievement %, Status and Prior Year for both windows, plus a vs PY percentage.
• Traffic lights with editable thresholds – On Target from 100%, At Risk 95% to 99%, Missed below 95%. The bands are plain formulas on the dashboard sheet, so you can change them.
• Upper-the-better and lower-the-better handling – mark a KPI UTB or LTB and achievement flips automatically, so beating a cost or bounce-rate target scores above 100%.
• A KPI Trend page per metric – choose any KPI and see twelve months of MTD and YTD actual, target and prior year, with two charts.
• A KPI Analysis page – group roll-up with counts of On Target, At Risk and Missed, plus ranked top-five and bottom-five tables.
• Driven by a master list – add, rename or delete a KPI on the KPI Definition sheet and every other sheet follows it. No formula editing.
• Nothing to install – native Google Sheets formulas only. No Apps Script, no add-on, no connector, no API key.

What’s Inside the Google Analytics KPI Dashboard in Google Sheets

Ten tabs: a Home navigator, three dashboard pages, three input sheets, a KPI Definition master list, a Read Me and a Get More Templates page.

Home

A cover sheet with three stat cards (15 KPIs, MTD + YTD, 100% formula-driven) and a link panel for every sheet in the file, grouped into Dashboard Pages, Input Sheets and Reference & Help. A three-step start guide sits underneath: enter your data, pick a month, read the scorecard.

KPI Dashboard

The scorecard. Seven summary cards across the top – Total KPIs Tracked, On Target (YTD), At Risk (YTD), Missed (YTD), Improving vs PY (MTD), Avg Achievement (MTD) and Avg Achievement (YTD) – then one row per KPI with its group, unit and type, a Month to Date block and a Year to Date block. In the demo month shown, 7 KPIs are On Target, 5 At Risk and 3 Missed on a YTD basis.

KPI Trend

Pick one KPI from a dropdown and the page rebuilds around it, showing its group, unit, type, owner, priority, frequency, formula and definition, then twelve months of MTD and YTD actual, target, prior year, achievement and status. Two charts follow: MTD Trend for Sessions and YTD Trend for Sessions, each plotting actual columns against target and prior-year lines (the titles change with the KPI you select).

KPI Analysis

A roll-up of the month selected on the dashboard. Performance by KPI Group counts how many KPIs in each group are On Target, At Risk or Missed and averages their MTD and YTD achievement; the Average YTD Achievement by KPI Group bar chart shows the same figures. Ranked Top 5 and Bottom 5 tables sit alongside, and a How to Read This Page box explains where the groups, the ranking and the thresholds come from.

KPI Input – Actual, Target and PY

Three identically shaped entry sheets – this year’s actual, this year’s target, last year’s actual. Each holds one row per KPI and a pair of MTD and YTD columns for all twelve months, with the entry cells shaded yellow. One cell sets the first month of your reporting year, so a July-to-June year re-bases the whole workbook without touching a formula.

KPI Definition

The master list every other sheet reads: KPI number, group, name, unit, formula, definition, type (UTB or LTB), owner, priority and frequency. Edit a name here and it changes everywhere; add a group and it appears on the Analysis page by itself.

Google Analytics KPI Dashboard in Google Sheets vs. an Excel KPI Workbook vs. Paid Marketing Analytics SaaS – Where This Fits

The honest summary: a paid platform pulls your data automatically and this does not. What this gives you instead is a fixed, board-ready scorecard you own outright, whose thresholds, KPI list and owners you control, and that costs nothing to run each month.

Who This Template Is For – and Who It’s Not For

It is for marketing managers who report a monthly web-performance pack to a leadership team; agency account managers reporting the same KPI set for several clients; in-house SEO and ecommerce leads who already export their monthly figures and want a consistent place to put them; and small teams who want targets, prior-year comparison and traffic lights without paying for a reporting platform.

It is not for anyone who wants a live feed from an analytics account – there is no connection, no OAuth and no scheduled refresh. It is not a session-level or event-level analysis tool: it works on monthly totals you supply, not raw hit data. It will not attribute conversions, de-duplicate users across devices, or reconcile your figures with any platform’s reporting. And it is not an audit or assurance product – the numbers on the scorecard are the numbers you type.

How to Use the Google Analytics KPI Dashboard in Google Sheets

1. Make your copy. Open the PDF in your download, click the sheet link, then choose File > Make a copy. The shared sheet is view-only, so your copy is private to your Drive.
2. Set your KPI list. On KPI Definition, keep the 15 supplied KPIs or replace them with your own – name, group, unit, formula, definition, type, owner, priority, frequency.
3. Set the start of your reporting year on the KPI Input – Actual sheet, then enter your monthly actuals. Repeat on KPI Input – Target and KPI Input – PY.
4. Pick a month from the dropdown on the KPI Dashboard. The scorecard and the KPI Analysis page both follow it.
5. Adjust the thresholds in the Status formulas if 100 / 95 / 95 are not your bands.
6. Drill into any KPI on the KPI Trend page to see its twelve-month shape against target and prior year.

Real-World Use Cases

Priya, marketing manager at a 40-person ecommerce brand. On the first working day of each month she pastes her exported totals into the three input sheets, sets the month picker, and screenshots the scorecard for the leadership deck. Conversion Rate and Revenue per Session sitting in the Bottom 5 is the slide that starts the meeting.

Daniel, account director at a small agency. He keeps one copy per client with the same 15 KPIs, so every monthly report reads identically and a client who moves between account managers sees no change in format.

Aisha, in-house SEO lead. She only cares about the Acquisition and Engagement groups, so she deletes the rest on KPI Definition; the dashboard, trend and analysis pages shrink to her six KPIs without a single formula change.

Frequently Asked Questions

Does this connect to my Google Analytics account?

No. It does not connect to, import from, sync with or authenticate against Google Analytics, GA4, Looker Studio or any Google API. There is no OAuth step, no connector and no scheduled refresh. You enter your own monthly numbers on the three KPI Input sheets. The template is independent and is not affiliated with, endorsed by or connected to Google.

Are the KPI definitions the same as GA4’s?

They are our own plain-English definitions, written on the KPI Definition sheet so you can read and change them. No parity with any platform’s metric definitions is claimed, and you should reconcile against whatever source you export from before you report the numbers.

Are the targets and figures in the screenshots real benchmarks?

No. Every number, target and threshold shown is demo data, placed there so the file is not empty on first open. Replace all of it with your own. Nothing in this template is a benchmark or a recommendation about what your figures should be.

Can I change the KPIs, the groups and the traffic-light bands?

Yes. The KPI list and its groups live on the KPI Definition sheet and every other sheet follows it. The 100% / 95% / below-95% bands are ordinary formulas in the Status columns on the KPI Dashboard – edit them to your own policy.

Does my financial year have to start in January?

No. One cell on the KPI Input – Actual sheet sets the first month of the reporting year, and the whole workbook re-bases from it.

What exactly do I download?

A PDF. It contains the link to the Google Sheets template plus a short setup guide. Open the link and use File > Make a copy – the copy is yours to edit, share and keep.

Is this the same as your analytical Google Sheets dashboards?

No. This is a KPI scorecard: a month picker, targets, achievement percentages, traffic lights and a twelve-month trend per KPI. The analytical dashboards in our Google Sheets range slice a transaction table with slicers and charts instead. Many customers keep one of each.

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.

Explore Related Templates

• Google Analytics KPI Dashboard in Power BI – the same scorecard idea rebuilt as a Power BI report.
• Website Traffic KPI Dashboard in Google Sheets – a traffic-weighted KPI set on the same scorecard pattern.
• SEO Content Performance KPI Dashboard in Google Sheets – for teams reporting on content and organic search.
• Marketing KPI Scorecard in Google Sheets – the wider marketing view, above channel level.
• Web Development KPI Dashboard in Google Sheets – the build-side companion to this reporting-side scorecard.
• Browse the whole Google Sheets KPI Dashboard range, or every Google Sheets template we publish.

Full walkthrough on the blog: Google Analytics KPI Dashboard in Google Sheets.

Add it to your cart, open the PDF, make your copy and you can have your own month on the scorecard today. Instant download, lifetime access, free minor updates.

Watch the step-by-step video Demo:

Last updated: 17 August 2026.