An In-Depth Guide To Begin With Looker Studio (The New Google Data Studio)

Posted by

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

While Google Data Studio made reporting much easier for lots of marketers, it definitely had its limitations.

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

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

Often, more time is spent pulling a report than providing actual insights.

When this occurs, we’re doing an injustice by investing more time “doing” and less time really evaluating the data.

There needs to be a much better method, right?

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

What Occurred To Google Data Studio?

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

Numerous marketers have actually utilized this tool for many years to combine and envision information sets from several channels.

Today, 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 announcement, Google specified:

“We are unifying our business intelligence item household under the Looker umbrella, uniting Looker, Data Studio, and core Google innovations like expert system (AI) and artificial intelligence (ML). Looker Studio is still complimentary, and has the exact same features 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 enables users to produce useful and visual dashboards that are simple to analyze, share, and tailor.

Essentially, Looker Studio assists go beyond information visualization. It’s aimed to help online marketers make more data-driven choices for their clients and brand names alike.

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

Looker Studio Vs. Data Studio

While Looker Studio promotes a number of the very same features as the previous Data Studio, the new name likewise brings new features.

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

Among the essential differences between Looker and Data Studio is the method data is modeled. Looker Studio utilizes LookML (Looker Modeling Language).

The second key difference that the majority of marketers will gain from is the brand-new and better data combining features from Looker.

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

However, the most significant downside of this was that the mixing function was based on a left outer join and frequently didn’t blend information in a manner that online marketers needed.

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

Sounds discouraging, 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 merge data from various sources.

The result? A much faster, more meaningful way to envision information from all your various marketing sources in an easy-to-digest format.

Getting Started With Looker Studio

There are a few key locations to ensure your very first Google Looker Studio report is a success. These include:

  • Choosing a design template or control panel.
  • Linking information sources.
  • Choosing metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to select a template.

To gain access to Looker Studio, go to Looker Studio utilizing your chosen Google Account. This should be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.

Looker Studio provides a variety of templates to get you began.

If you’re new to Looker Studio, it is essential to choose a design template based upon the kind of information being represented.

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to customize items and font styles to create a more constant report. The charm of these reports is that several pages can be added. Do not feel like your whole marketing story needs to be

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

designated audience is. For instance, I may produce a different control panel or report page if I’m speaking with a CMO vs. a Product Marketing Manager. Why?

Depending upon the role of who you’re speaking to, they will understand and translate information in various ways.

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

Link A Data Source

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

To add 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 presently 24 various Google connectors, such as Google Analytics, Google Advertisements, 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 ports, Looker Studio can connect over 650 different data sources from their partner ports!

Screenshot from Looker Studio, December 2022 By utilizing the connectors, it takes the manual tasks and synchronizes all data for you! It ‘d be difficult to note all the readily available data sources here, but a few of the primary ones I’ve used in the past consist of: Supermetrics ports for: Buy Facebook Verified Badge+Buy Instagram Verified Badge Insights. Microsoft Advertising. Ad +Google Analytics

  • Data. Position Tracking.
  • And much more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • information sources come
  • from third-party connectors.
  • Remember that a lot of them: Additional expense. Can decrease reports. Metrics are sometimes deprecated,

    • meaning it is vital
    • to remain on top of any changes to your report and rebuild metrics if required. When including 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 information dump. While Looker Studio is completely customizable, this does not imply we need to be showing all metrics offered. Does your customer appreciate return on marketing spend (ROAS)? Make sure to include

    metrics such as invest and revenue. How about total brand name awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, etc.

    By conveying the appropriate metrics and insights based upon goals, 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 linked your data sources, it’s time to tailor that report!

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

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

    Screenshot from Google Ads, December 2022

    You can start customizing your report by making use of the information 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 wish to pick.

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

    information fields from your chosen data source to alter any visualization. Not only can you develop 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 few ways to personalize the design of your report include: Typeface and background color. Altering comparison metric colors. Text padding to align either

  • left, center, or right.
  • Pro idea: If you wish to change all scorecards or
  • charts at once, just pick all at the very same time prior to.
  • The design modifications will use to all choices. Another time-saver! In this example, I altered the report background

    , scorecard colors, and label font styles to create brand standard 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 perseverance to

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

    This indicates that if the report is consisted of numerous pages, whenever the date variety is updated, all chart information updates together with it.

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

    Simply navigate to the toolbar and choose 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 ="Pick various filters for your information to drill down more granularly."/ > This permits you to filter the data on that particular page by project type.

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

    that filter. By default, filters included 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 select 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 benefit of developing a custom chart is that you’re in complete control from the start of envisioning precisely what matters most.

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

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

    For instance, you might wish to add an “Summary” table that encompasses the main metrics or key efficiency indicators (KPIs) that matter to them.

    To create a chart, click “Insert,” which will reveal you all the various charts to pick from. These consist of:

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

    In this example

    , I wish to pick a basic bullet chart to contribute to my CMO Overview page. The objective of this chart is to reveal if we fulfilled our

    monthly goal of app installs. The primary 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 certain to check package that states”Show Target.”Then, I input various range limits to show the progress.

    I kept the last range the same as the target worth. You can likewise put the last range as a greater value than your target, particularly if you surpass that target value.

    So, what does this chart state? It portrays that our goal was 5,500 app installs for the month of November. According to the bullet chart, they were close to striking their goal but didn’t quite make it.

    In some cases basic charts are all you need to represent the required data. Like all other aspects of Looker Studio, you can modify the style of any chart, table, or component as I did above.

    Sharing Reports

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

    • Welcome individuals.
    • Set up email 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 ="An Extensive Guide To Get Going With Looker Studio(The New Google Data Studio)"

    / > If you want to invite people to access the report in genuine time, it is essential to check the share settings. To add somebody via email, it should be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”

    • Another data 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 see(or edit– pick this setting carefully). Public. Anybody on the internet with the link can find and view(or edit– choose this setting thoroughly).

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

    • the right-hand corner: Avoid editors from altering gain access to and including brand-new individuals.
    • 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="An In-Depth Guide To Start 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 Start With Looker Studio (The New Google Data Studio)"/ > I typically suggest examining the very first box to prevent editors from altering access or including brand-new people.

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

    Get Started With Looker Studio Now

    Hopefully, this intro to Google Looker Studio will empower you to feel more confident in developing customized reports for your clients and brands.

    More Resources:

    Included Image: RomanR/Best SMM Panel