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

Posted by

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

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

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

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

Sometimes, more time is spent pulling a report than providing real insights.

When this takes place, we’re doing an injustice by spending more time “doing” and less time really evaluating the information.

There has to be a better way, right?

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

What Took Place To Google Data Studio?

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

Lots of marketers have actually utilized this tool for years to unify and envision data sets from multiple channels.

And 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 stated:

“We are unifying our business intelligence item family under the Looker umbrella, combining Looker, Data Studio, and core Google innovations like expert system (AI) and artificial intelligence (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) syncs all of your information sources into one combined reporting experience.

It enables users to produce informative and visual control panels that are easy to analyze, share, and customize.

Basically, Looker Studio helps surpass data visualization. It’s intended to help marketers make more data-driven decisions for their clients and brand names alike.

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

Looker Studio Vs. Data Studio

While Looker Studio touts many of the very same features as the previous Data Studio, the new name also brings brand-new functions.

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

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

The 2nd crucial difference that most online marketers will gain from is the brand-new and improved information merging features from Looker.

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

Nevertheless, the most significant drawback of this was that the mixing feature was based upon a left outer join and frequently didn’t blend information in a manner that online marketers required.

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

Sounds discouraging, ideal?

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

The outcome? A faster, 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 key locations to guarantee your first Google Looker Studio report is a success. These consist of:

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

Looker Studio Templates

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

To gain access to Looker Studio, go to Looker Studio utilizing your preferred Google Account. This need to be the account that you access your Google Analytics, Search Console, Google Advertisements, etc.

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

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

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to personalize products and fonts to develop a more consistent report. The beauty of these reports is that multiple pages can be added. Don’t seem like your whole marketing story needs to be

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

intended 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 Manager. Why?

Depending upon the function of who you’re speaking to, they will comprehend and translate data in various methods.

A CMO, for instance, does not need to know 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.

Connect A Data Source

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

To add an adapter to your template, go to Resource at the top navigation, then click Manage added data sources. Then, you’ll click + Add An Information Source.

Screenshot from Looker Studio, December 2022

There are currently 24 various Google ports, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

However, you’re most likely utilizing other platforms like social media, third-party tools, CRM systems, and more.

For those non-Google connectors, Looker Studio can connect over 650 different information sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By utilizing the adapters, it takes the manual jobs and synchronizes all data for you! It ‘d be impossible to list all the offered information sources here, however a few of the main ones I have actually used in the past consist of: Supermetrics adapters for: Buy Facebook Verification Badge+Buy Instagram Verification Badge 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 ports.
  • Bear in mind that much of them: Additional expense. Can slow down reports. Metrics are often deprecated,

    • indicating it is crucial
    • to remain on top of any modifications to your report and rebuild metrics if required. When including an information source, you’ll be asked to license the connection in between accounts.

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

    see a complete information dump. While Looker Studio is entirely adjustable, this does not indicate we must be showing all metrics offered. Does your customer care about return on advertising invest (ROAS)? Make sure to include

    metrics such as invest and income. 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 on goals, it reveals the customer that you are listening to them. A win-win for everybody!

    How To Edit A Report

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

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

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

    Screenshot from Google Advertisements, December 2022

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

    If you have actually selected a design template like the one above, the primary step is to change the data source for each chart you wish to pick.

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

    data fields from your picked information source to alter any visualization. Not just can you produce and edit charts and tables in Looker Studio, however the ability to pick the look of a report is a game-changer for customers. It offers a sense of consistency throughout a company.

    A couple of ways to personalize the style of your report consist of: Font style 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 at the same time, just select all at the very same time prior to.
  • The design modifications will use to all selections. Another time-saver! In this example, I altered 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 take some time, trial and error, and perseverance to

    create a report visual that satisfies your reader’s expectations. Don’t get dissuaded along the way! Including Report Filters An effective way to group several visualizations together is by adding report and page filters. For instance, if you desired all tables and charts to change when editing the date range, you might add a Date Variety icon and set it to “Report Level.”

    This means that if the report is comprised of numerous pages, whenever the date variety is upgraded, all chart data updates alongside it.

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

    Simply browse 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 enables you to filter the information on that specific page by campaign type.

    For instance, if you wished to show 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( indicating the filter would appear on each page of your report), simply right-click the filter and choose Make report-level.

    Create A Chart

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

    The advantage of developing a custom chart is that you remain in complete control from the start of picturing precisely what matters most.

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

    Your chart needs to tell a story, and it depends on you to visualize that effectively.

    For example, you may want to include an “Introduction” table that includes the primary metrics or crucial efficiency indications (KPIs) that matter to them.

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

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

    In this example

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

    monthly goal of app installs. The primary step is to pick the metric you’re determining. In this case, I picked” Installs.” To make this bullet chart effective, you require to add your target/goal. Make sure to check package that states”Show Target.”Then, I input different range limitations to show the progress.

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

    So, what does this chart state? It represents that our objective 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.

    Often basic charts are all you require to represent the essential information. Like all other components of Looker Studio, you can modify 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:

    • Welcome individuals.
    • Schedule e-mail delivery.
    • Get report link.
    • Embed report.
    • Download report.

    < img src="https://cdn.SMM Panel.com/wp-content/uploads/2022/12/looker-studio-sharing-options-6394dddd6bc0e-sej.png" alt ="An In-Depth Guide To Start With Looker Studio(The New Google Data Studio)"

    / > If you wish to welcome people to access the report in real time, it is very important to inspect the share settings. To include somebody via e-mail, it should be a Google account email. They can be added as a “Audience”or an”Editor.”

    • Another information precaution Looker Studio added was how links to the report can be shared. You can pick from: Restricted. Just individuals who you have shared the report with can open the link. Unlisted. Anyone on the internet with the link can see(or modify– select this setting carefully). Public. Anybody on the internet with the link can discover and see(or modify– select this setting thoroughly).

    Another cool feature Google added is the choice to limit 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 including 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="An Extensive 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 Begin With Looker Studio (The New Google Data Studio)"/ > I typically suggest inspecting the very first box to prevent editors from changing gain access to or including brand-new individuals.

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

    Start With Looker Studio Now

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

    More Resources:

    Featured Image: RomanR/SMM Panel