← All articles

Ads & SEO

Looker Studio dashboard for small businesses: a free template walkthrough

Build a free one-page dashboard in Looker Studio (renamed Data Studio in 2026) with your leads, ad spend, website and search data, step by step from a template.

6 min read

A useful small-business dashboard in Looker Studio fits on one page and answers five questions: how many leads came in, where they came from, what they cost, how the website is doing and how people find you on Google. You can build it for free by starting from a template, connecting Google Analytics, Google Ads, Search Console and a Google Sheet for your leads, then arranging a row of scorecards, a trend chart and two tables. One thing first: in April 2026, Google renamed Looker Studio back to Data Studio. It's the same free tool, and everything below applies to it.

What changed with the name

Google's release notes from April 16, 2026 say: "We've rebranded Looker Studio as Data Studio," along with a new home page for reports and data sources. Existing reports kept working. If a tutorial, agency or colleague mentions Looker Studio, it's the same product. Google's documentation describes it as a no-cost tool that turns data into shareable, customizable dashboards and reports.

There's also a paid tier, Data Studio Pro, with team workspaces, organization-owned content and more delivery options. A small business rarely needs it to start.

Decide what goes on the page

Most dashboards fail because they show everything. Before you open the tool, write down the decisions you'll make with it. For a typical service business:

QuestionMetricSource
Are we getting enough leads?Leads this month vs last monthGoogle Sheet or CRM export, or GA4 key events
Which channels bring them?Leads by source (Google Ads, organic search, Maps, social, referral)GA4, Sheet
What do they cost?Ad spend, cost per leadGoogle Ads, plus the leads count
Is the website working?Sessions, key events, conversion rateGA4
How do people find us on Google?Clicks, impressions and top queriesSearch Console

If a number won't change a decision, leave it off.

The data sources

Data Studio's Google connectors include Google Analytics, Google Ads, Search Console, YouTube Analytics and Google Sheets, among others. There are also third-party community connectors for platforms such as other ad networks or CRMs; check each one's terms, since they're built and run by outside companies.

For a small business, four sources usually cover it:

  1. Google Analytics 4: sessions, traffic sources and the events you've marked as key events (form submissions, booking clicks, phone-button taps).
  2. Google Ads: cost, clicks and conversions by campaign.
  3. Search Console: search clicks, impressions and queries for your site.
  4. Google Sheets: the leads that analytics can't see, such as phone calls, walk-ins and jobs won. A simple sheet with date, source, service and status, filled from your CRM or by hand, makes the dashboard honest.

The walkthrough

Start from a template

Google keeps a Template Gallery in Data Studio. You can also turn any report you have view access to into a template by adding /preview to its URL. To use one:

  1. Open the template. You can click around it in view mode.
  2. Click Use my own data, then either replace the template's data source with one of yours or create a new one by choosing your account and property.
  3. If the template uses several data sources, replace each one.
  4. Click Edit and share to copy it into your own report so you can change it.

Google's documentation flags two caveats: its templates are only available in English (your data still appears in its own language), and if you only have view access to a data source in the template, a copy may show errors. Replacing every data source with your own avoids this.

If you'd rather build from scratch, the quick start guide is short: create a report, add data, add charts, switch to view mode, then share.

Lay out the page

A simple layout that works on a laptop screen, top to bottom:

Row 1: scorecards. Five boxes across the top: leads, cost per lead, ad spend, website sessions and conversion rate. Set each scorecard to compare with the previous period, so you see the change at a glance.

Row 2: trend. One time series chart showing leads per week over the last six to twelve months, ideally with ad spend as a second line. Seasonality jumps out immediately.

Row 3, left: leads by channel. A table or bar chart from your leads sheet: source, number of leads, jobs won.

Row 3, right: campaigns. A table from Google Ads: campaign, cost, clicks, conversions and cost per conversion, sorted by cost.

Row 4: search. A Search Console table with your top queries, clicks, impressions and average position, and a second one by page.

Top of page: controls. A date range control so you can switch between this month, last month and the last 90 days.

The chart types are all standard: scorecard, time series, table, bar and column, among more than a dozen others.

Add a cost-per-lead calculation

Cost per lead needs numbers from two sources: spend from Google Ads and leads from your sheet or GA4. Data Studio supports blended data, which joins sources on a shared field such as date. Blend your Ads data and your leads data by date, then create a calculated field that divides cost by leads. Keep the definition simple and write it down on the dashboard so everyone reads it the same way.

Keep labels in plain language

Rename fields to words the owner uses: "Leads" not "generatelead," "Calls from website" not "clickto_call." Add a short text box under each section explaining what it shows.

Share it safely

You can share a report like a Google Doc, with specific people as viewers or editors, or by link. Other options include a PDF download, a link that keeps the current filters and date range, and embedding the report in another page.

Before you share, understand data credentials. A data source using owner's credentials lets viewers see the data through your access, even if they have no access to the underlying account. Google's documentation advises making sure you trust the people you share with. With viewer's credentials, each person needs their own access to the data. For a dashboard shared with a business partner or an agency, owner's credentials are convenient; for anything sensitive, be deliberate about who gets the link.

Get it by email

You can schedule a report to be emailed as a PDF. On the free version:

  • the most frequent schedule is once a day;
  • each report can have one schedule;
  • you can include up to 50 recipient addresses;
  • individual accounts can send to 200 recipients a day and 800 a month (higher limits for Google Workspace accounts).

For most owners, a Monday-morning email with last week's numbers is enough. Pro adds hourly schedules, multiple schedules per report and delivery to Google Chat and Slack.

Common mistakes

  • Counting form fills as sales. Analytics sees form submissions, not jobs won. Add your sheet.
  • Ignoring phone calls. For many service businesses, calls are most of the leads. Track call-button taps in GA4 and log calls in the sheet.
  • Mixing date ranges. Make sure every chart follows the same date range control.
  • Too many pages. One page that gets read beats ten that don't.
  • No owner. Someone has to update the leads sheet weekly, or the dashboard drifts from reality.

When to get help

Building the dashboard is the easy part. The hard part is making the numbers trustworthy: GA4 key events set up correctly, Google Ads conversion tracking that matches, calls tracked, and a lead source recorded for every inquiry. If your scorecards don't match what you see in your CRM or your bank account, the tracking needs work before the dashboard does.

How PNE can help

Our analytics service audits your tracking, fixes what's missing and delivers a one-page dashboard connecting ads, website, search and CRM data, with a monthly review of what the numbers mean for the next decision.

Sources

Free tracking check

Not sure which marketing brings in clients?

Tell us what you track today. We’ll reply with what is missing.

Prefer to talk? Book a free 30-minute call or call (647) 388-2843.

Keep reading