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

Posted by

If you have not heard, Looker Studio has replaced the popular Google Data Studio brand name.

While Google Data Studio made reporting simpler for numerous marketers, it definitely had its limitations.

As a brand’s marketing technique 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 costs hours updating the very same spreadsheets monthly.

In some cases, more time is spent pulling a report than providing actual insights.

When this takes place, we’re doing an injustice by investing more time “doing” and less time in fact evaluating the information.

There has to be a much better way, right?

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

What Occurred To Google Data Studio?

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

Numerous marketers have actually used this tool for many years to merge and visualize data sets from several channels.

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

Google formally rebranded its Data Studio product to be named Looker Studio in October 2022.

In their main announcement, Google specified:

“We are unifying our business intelligence product household under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and artificial intelligence (ML). Looker Studio is still free, and has the 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 easy to interpret, share, and personalize.

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

Currently, Looker Studio supports over 800 various information sources, along with 600+ information connectors.

Looker Studio Vs. Data Studio

While Looker Studio promotes a number of the same features as the previous Data Studio, the new name likewise brings brand-new features.

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

Among the key differences between Looker and Data Studio is the method information is modeled. Looker Studio utilizes LookML (Looker Modeling Language).

The 2nd essential difference that many marketers will gain from is the brand-new and improved data merging features from Looker.

In Data Studio, it allowed for information sources to be combined.

However, the biggest downside of this was that the blending feature was based upon a left outer join and typically didn’t blend information in such a way that marketers needed.

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

Sounds frustrating, ideal?

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

The outcome? A quicker, more significant method to visualize information from all your different marketing sources in an easy-to-digest format.

Getting Going With Looker Studio

There are a couple of essential areas to guarantee your first Google Looker Studio report is a success. These include:

  • Picking a design template or control panel.
  • Connecting data sources.
  • Picking metrics that matter.
  • Sharing reports.

Looker Studio Templates

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

To access Looker Studio, visit Looker Studio using your preferred Google Account. This must be the account that you access your Google Analytics, Search Console, Google Ads, etc.

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

If you’re new to Looker Studio, it is essential to choose a template based upon the type of data being represented.

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to customize products and fonts to produce a more constant 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 customer has various needs, and their reporting should be no different. The most efficient route I have discovered is to utilize and modify different control panels based on who the

desired audience is. For example, I might create a various dashboard or report page if I’m speaking to a CMO vs. a Product Marketing Supervisor. Why?

Depending upon the function of who you’re speaking to, they will comprehend and interpret data in various methods.

A CMO, for example, doesn’t require to understand the “in the weeds” data. They would like 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 link your information sources.

To add a port to your template, go to Resource at the top navigation, then click Manage included information sources. Then, you’ll click + Include An Information Source.

Screenshot from Looker Studio, December 2022

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

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

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

Screenshot from Looker Studio, December 2022 By using the adapters, it takes the manual jobs and syncs all data for you! It ‘d be impossible to note all the offered data sources here, but a few of the main ones I’ve utilized in the previous consist of: Supermetrics ports for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And much more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • information sources come
  • from third-party ports.
  • Remember that a lot of them: Extra expense. Can decrease reports. Metrics are often deprecated,

    • suggesting it is crucial
    • to remain on top of any changes to your report and restore metrics if needed. When adding an information source, you’ll be asked to license the connection in between accounts.

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

    see a complete data dump. While Looker Studio is completely personalized, this does not imply we need to be revealing all metrics offered. Does your customer appreciate return on marketing spend (ROAS)? Make certain to include

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

    By communicating the proper metrics and insights based on goals, it shows the client that you are listening to them. A win-win for everybody!

    How To Edit A Report

    Now that you’ve connected your data sources, it’s time to personalize that report!

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

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

    Screenshot from Google Advertisements, December 2022

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

    If you have actually selected a template like the one above, the first step is to alter the information source for each chart you wish to choose.

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

    information fields from your selected information source to alter any visualization. Not just can you develop and modify charts and tables in Looker Studio, but the capability to choose the look of a report is a game-changer for clients. It offers a sense of consistency throughout a company.

    A couple of methods to customize the design of your report include: Font style and background color. Changing comparison metric colors. Text padding to line up either

  • left, center, or right.
  • Pro suggestion: If you want to change all scorecards or
  • charts at the same time, merely select all at the exact same time prior to.
  • The design modifications will use to all choices. Another time-saver! In this example, I altered the report background

    , scorecard colors, and label fonts to develop 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 brand-new to Looker Studio

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

    create a report visual that fulfills your reader’s expectations. Don’t get prevented along the way! Including Report Filters An effective way to group multiple visualizations together is by adding report and page filters. For instance, if you wanted all tables and charts to change when modifying the date variety, you could add a Date Variety icon and set it to “Report Level.”

    This implies that if the report is consisted of several pages, whenever the date range is upgraded, all chart information updates together with it.

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

    Just browse to the toolbar and pick Add a control > Drop-down list and include 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 ="Select various filters for your information to drill down more granularly."/ > This allows you to filter the information on that specific page by project type.

    For instance, if you wished to show how Search carries out 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 pick Make report-level.

    Create A Chart

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

    The advantage of producing a customized chart is that you’re in complete control from the beginning of picturing precisely what matters most.

    The primary step is to consider who will read this report. Remember to include what information is necessary to them.

    Your chart ought to tell a story, and it depends on you to visualize that successfully.

    For example, you might want to include an “Introduction” table that includes the primary metrics or crucial performance indications (KPIs) that matter to them.

    To develop a chart, click “Insert,” which will show you all the various charts to select from. These consist of:

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

    In this example

    , I want to select a simple bullet chart to add to my CMO Summary page. The objective of this chart is to reveal if we fulfilled our

    regular monthly goal of app installs. The primary step is to choose the metric you’re measuring. In this case, I chose” Installs.” To make this bullet chart efficient, you require to add your target/goal. Make sure to check the box that states”Program Target.”Then, I input various range limits to show the progress.

    I kept the last range the same as the target worth. You can also put the last range as a greater value than your target, particularly if you surpass that target value.

    So, what does this chart state? It portrays 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 however didn’t rather make it.

    Sometimes easy charts are all you require to represent the needed information. Like all other components of Looker Studio, you can modify the style of any chart, table, or element as I did above.

    Sharing Reports

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

    • Invite people.
    • Arrange email delivery.
    • 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 Get Going With Looker Studio(The New Google Data Studio)"

    / > If you want to welcome individuals to access the report in genuine time, it is necessary to inspect the share settings. To include someone through email, it should be a Google account email. They can be included as a “Viewer”or an”Editor.”

    • Another information precaution Looker Studio added was how links to the report can be shared. You can pick from: Restricted. Just people who you have 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 discover and see(or modify– choose this setting carefully).

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

    • the right-hand corner: Avoid editors from altering access and including new individuals.
    • 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 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 Get Started With Looker Studio (The New Google Data Studio)"/ > I typically suggest checking the very first box to avoid editors from altering gain access to or including new people.

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

    Get Started With Looker Studio Now

    Ideally, this introduction to Google Looker Studio will empower you to feel more confident in producing personalized reports for your customers and brand names.

    More Resources:

    Included Image: RomanR/SMM Panel