An Extensive Guide To Start With Looker Studio (The New Google Data Studio)

Posted by

If you haven’t heard, Looker Studio has actually changed the widely known Google Data Studio brand.

While Google Data Studio made reporting much easier for lots of online marketers, it definitely had its limitations.

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

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

Sometimes, more time is invested pulling a report than supplying real insights.

When this occurs, we’re doing an injustice by investing more time “doing” and less time really examining the data.

There has to be a much better way, right?

This extensive Looker Studio guide will teach you how to develop and customize action-oriented reports based on your own data.

What Occurred To Google Data Studio?

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

Numerous marketers have actually used this tool for many years to unify and envision information sets from numerous channels.

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

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

In their main announcement, Google mentioned:

“We are unifying our service intelligence product family under the Looker umbrella, uniting Looker, Data Studio, and core Google innovations like artificial intelligence (AI) and artificial intelligence (ML). Looker Studio is still free, and has the very same features as Information Studio.”

What Is Google Looker Studio?

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

It enables users to create useful and visual control panels that are easy to interpret, share, and customize.

Basically, Looker Studio assists exceed data visualization. It’s aimed to assist marketers make more data-driven choices for their customers and brand names alike.

Presently, Looker Studio supports over 800 various information sources, along with 600+ information ports.

Looker Studio Vs. Data Studio

While Looker Studio touts much of the exact same functions as the former Data Studio, the brand-new name likewise brings new features.

  • Free version and Pro variation (paid).
  • Different modeling technique (LookML).
  • Looker combination with Google Sheets.
  • More flexible information modeling functions.
  • Supports 50+ SQLs and databases.
  • Merging functions from different data sources.

Among the key differences between Looker and Data Studio is the way information is designed. Looker Studio uses LookML (Looker Modeling Language).

The second essential difference that the majority of online marketers will benefit from is the brand-new and improved data combining features from Looker.

In Data Studio, it enabled data sources to be mixed.

However, the biggest downside of this was that the mixing function was based upon a left external join and frequently didn’t mix information in a way that marketers required.

It was a laborious procedure that left many to invest more time manually importing their information into a Google Sheet, then connecting that source to Data Studio.

Sounds discouraging, ideal?

Looker Studio, on the other hand, needs SQL databases to incorporate any source. This suggests that raw information is entered a database, making it much easier for Looker to combine information from different sources.

The outcome? A faster, more significant method to envision data from all your various marketing sources in an easy-to-digest format.

Beginning With Looker Studio

There are a few essential areas to ensure your very first Google Looker Studio report is a success. These include:

  • Choosing a template or dashboard.
  • Linking information sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to select a template.

To gain access to Looker Studio, see Looker Studio utilizing your preferred Google Account. This must be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.

Looker Studio offers a variety of design templates to get you started.

If you’re brand-new to Looker Studio, it is very important to choose a template based on the type of data being portrayed.

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to personalize products and font styles to create a more consistent report. The beauty of these reports is that multiple pages can be included. Do not feel like your entire marketing story requires to be

shown on one page! Every client has different needs, and their reporting needs to be no various. The most efficient path I have actually found is to utilize and tweak different control panels based on who the

designated audience is. For example, I might create a different dashboard or report page if I’m talking with a CMO vs. an Item Marketing Manager. Why?

Depending upon the function of who you’re talking to, they will comprehend and analyze information in various methods.

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

Connect A Data Source

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

To add a connector to your design template, go to Resource on top navigation, then click Handle included information sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

There are currently 24 different Google adapters, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

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

For those non-Google adapters, Looker Studio can link over 650 various information sources from their partner adapters!

