Last updated: March 2026 | Reading time: 10 minutes
Looker Studio (formerly Google Data Studio) is the default dashboard tool for marketing teams that live in the Google ecosystem. It’s free, it connects natively to Google Analytics, Google Ads, Search Console, and YouTube, and it produces shareable reports that look decent out of the box.
But “free” doesn’t mean “easy.” Setting up a marketing KPI dashboard in Looker Studio still involves data source configuration, metric calculations, chart layout, and troubleshooting connector quirks. This guide walks through the complete process of building a marketing KPI dashboard in Looker Studio — then shows you a faster path if you want the same insights without the manual work.
The Marketing KPIs You Should Track
Before building anything, nail down which metrics actually matter. Here’s what a solid marketing dashboard covers:
Acquisition KPIs:
– Website sessions / unique visitors
– Traffic by source (organic, paid, social, direct, referral)
– New users vs. returning users
– Cost per click (CPC) and cost per thousand impressions (CPM) for paid channels
Engagement KPIs:
– Bounce rate / engagement rate (GA4 uses engagement rate)
– Average session duration
– Pages per session
– Top landing pages by traffic and engagement
Conversion KPIs:
– Conversion rate (by channel and campaign)
– Total conversions / leads generated
– Cost per acquisition (CPA)
– Return on ad spend (ROAS)
SEO KPIs:
– Organic search impressions and clicks (Search Console)
– Average position for target keywords
– Click-through rate (CTR) from search results
– Organic traffic growth month-over-month
Step-by-Step: Build a Marketing Dashboard in Looker Studio
Step 1: Connect Your Data Sources
Go to lookerstudio.google.com and click Create > Report.
Add Google Analytics 4:
Click Add data > Google Analytics > select your GA4 property > Add. Looker Studio will pull in all available dimensions and metrics.
Add Google Search Console:
Click Add data > Search Console > select your site > choose “Site impression” or “URL impression” (site is usually what you want for a KPI dashboard) > Add.
Add Google Ads:
Click Add data > Google Ads > select your account > Add.
Important: Each data source is independent. You can’t natively blend GA4 and Search Console data in a single chart (e.g., you can’t show organic keywords alongside on-site conversion rates in one table without data blending, which has limitations).
Step 2: Set Your Date Range
Add a Date range control at the top of the report:
- Insert > Date range control
- Set the default to “Last 28 days” or “Last month” (avoid “Auto” — it confuses viewers)
- Position it in the top-right corner
This control will filter all charts on the page that share the same data source. Charts from different data sources need separate date controls (or you configure each chart’s date range manually).
Step 3: Build KPI Scorecard Tiles
Looker Studio has a native Scorecard chart type that’s perfect for headline KPIs.
For each KPI:
1. Insert > Scorecard
2. Select the metric (e.g., Sessions, Conversions, Bounce Rate)
3. Under Style, configure:
– Font size for the number (28-36pt works well)
– Add a “Comparison date range” to show period-over-period change (e.g., “Previous period”)
– Set positive change to green, negative to red
4. Add a label above each scorecard (use a text box with the KPI name)
Recommended scorecard row (6-8 tiles):
– Sessions | Users | Conversion Rate | Conversions | CPA | ROAS | Organic Clicks | Avg Position
Step 4: Create Traffic Source Charts
Traffic by channel (Pie or Donut chart):
1. Insert > Pie chart
2. Data source: GA4
3. Dimension: Session default channel group
4. Metric: Sessions
5. Sort by Sessions descending
6. Limit to top 6-8 channels (everything else becomes “Other”)
Traffic trend by channel (Time series with breakdown):
1. Insert > Time series chart
2. Data source: GA4
3. Date dimension: Date
4. Breakdown dimension: Session default channel group
5. Metric: Sessions
6. This shows you how each channel trends over time — essential for spotting drops or spikes
Step 5: Add SEO Performance Charts
Organic search performance (from Search Console):
1. Insert > Time series chart
2. Data source: Search Console
3. Metric 1: Impressions
4. Metric 2: Clicks
5. This shows your search visibility trend
Top keywords table:
1. Insert > Table
2. Data source: Search Console
3. Dimension: Query
4. Metrics: Impressions, Clicks, CTR, Average Position
5. Sort by Impressions descending
6. Set rows per page to 10-15
Top landing pages table:
1. Insert > Table
2. Data source: GA4 or Search Console
3. Dimension: Landing page (GA4) or Page (Search Console)
4. Metrics: Sessions, Engagement Rate, Conversions
Step 6: Add Paid Ads Performance (If Running Ads)
Campaign performance table:
1. Insert > Table
2. Data source: Google Ads
3. Dimensions: Campaign name
4. Metrics: Impressions, Clicks, CTR, CPC, Cost, Conversions, CPA, ROAS
5. Sort by Cost descending (shows biggest spenders first)
6. Add conditional formatting: highlight CPA cells red if above target, green if below
Ad spend vs. conversions trend:
1. Insert > Combo chart (bars + line)
2. Bar metric: Cost
3. Line metric: Conversions
4. Date dimension: Date or Week
5. This shows whether increased spend actually drives more conversions
Step 7: Layout and Design
Arrange the dashboard in a logical flow:
– Top: Title, date range control, filter controls
– Row 2: KPI scorecards (the big numbers)
– Row 3: Traffic overview charts (source breakdown + trend)
– Row 4: SEO performance (search trend + keyword table)
– Row 5: Paid performance (campaign table + spend vs. conversions)
Design tips:
– Use a consistent color scheme — pick 3-4 colors that match your brand
– Set the page background to white or very light gray
– Add thin borders or background rectangles to group related charts
– Set all fonts to the same family (Google Fonts are available in Looker Studio)
– Set report size to 1200x1800px or wider if needed — don’t cram everything into a small frame
– Add section headers using text boxes (e.g., “Search Performance,” “Paid Channels”)
Step 8: Add Filters and Interactive Controls
Drop-down filter for campaign or channel:
1. Insert > Drop-down list
2. Control field: Campaign name (or Channel group)
3. Position at the top of the report
Filter by device:
1. Insert > Drop-down list
2. Control field: Device category (Desktop, Mobile, Tablet)
Comparison date range:
– In each scorecard and chart, enable “Comparison date range” set to “Previous period” — this automatically shows percentage changes vs. the prior timeframe
Step 9: Share and Schedule
Share the report:
Click Share > add email addresses or get a shareable link. Set permissions (View or Edit).
Schedule email delivery:
Click Share > Schedule email delivery > set frequency (daily, weekly, monthly), recipients, and preferred time.
The report sends as a PDF attachment or a link. Note: scheduled emails send a snapshot — not an interactive report.
Where Looker Studio Falls Short
Google-only data integration. Native connectors are limited to Google products. Connecting Salesforce, HubSpot, Stripe, or databases requires paid third-party connectors ($40-200+/month) that add cost and complexity.
No data blending across sources for complex analysis. You can technically “blend” data sources, but it’s limited to left-outer joins on a single key field. You can’t combine Google Ads cost data with Salesforce revenue data in a meaningful way without workarounds.
Slow with large datasets. Looker Studio queries data in real-time from the source — there’s no caching layer. Complex dashboards with multiple data sources and calculated fields can take 10-30 seconds to load.
Limited calculated fields. Looker Studio’s formula language is basic compared to DAX or Tableau calculations. Complex metrics (weighted pipeline, customer lifetime value, cohort analysis) are difficult or impossible to build natively.
No AI analysis. Looker Studio visualizes data. It doesn’t analyze it. You’ll never get an answer to “why did traffic drop last week” or “which campaigns should I increase budget on.” That analysis is manual.
Template dependency. Many teams start with a community template, which works until they need to customize something specific. Debugging someone else’s Looker Studio report (especially data blending and calculated fields) is notoriously frustrating.
Quick Comparison
| Feature | Looker Studio | Pulse AI |
|---|---|---|
| Cost | Free (Google data), $40-200/mo for other connectors | Starts free |
| Setup time | 2-4 hours | Under 5 minutes |
| Data sources | Mainly Google (others require paid connectors) | 50+ native integrations |
| Learning curve | Moderate (data blending, calculated fields) | None — plain English |
| AI analysis | None | Built-in conversational AI |
| Cross-source analytics | Limited (basic blending) | Full cross-source queries |
| Real-time answers | No — predefined charts only | Yes — ask any question anytime |
| Scheduled reports | PDF snapshots via email | Interactive reports + summaries |
| Speed | Slow with complex reports (10-30s loads) | Sub-second responses |
When to keep Looker Studio:
If your marketing stack is 100% Google (GA4, Google Ads, Search Console), you don’t need cross-source analysis, and your team has time to build and maintain reports — Looker Studio works and costs nothing.
When to upgrade:
When you use non-Google tools (Meta Ads, LinkedIn Ads, HubSpot, Salesforce, Stripe), need AI-powered analysis to explain what’s happening, or want answers to questions that don’t have a pre-built chart — Pulse AI gets you there faster.
FAQ
Is Looker Studio really free?
The tool itself is free. Connecting Google data sources (GA4, Ads, Search Console, Sheets) is free. Connecting non-Google sources (Salesforce, Facebook Ads, HubSpot, etc.) requires third-party partner connectors that typically cost $40-200+/month.
Can Looker Studio handle real-time data?
Looker Studio queries your data source when you open or refresh the report — it’s not truly real-time. For GA4 data, there’s a 24-48 hour processing delay on standard reports. Google Ads data is near-real-time. The dashboard itself caches data to reduce query load, so you may not see the latest numbers without a manual refresh.
How do I track conversions from multiple channels in one view?
If all channels are tracked through GA4, you can create a table or chart with “Session default channel group” as the dimension and “Conversions” as the metric. If you need to combine GA4 conversions with Salesforce closed deals or Stripe payments, you’ll need data blending (limited) or an external tool like Pulse AI.
Can I embed a Looker Studio dashboard in my website or app?
Yes. Click File > Embed report to get an iframe code. Note that embedded reports are view-only, and you can control access (public, domain-restricted, or specific users).
What’s better for marketing — Looker Studio or Power BI?
Looker Studio wins for Google-ecosystem marketing data (it’s free and connected natively). Power BI wins when you need to combine marketing data with sales/finance data from multiple sources. Pulse AI wins when you want both without the setup time.
More analytics guides: Tableau vs Power BI, Excel Dashboard Tutorial, Best Tableau Alternatives for Non-Technical Users, or try Pulse AI free.
