An In-Depth Guide To Get Going With Looker Studio (The New Google Data Studio)

Posted by

If you have not heard, Looker Studio has actually changed the widely known Google Data Studio brand.

While Google Data Studio made reporting easier for numerous online marketers, it definitely had its restrictions.

As a brand name’s marketing method progresses and ends up being more intricate, so does the sophistication of its reporting needs.

If you’re anything like me, you’re likely tired of spending hours updating the very same spreadsheets monthly.

Often, more time is invested pulling a report than offering real insights.

When this occurs, we’re doing a disservice by spending more time “doing” and less time actually analyzing the data.

There needs to be a better method, right?

This extensive Looker Studio guide will teach you how to produce and tailor action-oriented reports based on your own information.

What Took Place To Google Data Studio?

Originally presented in beta mid-2016, Google Data Studio is a free data visualization tool.

Lots of marketers have utilized this tool for several years to merge and picture data sets from numerous channels.

And now, you’ll discover that Data Studio is no longer referenced. Where did it go?

Google officially rebranded its Data Studio item to be called Looker Studio in October 2022.

In their official announcement, Google specified:

“We are unifying our company intelligence product family under the Looker umbrella, combining Looker, Data Studio, and core Google technologies like expert system (AI) and artificial intelligence (ML). Looker Studio is still complimentary, and has the exact same functions as Information Studio.”

What Is Google Looker Studio?

Google Looker Studio (previously Data Studio) syncs all of your information sources into one combined reporting experience.

It allows users to create helpful and visual control panels that are easy to translate, share, and customize.

Basically, Looker Studio helps exceed information visualization. It’s aimed to help online marketers make more data-driven choices for their clients and brand names alike.

Currently, Looker Studio supports over 800 different data sources, in addition to 600+ information ports.

Looker Studio Vs. Data Studio

While Looker Studio touts many of the exact same features as the former Data Studio, the new name also brings new features.

  • Free version and Pro variation (paid).
  • Various modeling technique (LookML).
  • Looker integration with Google Sheets.
  • More versatile information modeling functions.
  • Supports 50+ SQLs and databases.
  • Merging functions from various data sources.

One of the essential distinctions between Looker and Data Studio is the way data is modeled. Looker Studio uses LookML (Looker Modeling Language).

The second crucial distinction that a lot of marketers will benefit from is the new and better data merging features from Looker.

In Data Studio, it enabled information sources to be blended.

However, the biggest drawback of this was that the mixing function was based on a left outer join and often didn’t mix data in a way that online marketers needed.

It was a tedious procedure that left numerous to spend more time by hand importing their data into a Google Sheet, then connecting that source to Data Studio.

Sounds discouraging, best?

Looker Studio, on the other hand, needs SQL databases to integrate any source. This indicates that raw information is passed into a database, making it a lot easier for Looker to merge data from various sources.

The result? A much faster, more significant way to visualize information from all your different marketing sources in an easy-to-digest format.

Starting With Looker Studio

There are a few essential locations to ensure your very first Google Looker Studio report is a success. These consist of:

  • Selecting a design template or dashboard.
  • Connecting information sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to choose a design template.

To gain access to Looker Studio, check out Looker Studio using your chosen Google Account. This need to be the account that you access your Google Analytics, Browse Console, Google Ads, etc.

Looker Studio provides a wide range of templates to get you started.

If you’re new to Looker Studio, it is necessary to choose a template based on the type of information being portrayed.

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to customize items and fonts to create a more constant report. The beauty of these reports is that numerous pages can be included. Don’t seem like your whole marketing story needs to be

revealed on one page! Every client has different requirements, and their reporting must be no various. The most efficient route I have actually found is to utilize and fine-tune various control panels based upon who the

designated audience is. For example, I might develop a different control panel or report page if I’m talking to a CMO vs. a Product Marketing Manager. Why?

Depending upon the function of who you’re talking with, they will understand and analyze information in different ways.

A CMO, for instance, does not need to understand the “in the weeds” data. They want to know what channels are working, what’s not, and if they’re on track to satisfy their objectives.

Link A Data Source

Now that you have actually chosen a design template, it’s time to connect your data sources.

To add an adapter to your template, go to Resource on top navigation, then click Handle included data sources. Then, you’ll click + Add An Information Source.

Screenshot from Looker Studio, December 2022

There are currently 24 various Google connectors, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

Nevertheless, you’re most likely utilizing other platforms like social media, third-party tools, CRM systems, and more.

