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

Posted by

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

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

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

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

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

When this takes place, we’re doing a disservice by investing more time “doing” and less time really examining the data.

There has to be a better way, right?

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

What Occurred To Google Data Studio?

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

Lots of online marketers have utilized this tool for many years to unify and imagine data sets from numerous 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 called Looker Studio in October 2022.

In their official announcement, Google mentioned:

“We are unifying our company intelligence item household under the Looker umbrella, combining Looker, Data Studio, and core Google innovations like artificial intelligence (AI) and machine learning (ML). Looker Studio is still complimentary, and has the very same functions as Data Studio.”

What Is Google Looker Studio?

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

It makes it possible for users to produce informative and visual control panels that are easy to translate, share, and personalize.

Essentially, Looker Studio assists go beyond information visualization. It’s intended to assist online marketers make more data-driven decisions for their clients and brands alike.

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

Looker Studio Vs. Data Studio

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

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

Among the key distinctions between Looker and Data Studio is the way data is modeled. Looker Studio utilizes LookML (Looker Modeling Language).

The 2nd crucial difference that the majority of marketers will take advantage of is the new and enhanced data combining functions from Looker.

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

However, the most significant downside of this was that the blending feature was based on a left outer join and frequently didn’t blend information in a manner that marketers required.

It was a tiresome procedure that left numerous to spend more time by hand importing their information into a Google Sheet, then connecting that source to Data Studio.

Sounds aggravating, ideal?

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

The result? A much faster, more significant way 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 locations to guarantee your first Google Looker Studio report is a success. These include:

  • Picking a template or control panel.
  • Linking data sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

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

To gain access to Looker Studio, check out Looker Studio utilizing your preferred Google Account. This ought to be the account that you access your Google Analytics, Search Console, Google Ads, and so on.

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

If you’re new to Looker Studio, it is important to pick a template based upon the type of information being depicted.

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

revealed on one page! Every client has various needs, and their reporting ought to be no different. The most efficient route I have found is to use and modify different dashboards based upon who the

desired audience is. For instance, I may develop a different control panel or report page if I’m talking with a CMO vs. an Item Marketing Manager. Why?

Depending on the role of who you’re talking to, they will comprehend and translate information in different methods.

A CMO, for example, doesn’t require 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 design template, it’s time to link your information sources.

To add an adapter to your template, go to Resource on top navigation, then click Handle 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.

Nevertheless, you’re most 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 utilizing the adapters, it takes the manual tasks and syncs all data for you! It ‘d be impossible to list all the available data sources here, however some of the main ones I’ve used in the previous include: Supermetrics adapters for: Buy Facebook Verification+Buy Instagram Verification 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.
  • Keep in mind that many of them: Extra cost. Can decrease reports. Metrics are often deprecated,

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

    Picking 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 totally adjustable, this does not suggest we need to be showing all metrics readily available. Does your customer care about return on marketing invest (ROAS)? Be sure to include

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

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

    How To Modify A Report

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

    Let’s review this Google Ads design template as an example.

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

    Screenshot from Google Ads, December 2022

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

    If you have actually chosen a template like the one above, the initial step is to alter the data source for each chart you wish to select.

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

    information fields from your selected data source to change any visualization. Not only can you create and edit charts and tables in Looker Studio, however the ability to choose the look of a report is a game-changer for clients. It offers a sense of consistency across a company.

    A few ways to customize the style of your report include: Font style and background color. Changing contrast metric colors. Text padding to line up either

  • left, center, or right.
  • Pro idea: If you want to alter all scorecards or
  • charts simultaneously, merely choose all at the exact same time before.
  • The design 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 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 Get Started With Looker Studio(The New Google Data Studio )"/ > If you’re new to Looker Studio

    , it will take some time, trial and error, and patience to

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

    This implies that if the report is comprised of numerous pages, whenever the date range is updated, all chart information updates alongside it.

    For example, if you wanted to dive into Campaign Type performance, 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 “Campaign type” as your filter.

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

    For example, if you wanted to show how Search carries out compared to Buy YouTube Subscribers, you ‘d pick from the dropdown in

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

    Produce A Chart

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

    The benefit of developing a custom chart is that you’re in full control from the start of picturing exactly what matters most.

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

    Your chart should narrate, and it depends on you to picture that effectively.

    For example, you may wish to add an “Summary” table that encompasses the primary metrics or key efficiency signs (KPIs) that matter to them.

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

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

    In this example

    , I wish to choose a basic bullet chart to contribute to my CMO Summary page. The goal of this chart is to reveal if we met our

    regular monthly objective of app installs. The primary step is to select the metric you’re measuring. In this case, I selected” Installs.” To make this bullet chart effective, you require to add your target/goal. Make certain to examine package that states”Program Target.”Then, I input various range limits to reveal the development.

    I kept the last range the like the target worth. You can likewise put the last variety as a higher worth than your target, specifically if you exceed 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 hitting their goal however didn’t rather make it.

    Often basic charts are all you need to represent the necessary information. Like all other aspects of Looker Studio, you can customize the style of any chart, table, or component as I did above.

    Sharing Reports

    The following alternatives are available 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 Panel.com/wp-content/uploads/2022/12/looker-studio-sharing-options-6394dddd6bc0e-sej.png" alt ="A Thorough Guide To Get Going With Looker Studio(The New Google Data Studio)"

    / > If you want to invite individuals to access the report in real time, it is very important to inspect the share settings. To add somebody by means of e-mail, it should be a Google account e-mail. They can be added as a “Audience”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 individuals who you have shared the report with can open the link. Unlisted. Anybody on the internet with the link can view(or edit– pick this setting thoroughly). Public. Anyone 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 alternatives. In the share settings, click on the”gear”icon in

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

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

    Start With Looker Studio Now

    Ideally, this introduction to Google Looker Studio will empower you to feel more confident in creating individualized reports for your clients and brands.

    More Resources:

    Included Image: RomanR/Best SMM Panel