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

Posted by

If you haven’t heard, Looker Studio has actually changed the well-known Google Data Studio brand name.

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

As a brand name’s marketing strategy 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 spending hours upgrading the same spreadsheets each month.

Often, more time is spent pulling a report than supplying real insights.

When this occurs, we’re doing a disservice by investing more time “doing” and less time actually analyzing the data.

There needs to be a much better method, right?

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

What Took Place To Google Data Studio?

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

Numerous online marketers have actually used this tool for many years to unify and imagine information sets from multiple channels.

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

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

In their official statement, Google specified:

“We are unifying our company intelligence item household under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and artificial intelligence (ML). Looker Studio is still free, and has the exact same features as Data Studio.”

What Is Google Looker Studio?

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

It allows users to develop useful and visual control panels that are easy to interpret, share, and personalize.

Basically, Looker Studio assists go beyond information visualization. It’s intended to help marketers make more data-driven decisions for their clients and brands alike.

Currently, Looker Studio supports over 800 different information sources, together with 600+ data connectors.

Looker Studio Vs. Data Studio

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

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

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

The 2nd crucial difference that many online marketers will gain from is the brand-new and better data merging features from Looker.

In Data Studio, it enabled data sources to be mixed.

However, the greatest downside of this was that the blending feature was based on a left external sign up with and typically didn’t mix information in a manner that marketers required.

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

Sounds frustrating, right?

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

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

Beginning With Looker Studio

There are a few crucial locations to guarantee your very first Google Looker Studio report is a success. These consist of:

  • Picking a design template or dashboard.
  • Connecting information sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to pick a template.

To access Looker Studio, check out Looker Studio using your preferred Google Account. This ought to be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.

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

If you’re brand-new to Looker Studio, it is essential to select a template based upon the kind of information being portrayed.

Screenshot from Looker Studio, December 2022 With any template, you have the ability to personalize products and font styles to produce a more consistent report. The appeal of these reports is that numerous pages can be included. Don’t feel like your entire marketing story needs to be

shown on one page! Every customer has different needs, and their reporting should be no different. The most efficient route I have discovered is to utilize and tweak various control panels based upon who the

intended audience is. For instance, I may develop a various control panel or report page if I’m talking with a CMO vs. a Product Marketing Manager. Why?

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

A CMO, for example, does not 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 fulfill their goals.

Link A Data Source

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

To include an adapter to your template, go to Resource on top navigation, then click Manage included information sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

There are presently 24 different Google connectors, such as Google Analytics, Google Ads, Google Sheets, BigQuery, and more.

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

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

Screenshot from Looker Studio, December 2022 By utilizing the connectors, it takes the manual tasks and syncs all data for you! It ‘d be impossible to list all the available data sources here, but a few of the primary ones I’ve used in the previous consist of: Supermetrics ports for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Marketing. 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.
  • Keep in mind that a number of them: Additional cost. Can slow down reports. Metrics are often deprecated,

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

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

    see a total data dump. While Looker Studio is entirely customizable, this does not imply we must be revealing all metrics available. Does your customer care about return on marketing spend (ROAS)? Be sure to consist of

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

    By conveying the correct metrics and insights based upon goals, it reveals the client that you are listening to them. A win-win for everybody!

    How To Edit A Report

    Now that you have actually connected your data sources, it’s time to personalize that report!

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

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

    Screenshot from Google Advertisements, December 2022

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

    If you’ve chosen a template like the one above, the initial step is to alter the data source for each chart you want to pick.

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

    data fields from your selected information source to change any visualization. Not only can you create and modify charts and tables in Looker Studio, however the ability to pick the look and feel of a report is a game-changer for customers. It gives a sense of consistency throughout an organization.

    A few methods to customize the design of your report consist of: Font and background color. Altering comparison metric colors. Text padding to line up either

  • left, center, or right.
  • Pro tip: If you want to change all scorecards or
  • charts simultaneously, merely select all at the very same time prior to.
  • The style changes will apply to all choices. Another time-saver! In this example, I altered the report background

    , scorecard colors, and label typefaces to develop brand basic consistency:< img src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/looker-studio-style-changes-6394d61d463a0-sej.png"alt =" An Extensive Guide To Get Started With Looker Studio(The New Google Data Studio )"/ > If you’re brand-new to Looker Studio

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

    develop a report visual that satisfies your reader’s expectations. Do not get dissuaded along the way! Including Report Filters An efficient way to group numerous visualizations together is by adding report and page filters. For example, if you desired all tables and charts to change when modifying the date range, you could include a Date Variety icon and set it to “Report Level.”

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

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

    Merely navigate to the toolbar and pick Add a control > Drop-down list and include 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 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 demonstrate how Browse performs 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), merely right-click the filter and select 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 developing a customized chart is that you’re in full control from the start of visualizing exactly what matters most.

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

    Your chart should narrate, and it’s up to you to picture that effectively.

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

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

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

    In this example

    , I wish to pick a simple bullet chart to contribute to my CMO Introduction page. The objective of this chart is to reveal if we met our

    monthly objective of app installs. The initial step is to select the metric you’re determining. In this case, I chose” Installs.” To make this bullet chart efficient, you need to add your target/goal. Make certain to inspect the box that states”Program Target.”Then, I input different range limitations to show the progress.

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

    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 objective however didn’t quite make it.

    Sometimes easy charts are all you require to represent the necessary data. 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 options are available for sharing a Looker Studio report:

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

    / > If you wish to welcome people to access the report in real time, it’s important to check the share settings. To include someone by means of email, it must be a Google account email. They can be included as a “Viewer”or an”Editor.”

    • Another information safety measure Looker Studio added was how links to the report can be shared. You can select from: Limited. Just individuals who you have shared the report with can open the link. Unlisted. Anyone on the web with the link can see(or edit– pick this setting thoroughly). Public. Anybody on the internet with the link can find and see(or edit– choose this setting thoroughly).

    Another cool feature Google added is the choice to restrict sharing in the following choices. In the share settings, click 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="An Extensive Guide To Get Going 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 Start With Looker Studio (The New Google Data Studio)"/ > I normally advise checking the first box to prevent editors from altering gain access to or adding brand-new individuals.

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

    Begin With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/Best SMM Panel