How can we help?

If you are still copying data from Google Analytics into Excel every Monday morning, there is a faster way.

Google Looker Studio (formerly Data Studio) is a free visualization tool that turns your raw data into interactive, clean and, most importantly, automated dashboards.

Here is a step-by-step guide to building your first report in under 15 minutes.

The Concept: How it Works

Looker Studio doesn't store data; it mirrors it.

Think of it like a TV connected to a DVD player. The movie (data) is on the DVD (Google Analytics), and the TV (Looker Studio) displays it.

Connector: The link between your data source (GA4, Google Ads, Google Sheets) and Looker Studio.

Report: The canvas where you build your charts.

Step-by-Step: Build Your Dashboard

Step 1: Create a blank report

1. Go to lookerstudio.google.com.

2. Click the "+" (Create) button and select Report.

Step 2: Connect your data

1. In the "Add data to report" window, select Google Analytics.

2. Choose your account and GA4 property.

3. Click Add.

Your dashboard is now live-linked to your website data.

Step 3: Add your first chart (scorecards)

Scorecards show single numbers (KPIs). Let’s add your total traffic.

1. Click Add a chart in the top toolbar.

2. Select Scorecard (the icon with a big number like "123").

3. Click anywhere on the blank canvas to place it.

4. In the right-hand panel, change the Metric from "Views" to "Sessions" or "Total users."

Step 4: Add a trend chart

Single numbers are useful; trends are better.

1. Click Add a chart > Time series chart.

2. Place it on the canvas.

3. It should show "Views by Date" automatically. If not, drag "Date" into the Dimension slot and "Views" into the Metric slot in the right-hand panel.

Step 5: Make it interactive (date range control)

1. Click Add a control in the top toolbar.

2. Select Date range control.

3. Place it in the top right corner.

Now, when you (or your manager) view the report, you can switch the dates to "Last month," "This year" or "Last 7 days," and every chart updates instantly.

The "Golden Rule" of Looker Studio

To build anything, you must understand the difference between Green and Blue chips in the sidebar:

Rule of thumb: If you can do math on it (sum, average), it’s a metric. If it’s a label, it’s a dimension.

Automating the Delivery

You don't need to email the link every week. Looker Studio can do it for you.

1. Click the Share button (top right).

2. Select Schedule delivery.

3. Set the time (e.g., every Monday at 8:00 AM).

4. Enter the email addresses of your team or clients.

They will receive a PDF and a link to the live dashboard in their inbox before the work week starts.