StretchLearn Course

Turn your Google data into a dashboard anyone can open by link

Connect GA4, Search Console, and Sheets in free Looker Studio, then add filters, blends, calculated fields, and live embeds.

Preview Curriculum Back to Catalog

Beginner9 hr 20 minSelf PacedRegistered

Course Overview

What this course is designed to develop

This course teaches anyone who lives in spreadsheets and Google Analytics to replace manual screenshot reports with a single Looker Studio dashboard that refreshes itself and that clients can open by link. You will connect the GA4, Search Console, and Google Sheets connectors, understand how a data source's fields, types, and aggregation drive every chart, and build scorecards, time-series, tables with heatmaps, bar and pie charts, and geo maps. You then add date-range controls, drop-down and input-box filters, filter controls scoped to specific charts, and report-level versus page-level filters; blend GA4 sessions with Sheets cost data on a join key to compute ROAS; write calculated fields using CASE, CONCAT, REGEXP_EXTRACT, and date functions; and finish by theming the report, setting viewer versus edit sharing, scheduling PDF email delivery, and embedding a live iframe. Each lesson works from concrete GA4 and Search Console data and flags the real traps: sampling, data freshness, blend left-join behavior, and the GA4 (other) row.

Learning Outcomes

What the learner should be able to understand, build, or execute.

Connect GA4, Google Search Console, and Google Sheets data sources and configure field types, aggregation, and data freshness

Build the core chart set including scorecards, time-series, tables with conditional formatting, bar, pie, and geo maps

Add date-range controls, drop-down list filters, and chart-scoped filter controls, and apply report-level versus page-level filters

Blend two data sources on a join key to combine GA4 sessions with Sheets ad-spend and compute metrics like ROAS and CPC

Create calculated fields using CASE, CONCAT, REGEXP_EXTRACT, and date functions to bucket, clean, and label dimensions

Theme, publish, share with viewer or edit access, schedule email delivery, and embed a live dashboard in a website

Curriculum Preview

Inside the curriculum: a structured path from fundamentals to execution.

Preview the course structure, see how the modules build on one another, and understand the path this program is designed to take you through.

Module 1

Module 1: Getting Started and Connecting Your Data

Learn what Looker Studio is, how reports and data sources differ, and connect GA4, Search Console, and Google Sheets so real numbers flow into your first charts.

3 lessons

What Looker Studio Is and the Report-vs-Data-Source ModelContent · 45 min

Preview Enabled

Connecting GA4 and Reading the Default TemplateContent · 50 min

LMS Access

Connecting Search Console and Google SheetsContent · 45 min

LMS Access

Module 2

Module 2: Building Charts and Laying Out the Dashboard

Turn your connected data into clear visuals: scorecards, time-series, tables, bar and pie charts, and geo maps, arranged into a clean, readable page.

3 lessons

Scorecards and Time-Series, the Backbone of a DashboardContent · 45 min

LMS Access

Tables, Bar Charts, Pie Charts, and Geo MapsContent · 50 min

LMS Access

Layout, Theme, and Reusable ComponentsContent · 40 min

LMS Access

Module 3

Module 3: Filters, Controls, and Interactivity

Make the dashboard interactive so viewers explore it themselves: date ranges, drop-downs, chart-scoped controls, and the rules of report-level versus page-level filters.

3 lessons

Date-Range and Drop-Down ControlsContent · 45 min

LMS Access

Filters: Report, Page, and Chart LevelContent · 50 min

LMS Access

Interaction Controls and Drill-DownContent · 40 min

LMS Access

Module 4

Module 4: Blending, Calculated Fields, and Sharing

Combine multiple sources with blends, compute new fields with formulas, then publish, schedule, and embed the finished dashboard.

3 lessons

Blending Data Sources on a Join KeyContent · 55 min

LMS Access

Calculated Fields with CASE, REGEXP, and Date FunctionsContent · 50 min

LMS Access

Publishing, Sharing, Scheduling, and EmbeddingContent · 45 min

LMS Access

Built for Application

A complete learning path, not a one-off inspiration hit.

This program is designed around progression: focused lessons, structured modules, applied resources, assessments, and a course rhythm that turns information into usable capability.

Looker StudioGA4Search ConsoleGoogle Sheetsdata blendingcalculated fieldsdashboardsmarketing analytics