Loading tutorials…
Loading tutorials…
Looker Studio is free and surprisingly powerful — but the first report is where most owners stall. This is the walk-through that gets you from blank canvas to a shareable dashboard without making the rookie structure mistakes you'll regret later.
Who this is forOwners or marketers who need a reporting layer over GA4, Google Ads, Search Console, or Sheets and haven't built one yet. If you're rebuilding the same spreadsheet every Monday, a Looker Studio dashboard pays for itself in the first month.
What you'll need
Step 1
Go to lookerstudio.google.com, sign in with the Google account that owns (or has access to) your data sources, and accept the country + ToS prompt.
Open lookerstudio.google.com in a fresh tab. Click Use it for free if you see the marketing landing page.
Sign in with the Google account that already has access to your GA4 property, Google Ads account, or Sheets. Using a different account is the #1 reason connectors fail on step 3.
On first login you'll see a "Welcome to Looker Studio" modal. Pick the country closest to your operating region and accept the Terms of Service. This setting drives default locale and currency in reports.
You'll land on the Home view with three top tabs: Reports, Data Sources, Explorer. Reports is where dashboards live, Data Sources is where connections live. You'll bounce between both for the rest of this tutorial.
Bookmark lookerstudio.google.com — there's no native desktop app and the URL is forgettable.
Step 2
From the Home → Data Sources tab, click Create → Data Source, pick a connector (GA4, Google Ads, Search Console, Sheets), and authorize access.
Click the + Create button (top-left) → Data source. You'll land on the connector gallery. Google maintains 24 native (free) connectors plus 700+ Partner connectors (most are paid).
For most marketing stacks, the four you care about are: Google Analytics, Google Ads, Search Console, Google Sheets. All four are native, free, and supported indefinitely.
Pick Google Analytics. Authorize access if prompted (this grants Looker Studio read-only access to your GA properties). Pick the GA4 account → property → web data stream.
Click Connect (top-right). You'll see the field list — every dimension and metric GA4 exposes. Don't edit anything yet. Click Create Report (top-right).
Looker Studio will create a new report with your GA4 source already attached and drop you into the edit canvas. Save the data source name as something obvious like "GA4 — Acme.com" so it's findable later.
Step 3
In the report canvas, add a text box for the title, then drop in a scorecard for Users and a time-series chart for Sessions over the last 28 days.
Top of the canvas — click Insert → Text. Type your report name (e.g., "Acme — Weekly Performance"). Set font size to 24px, bold, left-align. This becomes the H1 of every shareable PDF export.
Click Insert → Date range control. Drop it under the title. In the right-side panel, set Default date range to Last 28 days. This control will scope every chart on the page.
Click Insert → Scorecard. Drop it under the date range. In the right panel, set Metric to Total users. The number that appears is your last-28-day user count from GA4 — your first real data point.
Click Insert → Time series chart. Drop it next to the scorecard. Set Dimension to Date, Metric to Sessions. You've just built a 28-day sessions trendline with three clicks.
Click View (top-right) to see the report as a reader would. Click Edit to return. View mode is what you'll share — Edit mode is for builders only.
Step 4
Pages live in the left rail. Add a new page, drop in a table with Source/Medium and Sessions, and sort by Sessions descending.
In the edit canvas, look at the left rail. You'll see Page 1. Click + to add Page 2. Rename Page 1 to "Overview" and Page 2 to "Traffic Sources" by double-clicking the names.
On the Traffic Sources page, click Insert → Table. Drop it in. Set Dimension to Session source / medium, Metric to Sessions.
In the right panel → Style tab, enable Show summary row and Wrap text. In the Data tab, set Sort to Sessions descending.
Add a Date range control on this page too — controls don't carry across pages by default unless you make them report-level (Page → Make report-level).
Save (Looker Studio auto-saves, but Ctrl+S forces a checkpoint). You now have a 2-page report with a top-level view and a drill-down — the bare minimum for a useful dashboard.
Step 5
Click Share (top-right). Add viewers by email or grab a link. Set viewer permissions carefully — link sharing defaults are surprisingly open.
Click Share (top-right). You'll see a familiar Google Drive-style modal. Add specific email addresses to grant Viewer or Editor access — this is the recommended path for sensitive data.
For wider sharing, click Get link → change "Restricted" to "Anyone with the link" → role: Viewer. Anyone with the URL can now read the report but not edit.
WARNING: Anyone-with-link sharing means the report will appear in Google's search index if linked anywhere public. For client data, always use email-based sharing.
For PDF exports, click File → Download → PDF. The current page is exported by default; tick "All pages" for a full report PDF.
For scheduled email delivery, click File → Schedule email delivery. Pick recipients, frequency, and pages. This is the killer feature — set it once and weekly reports run themselves.
Step 6
Decide whether the data source uses Owner's or Viewer's credentials. Most marketing dashboards should use Owner's. Configure refresh frequency to balance freshness and load.
Open the data source (Resource → Manage added data sources → click your source). Look at the Credentials field. "Owner's credentials" means everyone sees the data through your access. "Viewer's credentials" means each viewer needs their own access to the underlying source.
For most marketing dashboards (one owner, many readers), use Owner's. For BI dashboards where row-level security matters, use Viewer's.
Set Data freshness in the same panel. GA4 sources default to 12-hour refresh; you can drop to 1-hour for free, or 15-minute for paid Looker Studio Pro. Faster refresh costs API quota — don't lower it without reason.
For Google Ads sources, the default is also 12 hours. This is usually fine — ad data updates only every 3 hours from Google's end anyway.
Save the data source. Refresh frequency settings apply to the source, not individual reports — so all reports using this source share the same refresh cadence.
Step 7
Reconcile the dashboard numbers against the source-of-truth UI (GA4 or Google Ads native reports) on at least 3 metrics before declaring the report ready.
Open GA4 → Reports → Acquisition → User acquisition. Note the Last 28 days Users count.
Open your new Looker Studio report → Overview page. The Total users scorecard should match GA4 within 1-2% (some discrepancy is normal due to sampling).
Repeat with Sessions and one source/medium row (e.g., google / cpc). Reconcile within 2%.
If numbers are off by more than 5%, the most common causes: wrong data stream selected, sampling kicked in (Looker Studio shows a yellow shield icon), or a hidden filter on the report.
Don't share a report you haven't reconciled. Stakeholders will spot mismatches in week 2 and trust in the dashboard evaporates — exactly when you need them to act on the data.
Common mistakes
Building from a blank canvas instead of a template
What goes wrong: You spend 8 hours laying out tiles, picking colors, and writing labels — work that's already been solved by Google's template gallery. Your first dashboard ships 2 weeks later than it should, costing $1,500-3,000 in opportunity time.
How to avoid: Start from the template gallery (Home → Template Gallery). Pick "GA4 Acquisition Report" or "Google Ads Overview" as your base. Replace the demo data source with yours in 2 clicks. You'll save 6+ hours.
Using embedded data sources instead of reusable ones
What goes wrong: You build 4 dashboards over 3 months, each with its own embedded GA4 source. When the property ID changes (migration, account restructure), you re-authenticate 4 separate sources and fix 4 reports manually. Easily 4-6 hours of avoidable rework.
How to avoid: Always create data sources from Home → Data Sources first. Then add them to reports via Add data → My data sources. One source, many reports.
Setting "Anyone with link" on client dashboards
What goes wrong: Client data ends up indexed by Google, scraped by aggregators, or surfaced in someone's email forward. A real estate firm had cap table data leaked this way in 2024 — the fallout was a $40K+ remediation engagement.
How to avoid: For any report containing client data, revenue, or PII, use email-based sharing only. Audit existing reports: Share → check if "Anyone with link" is set. Switch to Restricted.
Skipping the validation step
What goes wrong: You ship a dashboard whose Sessions number is 18% lower than GA4 says (because of an unfiltered internal-traffic filter). The CMO makes a budget decision on the bad number. The credibility cost compounds.
How to avoid: Reconcile 3 metrics against the source-of-truth UI before sharing. Document the comparison in a "Methodology" page in the report. Repeat quarterly.
Cramming too many tiles on one page
What goes wrong: A 14-tile dashboard takes 4-6 seconds longer to load than a focused 6-tile one. Viewers stop opening it after week 3. The dashboard becomes shelf-ware. The cost of unread reporting is the worst kind of waste — you can't even measure it.
How to avoid: One question per page. If a page tries to answer "How are we doing overall AND which channels work AND which pages convert," split into three pages with clear titles.
Recap
Done — what's next
How to connect Looker Studio to GA4 without the rookie mistakes
Read the next tutorial
Hand it off
Building one report is a project. Owning the reporting layer for a business is a job. Specialists build the dashboards, maintain the data sources, and audit the numbers quarterly. From $14-16/hr — most ongoing reporting engagements land between $300-800/mo depending on dashboard count and refresh complexity.
See specialist rates
Looker Studio (the dashboard tool you're using here) is permanently free with all native connectors. Looker Studio Pro ($9/user/month) adds team workspaces, scheduled delivery to BigQuery, mobile access, and faster refresh — most small teams don't need it. Start free and upgrade only when you hit a specific limitation.
First version in 2-3 hours. Reconciled and trustworthy in another 2-3 hours. A polished, multi-page executive dashboard typically takes 8-12 hours of focused work — or one afternoon for a specialist who has built dozens.
Yes — Looker Studio connects to 24 native sources (Sheets, Ads, Search Console, BigQuery, MySQL, and more) plus 700+ partner connectors. You don't need GA4 to use it. Many ecommerce teams build dashboards from Google Ads + Sheets exports without ever touching GA4.
Sampling, threshold filtering (GA4 hides small numbers for privacy), and slightly different default date ranges are the usual culprits. Look for the yellow shield icon on charts — that signals sampling. For exact-match reporting, lower the date range or use BigQuery export.
Yes — Share → Embed report → copy iframe code. Permissions still apply: viewers need access to the report or the report must be set to 'Anyone with link.' For public-facing embeds, never include data that's sensitive in aggregate.
Looker Studio
The native GA4 connector looks like three clicks — but the choices you make in those clicks lock in sampling, scope, and refresh patterns for the life of the report. Here's the right way to wire it up.
Looker Studio
Connecting Google Ads to Looker Studio is two clicks. Connecting it *correctly* — with the right scope, the right conversions, and a layout that survives a board meeting — is what this tutorial does.
Looker Studio
The Looker Studio template gallery saves you 6+ hours per dashboard. A custom brand theme adds another 2 hours of consistency. Combined, they turn 'every dashboard is a snowflake' into 'every dashboard launches in 30 minutes.'
Looker Studio
DIY Looker Studio is a great idea — until it isn't. This is the honest framework: when the cost of self-managing exceeds the cost of hiring, and how to tell which side you're on.