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

Posted by

If you haven’t heard, Looker Studio has changed the widely known Google Data Studio brand name.

While Google Data Studio made reporting simpler for lots of online marketers, it definitely had its restrictions.

As a brand’s marketing technique develops and ends up being 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 same spreadsheets every month.

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

When this takes place, we’re doing a disservice by investing more time “doing” and less time in fact evaluating the data.

There needs to be a much better way, 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?

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

Many marketers have actually used this tool for years to unify and picture data sets from numerous channels.

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

Google formally rebranded its Data Studio product to be named Looker Studio in October 2022.

In their main statement, Google stated:

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

What Is Google Looker Studio?

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

It allows users to develop useful and visual dashboards that are easy to translate, 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 brand names alike.

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

Looker Studio Vs. Data Studio

While Looker Studio touts many of the exact same functions as the previous Data Studio, the brand-new name also brings new functions.

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

One of the crucial distinctions between Looker and Data Studio is the way data is modeled. Looker Studio uses LookML (Looker Modeling Language).

The 2nd crucial difference that many marketers will gain from is the new and better information combining functions from Looker.

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

However, the biggest drawback of this was that the blending feature was based on a left outer join and frequently didn’t blend data in a way that marketers needed.

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

Sounds discouraging, right?

Looker Studio, on the other hand, needs SQL databases to integrate any source. This means that raw data is passed into a database, making it a lot easier for Looker to combine data from different sources.

The result? A faster, more meaningful way to envision information from all your various marketing sources in an easy-to-digest format.

Getting Started With Looker Studio

There are a few essential areas to ensure your first Google Looker Studio report is a success. These include:

  • Selecting a template or dashboard.
  • Connecting information sources.
  • Selecting metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to select a template.

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

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

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

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to personalize products and typefaces to create a more constant report. The charm of these reports is that multiple pages can be added. Do not seem like your whole marketing story needs to be

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

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

Depending upon the role of who you’re talking with, they will comprehend and analyze information in various methods.

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

Connect A Data Source

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

To add a connector to your template, go to Resource on top navigation, then click Handle added information sources. Then, you’ll click + Add A Data Source.

Screenshot from Looker Studio, December 2022

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

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

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

  • Data. Position Tracking.
  • And much more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • information sources come
  • from third-party connectors.
  • Bear in mind that a number of them: Additional expense. Can decrease reports. Metrics are sometimes deprecated,

    • suggesting it is important
    • to remain on top of any changes to your report and restore metrics if required. When adding a data source, you’ll be asked to authorize the connection 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 data dump. While Looker Studio is completely adjustable, this does not imply we ought to be revealing all metrics available. Does your customer appreciate return on marketing invest (ROAS)? Make certain to consist of

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

    By conveying the appropriate metrics and insights based on goals, it reveals 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 data sources, it’s time to personalize that report!

    Let’s evaluate 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 begin tailoring your report by using the data field sets on the right-hand side.

    If you’ve selected a template like the one above, the initial step is to alter the information source for each chart you want to choose.

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

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

    A couple of ways to individualize the design of your report include: Typeface and background color. Altering comparison metric colors. Text cushioning to align either

  • left, center, or right.
  • Pro pointer: If you want to alter all scorecards or
  • charts at once, simply select all at the exact same time before.
  • The style modifications will apply to all selections. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label typefaces to create brand name standard 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 brand-new to Looker Studio

    , it will take time, experimentation, and persistence to

    create a report visual that fulfills your reader’s expectations. Don’t get prevented along the way! Including Report Filters An efficient method to group numerous visualizations together is by adding report and page filters. For example, if you desired all tables and charts to change when modifying the date variety, you might include a Date Range icon and set it to “Report Level.”

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

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

    Simply navigate to the toolbar and select Add a control > Drop-down list and include 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 different filters for your information to drill down more granularly."/ > This allows you to filter the information on that particular page by campaign type.

    For instance, if you wanted to demonstrate how Browse performs 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 want to make the filter report-level( suggesting the filter would appear on each page of your report), merely right-click the filter and select 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 custom-made chart is that you’re in full control from the start of envisioning exactly what matters most.

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

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

    For instance, you might want to include an “Introduction” table that incorporates the main metrics or essential performance indications (KPIs) that matter to them.

    To produce a chart, click “Insert,” which will reveal you all the various charts to choose from. These consist of:

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

    In this example

    , I want to pick an easy bullet chart to add to my CMO Summary 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 determining. In this case, I picked” Installs.” To make this bullet chart efficient, you require to add your target/goal. Make sure to check the box that states”Show Target.”Then, I input different variety limits to reveal the development.

    I kept the last range the like the target worth. You can likewise put the last range as a greater worth than your target, specifically if you exceed that target value.

    So, what does this chart state? It represents that our goal was 5,500 app installs for the month of November. According to the bullet chart, they were close to hitting their objective but didn’t quite make it.

    In some cases basic charts are all you require to represent the necessary data. Like all other elements of Looker Studio, you can customize the style 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.
    • Schedule 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 Extensive Guide To Begin With Looker Studio(The New Google Data Studio)"

    / > If you want to welcome people to access the report in genuine time, it is essential to check the share settings. To include someone through e-mail, it should be a Google account email. They can be added as a “Viewer”or an”Editor.”

    • Another information precaution Looker Studio included was how links to the report can be shared. You can pick from: Limited. Only people who you have actually shared the report with can open the link. Unlisted. Anybody on the internet with the link can see(or modify– pick this setting carefully). Public. Anybody on the internet with the link can discover and see(or modify– choose this setting carefully).

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

    • the right-hand corner: Prevent editors from altering access and adding brand-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="A Thorough 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 Start With Looker Studio (The New Google Data Studio)"/ > I generally recommend checking the very first box to prevent editors from changing gain access to or including brand-new people.

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

    Start With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/Best SMM Panel