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

Posted by

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

While Google Data Studio made reporting simpler for numerous marketers, it certainly had its constraints.

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

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

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

When this happens, we’re doing an injustice by spending more time “doing” and less time in fact examining the data.

There needs to be a better way, right?

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

What Occurred To Google Data Studio?

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

Lots of marketers have actually utilized this tool for several years to combine and visualize data sets from numerous channels.

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

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

In their main announcement, Google stated:

“We are unifying our organization intelligence product household under the Looker umbrella, uniting 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 Data Studio.”

What Is Google Looker Studio?

Google Looker Studio (previously Data Studio) syncs all of your information sources into one merged reporting experience.

It makes it possible for users to create useful and visual dashboards that are easy to interpret, share, and tailor.

Essentially, Looker Studio helps surpass data visualization. It’s intended to assist marketers make more data-driven choices for their clients and brands alike.

Currently, Looker Studio supports over 800 various data sources, along with 600+ data connectors.

Looker Studio Vs. Data Studio

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

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

Among the crucial distinctions between Looker and Data Studio is the method data is designed. Looker Studio uses LookML (Looker Modeling Language).

The second crucial difference that a lot of online marketers will take advantage of is the new and enhanced data merging functions from Looker.

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

However, the most significant downside of this was that the mixing feature was based upon a left external join and frequently didn’t blend information in such a way that marketers required.

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

Sounds frustrating, right?

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

The outcome? A much faster, more significant method to imagine data from all your different marketing sources in an easy-to-digest format.

Beginning With Looker Studio

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

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

Looker Studio Templates

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

To access Looker Studio, visit Looker Studio utilizing your preferred Google Account. This should be the account that you access your Google Analytics, Search 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 pick a design template based upon the type of information being depicted.

Screenshot from Looker Studio, December 2022 With any template, you have the capability to customize products and typefaces to create 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 customer has various needs, and their reporting should be no different. The most efficient path I have found is to utilize and modify various control panels based on who the

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

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

A CMO, for example, doesn’t 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 fulfill their goals.

Link A Data Source

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

To add a connector to your template, go to Resource at the top navigation, then click Manage included data sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

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

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

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

Screenshot from Looker Studio, December 2022 By using the connectors, it takes the manual jobs and synchronizes all information for you! It ‘d be impossible to list all the readily available information sources here, but a few of the main ones I have actually utilized in the past include: Supermetrics connectors for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And much more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • data sources come
  • from third-party ports.
  • Keep in mind that much of them: Extra cost. Can decrease reports. Metrics are in some cases deprecated,

    • suggesting it is important
    • to stay on top of any modifications to your report and reconstruct metrics if required. When including an information source, you’ll be asked to authorize the connection between accounts.

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

    see a total data dump. While Looker Studio is entirely adjustable, this does not imply we should be revealing all metrics available. Does your client care about return on advertising spend (ROAS)? Make sure to consist of

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

    How To Edit A Report

    Now that you’ve connected your information sources, it’s time to personalize that report!

    Let’s examine this Google Ads template as an example.

    First, you’ll want to make certain you’re in the “Edit” mode and not “View.”

    Screenshot from Google Advertisements, December 2022

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

    If you’ve selected a design template like the one above, the initial step is to alter the information source for each chart you wish to pick.

    Screenshot from Google Advertisements, December 2022 From there, you can select from any of the different

    data fields from your chosen information source to change any visualization. Not just can you create and edit charts and tables in Looker Studio, however the capability to select the feel and look of a report is a game-changer for clients. It gives a sense of consistency across an organization.

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

  • left, center, or right.
  • Pro suggestion: If you wish to change all scorecards or
  • charts at once, merely pick all at the very same time before.
  • The style changes will use to all selections. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label fonts to produce 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 Get Started With Looker Studio(The New Google Data Studio )"/ > If you’re new to Looker Studio

    , it will take some time, experimentation, and patience to

    produce a report visual that meets your reader’s expectations. Don’t get prevented along the way! Adding Report Filters An effective method to group numerous visualizations together is by including report and page filters. For instance, if you desired all tables and charts to change when modifying the date variety, you could include a Date Variety icon and set it to “Report Level.”

    This suggests that if the report is comprised of several pages, whenever the date variety is updated, all chart data updates together with it.

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

    Simply navigate to the toolbar and select Add 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 ="Choose different filters for your data to drill down more granularly."/ > This enables you to filter the data on that specific page by campaign type.

    For example, if you wished to show how Search performs 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( implying the filter would appear on each page of your report), merely right-click the filter and choose Make report-level.

    Create A Chart

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

    The benefit of producing a custom-made chart is that you’re in full control from the beginning of visualizing exactly what matters most.

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

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

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

    To create a chart, click “Insert,” which will reveal you all the different charts to select 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 add to my CMO Summary page. The objective of this chart is to reveal if we met our

    regular monthly goal of app installs. The primary step is to choose the metric you’re measuring. In this case, I chose” Installs.” To make this bullet chart effective, you need to include your target/goal. Ensure to examine package that says”Show Target.”Then, I input various variety 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 higher worth than your target, particularly if you surpass that target value.

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

    Often easy charts are all you need to represent the essential information. Like all other components of Looker Studio, you can modify the style of any chart, table, or aspect as I did above.

    Sharing Reports

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

    • Welcome people.
    • Schedule 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 ="A Thorough Guide To Get Going With Looker Studio(The New Google Data Studio)"

    / > If you wish to invite individuals to access the report in genuine time, it is very important to check the share settings. To add someone via e-mail, it must be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”

    • Another information precaution Looker Studio added was how links to the report can be shared. You can select from: Restricted. Just 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– pick this setting carefully). Public. Anyone on the internet with the link can discover and view(or modify– pick this setting carefully).

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

    • the right-hand corner: Prevent editors from altering access 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="An In-Depth 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="A Thorough Guide To Get Going With Looker Studio (The New Google Data Studio)"/ > I typically advise checking the first box to prevent editors from altering gain access to or including new individuals.

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

    Start With Looker Studio Now

    Hopefully, this introduction to Google Looker Studio will empower you to feel more confident in developing customized reports for your customers and brand names.

    More Resources:

    Included Image: RomanR/Best SMM Panel