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

Posted by

If you have not heard, Looker Studio has replaced the popular Google Data Studio brand.

While Google Data Studio made reporting much easier for many marketers, it certainly had its limitations.

As a brand name’s marketing technique progresses and becomes more complex, so does the elegance of its reporting requirements.

If you’re anything like me, you’re likely tired of costs hours updating the same spreadsheets every month.

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

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

There has to be a much better way, right?

This extensive Looker Studio guide will teach you how to create and personalize action-oriented reports based on your own information.

What Happened To Google Data Studio?

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

Numerous marketers have actually used this tool for several years to merge and picture information 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 official statement, Google stated:

“We are unifying our business intelligence item family under the Looker umbrella, combining Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and machine learning (ML). Looker Studio is still free, and has the very same features as Information Studio.”

What Is Google Looker Studio?

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

It makes it possible for users to produce useful and visual control panels that are simple to translate, share, and customize.

Essentially, Looker Studio helps go beyond information visualization. It’s aimed to help marketers make more data-driven choices for their customers and brand names alike.

Presently, Looker Studio supports over 800 different information sources, along with 600+ data ports.

Looker Studio Vs. Data Studio

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

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

One of the key differences between Looker and Data Studio is the method information is modeled. Looker Studio uses LookML (Looker Modeling Language).

The 2nd key distinction that a lot of marketers will benefit from is the brand-new and improved information merging features from Looker.

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

Nevertheless, the greatest drawback of this was that the blending function was based upon a left external join and typically didn’t blend information in a manner that marketers needed.

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

Sounds aggravating, right?

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

The result? A quicker, more meaningful way to envision 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 guarantee your first Google Looker Studio report is a success. These consist of:

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

Looker Studio Templates

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

To access Looker Studio, see Looker Studio utilizing your preferred Google Account. This ought to be the account that you access your Google Analytics, Browse Console, Google Ads, and so on.

Looker Studio supplies a wide range of templates to get you began.

If you’re brand-new to Looker Studio, it is essential to choose a template based on the kind of information being depicted.

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to personalize items and fonts to produce a more consistent report. The charm of these reports is that multiple pages can be added. Do not seem like your whole marketing story requires to be

shown on one page! Every customer has various requirements, and their reporting should be no various. The most effective route I have found is to utilize and tweak various dashboards based on who the

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

Depending on the function of who you’re talking with, they will understand and analyze data in various methods.

A CMO, for example, does not need to know the “in the weeds” information. They would like to know what channels are working, what’s not, and if they’re on track to satisfy their goals.

Connect A Data Source

Now that you’ve picked a template, it’s time to link your information sources.

To add a port to your design template, go to Resource on top navigation, then click Manage included data sources. Then, you’ll click + Add An Information Source.

Screenshot from Looker Studio, December 2022

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

Nevertheless, 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 link over 650 different information sources from their partner connectors!

Screenshot from Looker Studio, December 2022 By utilizing the connectors, it takes the manual tasks and synchronizes all information for you! It ‘d be difficult to note all the available data sources here, but some of the main ones I’ve utilized in the previous consist of: Supermetrics adapters for: Buy Facebook Verified+Buy Instagram Verified Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • data sources come
  • from third-party adapters.
  • Bear in mind that a number of them: Additional cost. Can slow down reports. Metrics are in some cases deprecated,

    • suggesting it is essential
    • to stay 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 between accounts.

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

    see a complete information dump. While Looker Studio is entirely personalized, this does not mean 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 spend and revenue. How about total brand awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By communicating the proper metrics and insights based on goals, it reveals the customer that you are listening to them. A win-win for everyone!

    How To Modify A Report

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

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

    First, you’ll wish to make certain 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 Advertisements, December 2022 From there, you can choose from any of the different

    data fields from your selected information source to alter any visualization. Not only can you produce and modify charts and tables in Looker Studio, but the ability to pick the look and feel of a report is a game-changer for customers. It provides a sense of consistency throughout a company.

    A couple of methods to personalize the style of your report include: Font style and background color. Altering contrast metric colors. Text cushioning to line up 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 style changes will apply to all selections. Another time-saver! In this example, I altered the report background

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

    , it will take time, experimentation, and patience to

    create a report visual that satisfies your reader’s expectations. Do not get discouraged along the method! Including Report Filters An efficient method to group several visualizations together is by adding report and page filters. For example, if you wanted all tables and charts to alter when editing the date range, you could include a Date Range icon and set it to “Report Level.”

    This means that if the report is consisted of several pages, whenever the date range is upgraded, all chart information updates alongside it.

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

    Simply navigate to the toolbar and pick Include 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 ="Select various filters for your information to drill down more granularly."/ > This enables you to filter the information on that specific page by campaign type.

    For example, 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.

    Develop A Chart

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

    The advantage of producing a custom chart is that you’re in full control from the start of envisioning precisely what matters most.

    The first step is to consider who will read this report. Remember to include what data is necessary to them.

    Your chart ought to narrate, and it’s up to you to envision that successfully.

    For example, you might want to include an “Summary” table that incorporates the primary metrics or key efficiency indicators (KPIs) that matter to them.

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

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

    In this example

    , I want to select a simple bullet chart to contribute to my CMO Summary page. The goal of this chart is to reveal if we fulfilled our

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

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

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

    In some cases simple charts are all you need to represent the necessary data. Like all other elements of Looker Studio, you can customize the style of any chart, table, or component as I did above.

    Sharing Reports

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

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

    / > If you wish to welcome individuals to access the report in real time, it is very important to inspect the share settings. To include somebody via e-mail, it needs to be a Google account e-mail. They can be included as a “Audience”or an”Editor.”

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

    Another cool feature Google added is the option 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 including 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 Start 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 Begin With Looker Studio (The New Google Data Studio)"/ > I usually recommend examining the very first box to avoid editors from altering access or including new people.

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

    Begin With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/Best SMM Panel