For those non-Google ports, Looker Studio can link over 650 different information sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By utilizing the connectors, it takes the manual tasks and syncs all information for you! It ‘d be impossible to note all the readily available data sources here, however some of the primary ones I have actually utilized in the previous consist of: Supermetrics connectors for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Advertising. Advertisement +Google Analytics

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • information sources come
  • from third-party connectors.
  • Remember that much of them: Additional cost. Can slow down reports. Metrics are sometimes deprecated,

    • meaning it is important
    • to remain on top of any modifications to your report and rebuild metrics if required. When adding a data source, you’ll be asked to license the connection in between accounts.

    Choosing Metrics That Matter Speaking of metrics– they matter. Let’s be genuine, the worst is when clients open reports and

    see a complete information dump. While Looker Studio is completely customizable, this does not indicate we must be revealing all metrics offered. Does your client care about return on advertising spend (ROAS)? Be sure to consist of

    metrics such as spend and income. How about overall brand name awareness? Consist of pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By conveying the appropriate metrics and insights based upon goals, it shows the client that you are listening to them. A win-win for everyone!

    How To Modify A Report

    Now that you have actually connected your data sources, it’s time to customize that report!

    Let’s review this Google Advertisements design template as an example.

    Initially, you’ll wish to make certain you remain in the “Edit” mode and not “View.”

    Screenshot from Google Ads, December 2022

    You can start tailoring your report by making use of the data field sets on the right-hand side.

    If you’ve selected a design template like the one above, the initial step is to change the data source for each chart you want to choose.

    Screenshot from Google Advertisements, December 2022 From there, you can select from any of the different

    data fields from your selected data source to alter any visualization. Not just can you create and edit charts and tables in Looker Studio, however the ability to choose the look of a report is a game-changer for customers. It gives a sense of consistency across an organization.

    A few ways to customize the design of your report consist of: Font style and background color. Changing contrast metric colors. Text padding to line up either

  • left, center, or right.
  • Pro pointer: If you wish to alter all scorecards or
  • charts at the same time, just select all at the exact same time prior to.
  • The design modifications will use to all selections. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label font styles to create brand standard consistency:< img src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/looker-studio-style-changes-6394d61d463a0-sej.png"alt =" A Thorough Guide To Get Started With Looker Studio(The New Google Data Studio )"/ > If you’re new to Looker Studio

    , it will require time, trial and error, and persistence to

    develop a report visual that meets your reader’s expectations. Don’t get discouraged along the method! Including Report Filters An effective way to group numerous visualizations together is by including report and page filters. For instance, if you desired all tables and charts to change when editing the date variety, you might add a Date Range icon and set it to “Report Level.”

    This suggests that if the report is consisted of several pages, whenever the date range is updated, all chart information updates alongside it.

    For instance, if you wished to dive into Campaign Type efficiency, there’s a filter for that!

    Simply navigate to the toolbar and pick Add a control > Drop-down list and include the Control field of “Campaign type” as your filter.

    < img src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/campaign-type-filter-6394d7f8803d6-sej.png" alt ="Select various filters for your data to drill down more granularly."/ > This allows you to filter the data on that specific page by project type.

    For example, if you wanted to show how Search performs compared to Buy YouTube Subscribers, you ‘d pick from the dropdown in

    that filter. By default, filters added are at a page level. If you want to make the filter report-level( suggesting the filter would appear on each page of your report), merely right-click the filter and pick Make report-level.

    Develop A Chart

    If you have actually gotten comfy with your Looker Studio experience, let’s dive into how to develop a chart from scratch.

    The advantage of developing a custom chart is that you’re in full control from the beginning of imagining precisely what matters most.

    The primary step is to consider who will be reading this report. Keep in mind to include what information is very important to them.

    Your chart needs to narrate, and it’s up to you to picture that successfully.

    For instance, you might wish to include an “Overview” table that encompasses the primary metrics or crucial performance indications (KPIs) that matter to them.

    To develop a chart, click on “Insert,” which will reveal you all the different charts to select from. These include:

    • Time series.
    • Bar chart.
    • Pie chart.
    • Tables.
    • Scorecards.
    • Bullet charts.
    • A lot more.

    In this example

    , I wish to choose a simple bullet chart to add to my CMO Overview page. The goal of this chart is to reveal if we met our

    regular monthly goal of app installs. The initial step is to pick the metric you’re determining. In this case, I chose” Installs.” To make this bullet chart reliable, you need to add your target/goal. Ensure to check package that states”Show Target.”Then, I input various variety limitations to show the progress.

    I kept the last range the same as the target worth. You can likewise put the last range as a higher value than your target, especially if you exceed that target worth.

    So, what does this chart say? It represents that our goal was 5,500 app installs for the month of November. According to the bullet chart, they were close to hitting their goal but didn’t rather make it.

    Often simple charts are all you require to represent the required data. Like all other aspects of Looker Studio, you can modify the style of any chart, table, or aspect as I did above.

    Sharing Reports

    The following options are available for sharing a Looker Studio report:

    • Invite people.
    • Schedule email shipment.
    • Get report link.
    • Embed report.
    • Download report.

    < img src="https://cdn.SMM Panel.com/wp-content/uploads/2022/12/looker-studio-sharing-options-6394dddd6bc0e-sej.png" alt ="A Thorough Guide To Get Going With Looker Studio(The New Google Data Studio)"

    / > If you want to invite people to access the report in genuine time, it’s important to check the share settings. To add somebody via e-mail, it needs to be a Google account email. They can be added as a “Viewer”or an”Editor.”

    • Another information precaution Looker Studio added was how links to the report can be shared. You can select from: Restricted. Only individuals who you have actually shared the report with can open the link. Unlisted. Anyone on the web with the link can view(or edit– select this setting thoroughly). Public. Anyone on the internet with the link can find and see(or modify– choose this setting thoroughly).

    Another cool feature Google included is the option to limit sharing in the following choices. In the share settings, click on the”gear”icon in

    • the right-hand corner: Avoid editors from changing access and adding brand-new people.
    • Disable downloading, printing, and copying for viewers.

    < img src ="// www.w3.org/2000/svg%22%20viewBox=%220%200%20618%20175%22%3E%3C/svg%3E" alt="An Extensive Guide To Begin With Looker Studio (The New Google Data Studio)" width="618" height="175" data-src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/looker-studio-report-access-settings-6394dfae91a4e-sej.png"/ >< img src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/looker-studio-report-access-settings-6394dfae91a4e-sej.png" alt="A Thorough Guide To Begin With Looker Studio (The New Google Data Studio)"/ > I usually suggest checking the very first box to prevent editors from altering access or including new people.

    By doing so, it permits us to maintain control of the report settings and the integrity of report changes.

    Begin With Looker Studio Now

    Ideally, this introduction to Google Looker Studio will empower you to feel more confident in developing customized reports for your clients and brand names.

    More Resources:

    Featured Image: RomanR/SMM Panel