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 popular Google Data Studio brand.

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

As a brand name’s marketing strategy progresses and ends up being more intricate, so does the elegance of its reporting requirements.

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

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

When this takes place, we’re doing a disservice by spending more time “doing” and less time really analyzing the information.

There has to be a better way, right?

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

What Took Place To Google Data Studio?

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

Numerous marketers have utilized this tool for years to unify and envision information sets from numerous channels.

Now, you’ll discover 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 specified:

“We are unifying our organization intelligence product household under the Looker umbrella, bringing together Looker, Data Studio, and core Google innovations like artificial intelligence (AI) and artificial intelligence (ML). Looker Studio is still complimentary, and has the same functions as Information Studio.”

What Is Google Looker Studio?

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

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

Essentially, Looker Studio helps surpass data visualization. It’s intended to help marketers make more data-driven decisions for their customers and brands alike.

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

Looker Studio Vs. Data Studio

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

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

One of the key distinctions in between Looker and Data Studio is the method information is modeled. Looker Studio utilizes LookML (Looker Modeling Language).

The second key distinction that the majority of online marketers will benefit from is the new and better information combining functions from Looker.

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

However, the biggest disadvantage of this was that the mixing feature was based upon a left external sign up with and often didn’t mix data in such a way that online marketers required.

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

Sounds aggravating, ideal?

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

The outcome? A faster, more meaningful method to imagine data from all your different marketing sources in an easy-to-digest format.

Getting Going With Looker Studio

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

  • Picking a template or dashboard.
  • Linking information sources.
  • Picking metrics that matter.
  • Sharing reports.

Looker Studio Templates

The first thing to do is to choose a template.

To gain access to Looker Studio, check out Looker Studio using your preferred Google Account. This need to be the account that you access your Google Analytics, Browse Console, Google Ads, etc.

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

If you’re new to Looker Studio, it is essential to select a design template based on the kind of information being portrayed.

Screenshot from Looker Studio, December 2022 With any design template, you have the ability to personalize products and fonts to create a more consistent report. The appeal of these reports is that several pages can be included. Do not seem like your whole marketing story needs to be

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

desired audience is. For example, I may create a different control panel or report page if I’m speaking to a CMO vs. an Item Marketing Manager. Why?

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

A CMO, for instance, doesn’t need to understand the “in the weeds” information. They need to know what channels are working, what’s not, and if they’re on track to meet their goals.

Connect A Data Source

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

To include a connector to your design template, go to Resource at the top navigation, then click Handle included data sources. Then, you’ll click + Add A Data Source.

Screenshot from Looker Studio, December 2022

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

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

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

Screenshot from Looker Studio, December 2022 By using the adapters, it takes the manual tasks and synchronizes all data for you! It ‘d be impossible to list all the offered information sources here, but a few of the main ones I have actually used in the previous include: Supermetrics connectors for: Buy Facebook Verification+Buy Instagram Verification 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 ports.
  • Remember that many of them: Extra expense. Can decrease reports. Metrics are sometimes deprecated,

    • meaning it is important
    • to stay 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.

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

    see a complete data dump. While Looker Studio is entirely personalized, this does not indicate we ought to be showing all metrics available. Does your client care about return on marketing invest (ROAS)? Make sure to consist of

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

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

    How To Edit A Report

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

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

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

    Screenshot from Google Advertisements, December 2022

    You can start tailoring your report by utilizing the information 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 wish to choose.

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

    information fields from your selected data source to alter any visualization. Not only can you create and edit charts and tables in Looker Studio, however the capability to pick the feel and look of a report is a game-changer for customers. It provides a sense of consistency throughout an organization.

    A few ways to individualize the style of your report consist of: Font and background color. Changing contrast metric colors. Text padding to align either

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

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

    , it will take some time, trial and error, and perseverance to

    create a report visual that fulfills your reader’s expectations. Don’t get dissuaded along the way! Adding Report Filters An efficient method to group numerous 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 implies that if the report is comprised of several pages, whenever the date range is upgraded, all chart information updates together with it.

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

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

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

    Develop A Chart

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

    The advantage of developing a custom chart is that you remain in complete control from the beginning of picturing exactly what matters most.

    The first step is to consider who will be reading this report. Keep in mind to include what data is very important to them.

    Your chart should narrate, and it’s up to you to imagine that effectively.

    For instance, you may want to include an “Summary” table that includes the main metrics or crucial efficiency signs (KPIs) that matter to them.

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

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

    In this example

    , I want to pick an easy bullet chart to contribute to my CMO Introduction page. The objective of this chart is to reveal if we met our

    monthly objective of app installs. The primary step is to pick the metric you’re measuring. In this case, I picked” Installs.” To make this bullet chart efficient, you require to add your target/goal. Make certain to check the box that states”Show Target.”Then, I input various range limitations to reveal the progress.

    I kept the last range the same as the target value. You can likewise put the last variety as a higher worth than your target, especially if you exceed that target worth.

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

    In some cases easy charts are all you need to represent the required data. Like all other elements of Looker Studio, you can customize the design of any chart, table, or element as I did above.

    Sharing Reports

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

    • Welcome individuals.
    • Set up e-mail delivery.
    • 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 want to invite individuals to access the report in real time, it is necessary to examine the share settings. To add someone by means of e-mail, it must be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”

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

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

    • the right-hand corner: Avoid editors from changing gain access to and adding brand-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 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 Extensive Guide To Start With Looker Studio (The New Google Data Studio)"/ > I generally advise examining the very first box to avoid editors from changing access or adding brand-new people.

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

    Begin With Looker Studio Now

    Ideally, this intro to Google Looker Studio will empower you to feel more positive in developing individualized reports for your customers and brands.

    More Resources:

    Included Image: RomanR/Best SMM Panel