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

Posted by

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

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

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

If you’re anything like me, you’re likely tired of spending hours upgrading the very same spreadsheets each month.

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

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

There needs to be a better way, right?

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

What Occurred To Google Data Studio?

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

Numerous online marketers have utilized this tool for years to combine and visualize data sets from multiple channels.

But now, you’ll see 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 announcement, Google stated:

“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 complimentary, and has the exact 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 develop helpful and visual control panels that are easy to interpret, share, and personalize.

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

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

Looker Studio Vs. Data Studio

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

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

One of the key differences in between Looker and Data Studio is the way information is designed. Looker Studio uses LookML (Looker Modeling Language).

The 2nd key difference that a lot of online marketers will take advantage of is the new and better information combining features from Looker.

In Data Studio, it enabled information sources to be blended.

However, the biggest disadvantage of this was that the blending function was based upon a left external sign up with and often didn’t blend information in a way that marketers needed.

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

Sounds aggravating, ideal?

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

The outcome? A much faster, more significant way to envision data from all your different marketing sources in an easy-to-digest format.

Getting Going With Looker Studio

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

  • Picking a design template or control panel.
  • Connecting information sources.
  • Picking 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 using your chosen Google Account. This need to be the account that you access your Google Analytics, Browse Console, Google Ads, and so on.

Looker Studio supplies a wide range of templates to get you started.

If you’re brand-new to Looker Studio, it is very important to select a template based upon the type of information being depicted.

Screenshot from Looker Studio, December 2022 With any template, you have the capability to tailor products and fonts to create a more constant report. The beauty of these reports is that numerous pages can be included. Do not seem like your whole marketing story needs to be

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

designated audience is. For instance, I might produce a different control panel or report page if I’m talking with a CMO vs. a Product Marketing Manager. Why?

Depending upon the role of who you’re speaking with, they will understand and interpret information in different methods.

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

Link A Data Source

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

To include a connector to your design template, go to Resource at the top navigation, then click Manage included data sources. Then, you’ll click + Include 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 adapters, Looker Studio can link over 650 various data sources from their partner adapters!

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

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • Most of these
  • information sources come
  • from third-party adapters.
  • Keep in mind that much of them: Additional expense. Can decrease reports. Metrics are in some cases deprecated,

    • implying it is crucial
    • to remain on top of any modifications to your report and restore metrics if needed. When adding a data 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 information dump. While Looker Studio is entirely personalized, this does not imply we should be showing all metrics available. Does your customer care about return on marketing spend (ROAS)? Be sure to consist of

    metrics such as spend and profits. How about total brand name awareness? Include pre-click metrics such as impressions, clicks, CTR, view rate, and so on.

    By communicating the appropriate 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’ve linked your information sources, it’s time to personalize that report!

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

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

    Screenshot from Google Ads, December 2022

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

    If you have actually picked a design template like the one above, the primary step is to alter the data source for each chart you want to select.

    Screenshot from Google Ads, December 2022 From there, you can select from any of the different

    information fields from your picked information source to alter any visualization. Not just can you produce and modify charts and tables in Looker Studio, but the capability to select the feel and look of a report is a game-changer for customers. It gives a sense of consistency throughout an organization.

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

  • left, center, or right.
  • Pro tip: If you wish to alter all scorecards or
  • charts at once, merely select all at the very same time prior to.
  • The style modifications will use to all selections. Another time-saver! In this example, I changed the report background

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

    , it will require time, experimentation, and perseverance to

    create a report visual that satisfies your reader’s expectations. Do not get dissuaded along the way! Including Report Filters An effective method to group several visualizations together is by adding report and page filters. For instance, if you desired all tables and charts to alter when editing the date variety, you might include a Date Range icon and set it to “Report Level.”

    This implies that if the report is consisted of several pages, whenever the date range is upgraded, all chart information 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 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 ="Choose various filters for your data 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 demonstrate how Browse 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 want to make the filter report-level( implying the filter would appear on each page of your report), simply right-click the filter and pick Make report-level.

    Develop 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 benefit of developing a customized chart is that you’re in complete control from the start of envisioning exactly what matters most.

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

    Your chart ought to narrate, and it depends on you to envision that effectively.

    For example, you might wish to include an “Overview” table that incorporates the primary metrics or key efficiency indicators (KPIs) that matter to them.

    To produce a chart, click “Insert,” which will reveal you all the different 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 choose a basic bullet chart to add to my CMO Summary page. The objective of this chart is to reveal if we fulfilled our

    regular 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 reliable, you require to add your target/goal. Make certain to check package that states”Program Target.”Then, I input various variety limitations to reveal the progress.

    I kept the last range the like the target value. You can also put the last range as a greater worth than your target, particularly if you surpass that target worth.

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

    Often basic charts are all you need to represent the essential data. Like all other aspects of Looker Studio, you can customize the style of any chart, table, or aspect as I did above.

    Sharing Reports

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

    • Welcome people.
    • Set up email 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 Get Going With Looker Studio(The New Google Data Studio)"

    / > If you wish to welcome people to access the report in genuine time, it is very important to inspect the share settings. To include someone via email, it must be a Google account email. They can be added as a “Viewer”or an”Editor.”

    • Another data precaution Looker Studio added was how links to the report can be shared. You can pick from: Restricted. Only individuals who you have actually shared the report with can open the link. Unlisted. Anyone on the internet with the link can view(or modify– choose this setting thoroughly). Public. Anyone on the web with the link can find and view(or modify– select this setting carefully).

    Another cool function Google added is the choice 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 access and adding 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 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 Started With Looker Studio (The New Google Data Studio)"/ > I usually recommend checking the first box to prevent editors from changing access or including brand-new individuals.

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

    Get Started With Looker Studio Now

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

    More Resources:

    Featured Image: RomanR/SMM Panel