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 replaced the popular Google Data Studio brand.

While Google Data Studio made reporting easier for numerous marketers, it certainly had its restrictions.

As a brand’s marketing strategy develops and ends up being more intricate, so does the sophistication of its reporting requirements.

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

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 actually evaluating the data.

There has to be a better method, right?

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

What Took Place To Google Data Studio?

Initially presented in beta mid-2016, Google Data Studio is a totally free information visualization tool.

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

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

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

In their official announcement, Google stated:

“We are unifying our service intelligence product household under the Looker umbrella, uniting Looker, Data Studio, and core Google innovations like expert system (AI) and machine learning (ML). Looker Studio is still complimentary, and has the exact same functions as Data Studio.”

What Is Google Looker Studio?

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

It allows users to produce helpful and visual dashboards that are simple to analyze, share, and customize.

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

Presently, Looker Studio supports over 800 various data sources, together with 600+ information ports.

Looker Studio Vs. Data Studio

While Looker Studio promotes much of the same features as the previous Data Studio, the brand-new name likewise brings new functions.

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

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

The second crucial distinction that the majority of online marketers will gain from is the brand-new and enhanced data merging features from Looker.

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

Nevertheless, the greatest disadvantage of this was that the mixing feature was based upon a left outer sign up with and typically didn’t mix data in a way that marketers needed.

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

Sounds aggravating, best?

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

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

Starting With Looker Studio

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

  • Picking a template or dashboard.
  • Linking data sources.
  • Choosing metrics that matter.
  • Sharing reports.

Looker Studio Templates

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

To gain access to Looker Studio, visit Looker Studio utilizing your chosen Google Account. This must be the account that you access your Google Analytics, Search Console, Google Ads, and so on.

Looker Studio provides a wide range of templates to get you started.

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

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

revealed on one page! Every client has different needs, and their reporting ought to be no different. The most efficient route I have found is to utilize and fine-tune different dashboards based upon who the

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

Depending upon the role of who you’re talking with, they will comprehend and translate data in various methods.

A CMO, for instance, doesn’t need to understand the “in the weeds” information. They want to know what channels are working, what’s not, and if they’re on track to satisfy their goals.

Link A Data Source

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

To include an adapter to your design 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 different Google adapters, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

Nevertheless, you’re likely using other platforms like social networks, third-party tools, CRM systems, and more.

For those non-Google ports, Looker Studio can link over 650 various data sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By utilizing the adapters, it takes the manual jobs and synchronizes all information for you! It ‘d be difficult to note all the readily available data sources here, however a few of the main ones I’ve utilized in the previous include: Supermetrics ports for: Buy Facebook Verified+Buy Instagram Verified Insights. Microsoft Marketing. Advertisement +Google Analytics

  • Data. Position Tracking.
  • And a lot more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • information sources come
  • from third-party ports.
  • Remember that a number of them: Extra cost. Can decrease reports. Metrics are sometimes deprecated,

    • implying it is essential
    • to remain on top of any changes to your report and restore metrics if required. When adding an information source, you’ll be asked to authorize the connection between accounts.

    Choosing 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 entirely personalized, this does not indicate we must be revealing all metrics readily available. Does your client appreciate return on marketing spend (ROAS)? Make sure to consist of

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

    By conveying the correct metrics and insights based upon objectives, it shows the client 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 personalize that report!

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

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

    Screenshot from Google Advertisements, December 2022

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

    If you have actually picked a template like the one above, the first step is to alter the information source for each chart you want to pick.

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

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

    A few methods to customize the style of your report include: Font and background color. Altering contrast metric colors. Text padding to line up either

  • left, center, or right.
  • Pro tip: If you want to alter all scorecards or
  • charts at once, just pick all at the exact same time before.
  • The design modifications will apply to all choices. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label typefaces 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 =" A Thorough Guide To Get Started 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 patience to

    produce a report visual that satisfies your reader’s expectations. Do not get dissuaded along the method! Including Report Filters An efficient method to group several visualizations together is by including report and page filters. For instance, if you desired all tables and charts to alter when modifying the date variety, you might include a Date Range icon and set it to “Report Level.”

    This implies that if the report is consisted of multiple pages, whenever the date range is updated, all chart data updates alongside it.

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

    Just browse to the toolbar and pick Include 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 enables you to filter the information on that specific page by project type.

    For instance, if you wanted to show how Search performs compared to Buy YouTube Subscribers, you ‘d pick 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 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 remain in complete control from the start of visualizing exactly what matters most.

    The initial step is to consider who will be reading this report. Remember to include what information is very important to them.

    Your chart ought to tell a story, and it’s up to you to picture that successfully.

    For example, you may want to include an “Overview” table that incorporates the primary metrics or key performance indications (KPIs) that matter to them.

    To develop a chart, click “Insert,” which will show you all the different charts to choose from. These consist of:

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

    In this example

    , I want to choose a simple bullet chart to contribute to my CMO Overview page. The objective of this chart is to reveal if we satisfied our

    month-to-month goal of app installs. The primary step is to pick the metric you’re determining. In this case, I selected” Installs.” To make this bullet chart reliable, you require to include your target/goal. Ensure to check package that states”Show Target.”Then, I input different range limits to reveal the progress.

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

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

    Often simple charts are all you require to represent the required data. Like all other components of Looker Studio, you can customize the design of any chart, table, or element as I did above.

    Sharing Reports

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

    • Invite individuals.
    • Arrange 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 ="A Thorough Guide To Start With Looker Studio(The New Google Data Studio)"

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

    • Another information safety measure Looker Studio included 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. Anybody on the web with the link can view(or modify– pick this setting carefully). Public. Anyone on the internet with the link can discover and see(or modify– choose this setting carefully).

    Another cool feature Google included is the alternative 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 individuals.
    • 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 Started With Looker Studio (The New Google Data Studio)"/ > I typically suggest inspecting the first box to avoid editors from altering gain access to or including brand-new individuals.

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

    Start With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/Best SMM Panel