Ready to move from pre-packaged templated dashboards to individualized reports that actually answer your marketing questions? Learn how to build more effective reports using Looker Studio—starting with strategy, not just what buttons to click.

Why choose this workshop?

This workshop is broken into 4 sections, starting with reporting strategy before diving into the tool itself. We begin with question-driven report design principles, then cover Looker Studio fundamentals through hands-on building. Next, we do a deep-dive into data blending. Finally, we cover advanced features like calculated fields and parameters.

You’ll leave this workshop with practical hands-on knowledge in Looker Studio, plus an understanding of how to create reports that people will actually want to read and use to make decisions.

Requirements:

• You must bring a laptop and have access to at least one GA4 property, one Google Search Console property, and ideally one Google Ads account. You cannot use the Google Demo GA4 property due to quota limits.
• You don’t need any experience in Looker Studio, but you may want to bring a report or two that you want to improve.
• The instructor will provide individualized advice, depending on time.

Who should attend this workshop?

This workshop is for anyone who needs to create reports for their job and isn’t happy with how they are creating those reports right now.

You don’t need to have any prior experience in Looker Studio, but you should come equipped with knowledge of GA4 and Google Search Console (and ideally Google Ads) as we will primarily be working with data from these tools.

Workshop content

Question-Driven Reporting Strategy:

• The “Jeopardy method” of reporting—answering in the form of a question
• Three rules of effective reporting
• How to create digestible reports that answer questions, not just display data
• Testing and improving your reports

Looker Studio Fundamentals:

• Creating and naming data sources
• Working with charts and controls
• Understanding dimensions, metrics, and data types
• Navigation options and page management
• Hands-on: Building a “Performance at a Glance” dashboard with scorecards, time series, and tables

Data Blending Deep-Dive:

• Why and when to blend data sources
• Understanding aggregation issues and how to avoid them
• Different join types (inner, left outer, right outer, full outer, cross)
• Hands-on: Blending GA4 + GSC to compare impressions vs. visits
• Creative blending techniques (funnel drop-off, turning dimensions into metrics)

Advanced Features:

• Creating calculated fields with functions (CASE, COALESCE, COUNT_DISTINCT, CONCAT)
• Using parameters for dynamic goals and alerts
• Speeding up reports with extracted data sources
• Managing GA4 quota issues
• Sharing and scheduling reports
• Tracking report usage with Google Analytics