Marketing reporting
Google Sheets Dashboard Templates: 4 Copyable Layouts
Copy four Google Sheets dashboard templates for executive, marketing, sales, and project reporting, with formulas, setup steps, and chart guidance.
A Google Sheets dashboard should turn a stable source table into a small set of decisions. The four layouts below are designed to be copied into a workbook without add-ons: an executive scorecard, a marketing performance dashboard, a sales pipeline dashboard, and a project operations dashboard.
Use one workbook per reporting audience and keep raw records separate from summary formulas. A useful dashboard answers three questions quickly: what changed, whether the result is on target, and who owns the next action.
Start with a four-tab workbook
| Tab | Purpose | Recommended grain |
|---|---|---|
| Raw Data | Imported or manually entered source records | One event, campaign, opportunity, or task per row |
| Definitions | KPI formula, owner, source, direction, and refresh cadence | One KPI per row |
| Summary | Current value, target, comparison, variance, and status | One KPI per row |
| Dashboard | Cards, tables, charts, notes, and next actions | One reporting period per view |
Google Sheets formulas for a reusable dashboard
Variance when higher is better:
=IFERROR((B2-C2)/C2,0)
Status with direction in D2:
=IF(D2="Higher",IF(B2>=C2,"On track","Below target"),IF(B2<=C2,"On track","Above limit"))
Current-month total from dated rows:
=SUMIFS('Raw Data'!C:C,'Raw Data'!A:A,">="&EOMONTH(TODAY(),-1)+1,'Raw Data'!A:A,"<="&EOMONTH(TODAY(),0))
Seven-row moving average ending at B8:
=IFERROR(AVERAGE(INDEX(B:B,MAX(2,ROW()-6)):B8),"")These examples use commas as formula separators. Some spreadsheet locales use semicolons. Test the formulas with a zero target, an empty period, and one lower-is-better KPI before copying them down the sheet.
1. Executive dashboard template
| KPI | Current | Target | Prior period | Variance | Owner |
|---|---|---|---|---|---|
| Revenue | [value] | [value] | [value] | [%] | [name] |
| Gross margin | [%] | [%] | [%] | [points] | [name] |
| Qualified pipeline | [value] | [value] | [value] | [%] | [name] |
| Customer acquisition cost | [value] | [value] | [value] | [%] | [name] |
| Net revenue retention | [%] | [%] | [%] | [points] | [name] |
| Cash runway | [months] | [months] | [months] | [change] | [name] |
2. Marketing dashboard template
| Channel | Spend | Impressions | Clicks | Qualified leads | Revenue | CAC |
|---|---|---|---|---|---|---|
| Google Ads | [value] | [count] | [count] | [count] | [value] | [value] |
| Meta Ads | [value] | [count] | [count] | [count] | [value] | [value] |
| Organic search | $0 media | [count] | [count] | [count] | [value] | [value] |
| Referral | $0 media | [count] | [count] | [count] | [value] | [value] |
3. Sales pipeline dashboard template
| Period | Owner | Pipeline created | Bookings | Win rate | Median sales cycle | Forecast variance |
|---|---|---|---|---|---|---|
| [month] | [rep or team] | [value] | [value] | [%] | [days] | [%] |
| [month] | [rep or team] | [value] | [value] | [%] | [days] | [%] |
4. Project operations dashboard template
| Workstream | Completed | In progress | Blocked | Cycle time | On-time rate | Owner |
|---|---|---|---|---|---|---|
| Customer onboarding | [count] | [count] | [count] | [days] | [%] | [name] |
| Campaign launches | [count] | [count] | [count] | [days] | [%] | [name] |
| Support requests | [count] | [count] | [count] | [hours] | [%] | [name] |
How to build the dashboard in Google Sheets
- Create the four tabs and freeze the header row on every data table.
- Put one record per Raw Data row and one field per column; avoid merged cells in source tables.
- Add data validation for repeated fields such as Channel, Owner, Status, and Direction.
- Record each KPI's formula, source, owner, refresh cadence, and higher-or-lower direction on Definitions.
- Calculate current, target, prior period, variance, and status on Summary before building the presentation layer.
- Use named ranges only when they make formulas easier to audit; document every named range on Definitions.
- Protect formula ranges and leave input cells visibly distinct before sharing the workbook.
Choose charts that answer a question
- Use scorecards for a current value that must be compared with a target.
- Use line charts for time trends with consistent intervals.
- Use bar charts for comparisons across channels, teams, or categories.
- Use stacked bars only when both the total and its composition matter.
- Avoid gauges, 3D charts, and repeated charts that show the same number without adding context.
Make sharing and refreshes safe
- Share the dashboard as Viewer by default and grant Editor access only to data owners.
- Protect summary formulas and chart source ranges from accidental edits.
- Add a visible Last refreshed timestamp and name the person or process responsible for updates.
- Keep sensitive customer or employee fields out of presentation tabs and restrict the source workbook when necessary.
- Archive a period-end copy when the dashboard is also used as an audit record.
Refresh marketing metrics from source systems
A dashboard is only as reliable as its refresh process. NotFair lets an AI client inspect live Google Ads, Meta Ads, Search Console, and Analytics data, explain period changes, and draft reporting rows from chat. Keep the spreadsheet definitions as the reporting contract and the connected platforms as the source of record.
Dashboard mistakes to avoid
- Mixing raw records, formulas, and presentation cells on one tab.
- Changing KPI definitions between periods without documenting the change.
- Comparing periods of different lengths without normalization.
- Showing a rate without its numerator and denominator.
- Treating every increase as positive, including cost, error rate, and response time.
- Using manually typed totals when the source rows can calculate them.
FAQ
Move from article to live account work
Connect your account first, then use an MCP client to turn the article workflow into a reviewed account action.