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

Posted by

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

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

As a brand name’s marketing method progresses and becomes more intricate, so does the elegance of its reporting needs.

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

Often, more time is invested pulling a report than supplying real insights.

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

There needs to be a much better way, right?

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

What Occurred To Google Data Studio?

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

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

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

Google officially rebranded its Data Studio item to be called Looker Studio in October 2022.

In their official statement, Google specified:

“We are unifying our service intelligence item family under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and machine learning (ML). Looker Studio is still free, and has the same features as Information Studio.”

What Is Google Looker Studio?

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

It enables users to develop helpful and visual control panels that are simple to interpret, share, and personalize.

Basically, Looker Studio assists go beyond data visualization. It’s aimed to assist marketers make more data-driven choices for their customers and brands alike.

Currently, Looker Studio supports over 800 various data sources, together with 600+ information adapters.

Looker Studio Vs. Data Studio

While Looker Studio promotes a lot of the same functions as the former Data Studio, the brand-new name likewise brings new functions.

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

One of the key differences between Looker and Data Studio is the method information is modeled. Looker Studio uses LookML (Looker Modeling Language).

The 2nd key distinction that the majority of online marketers will gain from is the new and enhanced data combining features from Looker.

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

However, the greatest disadvantage of this was that the blending feature was based on a left outer join and often didn’t mix data in such a way that marketers required.

It was a laborious process that left many to invest more time manually importing their data 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 entered a database, making it much easier for Looker to combine data from different sources.

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

Getting Going With Looker Studio

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

  • Selecting a template or dashboard.
  • Connecting information sources.
  • Choosing metrics that matter.
  • Sharing reports.

Looker Studio Templates

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

To access Looker Studio, check out Looker Studio using your preferred Google Account. This need to be the account that you access your Google Analytics, Search Console, Google Advertisements, and so on.

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

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

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to personalize products and fonts to develop a more constant report. The beauty of these reports is that multiple pages can be added. Do not feel like your entire marketing story needs to be

revealed on one page! Every customer has different requirements, and their reporting ought to be no different. The most efficient path I have found is to utilize and modify various dashboards based upon who the

intended audience is. For instance, I may develop a different dashboard or report page if I’m talking to a CMO vs. a Product Marketing Supervisor. Why?

Depending upon the function of who you’re talking with, they will understand and analyze information in different ways.

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

Link A Data Source

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

To add a connector to your design template, go to Resource on top navigation, then click Manage added information sources. Then, you’ll click + Include An Information Source.

Screenshot from Looker Studio, December 2022

There are presently 24 various Google adapters, such as Google Analytics, Google Ads, 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 link over 650 different data sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By utilizing the ports, it takes the manual jobs and synchronizes all information for you! It ‘d be impossible to list all the offered information sources here, however a few of the main ones I have actually utilized in the previous include: Supermetrics ports for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Advertising. Advertisement +Google Analytics

  • Data. Position Tracking.
  • And a lot more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • information sources come
  • from third-party adapters.
  • Keep in mind that much of them: Additional cost. Can slow down reports. Metrics are often deprecated,

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

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

    see a total information dump. While Looker Studio is completely adjustable, this does not indicate we must be revealing all metrics offered. Does your customer care about return on marketing invest (ROAS)? Be sure to consist of

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

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

    How To Modify A Report

    Now that you’ve linked your information sources, it’s time to tailor that report!

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

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

    Screenshot from Google Advertisements, December 2022

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

    If you’ve picked a template like the one above, the primary step is to change the information source for each chart you want to choose.

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

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

    A couple of ways to personalize the design of your report include: Typeface and background color. Changing comparison metric colors. Text cushioning to align either

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

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

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

    create a report visual that fulfills your reader’s expectations. Do not get discouraged along the method! Including Report Filters An effective method to group numerous visualizations together is by including report and page filters. For example, 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 suggests that if the report is consisted of multiple pages, whenever the date variety is upgraded, all chart information updates along with it.

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

    Merely browse to the toolbar and choose Include a control > Drop-down list and add 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 allows you to filter the information on that specific page by campaign type.

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

    Produce A Chart

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

    The advantage of creating a custom-made chart is that you’re in complete control from the beginning of picturing exactly what matters most.

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

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

    For instance, you might wish to add an “Overview” table that incorporates the main metrics or key performance signs (KPIs) that matter to them.

    To create 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.
    • Much 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 reveal if we met our

    month-to-month objective of app installs. The first 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. Ensure to inspect package that states”Show Target.”Then, I input different variety limitations to reveal the progress.

    I kept the last variety the like the target worth. You can also put the last range as a greater value than your target, especially if you go beyond that target worth.

    So, what does this chart say? It represents 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 but didn’t quite make it.

    Sometimes easy charts are all you need to represent the required data. Like all other components of Looker Studio, you can modify the design of any chart, table, or aspect as I did above.

    Sharing Reports

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

    • Invite individuals.
    • Schedule e-mail 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 Extensive Guide To Begin With Looker Studio(The New Google Data Studio)"

    / > If you wish to invite individuals to access the report in genuine time, it is necessary to examine the share settings. To include someone through e-mail, it should be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”

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

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

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

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

    Get Started With Looker Studio Now

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

    More Resources:

    Featured Image: RomanR/Best SMM Panel