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

Posted by

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

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

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

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

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

When this happens, we’re doing an injustice by investing more time “doing” and less time actually analyzing the data.

There has to be a much better way, right?

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

What Happened To Google Data Studio?

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

Many online marketers have actually utilized this tool for many years to unify and visualize data sets from multiple channels.

Today, 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 mentioned:

“We are unifying our business intelligence product family under the Looker umbrella, bringing together Looker, Data Studio, and core Google innovations like expert system (AI) and machine learning (ML). Looker Studio is still complimentary, and has the exact same functions as Data Studio.”

What Is Google Looker Studio?

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

It makes it possible for users to produce useful and visual dashboards that are easy to translate, share, and customize.

Basically, Looker Studio helps surpass data visualization. It’s intended to help marketers make more data-driven choices for their clients and brands alike.

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

Looker Studio Vs. Data Studio

While Looker Studio promotes many of the same functions as the previous Data Studio, the new name likewise brings brand-new functions.

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

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

The 2nd key distinction that a lot of marketers will take advantage of is the brand-new and better data combining functions from Looker.

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

Nevertheless, the biggest drawback of this was that the blending feature was based on a left outer sign up with and frequently didn’t blend information in such a way that online marketers required.

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

Sounds frustrating, right?

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 combine information from different sources.

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

Getting Going With Looker Studio

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

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

Looker Studio Templates

The first thing to do is to choose a template.

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

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

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

Screenshot from Looker Studio, December 2022 With any template, you have the capability to tailor products and fonts to develop a more constant report. The beauty of these reports is that several pages can be included. Do not seem like your whole marketing story needs to be

revealed on one page! Every customer has different needs, and their reporting needs to be no various. The most efficient path I have actually discovered is to use and fine-tune different control panels based upon who the

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

Depending upon the role of who you’re talking to, they will comprehend and translate data in different ways.

A CMO, for example, 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 meet their objectives.

Connect A Data Source

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

To add an adapter to your template, go to Resource at the top navigation, then click Manage included data sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

There are currently 24 different Google ports, such as Google Analytics, Google Ads, Google Sheets, BigQuery, and more.

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

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

Screenshot from Looker Studio, December 2022 By using the ports, it takes the manual jobs and syncs all data for you! It ‘d be impossible to list all the available data sources here, however a few of the main ones I’ve utilized in the previous consist of: Supermetrics adapters for: Buy Facebook Verified+Buy Instagram Verified Insights. Microsoft Advertising. Advertisement +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: Extra cost. Can slow down reports. Metrics are often deprecated,

    • implying it is essential
    • to stay on top of any modifications to your report and restore metrics if required. When including a data source, you’ll be asked to license the connection between accounts.

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

    see a total data dump. While Looker Studio is entirely adjustable, this does not suggest we need to be showing all metrics offered. Does your customer appreciate return on advertising spend (ROAS)? Be sure to consist of

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

    By conveying the correct 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 information sources, it’s time to personalize that report!

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

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

    Screenshot from Google Ads, December 2022

    You can begin 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 first step is to change the data source for each chart you want to pick.

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

    information fields from your selected information source to alter any visualization. Not just can you produce and edit charts and tables in Looker Studio, but the capability to choose the look and feel of a report is a game-changer for customers. It gives a sense of consistency throughout an organization.

    A few methods to personalize the design of your report include: Font and background color. Altering comparison metric colors. Text cushioning to align either

  • left, center, or right.
  • Pro tip: If you wish to change all scorecards or
  • charts at once, just choose all at the same time prior to.
  • The style changes will apply to all selections. Another time-saver! In this example, I altered the report background

    , scorecard colors, and label typefaces to produce brand name standard consistency:< img src=""alt =" A Thorough Guide To Begin With Looker Studio(The New Google Data Studio )"/ > If you’re brand-new to Looker Studio

    , it will require time, experimentation, and persistence to

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

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

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

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

    < img src="" alt ="Select different filters for your data to drill down more granularly."/ > This permits you to filter the data on that specific page by project type.

    For instance, if you wanted 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 want to make the filter report-level( suggesting the filter would appear on each page of your report), merely right-click the filter and select Make report-level.

    Create A Chart

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

    The advantage of creating a custom-made 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 be reading this report. Keep in mind to include what data is necessary to them.

    Your chart ought to narrate, and it depends on you to imagine that effectively.

    For example, you might wish to add an “Summary” table that incorporates the main metrics or essential efficiency indications (KPIs) that matter to them.

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

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

    In this example

    , I want to pick a simple bullet chart to contribute to my CMO Overview page. The goal of this chart is to reveal if we met our

    regular monthly goal of app installs. The first step is to pick the metric you’re determining. In this case, I picked” Installs.” To make this bullet chart effective, you require to include your target/goal. Ensure to inspect the box that says”Show Target.”Then, I input various variety limitations to reveal the development.

    I kept the last range the like the target value. You can likewise put the last range as a greater value than your target, particularly if you exceed 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 objective however didn’t quite make it.

    Often basic charts are all you need to represent the necessary 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 choices 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.Best SMM" alt ="A Thorough Guide To Start With Looker Studio(The New Google Data Studio)"

    / > If you wish to invite people to access the report in real time, it is very important to inspect the share settings. To add somebody via e-mail, it should be a Google account email. They can be added as a “Viewer”or an”Editor.”

    • Another information safety measure Looker Studio added was how links to the report can be shared. You can pick from: Limited. Just people who you have actually shared the report with can open the link. Unlisted. Anyone on the web with the link can view(or modify– pick 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 alternative to restrict sharing in the following alternatives. In the share settings, click the”equipment”icon in

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

    < img src ="//" alt="A Thorough Guide To Get Started With Looker Studio (The New Google Data Studio)" width="618" height="175" data-src=""/ >< img src="" alt="A Thorough Guide To Start With Looker Studio (The New Google Data Studio)"/ > I generally advise inspecting the very first box to prevent 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 modifications.

    Start With Looker Studio Now

    Hopefully, this intro to Google Looker Studio will empower you to feel more positive in producing personalized reports for your clients and brand names.

    More Resources:

    Featured Image: RomanR/Best SMM Panel