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

Posted by

If you have not heard, Looker Studio has actually replaced the well-known Google Data Studio brand name.

While Google Data Studio made reporting much easier for lots of online marketers, it certainly had its restrictions.

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

If you’re anything like me, you’re likely tired of costs hours upgrading the exact same spreadsheets each month.

In some cases, more time is invested pulling a report than supplying real insights.

When this happens, we’re doing a disservice by spending 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 create and personalize action-oriented reports based on your own data.

What Occurred To Google Data Studio?

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

Many marketers have utilized this tool for many years to merge and visualize data sets from several channels.

Today, you’ll notice 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 official statement, Google specified:

“We are unifying our business intelligence item household under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like expert system (AI) and artificial intelligence (ML). Looker Studio is still totally free, and has the same functions as Information Studio.”

What Is Google Looker Studio?

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

It enables users to develop helpful and visual control panels that are simple to analyze, share, and personalize.

Basically, Looker Studio helps surpass information visualization. It’s intended to help marketers make more data-driven choices for their customers and brands alike.

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

Looker Studio Vs. Data Studio

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

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

Among the key differences in between Looker and Data Studio is the way information is designed. Looker Studio uses LookML (Looker Modeling Language).

The second key difference that many marketers will gain from is the brand-new and enhanced data combining functions from Looker.

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

However, the biggest downside of this was that the blending function was based on a left outer sign up with and often didn’t blend data in such a way that marketers needed.

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

Sounds discouraging, ideal?

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

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

Getting Going With Looker Studio

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

  • Choosing a design template or dashboard.
  • Linking information sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

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

To access Looker Studio, check out Looker Studio using your preferred Google Account. This should be the account that you access your Google Analytics, Browse Console, Google Ads, etc.

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

If you’re new to Looker Studio, it is important to pick a design template based on the type of information being represented.

Screenshot from Looker Studio, December 2022 With any template, you have the ability to customize items and font styles to produce a more consistent report. The beauty of these reports is that several pages can be added. Don’t seem like your entire marketing story requires to be

revealed on one page! Every client has various needs, and their reporting must be no various. The most effective route I have discovered is to utilize and modify various dashboards based upon who the

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

Depending on the role of who you’re speaking with, they will understand and translate data in different methods.

A CMO, for instance, doesn’t require to know the “in the weeds” data. They wish 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 chosen a template, it’s time to connect your data sources.

To add a port to your template, go to Resource at the top navigation, then click Handle added information sources. Then, you’ll click + Include An Information 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.

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

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

Screenshot from Looker Studio, December 2022 By using the connectors, it takes the manual tasks and syncs all data for you! It ‘d be impossible to list all the readily available data sources here, but some of the main ones I’ve used in the previous include: Supermetrics ports for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Advertising. Ad +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 much of them: Additional cost. Can decrease reports. Metrics are sometimes deprecated,

    • indicating it is essential
    • to remain on top of any modifications to your report and rebuild metrics if needed. When including a data source, you’ll be asked to authorize the connection in 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 complete information dump. While Looker Studio is entirely personalized, this does not suggest we ought to be showing all metrics readily available. Does your client appreciate return on advertising invest (ROAS)? Be sure to include

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

    By communicating the correct 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’ve linked your information sources, it’s time to customize that report!

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

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

    Screenshot from Google Ads, December 2022

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

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

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

    data fields from your picked information source to change any visualization. Not only can you create and edit charts and tables in Looker Studio, however the capability to pick the look of a report is a game-changer for customers. It gives a sense of consistency across a company.

    A couple of methods to customize the design of your report consist of: Font and background color. Changing comparison metric colors. Text padding to align either

  • left, center, or right.
  • Pro pointer: If you wish to change all scorecards or
  • charts at once, just pick all at the exact same time before.
  • The design changes will apply to all choices. Another time-saver! In this example, I altered the report background

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

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

    produce a report visual that meets your reader’s expectations. Don’t get dissuaded along the way! Including Report Filters An efficient way to group numerous visualizations together is by including report and page filters. For instance, if you desired all tables and charts to change when editing the date variety, you could include a Date Range 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 information updates along with it.

    For instance, if you wanted to dive into Campaign 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 different filters for your information to drill down more granularly."/ > This enables you to filter the information on that particular page by campaign type.

    For example, if you wanted to demonstrate how Browse carries out compared to Buy YouTube Subscribers, you ‘d choose from the dropdown in

    that filter. By default, filters included are at a page level. If you wish to make the filter report-level( meaning the filter would appear on each page of your report), merely right-click the filter and pick Make report-level.

    Produce A Chart

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

    The advantage of developing a customized chart is that you’re in complete control from the beginning of envisioning precisely what matters most.

    The initial step is to consider who will be reading this report. Remember to include what data is essential to them.

    Your chart ought to tell a story, and it depends on you to imagine that effectively.

    For instance, you might want to add an “Overview” table that incorporates the main metrics or essential efficiency signs (KPIs) that matter to them.

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

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

    In this example

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

    monthly objective of app installs. The initial step is to pick the metric you’re determining. In this case, I chose” Installs.” To make this bullet chart efficient, you require to include your target/goal. Make certain to inspect the box that states”Show Target.”Then, I input different range limits to reveal the development.

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

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

    In some cases basic charts are all you require to represent the essential information. Like all other components of Looker Studio, you can modify the design of any chart, table, or aspect as I did above.

    Sharing Reports

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

    • Invite individuals.
    • Arrange email shipment.
    • 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 Extensive Guide To Begin With Looker Studio(The New Google Data Studio)"

    / > If you wish to invite individuals to access the report in real time, it is necessary to check the share settings. To add someone by means of email, it should be a Google account e-mail. They can be added as a “Viewer”or an”Editor.”

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

    Another cool feature Google included is the alternative to restrict sharing in the following alternatives. In the share settings, click the”gear”icon in

    • the right-hand corner: Prevent editors from changing gain access to and adding 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 In-Depth 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 Extensive Guide To Start With Looker Studio (The New Google Data Studio)"/ > I normally suggest examining the very first box to avoid editors from changing gain access to or adding new people.

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

    Get Going With Looker Studio Now

    Ideally, this intro to Google Looker Studio will empower you to feel more positive in producing customized reports for your customers and brand names.

    More Resources:

    Featured Image: RomanR/SMM Panel