Screenshot from Looker Studio, December 2022 By using the ports, it takes the manual jobs and synchronizes all data for you! It ‘d be difficult to list all the available data sources here, but some of the main ones I have actually used in the past consist of: Supermetrics adapters for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And a lot more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • data sources come
  • from third-party ports.
  • Bear in mind that much of them: Additional cost. Can decrease reports. Metrics are often deprecated,

    • indicating it is important
    • to stay on top of any changes to your report and restore metrics if required. When adding a data source, you’ll be asked to authorize the connection in between accounts.

    Choosing Metrics That Matter Mentioning metrics– they matter. Let’s be real, the worst is when customers open reports and

    see a total information dump. While Looker Studio is totally customizable, this does not suggest we should be revealing all metrics available. Does your client appreciate return on marketing invest (ROAS)? Be sure to include

    metrics such as spend and earnings. How about overall brand awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, etc.

    By communicating the correct metrics and insights based upon objectives, it reveals the client that you are listening to them. A win-win for everyone!

    How To Edit A Report

    Now that you’ve linked your information sources, it’s time to personalize that report!

    Let’s evaluate this Google Ads template as an example.

    First, you’ll want to make sure you remain in the “Edit” mode and not “View.”

    Screenshot from Google Ads, December 2022

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

    If you’ve chosen a template like the one above, the primary step is to change the information source for each chart you want to pick.

    Screenshot from Google Ads, December 2022 From there, you can pick from any of the different

    data fields from your picked data source to alter any visualization. Not only can you produce and modify charts and tables in Looker Studio, but the ability to choose the look and feel of a report is a game-changer for customers. It gives a sense of consistency across a company.

    A couple of methods to personalize the design of your report consist of: Typeface and background color. Changing contrast metric colors. Text cushioning to align either

  • left, center, or right.
  • Pro suggestion: If you wish to alter all scorecards or
  • charts simultaneously, just select all at the very same time before.
  • The style modifications will use to all choices. Another time-saver! In this example, I altered the report background

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

    , it will take time, trial and error, and perseverance to

    develop a report visual that meets your reader’s expectations. Do not get discouraged along the way! Including Report Filters An effective method to group several visualizations together is by adding report and page filters. For example, if you desired all tables and charts to change when editing the date range, you could add a Date Variety icon and set it to “Report Level.”

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

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

    Merely navigate to the toolbar and pick Include a control > Drop-down list and add the Control field of “Project type” as your filter.

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

    For instance, if you wished to demonstrate how Browse performs compared to Buy YouTube Subscribers, you ‘d choose from the dropdown in

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

    Create A Chart

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

    The benefit of producing a custom chart is that you’re in complete control from the start of imagining exactly what matters most.

    The first step is to consider who will be reading this report. Keep in mind to include what information is necessary to them.

    Your chart needs to narrate, and it’s up to you to envision that effectively.

    For instance, you may want to include an “Summary” table that encompasses the main metrics or key performance indications (KPIs) that matter to them.

    To produce a chart, click “Insert,” which will show you all the various charts to choose from. These include:

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

    In this example

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

    monthly goal of app installs. The first step is to pick the metric you’re measuring. In this case, I chose” Installs.” To make this bullet chart reliable, you require to add your target/goal. Ensure to check the box that states”Program Target.”Then, I input various variety limits to show the progress.

    I kept the last variety the like the target worth. You can likewise put the last variety as a greater value than your target, particularly if you exceed that target worth.

    So, what does this chart say? It depicts that our objective 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 quite make it.

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

    Sharing Reports

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

    • Welcome people.
    • Arrange email shipment.
    • Get report link.
    • Embed report.
    • Download report.

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

    / > If you wish to invite individuals to access the report in real time, it is very important to check the share settings. To add someone by means of e-mail, it needs to be a Google account email. They can be included as a “Audience”or an”Editor.”

    • Another data safety measure Looker Studio included was how links to the report can be shared. You can choose from: Restricted. Only people who you have shared the report with can open the link. Unlisted. Anybody on the internet with the link can see(or modify– pick this setting carefully). Public. Anybody on the internet with the link can discover and view(or edit– pick this setting carefully).

    Another cool function Google included is the choice to restrict sharing in the following choices. In the share settings, click on the”gear”icon in

    • the right-hand corner: Prevent editors from altering gain access to and adding new individuals.
    • Disable downloading, printing, and copying for audiences.

    < img src ="// www.w3.org/2000/svg%22%20viewBox=%220%200%20618%20175%22%3E%3C/svg%3E" alt="A Thorough Guide To Get Going 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="An Extensive Guide To Get Going With Looker Studio (The New Google Data Studio)"/ > I typically advise checking the first box to prevent editors from changing gain access to or including new people.

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

    Get Started With Looker Studio Now

    Ideally, this intro to Google Looker Studio will empower you to feel more confident in developing tailored reports for your customers and brand names.

    More Resources:

    Included Image: RomanR/Best SMM Panel