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 changed the widely known Google Data Studio brand name.

While Google Data Studio made reporting simpler for many online marketers, it certainly had its restrictions.

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

If you’re anything like me, you’re likely tired of spending hours upgrading the exact same spreadsheets every month.

Often, more time is invested pulling a report than providing actual insights.

When this happens, we’re doing a disservice by spending more time “doing” and less time in fact examining the data.

There has to be a much better method, right?

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

What Took Place To Google Data Studio?

Initially presented in beta mid-2016, Google Data Studio is a complimentary information visualization tool.

Lots of online marketers have actually utilized this tool for years to combine and imagine information sets from numerous channels.

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

Google officially rebranded its Information Studio item to be named Looker Studio in October 2022.

In their main statement, Google specified:

“We are unifying our service intelligence product family under the Looker umbrella, bringing together 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 functions as Data Studio.”

What Is Google Looker Studio?

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

It enables users to create informative and visual dashboards that are easy to analyze, share, and customize.

Basically, Looker Studio helps surpass information visualization. It’s aimed to help online marketers make more data-driven decisions for their customers and brands alike.

Currently, Looker Studio supports over 800 different information sources, along with 600+ information adapters.

Looker Studio Vs. Data Studio

While Looker Studio touts many of the very same features as the previous Data Studio, the brand-new name also brings new features.

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

Among the crucial distinctions in between Looker and Data Studio is the method data is designed. Looker Studio utilizes LookML (Looker Modeling Language).

The second key distinction that most online marketers will benefit from is the brand-new and enhanced data merging features from Looker.

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

Nevertheless, the greatest drawback of this was that the mixing function was based on a left outer sign up with and often didn’t mix data in a manner that online marketers required.

It was a tedious procedure that left lots of to spend more time by hand importing their information into a Google Sheet, then linking that source to Data Studio.

Sounds frustrating, best?

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

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

Getting Started With Looker Studio

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

  • Picking a design template or dashboard.
  • Linking data sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to choose a template.

To gain access to Looker Studio, check out Looker Studio using your chosen Google Account. This ought to be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.

Looker Studio supplies a wide array of templates to get you started.

If you’re brand-new to Looker Studio, it is very important to select a template based upon the kind of information being portrayed.

Screenshot from Looker Studio, December 2022 With any template, you have the ability to customize products and font styles to develop a more constant report. The charm of these reports is that numerous pages can be added. Do not feel like your whole marketing story requires to be

shown on one page! Every client has different requirements, and their reporting must be no various. The most efficient route I have found is to utilize and modify different dashboards based on who the

intended audience is. For instance, I may create a various control panel or report page if I’m talking to a CMO vs. an Item Marketing Supervisor. Why?

Depending on the role of who you’re talking with, they will understand and interpret information in various methods.

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

Connect A Data Source

Now that you have actually selected a template, it’s time to link your information sources.

To include an adapter to your template, go to Resource on top navigation, then click Manage added data sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

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

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

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

Screenshot from Looker Studio, December 2022 By using the adapters, it takes the manual tasks and syncs all data for you! It ‘d be difficult to list all the available information sources here, however some of the primary ones I’ve used in the previous consist of: Supermetrics connectors for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Advertising. Ad +Google Analytics

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

    • meaning it is vital
    • to stay on top of any modifications to your report and reconstruct metrics if needed. When adding an information source, you’ll be asked to license the connection in between accounts.

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

    see a complete data dump. While Looker Studio is completely personalized, this does not imply we must be revealing all metrics readily available. Does your customer care about return on marketing spend (ROAS)? Be sure to include

    metrics such as invest and revenue. How about overall brand awareness? Consist of pre-click metrics such as impressions, clicks, CTR, view rate, etc.

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

    How To Modify A Report

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

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

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

    Screenshot from Google Ads, December 2022

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

    If you have actually picked a design template like the one above, the primary step is to change the data source for each chart you want to select.

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

    information fields from your picked data source to alter any visualization. Not just can you produce and edit charts and tables in Looker Studio, but the capability to choose the feel and look of a report is a game-changer for clients. It provides a sense of consistency across a company.

    A couple of ways to individualize the design of your report consist of: Font and background color. Altering comparison metric colors. Text padding to line up either

  • left, center, or right.
  • Pro idea: If you wish to change all scorecards or
  • charts at the same time, simply pick all at the very same time prior to.
  • The style changes will use to all choices. Another time-saver! In this example, I altered the report background

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

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

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

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

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

    Merely browse to the toolbar and pick Add 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 ="Pick different filters for your information to drill down more granularly."/ > This permits you to filter the information on that specific page by campaign type.

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

    that filter. By default, filters added are at a page level. If you wish to make the filter report-level( suggesting 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’ve gotten comfortable with your Looker Studio experience, let’s dive into how to develop a chart from scratch.

    The advantage of creating a customized chart is that you remain in full control from the start of visualizing precisely what matters most.

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

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

    For instance, you might wish to add an “Summary” table that includes the primary metrics or essential efficiency indicators (KPIs) that matter to them.

    To create 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 want to select a basic bullet chart to add to my CMO Summary page. The objective of this chart is to reveal if we satisfied our

    regular monthly goal of app installs. The initial step is to select the metric you’re determining. In this case, I chose” Installs.” To make this bullet chart reliable, you require to include your target/goal. Make sure to examine the box that states”Show Target.”Then, I input different variety limits to show the progress.

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

    So, what does this chart state? 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.

    Sometimes easy charts are all you require to represent the essential information. Like all other aspects of Looker Studio, you can customize the style of any chart, table, or aspect as I did above.

    Sharing Reports

    The following alternatives are offered for sharing a Looker Studio report:

    • Invite individuals.
    • 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 ="A Thorough Guide To Get Started With Looker Studio(The New Google Data Studio)"

    / > If you want to invite individuals to access the report in genuine time, it is very important to inspect the share settings. To add someone through email, it should be a Google account e-mail. They can be included as a “Audience”or an”Editor.”

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

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

    • the right-hand corner: Avoid editors from changing gain access to and adding new people.
    • 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="An Extensive 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="A Thorough Guide To Get Started With Looker Studio (The New Google Data Studio)"/ > I generally recommend checking the first box to avoid editors from altering gain access to or including new people.

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

    Get Going With Looker Studio Now

    Ideally, this intro to Google Looker Studio will empower you to feel more positive in creating individualized reports for your clients and brand names.

    More Resources:

    Included Image: RomanR/SMM Panel