You've got Google Analytics showing one number, your email platform showing another, and your bank account showing something completely different. You know you should be "tracking metrics," but right now you're just drowning in disconnected data with no clear picture of what's actually working.
Here's the truth: measurement stops being guesswork the moment you visualise your KPIs in one place. This isn't about building a complex, fully automated system with fancy integrations. It's about creating a simple, 1-page summary that tells you—at a glance—whether your marketing is moving in the right direction.
This step transforms scattered numbers into actionable intelligence. By the end of this guide, you'll have a functioning dashboard that tracks your 3-5 core metrics, shows you what's working, and guides every future marketing decision with actual data instead of gut feeling.
What You'll Have When Done:
A simple, 1-page Google Sheet dashboard tracking 3 core metrics against set goals
Time Needed: 45 minutes
Difficulty: Confident
Prerequisites:
Set Simple Marketing Goals You Can Track; Pick a Handful of Numbers That Matter
In This Guide:
---
Before You Start, Make Sure You Have:
This quick version gets you from zero to functioning dashboard in five minutes. You'll create a simple scorecard that shows your three most important numbers and whether you're hitting your targets.
Step 1: Create Your Sheet Structure
Open a new Google Sheet and create three tabs along the bottom: "Dashboard," "Data Input," and "Goals." The Dashboard is what you'll look at weekly. Data Input is where you'll paste numbers. Goals is your reference point.
Step 2: List Your Core Metrics
On the Dashboard tab, list your 3 core KPIs in column A. For most micro businesses, this is:
Step 3: Input Current Numbers and Goals
In column B, add this week's actual numbers for each metric. In column C, add your weekly goal for each (these come from the goals you set in Blueprint 1). In column D, calculate the percentage: `=B2/C2` (then format as percentage).
Step 4: Add Visual Indicators
Select column D. Go to Format → Conditional Formatting. Set up three rules:
Step 5: Bookmark and Schedule
Save the sheet with a clear name like "Marketing Dashboard 2025." Bookmark it in your browser. Set a recurring calendar reminder for the same time each week to update these three numbers.
[MEDIA:SCREENSHOT:google-sheet-simple-dashboard]
A clean, manual marketing dashboard example in Google Sheets, focusing on the Big 3 metrics.
Not sure you've covered the prerequisites like technical health, or if your basic tracking is set up correctly? NetNav runs a full website audit checking connectivity, speed, and tracking basics in 60 seconds, ensuring your underlying data is sound before you try to measure it.
✓ You've Created a Basic Dashboard If:
✅ Completed the quick version? Move on to Weekly Marketing Check-In (15-Minute Routine) or continue below for the detailed walkthrough with visualisations and trend tracking.
---
The quick start gives you a functional scorecard. This complete guide transforms it into a visual dashboard with trend charts, context, and the structure to support better decision-making as your business grows.
You have two realistic options for a free marketing dashboard:
Option A: Google Sheets (Recommended for Most)
Best for: Manual control, simplicity, and businesses just starting measurement. You'll update numbers weekly by copying and pasting from your various platforms. This sounds tedious, but it takes 5 minutes and forces you to actually look at your data.
Option B: Looker Studio (For the Confident)
Best for: Visual appeal and businesses with consistent GA4 data. Looker Studio (formerly Data Studio) can connect directly to Google Analytics, Search Console, and some other platforms to create automated visual reports. The setup is more complex, and troubleshooting connection issues can be frustrating.
For this guide, we're focusing on Google Sheets with visual enhancements. Automation is an optimisation, not a Core requirement. You can always upgrade later once you've proven the habit of weekly reviews.
Open your Google Sheet from the Quick Start (or create a new one with the three tabs: Dashboard, Data Input, Goals).
Your dashboard must fit on a single screen. This is non-negotiable. If you need to scroll to see your key metrics, you won't use it.
Structure your Dashboard tab around the three stages of your sales funnel:
Acquisition (Top of Funnel):
Conversion (Middle of Funnel):
Value (Bottom of Funnel):
[MEDIA:DIAGRAM:dashboard-big-3-layout]
Recommended Dashboard Layout: Focusing on Acquisition, Conversion, and Value Metrics.
Layout Template:
Keep it clean. Resist the urge to add every possible metric. You can always revisit your overall goals and adjust later, but complexity kills adoption.
This is where most people get stuck. You need a simple, repeatable process for getting numbers from various platforms into your dashboard.
Create a Data Collection Routine:
On your "Data Input" tab, create a simple table with these columns:
Each week, you'll add one new row with that week's data.
Where to Find Your Numbers:
Website Traffic: Log into Google Analytics 4 (if you've set up basic tracking). Go to Reports → Life Cycle → Acquisition → Traffic Acquisition. Look at "Total Users" for your date range (last 7 days). Copy that number.
New Leads: This depends on your lead capture method:
Sales/Revenue: Check your actual bank deposits, payment processor (Stripe, PayPal), or accounting software. This is the most important number—it's real money, not a proxy metric.
Manual Process (5 minutes weekly):
Connecting and extracting data from multiple sources (GA4, Search Console, your CRM) can be the biggest time sink. This is one of the administrative checks NetNav handles automatically, pulling key performance data from multiple sources to give you a consolidated view of your site's health without relying on manual entry.
[MEDIA:SCREENSHOT:looker-studio-connect-ga4]
Connecting Google Analytics 4 (GA4) as a data source to a free visualiser like Looker Studio.
Now transform your data into something you can understand at a glance.
Create Big Number Scorecards:
On your Dashboard tab, create three prominent cells showing this week's performance:
In cell B4, add a formula that pulls the latest week's traffic from your Data Input tab:
```
='Data Input'!B2
```
(Assuming B2 is your most recent traffic number)
Format this cell:
Repeat for Leads (cell D4) and Sales (cell F4).
Below each big number, add a smaller comparison showing last week's performance and the percentage change. This gives instant context: are things getting better or worse?
Create Trend Charts:
Select your Data Input range (last 12 weeks of data). Insert a line chart. Keep it simple:
Add a horizontal reference line showing your goal. In Google Sheets:
Format the chart:
Position these charts in rows 8-15 of your Dashboard tab, ensuring everything still fits on one screen at 100% zoom.
Pro Tip: Use sparklines for ultra-compact trend visualisation. In a cell next to your big number, add:
```
=SPARKLINE('Data Input'!B2:B13)
```
This creates a tiny line chart showing the trend without taking up much space.
Data without context is just numbers. Your dashboard needs to prompt action.
Add an Insights Section:
In rows 17-20, create a simple table:
This forces you to interpret the data, not just collect it. If traffic is down, your action might be "Publish 2 blog posts." If leads are up but sales are flat, your action might be "Follow up with last week's enquiries."
Set Up Alerts:
Use conditional formatting to make problems obvious:
You can also set up email alerts in Google Sheets (Tools → Notification Rules) to notify you if a cell value drops below a certain threshold. Use this sparingly—you don't want alert fatigue.
Document Your Process:
On a separate "Instructions" tab, write down:
This is essential if you ever delegate dashboard updates or if you're building this as part of documenting your processes.
✓ You've Built a Complete Dashboard If:
🎉 Completed? You now have the visibility required to measure ROI and make data-driven decisions. You're ready for Weekly Marketing Check-In (15-Minute Routine).
---
Common Problems and Fixes:
Problem: Data won't connect/sync automatically (especially if attempting Looker Studio/Data Studio).
Fix: Revert to the manual Google Sheets method. Automation is an optimisation, not a Core requirement. The 5 minutes you spend manually updating forces you to actually engage with your data, which is more valuable than automation at this stage. If you're determined to automate, focus on connecting just one source (GA4) first, get that working, then add others one at a time.
Problem: Overwhelming desire to track everything in one place.
Fix: Stick strictly to the 3-5 KPIs you defined in the previous step. The dashboard must fit on one screen to be useful. Every additional metric you add reduces the clarity of the important ones. Create a separate "Deep Dive" sheet if you want to track secondary metrics, but keep your main dashboard ruthlessly focused.
Problem: Not sure where to find the data (e.g., conversion numbers).
Fix: Review your lead flow map and focus on reporting from your CRM, email platform, or contact form notifications first. If you don't have conversion tracking set up in GA4 yet, use manual counts from your inbox or CRM. Perfect data is the enemy of useful data. Start with what you can easily access, even if it's not automated.
Additional Issues:
"My numbers don't match between platforms"
This is normal and expected. Google Analytics counts visitors differently than your email platform counts subscribers. Focus on trends within each platform rather than trying to reconcile exact numbers across platforms. As long as each individual metric is consistently measured, you can spot patterns.
"I don't have 12 weeks of historical data yet"
Start with what you have. Even 2-3 weeks of data is enough to begin the habit. Your dashboard will become more useful as you accumulate history. The important thing is starting the weekly update routine now.
"The dashboard looks ugly/unprofessional"
Good. This is a tool for you, not a presentation for clients. Function over form. A ugly dashboard you actually use beats a beautiful one you ignore. Polish it later if needed.
---
You've built the foundation for data-driven marketing decisions. Your dashboard gives you visibility, but visibility alone doesn't improve results. The next step is building the habit of actually using this dashboard to guide your actions.
Immediate Next Step:
Weekly Marketing Check-In (15-Minute Routine) — Implement a simple weekly habit to review your dashboard and make necessary adjustments. This is where measurement transforms into improvement.
---
Want to enhance your dashboard or explore more advanced measurement approaches?
Google Analytics 4 Dashboard for Beginners
For a complete breakdown of setting up visual reports directly within Google Analytics 4 without external tools. Useful if you want to leverage GA4's built-in dashboards instead of building your own.
Custom Dashboards with Google Sheets/Data Studio
Dive into advanced data blending and automation techniques using Looker Studio (formerly Data Studio). Covers API connections, calculated fields, and multi-source reporting for when you're ready to level up.
---
---
You've completed setting up your first measurement dashboard—that's a huge win that puts you ahead of 90% of micro businesses. NetNav can audit your entire site across 9 pillars in 60 seconds—see what else needs attention before your next weekly review.
Previous in sequence
Next in sequence
Other Start Here Guides:
Not sure where to start? Get a free audit of your current online presence and discover your biggest opportunities.
Run Your Free NetNav Audit Now →