A Thorough Guide To Get Going With Looker Studio (The New Google Data Studio)

Posted by

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

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

As a brand name’s marketing technique develops and ends up being more complex, so does the elegance of its reporting needs.

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

In some cases, more time is invested pulling a report than supplying actual insights.

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

There has to be a much better method, right?

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

What Happened To Google Data Studio?

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

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

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

Google formally rebranded its Information Studio product to be called Looker Studio in October 2022.

In their main statement, Google mentioned:

“We are unifying our company intelligence item household under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and machine learning (ML). Looker Studio is still totally free, and has the exact same functions 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 allows users to create helpful and visual control panels that are simple to interpret, share, and customize.

Essentially, Looker Studio assists exceed data visualization. It’s aimed to help online marketers make more data-driven choices for their customers and brands alike.

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

Looker Studio Vs. Data Studio

While Looker Studio promotes much of the same features as the former Data Studio, the new name also brings brand-new functions.

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

One of the essential distinctions in between Looker and Data Studio is the method data is designed. Looker Studio uses LookML (Looker Modeling Language).

The second crucial difference that many marketers will gain from is the brand-new and improved information combining features from Looker.

In Data Studio, it permitted information sources to be combined.

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

It was a tiresome process that left numerous to spend more time manually importing their data into a Google Sheet, then linking that source to Data Studio.

Sounds frustrating, right?

Looker Studio, on the other hand, requires SQL databases to integrate any source. This means that raw data is entered a database, making it much easier for Looker to merge data from various sources.

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

Getting Started With Looker Studio

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

  • Choosing a template or control panel.
  • Linking information sources.
  • Picking metrics that matter.
  • Sharing reports.

Looker Studio Templates

The very first thing to do is to pick a design template.

To access Looker Studio, see Looker Studio utilizing your chosen Google Account. This ought to be the account that you access your Google Analytics, Search Console, Google Advertisements, etc.

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

If you’re brand-new to Looker Studio, it is essential to pick a template based upon the type of information being represented.

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

shown on one page! Every client has different needs, and their reporting ought to be no various. The most effective route I have actually found is to use and fine-tune various dashboards based upon who the

designated audience is. For instance, I may produce a different dashboard or report page if I’m talking with a CMO vs. a Product Marketing Manager. Why?

Depending on the role of who you’re speaking with, they will understand and translate data in various ways.

A CMO, for instance, does not require to know the “in the weeds” information. They want 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 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 + Add A Data Source.

Screenshot from Looker Studio, December 2022

There are presently 24 various Google ports, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

Nevertheless, you’re most likely using 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 utilizing the adapters, it takes the manual jobs and synchronizes all data for you! It ‘d be impossible to list all the available data sources here, however a few of the primary ones I have actually used in the past consist of: Supermetrics adapters for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Advertising. Advertisement +Google Analytics

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • information sources come
  • from third-party connectors.
  • Keep in mind that a lot of them: Additional cost. Can slow down reports. Metrics are sometimes deprecated,

    • meaning it is crucial
    • to remain on top of any changes to your report and rebuild metrics if needed. When adding a data source, you’ll be asked to authorize 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 data dump. While Looker Studio is totally customizable, this does not suggest we need to be showing all metrics readily available. Does your customer appreciate return on marketing invest (ROAS)? Make certain 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 proper metrics and insights based upon objectives, it shows the customer that you are listening to them. A win-win for everybody!

    How To Edit A Report

    Now that you have actually connected your data 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 begin customizing your report by making use of the information field sets on the right-hand side.

    If you have actually chosen a design template like the one above, the first step is to change the data source for each chart you want to pick.

    Screenshot from Google Advertisements, December 2022 From there, you can pick from any of the various

    information fields from your selected data source to change any visualization. Not only can you create and modify charts and tables in Looker Studio, but the capability to choose the look of a report is a game-changer for customers. It provides a sense of consistency across an organization.

    A few methods to customize the design of your report include: Font and background color. Changing contrast metric colors. Text cushioning to align either

  • left, center, or right.
  • Pro tip: If you want to alter all scorecards or
  • charts at the same time, simply select all at the same time prior to.
  • The design changes will use to all choices. Another time-saver! In this example, I changed the report background

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

    , it will take some time, experimentation, and persistence to

    develop a report visual that fulfills your reader’s expectations. Don’t get dissuaded along the way! Adding 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 alter when modifying the date variety, you could include a Date Variety icon and set it to “Report Level.”

    This indicates that if the report is comprised of multiple pages, whenever the date range is updated, all chart data updates along with it.

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

    Just browse to the toolbar and choose 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 ="Choose various filters for your data to drill down more granularly."/ > This permits you to filter the data on that specific page by campaign type.

    For instance, if you wanted to show how Browse 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 wish to make the filter report-level( implying the filter would appear on each page of your report), just right-click the filter and select Make report-level.

    Produce A Chart

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

    The benefit of developing a customized chart is that you remain in complete control from the start of picturing precisely what matters most.

    The first step is to consider who will be reading this report. Remember to include what data is important to them.

    Your chart needs to tell a story, and it depends on you to envision that successfully.

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

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

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

    In this example

    , I wish to pick a basic bullet chart to add to my CMO Introduction page. The objective of this chart is to reveal if we fulfilled our

    month-to-month objective 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 include your target/goal. Make sure to inspect package that states”Program Target.”Then, I input different variety limitations to reveal the progress.

    I kept the last variety the like the target worth. You can likewise put the last range as a higher worth than your target, particularly if you surpass that target worth.

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

    Sometimes easy charts are all you require to represent the necessary 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 choices are readily available for sharing a Looker Studio report:

    • Invite people.
    • Set up e-mail 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 ="An In-Depth Guide To Begin With Looker Studio(The New Google Data Studio)"

    / > If you want to welcome individuals to access the report in genuine time, it’s important to check the share settings. To include somebody through email, it must be a Google account e-mail. They can be added as a “Audience”or an”Editor.”

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

    Another cool function Google added is the alternative to limit sharing in the following choices. In the share settings, click the”gear”icon in

    • the right-hand corner: Prevent editors from changing access and including 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 In-Depth Guide To Get Started 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 In-Depth Guide To Start With Looker Studio (The New Google Data Studio)"/ > I usually recommend inspecting the first box to avoid editors from altering gain access to or adding brand-new individuals.

    By doing so, it enables us to preserve control of the report settings and the integrity of report modifications.

    Begin With Looker Studio Now

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

    More Resources:

    Featured Image: RomanR/SMM Panel