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

Posted by

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

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

As a brand name’s marketing method develops and becomes more complicated, 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 each month.

Sometimes, more time is invested 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 information.

There has 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 information.

What Occurred To Google Data Studio?

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

Numerous marketers have actually used this tool for many years to merge and visualize data sets from numerous channels.

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

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

In their main announcement, Google stated:

“We are unifying our company intelligence item household under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like expert system (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) synchronizes all of your data sources into one unified reporting experience.

It allows users to produce helpful and visual dashboards that are simple to translate, share, and tailor.

Basically, Looker Studio helps go beyond data visualization. It’s aimed to assist marketers make more data-driven choices for their customers and brands alike.

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

Looker Studio Vs. Data Studio

While Looker Studio promotes a lot of the very same functions as the former Data Studio, the brand-new name likewise brings new functions.

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

Among the essential differences between Looker and Data Studio is the way data is modeled. Looker Studio uses LookML (Looker Modeling Language).

The second crucial distinction that many marketers will gain from is the new and enhanced information combining functions from Looker.

In Data Studio, it allowed for data sources to be combined.

However, the greatest downside of this was that the mixing function was based on a left external join and typically didn’t mix data in a way that online marketers required.

It was a tiresome process that left numerous to invest more time by hand importing their information into a Google Sheet, then connecting that source to Data Studio.

Sounds discouraging, right?

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

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

Getting Going With Looker Studio

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

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

Looker Studio Templates

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

To gain access to Looker Studio, visit Looker Studio using your preferred Google Account. This should be the account that you access your Google Analytics, Browse Console, Google Ads, and so on.

Looker Studio offers a wide array of templates to get you started.

If you’re new to Looker Studio, it is very important to select a design template based upon the type of data being portrayed.

Screenshot from Looker Studio, December 2022 With any template, you have the capability to personalize products and typefaces to produce a more consistent report. The appeal of these reports is that several pages can be included. Do not feel like your whole marketing story requires to be

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

desired audience is. For instance, I may develop a various dashboard 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 analyze information in various methods.

A CMO, for example, does not require to understand the “in the weeds” data. They would like 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 have actually chosen a template, it’s time to link your information sources.

To add a port to your design template, go to Resource at the top navigation, then click Manage added information sources. Then, you’ll click + Add A Data Source.

Screenshot from Looker Studio, December 2022

There are presently 24 various Google ports, such as Google Analytics, Google Ads, Google Sheets, BigQuery, and more.

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

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

Screenshot from Looker Studio, December 2022 By utilizing the ports, it takes the manual jobs and syncs all information for you! It ‘d be impossible to list all the readily available data sources here, but a few of the main ones I’ve utilized in the previous include: Supermetrics connectors 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.
  • Most of these
  • information sources come
  • from third-party ports.
  • Bear in mind that a number of them: Extra expense. Can slow down reports. Metrics are often deprecated,

    • indicating it is crucial
    • to stay on top of any changes to your report and rebuild metrics if needed. When including a data source, you’ll be asked to license the connection between accounts.

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

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

    metrics such as invest and profits. How about general brand name awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By conveying the proper metrics and insights based upon objectives, it shows 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 information sources, it’s time to customize that report!

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

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

    Screenshot from Google Ads, December 2022

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

    If you have actually chosen a design template like the one above, the primary step is to alter the information source for each chart you wish to choose.

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

    data fields from your picked data source to change any visualization. Not only can you create and modify charts and tables in Looker Studio, but the ability to select the look of a report is a game-changer for clients. It provides a sense of consistency across an organization.

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

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

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

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

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

    This suggests that if the report is comprised of numerous pages, whenever the date variety is updated, all chart information updates along with it.

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

    Simply browse to the toolbar and select 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 ="Pick various filters for your data to drill down more granularly."/ > This allows you to filter the data on that particular page by campaign type.

    For instance, if you wanted to demonstrate how Search 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), just 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 advantage of developing a customized chart is that you remain in full control from the beginning of imagining precisely what matters most.

    The first step is to consider who will read this report. Keep in mind to include what data is essential to them.

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

    For example, you may want to add an “Introduction” table that encompasses the primary metrics or key efficiency signs (KPIs) that matter to them.

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

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

    In this example

    , I wish to pick an easy bullet chart to contribute to my CMO Summary page. The goal of this chart is to show if we satisfied our

    regular monthly objective of app installs. The initial step is to select the metric you’re determining. In this case, I selected” Installs.” To make this bullet chart effective, you need to include your target/goal. Make certain to inspect package that states”Program Target.”Then, I input different variety limits to show the development.

    I kept the last variety the same as the target value. You can likewise put the last range as a greater value than your target, specifically if you surpass 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 however didn’t quite make it.

    Sometimes easy charts are all you need to represent the required information. Like all other aspects of Looker Studio, you can modify the design of any chart, table, or aspect as I did above.

    Sharing Reports

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

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

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

    • Another data precaution Looker Studio added was how links to the report can be shared. You can choose from: Restricted. Only people who you have actually shared the report with can open the link. Unlisted. Anyone on the internet with the link can view(or modify– pick this setting carefully). Public. Anyone on the web with the link can find and see(or edit– choose this setting thoroughly).

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

    • the right-hand corner: Avoid editors from changing access and adding brand-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 In-Depth Guide To Get Started With Looker Studio (The New Google Data Studio)"/ > I normally recommend checking the very first box to avoid editors from changing access or adding brand-new individuals.

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

    Get Started With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/SMM Panel