If you have not heard, Looker Studio has changed the well-known Google Data Studio brand.
While Google Data Studio made reporting simpler for lots of marketers, it definitely had its restrictions.
As a brand name’s marketing method develops and ends up being more intricate, so does the sophistication of its reporting requirements.
If you’re anything like me, you’re likely tired of costs hours upgrading the exact same spreadsheets every month.
Often, more time is invested pulling a report than offering real insights.
When this occurs, we’re doing a disservice by investing more time “doing” and less time in fact evaluating the information.
There needs to be a much better way, right?
This thorough Looker Studio guide will teach you how to produce 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 free information visualization tool.
Lots of marketers have used this tool for years to unify and picture data sets from multiple channels.
And now, you’ll discover that Data Studio is no longer referenced. Where did it go?
Google formally rebranded its Data Studio item to be named Looker Studio in October 2022.
In their main statement, Google stated:
“We are unifying our business intelligence item family under the Looker umbrella, uniting Looker, Data Studio, and core Google technologies like artificial intelligence (AI) and machine learning (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 merged reporting experience.
It makes it possible for users to produce useful and visual dashboards that are easy to analyze, share, and customize.
Essentially, Looker Studio helps surpass information visualization. It’s aimed to help marketers make more data-driven choices for their clients and brands alike.
Currently, Looker Studio supports over 800 different data sources, in addition to 600+ information connectors.
Looker Studio Vs. Data Studio
While Looker Studio touts much of the same features as the previous Data Studio, the new name also brings brand-new features.
- Free variation and Pro version (paid).
- Different modeling method (LookML).
- Looker integration with Google Sheets.
- More flexible information modeling features.
- Supports 50+ SQLs and databases.
- Combining functions from different information sources.
Among 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 difference that the majority of online marketers will benefit from is the new and enhanced information merging features from Looker.
In Data Studio, it permitted data sources to be blended.
However, the biggest disadvantage of this was that the blending function was based upon a left outer sign up with and typically didn’t mix information in such a way that online marketers required.
It was a tedious process that left lots of to spend 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, requires SQL databases to integrate any source. This indicates that raw data is passed into a database, making it a lot easier for Looker to combine information from different sources.
The result? A faster, more significant way to picture information from all your various marketing sources in an easy-to-digest format.
Beginning With Looker Studio
There are a few crucial locations to ensure your first Google Looker Studio report is a success. These consist of:
- Choosing a template or control panel.
- Connecting data sources.
- Picking metrics that matter.
- Sharing reports.
Looker Studio Templates
The first thing to do is to choose a design template.
To gain access to Looker Studio, see Looker Studio utilizing your preferred Google Account. This need to be the account that you access your Google Analytics, Browse Console, Google Advertisements, and so on.
Looker Studio supplies a variety of design templates to get you started.
If you’re brand-new to Looker Studio, it is essential to choose a template based on the type of data being depicted.
Screenshot from Looker Studio, December 2022 With any design template, you have the capability to tailor products and font styles to develop a more consistent report. The appeal of these reports is that several pages can be included. Do not feel like your whole marketing story needs to be
revealed on one page! Every customer has different needs, and their reporting needs to be no various. The most effective route I have actually found is to use and modify different dashboards based on who the
designated audience is. For instance, I might develop a various dashboard or report page if I’m speaking with a CMO vs. an Item Marketing Supervisor. Why?
Depending upon the role of who you’re speaking to, they will comprehend and interpret information in different methods.
A CMO, for instance, doesn’t need to know 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 goals.
Connect A Data Source
Now that you’ve chosen a template, it’s time to connect your information sources.
To add an adapter to your template, go to Resource at the top navigation, then click Handle added data sources. Then, you’ll click + Add An Information 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 using other platforms like social networks, third-party tools, CRM systems, and more.
For those non-Google ports, Looker Studio can link 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 information for you! It ‘d be difficult to list all the readily available data sources here, however a few of the main ones I have actually utilized in the past consist of: Supermetrics adapters for: Buy Facebook Verification Badge+Buy Instagram Verification Badge Insights. Microsoft Advertising. Advertisement +Google Analytics
- Data. Position Tracking.
- And many more.
- SEOMonitor. CallRail.
Keep in mind that much of them: Additional expense. Can slow down reports. Metrics are often deprecated,
- indicating it is vital
- to remain on top of any modifications to your report and reconstruct metrics if needed. When adding an information source, you’ll be asked to license the connection between accounts.
Picking Metrics That Matter Mentioning metrics– they matter. Let’s be genuine, the worst is when clients open reports and
see a total information dump. While Looker Studio is totally customizable, this does not mean we must be showing all metrics available. Does your customer appreciate return on marketing spend (ROAS)? Make sure to consist of
metrics such as invest and revenue. How about general brand awareness? Consist of pre-click metrics such as impressions, clicks, CTR, view rate, and so on.
By conveying the proper metrics and insights based on goals, it shows the customer that you are listening to them. A win-win for everybody!
How To Modify A Report
Now that you’ve connected your information sources, it’s time to customize that report!
Let’s evaluate this Google Ads design template as an example.
First, you’ll want to make certain you’re in the “Edit” mode and not “View.”
Screenshot from Google Advertisements, December 2022
You can begin personalizing your report by making use of the information field sets on the right-hand side.
If you have actually picked a template like the one above, the initial step is to change the data source for each chart you wish to select.
Screenshot from Google Advertisements, December 2022 From there, you can select from any of the different
information fields from your picked information source to change any visualization. Not only can you create and modify charts and tables in Looker Studio, however the capability to choose the feel and look of a report is a game-changer for clients. It gives a sense of consistency across a company.
A few ways to individualize the design of your report include: Font and background color. Changing comparison metric colors. Text padding to line up either
The design changes will apply to all choices. Another time-saver! In this example, I altered 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 =" A Thorough Guide To Get Started With Looker Studio(The New Google Data Studio )"/ > If you’re new to Looker Studio
, it will take time, trial and error, and perseverance to
create a report visual that satisfies your reader’s expectations. Do not get discouraged along the way! Including Report Filters An efficient way to group numerous visualizations together is by including report and page filters. For example, if you desired all tables and charts to alter when editing the date range, you could include a Date Variety icon and set it to “Report Level.”
This indicates that if the report is consisted of several pages, whenever the date range is upgraded, all chart information updates alongside it.
For instance, if you wanted to dive into Project Type performance, there’s a filter for that!
Just 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 data to drill down more granularly."/ > This permits you to filter the data on that particular page by campaign type.
For instance, 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 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 choose 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 creating a custom chart is that you’re in full control from the start of envisioning precisely what matters most.
The first step is to consider who will read this report. Remember to include what information is necessary to them.
Your chart ought to narrate, and it’s up to you to imagine that successfully.
For example, you may want to add an “Summary” table that includes the primary metrics or key performance indications (KPIs) that matter to them.
To develop a chart, click on “Insert,” which will reveal you all the different charts to select from. These consist of:
- Time series.
- Bar chart.
- Pie chart.
- Bullet charts.
- Much more.
In this example
, I wish to choose a simple bullet chart to add to my CMO Introduction page. The objective of this chart is to show if we fulfilled our
monthly objective of app installs. The first step is to select the metric you’re determining. In this case, I picked” Installs.” To make this bullet chart effective, you require to include your target/goal. Ensure to examine package that states”Program Target.”Then, I input various range limitations to reveal the progress.
I kept the last range the same as the target worth. You can likewise put the last variety as a greater value than your target, particularly if you go beyond that target worth.
So, what does this chart say? It represents 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.
In some cases basic charts are all you need to represent the necessary information. Like all other aspects of Looker Studio, you can modify the style of any chart, table, or element as I did above.
The following options are available for sharing a Looker Studio report:
- Welcome individuals.
- Schedule 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 ="A Thorough Guide To Begin 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 by means of email, it should be a Google account e-mail. They can be included as a “Viewer”or an”Editor.”
- Another data precaution Looker Studio included was how links to the report can be shared. You can choose from: Limited. Just individuals who you have shared the report with can open the link. Unlisted. Anyone on the internet with the link can view(or edit– choose this setting carefully). Public. Anyone on the internet with the link can find and view(or edit– select this setting carefully).
Another cool function Google included is the alternative to limit sharing in the following alternatives. In the share settings, click on the”equipment”icon in
- the right-hand corner: Avoid editors from altering gain access to and including 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="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 Begin With Looker Studio (The New Google Data Studio)"/ > I typically suggest examining the very first box to prevent editors from altering access or adding brand-new individuals.
By doing so, it allows us to preserve control of the report settings and the integrity of report changes.
Start With Looker Studio Now
Ideally, this introduction to Google Looker Studio will empower you to feel more positive in creating personalized reports for your customers and brands.
Featured Image: RomanR/SMM Panel