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

Posted by

If you have not heard, Looker Studio has actually changed the widely known Google Data Studio brand name.

While Google Data Studio made reporting much easier for many online marketers, it certainly had its restrictions.

As a brand’s marketing technique develops and becomes more complex, so does the elegance of its reporting requirements.

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

Often, more time is spent pulling a report than supplying actual insights.

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

There needs to be a better way, right?

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

What Happened To Google Data Studio?

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

Many marketers have used this tool for several years to unify and picture information sets from several channels.

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

Google officially rebranded its Information Studio product to be named Looker Studio in October 2022.

In their main statement, Google mentioned:

“We are unifying our business intelligence item family under the Looker umbrella, bringing together Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and machine learning (ML). Looker Studio is still free, and has the very same features as Information Studio.”

What Is Google Looker Studio?

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

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

Basically, Looker Studio helps exceed information visualization. It’s intended to assist online marketers make more data-driven decisions for their customers and brand names alike.

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

Looker Studio Vs. Data Studio

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

  • Free variation and Pro version (paid).
  • Different modeling technique (LookML).
  • Looker integration with Google Sheets.
  • More flexible data modeling features.
  • Supports 50+ SQLs and databases.
  • Merging functions from different information sources.

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

The 2nd essential distinction that many online marketers will take advantage of is the new and better information combining features from Looker.

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

Nevertheless, the biggest disadvantage of this was that the mixing feature was based on a left external join and typically didn’t blend data in a manner that marketers needed.

It was a tedious procedure that left lots of to invest more time manually importing their data 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 means that raw data is passed into a database, making it a lot easier for Looker to merge information from different sources.

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

Starting With Looker Studio

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

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

Looker Studio Templates

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

To gain access to Looker Studio, go to Looker Studio utilizing your chosen Google Account. This should be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.

Looker Studio offers a variety of templates to get you began.

If you’re brand-new to Looker Studio, it is essential to choose a design template based upon the type of information 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 beauty of these reports is that numerous pages can be added. Don’t feel like your whole marketing story requires to be

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

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

Depending on the function of who you’re speaking to, they will comprehend and interpret data in various methods.

A CMO, for instance, doesn’t require to understand the “in the weeds” data. 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’ve picked a design template, it’s time to link your information sources.

To include an adapter to your design template, go to Resource at the top navigation, then click Handle included information sources. Then, you’ll click + Add An Information Source.

Screenshot from Looker Studio, December 2022

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

However, you’re most 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 various data sources from their partner ports!

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

  • Data. Position Tracking.
  • And many more.
  • SEOMonitor. CallRail.
  • Salesforce.
  • HubSpot.
  • The majority of these
  • data sources come
  • from third-party adapters.
  • Keep in mind that a number of them: Additional expense. Can decrease reports. Metrics are sometimes deprecated,

    • meaning it is important
    • 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 authorize the connection in between accounts.

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

    see a complete data dump. While Looker Studio is completely adjustable, this does not mean we should be revealing all metrics readily available. Does your client care about return on advertising invest (ROAS)? Make certain to consist of

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

    By conveying the appropriate metrics and insights based upon objectives, 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 tailor that report!

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

    Initially, you’ll wish 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 information field sets on the right-hand side.

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

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

    data fields from your selected information source to change any visualization. Not only can you produce and modify charts and tables in Looker Studio, however the ability to pick the look of a report is a game-changer for customers. It offers a sense of consistency across an organization.

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

  • left, center, or right.
  • Pro suggestion: If you wish to alter all scorecards or
  • charts simultaneously, simply choose all at the exact same time prior to.
  • The style changes will apply to all selections. Another time-saver! In this example, I changed the report background

    , scorecard colors, and label font styles to produce brand name basic consistency:< img src="https://cdn.searchenginejournal.com/wp-content/uploads/2022/12/looker-studio-style-changes-6394d61d463a0-sej.png"alt =" A Thorough 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

    create a report visual that satisfies your reader’s expectations. Do not get dissuaded 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 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 updated, all chart information updates alongside it.

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

    Simply browse to the toolbar and choose 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 information to drill down more granularly."/ > This enables you to filter the data on that particular page by project type.

    For example, if you wanted to demonstrate how Browse carries out 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 wish to make the filter report-level( indicating 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 comfy with your Looker Studio experience, let’s dive into how to develop a chart from scratch.

    The benefit of producing a custom chart is that you’re in full control from the beginning of visualizing exactly what matters most.

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

    Your chart ought to narrate, and it’s up to you to envision that successfully.

    For example, you might wish to include an “Overview” table that includes the main metrics or crucial efficiency signs (KPIs) that matter to them.

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

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

    In this example

    , I wish to pick a simple bullet chart to contribute to my CMO Summary page. The objective of this chart is to reveal if we fulfilled our

    month-to-month objective of app installs. The primary step is to select the metric you’re measuring. In this case, I selected” Installs.” To make this bullet chart efficient, you require to add your target/goal. Make sure to examine the box that says”Program Target.”Then, I input various range limits to show the progress.

    I kept the last range the like the target worth. You can likewise put the last range as a greater value than your target, specifically if you exceed 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 hitting their goal but didn’t rather make it.

    Often basic charts are all you require to represent the required information. Like all other elements of Looker Studio, you can customize the design of any chart, table, or component as I did above.

    Sharing Reports

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

    • Invite individuals.
    • Schedule email 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 Get Started With Looker Studio(The New Google Data Studio)"

    / > If you want to invite individuals to access the report in genuine time, it is very 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 people who you have actually shared the report with can open the link. Unlisted. Anyone on the web with the link can view(or edit– select this setting thoroughly). Public. Anyone on the internet with the link can find and view(or modify– choose this setting carefully).

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

    • the right-hand corner: Avoid editors from altering gain access to and including 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 In-Depth Guide To Get Going 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 Begin With Looker Studio (The New Google Data Studio)"/ > I generally recommend inspecting the first box to prevent editors from altering gain access to or adding 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

    Hopefully, this intro to Google Looker Studio will empower you to feel more positive in producing tailored reports for your customers and brand names.

    More Resources:

    Featured Image: RomanR/Best SMM Panel