Table of contents
- What is Looker Studio?
- What are the benefits of using Looker Studio?
- Looker Studio Navigation
- Dataset, Data Connector, Data Source in Looker Studio
- Metrics and Dimensions in Looker Studio
- How to Build a Report in Looker Studio?
- Collect data in BigQuery for Looker Studio
- How to build an advanced report in Looker Studio with OWOX BI
Step-by-Step Looker Studio Tutorial for Beginners
Liubov Zhovtonizhko, Creative Writer @ OWOX
In this tutorial for beginners, we take a look at Looker Studio (Formerly Google Data Studio) – one of the most popular services for visualizing data – and show you step-by-step how to use it to build informative, understandable and, more importantly, actionable reports based on data from various sources.
Please note, that Looker Studio is different from another software tool called Looker. Here is a detailed and complete comparison of Lookers by Google.
Note: This post was originally published in August 2020 as the Google Data Studio tutorial and was completely updated in January 2024 for accuracy and comprehensiveness on marketing analytics.
What is Looker Studio?
Let's start with an introduction to Looker Studio. It's a service perfect for beginners to create interactive reports. It allows you to import information from different platforms, starting from other Google services: Google Ads, BigQuery, Google Analytics 4, Google Sheets, and YouTube Analytics, as well as non-google tools so you can visualize data with charts, tables, and diagrams, and monitor KPIs (or other indicators) in real-time.
Even the free version provides the ability to share reports with colleagues, shareholders or clients. You’re also in the driver’s seat - managing the access rights, giving the editing permissions. In addition, you can make a template of a report so that others can copy and apply their data to your ready-made visuals.
According to Portermetrics, Looker Studio is used by 67% of Fortune 500 companies and has over 3 million users worldwide. We have created a gallery of absolutely free dashboard templates that you can use to build reports with your data.
What are the benefits of using Looker Studio?
Looker Studio is an excellent service that allows you to visualize data and get fresh, automatically updated reports, avoiding the limitations of the number of widgets in Google Analytics 4 Dashboards.
Here are some of the other core benefits:
- Free plan is available (and 99% of users do not need a PRO subscription)
- There are lots of widget types to personalize your report.
- Google-like sharing options.
- Report Gallery with free templates and ready-to-use dashboards.
Also, the data blending capabilities are too limited, so you’d likely use and external tool for data preparation.
Save 70+ hours on data preparation
Spend time reaching your monthly KPIs instead of collecting the data or building reports
Looker Studio Navigation
Once logged in, navigate to the Looker Studio website at lookerstudio.google.com. This is your gateway to exploring Looker Studio.
Let’s explore the Looker Studio starting page and its primary navigation elements:
Left Menu: Offers quick access to create new reports, data sources, or explore features. It also allows you to view reports shared with you, manage your own reports, and access deleted reports in the trash.
Toolbar Menu: This menu includes options to view all your reports, manage your data sources, and explore charts and data without changing existing reports.
Search Bar: Positioned at the top, it enables you to quickly find reports by searching for their names.
Template Gallery: Provides a starting point for new dashboards, offering a choice between starting from scratch or using pre-made templates. More templates can be found by clicking “Template Gallery” in the top-right corner of this section.
Report List: Located below the Template Gallery, this area displays your reports and allows sorting by name, owner, or last opened date, helping you organize and access your work efficiently.
Dataset, Data Connector, Data Source in Looker Studio
Before you dive into report creation, you need to set up a source of data that you’re going to use in the report. Understanding the distinction between your original data and what Looker Studio uses is key:
A data source, in the context of Looker Studio, is a repository or location from where Looker Studio retrieves your data. This repository could be a database management system, a set of spreadsheets, a cloud-based data storage system, or any other system that stores and manages data.
The structure and system of these data sources can vary, but their goal stays consistent, i.e., to house data that Looker Studio can analyze.
"A data source in Looker Studio is the foundational rock of data analysis. It's like the library that stocks the books (data) you need for your research (analysis). Without it, data analysis would be like fishing in a pond with no fish."
- Google Services: Google Ads, Youtube Analytics, GA4, and Google Search Console could be the source of your data.
- Database: This could be a traditional SQL database like MySQL or PostgreSQL where data are stored in tables.
- Spreadsheet Files: Google Sheets files or CSVs containing tables with data can also work as data sources in Looker Studio.
- Cloud-based Storage System: Platforms like BigQuery, Snowflake or Amazon S3, which store large datasets, are common data sources for Looker Studio.
- Third-party applications.
To link your data source to Looker Studio, you need a data connector. This connector acts as a bridge between a source and a Looker Studio so you can access and use your data.
Data connector as a bridge. It connects Looker Studio to all of the data available from the data sources enabling smooth, automatically updated data flow.
Looker Studio supports over 800 connectors (most of them are paid, but the ones to Google Services are free).
The best part is that setting up a data connector in Looker Studio is as easy as pie. But more on that later.
Once a data connector to a data source is established, you can add a dataset.
A dataset is a collection of related data points. It's a table, or multiple tables, filled with rows and columns of data that have some shared characteristics or themes. In Looker Studio, you can think of a dataset as the raw material for your data analysis.
The quality and organization of your dataset significantly influence the accuracy of your analysis. By working with a well-structured dataset, you can:
- Ensure consistency in your reporting,
- Create reliable and trusted reports to act upon,
- Minimize bias, achieving more objective results,
- Improve efficiency by avoiding unnecessary manual data cleaning.
The data source keeps the connection credentials and tracks all the datasets involved in that connection.
Working with Multiple Data Sources
Looker Studio's is flexible when working with multiple data sources. So it’s easy to visualize data from multiple sources on separate charts, tables or reports. This functionality proves valuable in collaborative projects, enabling diverse team members to access different data sources within the same report, or just within the same Looker Studio account.
However, the data blending capabilities are pretty low. That is why it’s important to prepare your datasets carefully before you connect them to Looker Studio. Specifically, you need to ensure that your datasets are correctly formatted, cleaned, and structured. This pre-processing shields against inaccurate data representations, which could lead to misguided decision-making.
Evolution of Data Sources in Looker Studio
Initially, Looker Studio supported only a handful of Google-based data sources. However, the platform has significantly evolved. Now, you can use third-party connectors to access a wide range of non-Google services like LinkedIn, PayPal, Facebook, Twitter, HubSpot, and more through third-party connectors. It's important to note that most of these third-party connectors are not free.
In summary, Looker Studio's ability to integrate with diverse data sources and connectors makes it a great tool for creating detailed and dynamic reports, catering to a wide range of data visualization needs.
Metrics and Dimensions in Looker Studio
In Looker Studio, there is a foundation of utilizing two fundamental components: metrics and dimensions. These elements are essential for building the elements for actually transforming raw data into insightful visualizations.
Here's a breakdown of what metrics and dimensions represent in Looker Studio:
Metrics are numerical values used to measure or quantify data. They are derived by applying aggregation functions like COUNT(), SUM(), AVG(), etc., either explicitly or implicitly, to your dataset. Metrics provide quantitative insights into your data and are typically represented as numbers. Examples of metrics include counts, sums, percentages, durations, and currency values.
Dimensions, however, encompass the attributes or characteristics that describe and categorize your data. They provide context to your metrics by offering names, descriptions, or other identifying features of the data you're measuring or counting. Dimensions are used to group and categorize your data in charts and reports. Examples of dimensions include categories like Country, Age, Product ID, Date, or Campaign Name.
In simpler terms, dimensions help organize your data into meaningful groups or categories, while metrics provide the numerical values that quantify aspects of those categories.
Together, metrics and dimensions enable you to create informative and visually appealing dashboards in Looker Studio by effectively summarizing and presenting your data.
How to Build a Report in Looker Studio?
Step #1. Connect a Data Source in Looker Studio
1. Go to the starting page and click on “+ Create” and select “Data Source”.
2. Select the desired connector – in our example, Google BigQuery (If you’re using OWOX BI, your dataset for reporting is already automatically created in Google BigQuery).
3. Next, give necessary Google BigQuery permissions to access your data.
4. Select the desired account, project and a dataset.
5. In the upper right corner, click Connect. All information will automatically be loaded to Looker Studio.
Use the same procedure, to connect the other data sources.
Step #2: Create charts, graphs, and diagrams in Looker Studio
Once you’ve connected to BigQuery, it’s time to build reports.
Looker Studio provides different visual elements:
All visual elements are divided into three groups:
- Elements for visualizing
- Design elements
- Elements for filtering
To use these visual elements, you need to:
1. Click the Create Blank Report button to go to the reporting page and free your analytical imagination.
2. Add a visual element. Just indicate which element you want to add and select the area in which you want to add it.
For example, say you’ve selected a pie chart. Here’s what you can do with it:
- Change the style (number of segments, color, background, borders, title of the chart, etc.)
- Change/add parameters, indicators, sorting, and filters
The first bullet point is intuitive, but the second needs a little explaining. Here’s the list of elements you can work with:
- Dimensions let report editors override default values in a source. You can select, for example, the Date Time parameter.
- Metrics are numerical values – for example, Sessions, Revenue, Goals, Cost, or your own indicators.
- There’s also a field with a filter. You can use it to recalculate indicators only for paid advertising by unchecking all sources, for example, leaving only paid advertising.
After completing all these steps and adjusting all these settings, you’ll get a visual dashboard. Here’s an example of one of these dashboards:
Step #3: How to share a Looker Studio report with your team?
The report is built, you’re happy, and you’d like to hear the opinions of your colleagues. Time to share it with your team.
There are two ways to do this:
- In the File menu, choose Share.
- In the upper right corner, click the Share button.
Choose whichever method you prefer. Then add the emails of your colleagues, click Share and the report is already in their inboxes. You can also schedule report deliver to the emails of the stakeholders or your clients.
Dive deeper with this read
The OWOX BI guide for digital marketers: data collection, dashboards, and templates
Collect data in BigQuery for Looker Studio
Our short Looker Studio tutorial for beginners starts with these 3 simple steps above. But earlier, we’ve mentioned that Looker Studio has very limited data blending capabilities.
That is why, it’s important to note, that if you want to visualize data from multiple sources:
- All social media ads together: Facebook ads, LinkedIn ads, and Twitter ads in the same report…
- All search ads (Google and Bing Ads)...
- All paid media campaigns together…
- Marketing campaign performance based on conversions from Google Analytics 4…
- Google Seach Console Performance with revenue generated based on either online or offline conversions…
- Marketing attribution report…
- Cohort analysis, or, basically any other report based on multiple data sources
You need to prepare data for your reporting in Looker Studio in advance.
The easiest way to do so is to prepare data for your report in a cloud data warehouse, for example in Google BigQuery in 3 simple steps.
Step #1: Collect all of your data in BigQuery
To collect all information from different services automatically and get rid of busy work, use OWOX BI Pipeline. At least you’ll need to import Cost data from advertising services, collect website user behavior data with OWOX BI Streaming or setup native GA4 BigQuery export.
NOTE: When directly connecting GA4 to Looker Studio, you can run into limitations of data sampling or quota limitations.
Automate your digital marketing reporting
Manage and analyze all your data in one place! Access fresh & reliable data with OWOX BI — an all-in-one reporting and analytics tool
To configure cost data import to Google BigQuery with OWOX BI, everything you need is to provide access to advertising platforms (Facebook, LinkedIn, Bing/Microsoft Ads, Criteo), then provide access to your BigQuery project and all of the data are going to be automatically uploaded (and updated) every day.
In addition, you can use OWOX BI to collect information from CRM/ERP systems, call-tracking, or third-party applications to BigQuery so you’ll have the opportunity to compare costs and revenue as well as track important metrics for your business.
Once you’ve collected all your figures in Google BigQuery, it’s time to transform you data.
Step #2: Transform Your Data
The data from different data sources is siloed. Different field names, different structures, and formats. BigQuery is a cloud-based data warehouse, perfect for storing raw data, however, it requires SQL knowledge to manipulate the data and blend.
The good news is, that we’ve already prepared all of the necessary no-code SQL templates that you can apply without any changes in OWOX BI and get your advertising costs merged, GA4 events collected into sessions, attribute paid expenses to sessions, attribution models applied and so much more.
Step #3: Prepare a dataset for reporting
Once you’ve collected the data and transformed raw data into analytics-ready data, you can prepare your data for reporting - create a dataset with all the necessary information you need for a specific report (or a set of reports).
For example, we’ve prepared a template for Looker Studio with over 50 reports in one for measuring and optimizing all of the main marketing metrics and KPIs.
All-in-one Digital marketing DashboardDownload template
When you sign up for a free trial of OWOX BI, you’ll get access to no-code transformation templates to not only do the basic data manipulations but also to get all of the reports datasets for looker studio prepared for you.
All with no code. You don’t need to hire a data scientist or have SQL coding experience.
How to build an advanced report in Looker Studio with OWOX BI
Looker Studio is a visualization service only. To automatically run more complex calculations and build dashboards based on them, you can use OWOX BI products.
- Automatically import cost data to Google Analytics 4 from Facebook, Bing Ads, Criteo, and other advertising sources and measure ROAS and CPA in the interface you’re familiar with.
- Get all the data you need for advanced marketing analysis: OWOX BI combines information from your advertising services, website tracking systems, offline shops, call-tracking, and CRM systems. You don’t need to look for connectors or manually clean and process data.
- Build reports on ad campaigns (ROI, attribution), ROPO, RFM, cohort, and CPA partners analysis, as well as LTV and CAC reports to measure what works best in your marketing.
- The final step is to connect the dataset prepared with OWOX BI to the ready-made template for Looker Studio with just a few clicks.
Gain clarity for better decisions without chaos
No switching between platforms. Get the reports you need to focus on campaign optimization
Below are examples of reports built with OWOX BI.
Here you can see how user behavior differs depending on the product category and traffic source:
On the next screen, you can see how the conversion is distributed depending on the type of page and traffic source (the list of sources can be adjusted using a filter):
Want to see more examples? Go to our section with Looker Studio dashboard templates by OWOX BI.
If you have any questions concerning marketing problems you want to solve, book a demo, and our specialists will assist you with any questions or issues.
How do you prepare data for Looker Studio?To prepare data for Looker Studio, you typically follow these steps:
- Data Extraction: Gather and extract data from various sources, ensuring it's in a structured format.
- Data Cleaning: Cleanse and preprocess the data by handling missing values, duplicates, and inconsistencies.
- Data Transformation: Transform data as needed, including aggregating, filtering, and joining tables.
- Data Modeling: Create a logical data model that defines relationships between different data sets.
- Data Loading: Load the prepared data into Looker Studio or the connected database.
- Define Metrics and Dimensions: Specify metrics and dimensions to facilitate data analysis.
- Build Reports and Dashboards: Leverage Looker Studio's interface to craft reports and dashboards, facilitating data visualization and analysis.
What is Looker Studio used for?Looker Studio is primarily used for data visualization and reporting. It enables users to establish connections with a variety of data sources, convert raw data into meaningful visualizations, and construct interactive dashboards and reports. It's commonly used for data analysis, business intelligence, and sharing data-driven insights within organizations, helping users make informed decisions based on data.
How do I share my reports and dashboards with others in Google Looker Studio?You can share your reports and dashboards with others in Google Looker Studio by selecting the "Share" button and choosing the sharing options, such as "Viewer" or "Editor" access.
Can I customize the appearance of my reports and dashboards in Google Looker Studio?Yes, you can customize the appearance of your reports and dashboards in Google Looker Studio by downloading custom templates, changing colors, and adding logos or images.
How do I connect my data sources to Google Looker Studio?You can connect your data sources to Google Looker Studio by selecting the "Add data" option and then choosing the type of data source, such as Google Analytics, Google Sheets, or a third-party connector.