An In-Depth 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 widely known Google Data Studio brand name.

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

As a brand name’s marketing strategy progresses and becomes more complex, so does the sophistication of its reporting needs.

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

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

When this happens, we’re doing a disservice by spending more time “doing” and less time actually analyzing the information.

There has to be a much better way, right?

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

What Took Place To Google Data Studio?

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

Numerous marketers have actually used this tool for years to merge and imagine information sets from several channels.

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

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

In their main announcement, Google mentioned:

“We are unifying our organization intelligence product family under the Looker umbrella, uniting Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and artificial intelligence (ML). Looker Studio is still totally free, and has the same functions as Information Studio.”

What Is Google Looker Studio?

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

It makes it possible for users to produce helpful and visual dashboards that are easy to analyze, share, and personalize.

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

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

Looker Studio Vs. Data Studio

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

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

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

The second key difference that many online marketers will gain from is the brand-new and improved information merging functions from Looker.

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

Nevertheless, the greatest disadvantage of this was that the mixing function was based on a left outer join and frequently didn’t mix data in a manner that online marketers required.

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

Sounds aggravating, right?

Looker Studio, on the other hand, needs SQL databases to integrate any source. This implies that raw information is passed into a database, making it much easier for Looker to combine information from different sources.

The outcome? A much faster, more meaningful method to envision information from all your different marketing sources in an easy-to-digest format.

Getting Started With Looker Studio

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

  • Choosing a template or dashboard.
  • Connecting information 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, visit Looker Studio using your chosen Google Account. This need to be the account that you access your Google Analytics, Search Console, Google Advertisements, etc.

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

If you’re new to Looker Studio, it is very important to select a design template based on the kind of information being represented.

Screenshot from Looker Studio, December 2022 With any template, you have the capability to customize items and fonts to produce a more constant report. The appeal of these reports is that multiple pages can be added. Do not feel like your entire marketing story requires to be

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

desired audience is. For instance, I might develop a different control panel or report page if I’m speaking with a CMO vs. a Product Marketing Supervisor. Why?

Depending upon the role of who you’re speaking with, they will comprehend and interpret information in various methods.

A CMO, for example, does not need to know the “in the weeds” data. They want to know what channels are working, what’s not, and if they’re on track to fulfill their objectives.

Connect A Data Source

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

To include a connector to your template, go to Resource at the top navigation, then click Handle included information sources. Then, you’ll click + Add An Information Source.

Screenshot from Looker Studio, December 2022

There are currently 24 various 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 adapters, Looker Studio can connect over 650 various information sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By using the connectors, it takes the manual jobs and synchronizes all data for you! It ‘d be impossible to note all the offered data sources here, however a few of the primary ones I’ve used in the previous include: Supermetrics connectors for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Marketing. Ad +Google Analytics

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

    • implying it is crucial
    • to remain on top of any changes to your report and reconstruct 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 real, the worst is when customers open reports and

    see a total information dump. While Looker Studio is completely customizable, 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 earnings. How about overall brand awareness? Consist of pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

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

    How To Edit A Report

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

    Let’s evaluate this Google Advertisements design template as an example.

    Initially, you’ll want to ensure you remain in the “Edit” mode and not “View.”

    Screenshot from Google Advertisements, December 2022

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

    If you have actually picked a design template like the one above, the initial step is to alter 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

    data fields from your selected data source to change any visualization. Not only can you develop and modify charts and tables in Looker Studio, but the capability to select the feel and look of a report is a game-changer for customers. It provides a sense of consistency throughout a company.

    A few methods to personalize the design of your report include: Typeface and background color. Changing comparison metric colors. Text cushioning to line up either

  • left, center, or right.
  • Pro pointer: If you want to change all scorecards or
  • charts simultaneously, merely select all at the exact same time prior to.
  • The style changes will apply to all selections. Another time-saver! In this example, I changed the report background

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

    , it will require time, experimentation, and patience to

    develop a report visual that satisfies your reader’s expectations. Don’t get dissuaded along the way! Including Report Filters An efficient way to group multiple visualizations together is by including report and page filters. For example, if you desired all tables and charts to alter when modifying the date range, you could add a Date Range icon and set it to “Report Level.”

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

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

    Just navigate to the toolbar and select 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 different filters for your information to drill down more granularly."/ > This permits you to filter the information on that particular page by project type.

    For example, if you wished to demonstrate how Browse performs 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( meaning the filter would appear on each page of your report), just right-click the filter and choose Make report-level.

    Produce A Chart

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

    The advantage of producing a custom chart is that you’re in complete control from the start of visualizing precisely what matters most.

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

    Your chart must tell a story, and it depends on you to picture that effectively.

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

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

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

    In this example

    , I wish to pick a simple bullet chart to add to my CMO Introduction page. The goal of this chart is to show if we met our

    regular monthly goal of app installs. The initial step is to pick the metric you’re measuring. In this case, I chose” Installs.” To make this bullet chart effective, you require to add your target/goal. Make sure to inspect the box that says”Show Target.”Then, I input various variety limitations to show the progress.

    I kept the last variety the like the target value. You can also put the last variety as a greater worth than your target, specifically if you go beyond 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 striking their objective however didn’t quite make it.

    In some cases simple charts are all you need to represent the required information. Like all other components of Looker Studio, you can modify the design of any chart, table, or element as I did above.

    Sharing Reports

    The following choices are available for sharing a Looker Studio report:

    • Invite individuals.
    • Arrange email delivery.
    • 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 ="An In-Depth Guide To Get Started With Looker Studio(The New Google Data Studio)"

    / > If you wish to welcome people to access the report in real time, it’s important to inspect the share settings. To add someone via email, it should be a Google account email. They can be included as a “Viewer”or an”Editor.”

    • Another information safety measure Looker Studio included was how links to the report can be shared. You can select from: Restricted. Only individuals who you have actually shared the report with can open the link. Unlisted. Anyone on the internet with the link can see(or edit– choose this setting thoroughly). Public. Anybody on the internet with the link can discover and see(or edit– choose this setting thoroughly).

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

    • the right-hand corner: Prevent editors from changing gain access to and including brand-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="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 Going With Looker Studio (The New Google Data Studio)"/ > I normally advise inspecting the first box to prevent editors from changing gain access to or including new people.

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

    Get Going With Looker Studio Now

    Ideally, this introduction to Google Looker Studio will empower you to feel more confident in developing tailored reports for your customers and brands.

    More Resources:

    Featured Image: RomanR/Best SMM Panel