An In-Depth Guide To Get Going With Looker Studio (The New Google Data Studio)

Posted by

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

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

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 upgrading the very same spreadsheets each month.

Sometimes, more time is spent pulling a report than offering real insights.

When this occurs, we’re doing an injustice by spending more time “doing” and less time actually examining the information.

There has to be a much better method, right?

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

What Occurred To Google Data Studio?

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

Numerous marketers have utilized this tool for many years to unify and picture data sets from several channels.

Now, you’ll discover that Data Studio is no longer referenced. Where did it go?

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

In their official statement, Google stated:

“We are unifying our organization intelligence product family under the Looker umbrella, combining Looker, Data Studio, and core Google technologies like expert system (AI) and machine learning (ML). Looker Studio is still free, and has the exact same functions as Data Studio.”

What Is Google Looker Studio?

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

It enables users to create useful and visual dashboards that are easy to translate, share, and personalize.

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

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

Looker Studio Vs. Data Studio

While Looker Studio touts a lot of the exact same features as the former Data Studio, the new name likewise brings brand-new features.

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

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

The 2nd crucial difference that many marketers will benefit from is the brand-new and enhanced data combining functions from Looker.

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

Nevertheless, the greatest disadvantage of this was that the blending feature was based upon a left external join and often didn’t blend data in such a way that online marketers needed.

It was a laborious procedure that left many to spend more time by hand importing their information into a Google Sheet, then connecting that source to Data Studio.

Sounds frustrating, right?

Looker Studio, on the other hand, needs SQL databases to incorporate any source. This suggests that raw data is passed into a database, making it much easier for Looker to merge information from various sources.

The result? A quicker, more meaningful method to visualize data from all your various marketing sources in an easy-to-digest format.

Getting Started With Looker Studio

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

  • Choosing 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 select a template.

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

Looker Studio provides a wide variety of templates to get you started.

If you’re new to Looker Studio, it is important to choose a template based upon the kind of information being represented.

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to customize products and typefaces to produce a more constant report. The beauty of these reports is that multiple pages can be added. Don’t seem like your whole marketing story needs to be

revealed on one page! Every customer has various requirements, and their reporting must be no various. The most effective path I have discovered is to use and tweak various dashboards based on who the

intended audience is. For instance, I might develop a different dashboard or report page if I’m talking to a CMO vs. a Product Marketing Supervisor. Why?

Depending upon the role of who you’re speaking with, they will comprehend and interpret data in different ways.

A CMO, for instance, does not require to understand the “in the weeds” data. They wish to know what channels are working, what’s not, and if they’re on track to fulfill their objectives.

Link A Data Source

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

To include an adapter to your design template, go to Resource at the top navigation, then click Handle added information sources. Then, you’ll click + Include A Data Source.

Screenshot from Looker Studio, December 2022

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

Nevertheless, you’re most likely utilizing 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 ports!

Screenshot from Looker Studio, December 2022 By utilizing the ports, it takes the manual jobs and syncs all information for you! It ‘d be difficult to list all the readily available information sources here, however a few of the primary ones I’ve utilized in the previous consist of: Supermetrics connectors for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • information sources come
  • from third-party connectors.
  • Bear in mind that many of them: Extra cost. Can slow down reports. Metrics are sometimes deprecated,

    • meaning it is vital
    • to remain on top of any modifications to your report and reconstruct metrics if needed. When adding an information source, you’ll be asked to license 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 adjustable, this does not suggest we need to be showing all metrics readily available. Does your client care about return on marketing spend (ROAS)? Make sure to consist of

    metrics such as invest and revenue. How about general brand awareness? Consist of pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By communicating the proper metrics and insights based upon objectives, it shows the client that you are listening to them. A win-win for everyone!

    How To Modify A Report

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

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

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

    Screenshot from Google Ads, December 2022

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

    If you’ve selected a template like the one above, the primary step is to change the information source for each chart you want to select.

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

    information fields from your chosen information source to alter any visualization. Not just can you produce 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 customers. It gives a sense of consistency throughout a company.

    A few methods to customize the style of your report include: Font style and background color. Altering comparison metric colors. Text padding to align either

  • left, center, or right.
  • Pro tip: If you want to alter all scorecards or
  • charts at once, just pick all at the very same time prior to.
  • The style changes will use to all selections. Another time-saver! In this example, I altered the report background

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

    , it will require time, experimentation, and persistence to

    develop a report visual that fulfills your reader’s expectations. Do not get discouraged along the way! Including Report Filters An effective way to group multiple visualizations together is by adding report and page filters. For instance, if you desired all tables and charts to alter 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 comprised of numerous pages, whenever the date range is updated, all chart data updates along with it.

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

    Merely navigate to the toolbar and pick Add a control > Drop-down list and add 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 ="Choose different filters for your information to drill down more granularly."/ > This allows you to filter the data on that specific page by campaign type.

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

    Create A Chart

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

    The advantage of developing a custom-made chart is that you’re in complete control from the beginning of visualizing exactly what matters most.

    The initial step is to consider who will read this report. Remember to include what information is very important to them.

    Your chart needs to tell a story, and it depends on you to imagine that successfully.

    For example, you might want to add an “Summary” table that incorporates 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 pick from. These consist of:

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

    In this example

    , I wish to select a simple bullet chart to add to my CMO Overview page. The goal of this chart is to reveal if we satisfied our

    monthly objective of app installs. The primary step is to choose the metric you’re measuring. In this case, I selected” Installs.” To make this bullet chart effective, you require to include your target/goal. Ensure to check package that says”Program Target.”Then, I input different range limits to show the progress.

    I kept the last variety the same as the target value. You can also put the last variety as a higher worth than your target, particularly if you go beyond that target value.

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

    In some cases simple charts are all you need to represent the required information. Like all other elements of Looker Studio, you can modify the style of any chart, table, or element as I did above.

    Sharing Reports

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

    • Welcome people.
    • Arrange 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 ="An In-Depth Guide To Begin With Looker Studio(The New Google Data Studio)"

    / > If you wish to invite people to access the report in real time, it is necessary to inspect the share settings. To add someone via e-mail, it should 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 select from: Limited. Only individuals who you have actually shared the report with can open the link. Unlisted. Anybody on the internet with the link can see(or modify– select this setting carefully). Public. Anyone on the internet with the link can find and see(or modify– pick this setting thoroughly).

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

    • the right-hand corner: Avoid editors from changing gain access to and including 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 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="A Thorough Guide To Get Started With Looker Studio (The New Google Data Studio)"/ > I typically suggest inspecting the very first box to avoid editors from altering gain access to or adding brand-new individuals.

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

    Start With Looker Studio Now

    Hopefully, this intro to Google Looker Studio will empower you to feel more positive in creating individualized reports for your customers and brand names.

    More Resources:

    Included Image: RomanR/SMM Panel