A Thorough Guide To Get Started 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 simpler for numerous marketers, it definitely had its restrictions.

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

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

Sometimes, more time is spent pulling a report than providing actual insights.

When this takes place, we’re doing an injustice by spending more time “doing” and less time in fact analyzing the data.

There has to be a better way, right?

This extensive Looker Studio guide will teach you how to develop 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.

Lots of marketers have utilized this tool for years to unify and imagine data sets from several channels.

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

Google formally rebranded its Data Studio item to be called Looker Studio in October 2022.

In their official statement, Google mentioned:

“We are unifying our service intelligence product family under the Looker umbrella, uniting Looker, Data Studio, and core Google innovations like expert system (AI) and artificial intelligence (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) syncs all of your information sources into one merged reporting experience.

It makes it possible for users to create useful and visual control panels that are easy to interpret, share, and tailor.

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

Currently, Looker Studio supports over 800 various data sources, in addition to 600+ data ports.

Looker Studio Vs. Data Studio

While Looker Studio promotes a number of the same functions as the former 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 data modeling features.
  • Supports 50+ SQLs and databases.
  • Merging functions from different data sources.

Among the essential distinctions in between Looker and Data Studio is the way information is modeled. Looker Studio uses LookML (Looker Modeling Language).

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

In Data Studio, it allowed for information sources to be blended.

However, the most significant downside of this was that the blending feature was based upon a left outer sign up with and typically didn’t blend data in a way that marketers needed.

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

Sounds discouraging, best?

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 picture information from all your different marketing sources in an easy-to-digest format.

Beginning With Looker Studio

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

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

Looker Studio Templates

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

To gain access to Looker Studio, go to 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 design templates to get you began.

If you’re brand-new to Looker Studio, it is important to choose a template based upon the type of data being portrayed.

Screenshot from Looker Studio, December 2022 With any template, you have the ability to tailor products and typefaces to produce a more consistent report. The appeal of these reports is that numerous pages can be added. Don’t seem like your entire marketing story requires to be

revealed on one page! Every customer has different requirements, and their reporting must be no different. The most efficient route I have actually found is to use and tweak various control panels based upon who the

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

Depending upon the function of who you’re talking with, they will understand and interpret information in various ways.

A CMO, for example, does not need 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 objectives.

Connect A Data Source

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

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

Screenshot from Looker Studio, December 2022

There are currently 24 different Google connectors, such as Google Analytics, Google Advertisements, Google Sheets, BigQuery, and more.

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

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

Screenshot from Looker Studio, December 2022 By using the ports, it takes the manual jobs and synchronizes all information for you! It ‘d be impossible to note all the readily available data sources here, however some of the main ones I have actually used in the past consist of: Supermetrics adapters for: Buy Facebook Verification+Buy Instagram Verification Insights. Microsoft Marketing. Ad +Google Analytics

  • Data. Position Tracking.
  • And much more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • data sources come
  • from third-party ports.
  • Keep in mind that much of them: Additional cost. Can decrease reports. Metrics are in some cases deprecated,

    • indicating it is important
    • to remain on top of any changes to your report and restore metrics if needed. When adding an information source, you’ll be asked to license the connection in between accounts.

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

    see a total information dump. While Looker Studio is entirely customizable, this does not suggest we must be revealing all metrics readily available. Does your client appreciate return on marketing spend (ROAS)? Make certain to include

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

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

    How To Modify A Report

    Now that you’ve connected your data sources, it’s time to personalize 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 start tailoring your report by using the data field sets on the right-hand side.

    If you have actually selected a template like the one above, the initial step is to change the data source for each chart you want to select.

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

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

    A few methods to individualize the style of your report consist of: Font style and background color. Altering contrast metric colors. Text cushioning to line up either

  • left, center, or right.
  • Pro tip: If you want to change all scorecards or
  • charts simultaneously, just select all at the exact same time prior to.
  • The style 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 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 new to Looker Studio

    , it will require time, experimentation, and patience to

    develop a report visual that satisfies your reader’s expectations. Do not get discouraged along the way! Including Report Filters An efficient way 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 variety, you could include a Date Range icon and set it to “Report Level.”

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

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

    Merely browse to the toolbar and pick Include 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 ="Select different filters for your data to drill down more granularly."/ > This permits you to filter the information on that specific page by project type.

    For example, 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 included are at a page level. If you want to make the filter report-level( meaning the filter would appear on each page of your report), simply right-click the filter and pick Make report-level.

    Create 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 creating a customized chart is that you remain in full control from the start of visualizing exactly what matters most.

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

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

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

    To produce a chart, click on “Insert,” which will show you all the various charts to select from. These include:

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

    In this example

    , I wish to select a basic 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 first step is to choose 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 check the box that states”Program Target.”Then, I input different variety limitations to reveal the progress.

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

    So, what does this chart state? It portrays 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 rather make it.

    Sometimes basic charts are all you require to represent the essential information. Like all other elements of Looker Studio, you can modify the style of any chart, table, or aspect 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 ="An In-Depth Guide To Get Going With Looker Studio(The New Google Data Studio)"

    / > If you want to invite individuals to access the report in real time, it’s important to inspect the share settings. To include someone through e-mail, it should be a Google account email. They can be added as a “Audience”or an”Editor.”

    • Another information precaution Looker Studio included 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. Anyone on the web with the link can view(or modify– pick this setting thoroughly). Public. Anyone on the internet with the link can find and see(or edit– select this setting carefully).

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

    • the right-hand corner: Prevent editors from changing gain access to and adding new individuals.
    • Disable downloading, printing, and copying for viewers.

    < img src ="// www.w3.org/2000/svg%22%20viewBox=%220%200%20618%20175%22%3E%3C/svg%3E" alt="An In-Depth Guide To Get Started 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 Going With Looker Studio (The New Google Data Studio)"/ > I generally advise examining the first box to avoid editors from changing access or including new individuals.

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

    Begin With Looker Studio Now

    Ideally, this introduction to Google Looker Studio will empower you to feel more confident in creating personalized reports for your customers and brands.

    More Resources:

    Featured Image: RomanR/Best SMM Panel