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

Posted by

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

While Google Data Studio made reporting simpler for many online marketers, it definitely had its limitations.

As a brand’s marketing technique develops and ends up being more complex, so does the sophistication of its reporting requirements.

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

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

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

There has to be a much better method, right?

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

What Took Place To Google Data Studio?

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

Lots of marketers have used this tool for many years to merge and picture data sets from numerous channels.

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

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

In their main announcement, Google specified:

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

What Is Google Looker Studio?

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

It makes it possible for users to produce useful and visual dashboards that are simple to interpret, share, and tailor.

Essentially, Looker Studio helps surpass information visualization. It’s aimed to help online marketers make more data-driven choices for their clients and brands alike.

Presently, Looker Studio supports over 800 various data sources, together with 600+ data connectors.

Looker Studio Vs. Data Studio

While Looker Studio touts much of the same features as the former Data Studio, the brand-new name also brings new functions.

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

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

The 2nd crucial difference that a lot of online marketers will benefit from is the new and enhanced data merging features from Looker.

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

Nevertheless, the greatest disadvantage of this was that the blending function was based on a left outer join and often didn’t blend information in such a way that online marketers needed.

It was a laborious process that left numerous to invest more time manually importing their data into a Google Sheet, then connecting that source to Data Studio.

Sounds aggravating, ideal?

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

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

Beginning With Looker Studio

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

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

Looker Studio Templates

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

To gain access to Looker Studio, check out Looker Studio utilizing your chosen Google Account. This need to be the account that you access your Google Analytics, Search Console, Google Advertisements, etc.

Looker Studio provides a variety of design templates to get you began.

If you’re new to Looker Studio, it is important to choose a design template based on the type of information being portrayed.

Screenshot from Looker Studio, December 2022 With any design template, you have the capability to customize products and font styles to develop a more consistent report. The beauty of these reports is that several pages can be added. Don’t seem like your whole marketing story requires to be

revealed on one page! Every client has different requirements, and their reporting ought to be no various. The most effective route I have actually discovered is to use and tweak various control panels based on who the

desired audience is. For instance, I may produce a different dashboard or report page if I’m talking to a CMO vs. a Product Marketing Manager. Why?

Depending on the role of who you’re talking with, they will understand and analyze data in different ways.

A CMO, for instance, does not require to understand the “in the weeds” information. They wish 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 selected a design template, it’s time to connect your data sources.

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

Screenshot from Looker Studio, December 2022

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

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

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

Screenshot from Looker Studio, December 2022 By utilizing the ports, it takes the manual jobs and syncs all data for you! It ‘d be impossible to list all the available data sources here, however some of the main ones I’ve utilized in the previous include: Supermetrics adapters for: Buy Facebook Verified+Buy Instagram Verified Insights. Microsoft Advertising. Advertisement +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 much of them: Extra expense. Can slow down reports. Metrics are sometimes deprecated,

    • suggesting it is vital
    • to stay on top of any modifications to your report and restore metrics if required. When adding a data source, you’ll be asked to authorize the connection in between accounts.

    Picking 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 completely adjustable, this does not indicate we ought to be revealing all metrics offered. Does your customer care about return on marketing spend (ROAS)? Be sure to consist of

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

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

    How To Modify A Report

    Now that you’ve linked your data sources, it’s time to personalize that report!

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

    First, you’ll wish to ensure you’re in the “Edit” mode and not “View.”

    Screenshot from Google Advertisements, December 2022

    You can start tailoring your report by utilizing the data field sets on the right-hand side.

    If you have actually selected a design template like the one above, the primary step is to change the information source for each chart you wish to select.

    Screenshot from Google Ads, December 2022 From there, you can select 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, 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 methods to personalize the style of your report include: Font and background color. Altering contrast metric colors. Text padding to align either

  • left, center, or right.
  • Pro suggestion: If you want to alter all scorecards or
  • charts at once, simply pick 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 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 Started 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 persistence to

    develop a report visual that fulfills your reader’s expectations. Do not get prevented along the method! Including Report Filters An effective method to group several visualizations together is by including report and page filters. For example, if you wanted all tables and charts to alter when modifying the date variety, you might include a Date Range icon and set it to “Report Level.”

    This means that if the report is comprised of multiple pages, whenever the date range is updated, all chart data updates along with it.

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

    Simply navigate to the toolbar and choose Include 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 data to drill down more granularly."/ > This permits you to filter the data on that particular page by campaign type.

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

    Produce A Chart

    If you have actually 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 full control from the start of imagining exactly what matters most.

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

    Your chart must narrate, and it’s up to you to picture that effectively.

    For example, you might wish to include an “Introduction” table that incorporates the primary metrics or crucial performance indications (KPIs) that matter to them.

    To create a chart, click on “Insert,” which will show you all the different charts to choose from. These include:

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

    In this example

    , I want to pick a basic bullet chart to add to my CMO Overview page. The objective of this chart is to reveal if we met our

    regular monthly objective of app installs. The first step is to select the metric you’re determining. In this case, I selected” Installs.” To make this bullet chart efficient, you require to add your target/goal. Ensure to check package that says”Show Target.”Then, I input various range limitations to show the development.

    I kept the last range the same as the target value. You can also put the last range as a higher value than your target, especially if you go beyond 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 quite make it.

    Often simple charts are all you need to represent the needed information. Like all other components of Looker Studio, you can customize the design of any chart, table, or aspect as I did above.

    Sharing Reports

    The following alternatives 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 ="An Extensive Guide To Get Started With Looker Studio(The New Google Data Studio)"

    / > If you want to invite people to access the report in genuine time, it’s important to examine the share settings. To add somebody via e-mail, it needs to be a Google account e-mail. They can be added as a “Audience”or an”Editor.”

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

    Another cool function Google added is the choice to restrict sharing in the following choices. In the share settings, click the”gear”icon in

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

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

    Get Started With Looker Studio Now

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

    More Resources:

    Included Image: RomanR/Best SMM Panel