Looker Studio Dashboard Tutorial

Looker Studio is Google's tool for turning data into shareable reports and dashboards. It connects to sources such as GA4, Google Ads, Search Console and Google Sheets, and lets you build charts by dragging fields onto a page. The report refreshes from the data source, so the team always sees current numbers without copying anything.

• Connectors: Built-in links to Google products and to many other sources through partner connectors.
• Charts: Scorecards, time series, tables, bar charts, maps and more, each placed where you want it on the page.
• Controls: Date range pickers and drop-down filters that let viewers change what they see.
• Calculated fields: Your own formulas, such as cost per booking, built from the fields in a data source.
• Sharing: Share a report like a Google Doc, or schedule it to arrive by email.

This Looker Studio tutorial follows one example: a dental clinic in Chennai with two branches. Patients book appointments through a website form, and the clinic runs Google search ads for "dental clinic near me" and posts on Instagram. The doctors want one page every Monday showing visits, bookings and cost per booking by source, without logging into three tools.

Right now the clinic manager copies numbers from GA4 and Google Ads into a spreadsheet each week, which takes time and often goes wrong when a number is copied from the wrong date range. A Looker Studio dashboard replaces that routine with a single link that always shows the latest data, so the Monday meeting can start with decisions instead of arguments about whose numbers are right.

Prerequisites for Looker Studio

• A Google account: Use the clinic's shared business account, so the report does not disappear when one staff member leaves.
• Access to the data: At least viewer access to GA4 and Google Ads, and edit access to any Google Sheet you will use.
• Clean tracking: The booking form sends a key event, set up as in GA4 events and conversions, and campaign links carry UTM parameters.
• Agreed metrics: Decide on the four or five numbers that matter before you build, using the digital marketing KPIs lesson as a guide.

Setup: Create a Report and Add Data

1. Go to lookerstudio.google.com and select Blank report.
2. Add data: Choose the Google Analytics connector, pick the clinic's account and GA4 property, and select Add.
3. More sources: Use Add data again for Google Ads and for a Google Sheets file that holds monthly offline costs, such as a newspaper ad.
4. Name the report: Call it "Clinic bookings report", so that anyone on the team can find it later in the list of reports.

Step-by-Step: Build the Clinic Dashboard

Step 1: Plan the Page

Sketch the layout on paper first. The clinic's page has four rows: a header with a date control, three scorecards, a trend chart, and a table by source. Keep one page to one question: "Where do our bookings come from, and what do they cost?"

People read a dashboard from the top left, so put the most important number there and the detail lower down. If a second question comes up later, such as which treatments people search for, give it its own page instead of squeezing more charts onto the first one.

Step 2: Add a Date Range Control

Select Add a control > Date range control and place it top right, then set its default period to the last 28 days. Every chart on the page follows this control, so viewers can change the period themselves.

Step 3: Add Scorecards

Add three scorecards from the chart menu:

• Sessions: Taken from GA4, to show how many visits the site received in the period.
• Bookings: Taken from GA4, using the key event count for the booking event.
• Cost per booking: Added in Step 6, because it needs cost from Google Ads and bookings from GA4 in the same chart.

In the setup panel, set the comparison date range to the previous period, so each scorecard shows how much the number changed since the last period.

Step 4: Add a Time Series

Add a Time series chart with Date as the dimension (set to week) and bookings as the metric. This shows whether bookings are rising or falling, and when a campaign started working. Weekly points are easier to read than daily ones for a small clinic, because a single quiet day, such as a public holiday, can make a daily line look like a sudden drop.

Step 5: Add a Table by Source

Add a Table with Session source / medium as the dimension and sessions and bookings as metrics. Sort by bookings. Because the clinic's links use UTM parameters, Instagram and WhatsApp appear as separate rows instead of hiding in direct traffic.

Step 6: Create a Calculated Field with Blended Data

Cost lives in Google Ads and bookings live in GA4. To combine them:

1. Select a chart, then Blend data in the setup panel.
2. Join Google Ads and GA4 on Date and Campaign, which only works when the campaign names match exactly in both sources.
3. Add a calculated field named "Cost per booking":

Cost / Bookings

Use the new field in the third scorecard, and if the join returns empty values, check that the campaign names are spelled the same way in both sources.

Step 7: Add a Branch Filter

Add a Drop-down list control on a page path or a custom dimension that holds the branch name, so that doctors at each branch can pick their own clinic and see only their own numbers.

Step 8: Style and Share

• Keep it plain: Use the clinic's colours for headers only, and one colour for all charts, so the numbers stand out more than the design.
• Share: Select Share, add the doctors' emails with view access, and set data credentials so viewers see the data.
• Schedule: Use Schedule delivery to email the report every Monday morning.

Common Mistakes in Looker Studio

• Too many charts: Twenty charts on one page load slowly and answer nothing, so start with five and add more only when someone asks a question the page cannot answer.
• Quota errors: Many live GA4 charts can hit the connector's limits, so reuse one data source across charts and consider extracting the data.
• Mismatched names: A blend fails silently when a campaign called "Chennai_Dental" in Google Ads appears as "chennai dental" in GA4, so agree on one spelling.
• Mixing definitions: GA4 users and Ads clicks are not the same thing, so label every scorecard clearly with what it counts and where it comes from.
• Patient data: Never connect a sheet with patient names, phone numbers or treatments to a shared marketing dashboard, because totals are all a marketing report needs.

Next Steps

• Bigger data: When reports get slow or you need raw events, read from BigQuery with the GA4 BigQuery export.
• Automation: Send a written summary with the dashboard using automated marketing reports with AI.
• Deeper analysis: Ask better questions of the numbers with analyze marketing data with AI.

How AI Changes Looker Studio Reporting

What AI Automates Now

AI assistants can suggest a dashboard layout from a list of goals, write calculated field formulas, and explain a chart's trend in plain words. Google has been adding Gemini features to Looker Studio Pro for building charts and summaries from plain-language requests.

What Still Needs a Human

Choosing which numbers matter, and what the doctors should do when a number moves, is human work. A person must also check that each metric means what its label says, because a chart labelled bookings that actually counts form starts will mislead everyone who reads it.

Risk to Watch

AI-written summaries can describe a change as a success when it is really a tracking fault, such as a form that stopped sending bookings or a tag that fired twice, so always check a big change against the raw source before reporting it.

Do It with AI

Use this prompt to plan a dashboard before you build it. It works in ChatGPT, Claude or Gemini.

1. Fill in your business, audience and sources.
2. Sketch the suggested layout and cut any chart that does not answer the main question.
3. Build the report and compare each scorecard with the number in GA4 or Google Ads.
4. Share it and ask the viewers what they still cannot answer.

Check Before You Use It

• Facts: Every number on the dashboard must match its source tool for the same date range.
• Brand fit: Use plain labels the doctors use, such as "bookings", not technical field names.
• Compliance: Keep patient and personal data out of reports, in line with the DPDP Act.