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

Posted by

If you have not heard, Looker Studio has actually changed the well-known Google Data Studio brand.

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

As a brand name’s marketing method develops and becomes more complicated, so does the sophistication of its reporting needs.

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

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

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

There has to be a much better method, right?

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

What Took Place To Google Data Studio?

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

Many marketers have used this tool for several years to unify and envision information sets from several channels.

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

Google officially rebranded its Data Studio product to be named Looker Studio in October 2022.

In their official announcement, Google stated:

“We are unifying our organization intelligence item household under the Looker umbrella, combining Looker, Data Studio, and core Google technologies like expert system (AI) and artificial intelligence (ML). Looker Studio is still complimentary, and has the very same features 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 allows users to create helpful and visual control panels that are easy to interpret, share, and customize.

Essentially, Looker Studio assists exceed data visualization. It’s aimed to help marketers make more data-driven decisions for their clients and brands alike.

Presently, Looker Studio supports over 800 different data sources, along with 600+ data ports.

Looker Studio Vs. Data Studio

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

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

Among the crucial differences in between Looker and Data Studio is the way information is designed. Looker Studio utilizes LookML (Looker Modeling Language).

The 2nd crucial distinction that a lot of marketers will take advantage of is the new and better information combining features from Looker.

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

However, the most significant downside of this was that the blending function was based on a left external join and typically didn’t mix data in a way that online marketers needed.

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

Sounds discouraging, best?

Looker Studio, on the other hand, needs SQL databases to incorporate any source. This suggests that raw information is passed into a database, making it a lot easier for Looker to merge data from various sources.

The result? A quicker, more meaningful way to imagine data from all your different marketing sources in an easy-to-digest format.

Getting Going With Looker Studio

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

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

Looker Studio Templates

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

To access 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 variety of templates to get you started.

If you’re brand-new to Looker Studio, it is important to select a template based upon the type of data being depicted.

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to customize items and fonts to create a more constant report. The beauty of these reports is that several pages can be added. Don’t feel like your whole marketing story requires to be

shown on one page! Every client has various needs, and their reporting must be no various. The most effective path I have actually found is to utilize and tweak different control panels based upon who the

designated audience is. For instance, I may produce a various control panel or report page if I’m talking to a CMO vs. a Product Marketing Supervisor. Why?

Depending on the function of who you’re speaking with, they will comprehend and translate data in different ways.

A CMO, for example, doesn’t require to understand the “in the weeds” data. They would like to know what channels are working, what’s not, and if they’re on track to satisfy their objectives.

Connect A Data Source

Now that you have actually selected a design template, it’s time to connect your data sources.

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

Screenshot from Looker Studio, December 2022

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

Screenshot from Looker Studio, December 2022 By using the ports, it takes the manual jobs and syncs all information for you! It ‘d be difficult to note all the offered data sources here, however a few of the main ones I have actually used in the previous consist of: Supermetrics connectors for: Buy Facebook Verified+Buy Instagram Verified Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • data sources come
  • from third-party adapters.
  • Remember that a lot of them: Additional expense. Can decrease reports. Metrics are in some cases deprecated,

    • suggesting it is crucial
    • to remain on top of any modifications to your report and restore metrics if required. When including an information source, you’ll be asked to authorize the connection 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 entirely personalized, this does not imply we need to be revealing all metrics available. Does your customer care about return on advertising invest (ROAS)? Make certain to include

    metrics such as spend and revenue. How about total brand awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By conveying the correct metrics and insights based on objectives, it shows the customer that you are listening to them. A win-win for everybody!

    How To Edit A Report

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

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

    First, you’ll wish to ensure you’re in the “Edit” mode and not “View.”

    Screenshot from Google Advertisements, December 2022

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

    If you’ve selected a template like the one above, the first step is to change the data source for each chart you want to select.

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

    information fields from your selected information source to change any visualization. Not just can you create and modify charts and tables in Looker Studio, but the capability to choose the look and feel of a report is a game-changer for clients. It offers a sense of consistency throughout a company.

    A few methods to individualize the design of your report include: Typeface and background color. Altering comparison metric colors. Text padding to line up either

  • left, center, or right.
  • Pro tip: If you wish to alter all scorecards or
  • charts at the same time, merely choose all at the exact same time prior to.
  • The design modifications will use to all choices. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label font styles to create 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 Begin With Looker Studio(The New Google Data Studio )"/ > If you’re brand-new to Looker Studio

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

    produce a report visual that fulfills your reader’s expectations. Don’t get prevented along the method! Including Report Filters An efficient method to group numerous visualizations together is by including report and page filters. For example, if you desired all tables and charts to alter when editing the date range, you might add a Date Variety icon and set it to “Report Level.”

    This suggests that if the report is consisted of several pages, whenever the date range is updated, all chart information updates together 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 select Include 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 ="Choose different filters for your data to drill down more granularly."/ > This allows you to filter the information on that particular page by project type.

    For instance, if you wanted to demonstrate how Browse carries out 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( indicating the filter would appear on each page of your report), simply 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 benefit of producing a custom-made chart is that you’re in full control from the beginning 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 should tell a story, and it’s up to you to envision that successfully.

    For instance, you may wish to add an “Summary” table that incorporates the primary metrics or essential performance signs (KPIs) that matter to them.

    To create a chart, click “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 pick an easy bullet chart to add to my CMO Summary page. The goal of this chart is to reveal if we satisfied our

    monthly goal of app installs. The initial step is to choose the metric you’re determining. In this case, I picked” Installs.” To make this bullet chart efficient, you need to add your target/goal. Ensure to inspect the box that says”Show Target.”Then, I input different range limitations to reveal the development.

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

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

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

    Sharing Reports

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

    • Invite people.
    • 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 Started With Looker Studio(The New Google Data Studio)"

    / > If you want to welcome individuals to access the report in genuine time, it is necessary to inspect the share settings. To add somebody through e-mail, it needs to be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”

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

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

    • the right-hand corner: Avoid editors from changing access 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 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="An Extensive Guide To Begin With Looker Studio (The New Google Data Studio)"/ > I generally suggest inspecting the first box to avoid editors from altering gain access to or adding brand-new individuals.

    By doing so, it allows us to keep control of the report settings and the integrity 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 customers and brand names.

    More Resources:

    Featured Image: RomanR/Best SMM Panel