When you haven’t heard, Looker Studio has changed the well-known Google Knowledge Studio model.
Whereas Google Knowledge Studio made reporting simpler for a lot of entrepreneurs, it definitely had its limitations.
As a model’s advertising technique evolves and turns into extra advanced, so does the sophistication of its reporting wants.
When you’re something like me, you’re possible bored with spending hours updating the identical spreadsheets every month.
Generally, extra time is spent pulling a report than offering precise insights.
When this occurs, we’re doing a disservice by spending extra time “doing” and fewer time truly analyzing the info.
There must be a greater approach, proper?
This in-depth Looker Studio information will educate you the best way to create and customise action-oriented reviews primarily based by yourself knowledge.
What Occurred To Google Knowledge Studio?
Initially launched in beta mid-2016, Google Knowledge Studio is a free data visualization device.
Many entrepreneurs have used this device for years to unify and visualize knowledge units from a number of channels.
However now, you’ll discover that Knowledge Studio is not referenced. The place did it go?
Google formally rebranded its Knowledge Studio product to be named Looker Studio in October 2022.
Of their official announcement, Google acknowledged:
“We’re unifying our enterprise intelligence product household below the Looker umbrella, bringing collectively Looker, Knowledge Studio, and core Google applied sciences like synthetic intelligence (AI) and machine studying (ML). Looker Studio remains to be free, and has the identical options as Knowledge Studio.”
What Is Google Looker Studio?
Google Looker Studio (previously Knowledge Studio) syncs your whole knowledge sources into one unified reporting expertise.
It allows customers to create informative and visible dashboards which might be simple to interpret, share, and customise.
Primarily, Looker Studio helps transcend knowledge visualization. It’s aimed to assist entrepreneurs make extra data-driven selections for his or her shoppers and types alike.
At the moment, Looker Studio helps over 800 completely different knowledge sources, together with 600+ knowledge connectors.
Looker Studio Vs. Knowledge Studio
Whereas Looker Studio touts lots of the similar options as the previous Knowledge Studio, the brand new identify additionally brings new options.
- Free model and Pro model (paid).
- Totally different modeling technique (LookML).
- Looker integration with Google Sheets.
- Extra versatile knowledge modeling options.
- Helps 50+ SQLs and databases.
- Merging options from completely different knowledge sources.
One of many key variations between Looker and Knowledge Studio is the way in which knowledge is modeled. Looker Studio makes use of LookML (Looker Modeling Language).
The second key distinction that the majority entrepreneurs will profit from is the brand new and improved knowledge merging options from Looker.
In Knowledge Studio, it allowed for knowledge sources to be blended.
Nevertheless, the most important draw back of this was that the mixing characteristic was primarily based on a left outer be a part of and infrequently didn’t mix knowledge in a approach that entrepreneurs wanted.
It was a tedious course of that left many to spend extra time manually importing their knowledge right into a Google Sheet, then connecting that supply to Knowledge Studio.
Sounds irritating, proper?
Looker Studio, then again, requires SQL databases to combine any supply. Because of this uncooked knowledge is handed right into a database, making it a lot simpler for Looker to merge data from completely different sources.
The end result? A sooner, extra significant method to visualize knowledge from all of your completely different advertising sources in an easy-to-digest format.
Getting Began With Looker Studio
There are just a few key areas to make sure your first Google Looker Studio report is a hit. These embrace:
- Selecting a template or dashboard.
- Connecting knowledge sources.
- Selecting metrics that matter.
- Sharing reviews.
Looker Studio Templates
The very first thing to do is to decide on a template.
To entry Looker Studio, go to Looker Studio utilizing your most popular Google Account. This needs to be the account that you just entry your Google Analytics, Search Console, Google Advertisements, and so on.
Looker Studio supplies all kinds of templates to get you began.
When you’re new to Looker Studio, you will need to select a template primarily based on the kind of knowledge being portrayed.
With any template, you could have the power to customise objects and fonts to create a extra constant report.
The fantastic thing about these reviews is that a number of pages might be added.
Don’t really feel like your complete advertising story must be proven on one web page!
Each consumer has completely different wants, and their reporting needs to be no completely different.
Essentially the most environment friendly route I’ve discovered is to make use of and tweak completely different dashboards primarily based on who the supposed viewers is.
For instance, I could create a special dashboard or report web page if I’m speaking to a CMO vs. a Product Advertising Supervisor. Why?
Relying on the function of who you’re speaking to, they may perceive and interpret knowledge in several methods.
A CMO, for instance, doesn’t have to know the “within the weeds” knowledge. They wish to know what channels are working, what’s not, and in the event that they’re on observe to satisfy their objectives.
Join A Knowledge Supply
Now that you just’ve chosen a template, it’s time to attach your knowledge sources.
So as to add a connector to your template, go to Useful resource on the prime navigation, then click on Handle added knowledge sources. Then, you’ll click on + Add A Knowledge Supply.
There are at present 24 completely different Google connectors, equivalent to Google Analytics, Google Advertisements, Google Sheets, BigQuery, and extra.
Nevertheless, you’re possible utilizing different platforms like social media, third-party instruments, CRM programs, and extra.
For these non-Google connectors, Looker Studio can join over 650 completely different knowledge sources from their companion connectors!
Through the use of the connectors, it takes the handbook duties and syncs all knowledge for you!
It’d be inconceivable to record all of the obtainable knowledge sources right here, however a few of the fundamental ones I’ve used up to now embrace:
- Supermetrics connectors for:
- Fb + Instagram Insights.
- Microsoft Promoting.
- Advert + Google Analytics Knowledge.
- Place Monitoring.
- And lots of extra.
Most of those knowledge sources come from third-party connectors. Take into account that lots of them:
- Extra value.
- Can decelerate reviews.
- Metrics are generally deprecated, which means it’s important to remain on prime of any modifications to your report and rebuild metrics if wanted.
When including an information supply, you’ll be requested to authorize the connection between accounts.
Selecting Metrics That Matter
Talking of metrics – they matter.
Let’s be actual, the worst is when shoppers open reviews and see an entire knowledge dump.
Whereas Looker Studio is totally customizable, this doesn’t imply we needs to be displaying all metrics obtainable.
Does your consumer care about return on promoting spend (ROAS)? Make sure to embrace metrics equivalent to spend and income.
How about total model consciousness? Embody pre-click metrics equivalent to impressions, clicks, CTR, view charge, and so on.
By conveying the right metrics and insights primarily based on objectives, it exhibits the consumer that you’re listening to them. A win-win for everybody!
How To Edit A Report
Now that you just’ve linked your knowledge sources, it’s time to customise that report!
Let’s evaluation this Google Advertisements template for instance.
First, you’ll wish to ensure you’re within the “Edit” mode and never “View.”
You can begin customizing your report by using the info area units on the right-hand aspect.
When you’ve chosen a template just like the one above, step one is to vary the info supply for every chart you want to select.
From there, you possibly can select from any of the completely different knowledge fields out of your chosen knowledge supply to vary any visualization.
Not solely are you able to create and edit charts and tables in Looker Studio, however the means to decide on the appear and feel of a report is a game-changer for shoppers.
It offers a way of consistency throughout a corporation.
A number of methods to personalize the model of your report embrace:
- Font and background shade.
- Altering comparability metric colours.
- Textual content padding to align both left, middle, or proper.
Professional tip: If you wish to change all scorecards or charts without delay, merely choose all on the similar time earlier than.
The model modifications will apply to all picks. One other time-saver!
On this instance, I modified the report background, scorecard colours, and label fonts to create model normal consistency:
When you’re new to Looker Studio, it should take time, trial and error, and endurance to create a report visible that meets your reader’s expectations. Don’t get discouraged alongside the way in which!
Including Report Filters
An environment friendly method to group a number of visualizations collectively is by including report and web page filters.
For instance, when you needed all tables and charts to vary when enhancing the date vary, you may add a Date Vary icon and set it to “Report Stage.”
Because of this if the report is comprised of a number of pages, each time the date vary is up to date, all chart knowledge updates alongside it.
For instance, when you needed to dive into Marketing campaign Sort efficiency, there’s a filter for that!
Merely navigate to the toolbar and select Add a management > Drop-down record and add the Management area of “Marketing campaign sort” as your filter.
This lets you filter the info on that exact web page by marketing campaign sort.
For instance, when you needed to indicate how Search performs in comparison with YouTube, you’d select from the dropdown in that filter.
By default, filters added are at a web page degree.
When you want to make the filter report-level (which means the filter would seem on every web page of your report), merely right-click the filter and select Make report-level.
Create A Chart
When you’ve gotten snug along with your Looker Studio expertise, let’s dive into the best way to create a chart from scratch.
The benefit of making a customized chart is that you just’re in full management from the start of visualizing precisely what issues most.
Step one is to contemplate who will probably be studying this report. Keep in mind to incorporate what knowledge is essential to them.
Your chart ought to inform a narrative, and it’s as much as you to visualise that efficiently.
For instance, chances are you’ll wish to add an “Overview” desk that encompasses the principle metrics or key efficiency indicators (KPIs) that matter to them.
To create a chart, click on on “Insert,” which is able to present you all of the completely different charts to select from. These embrace:
- Time collection.
- Bar chart.
- Pie chart.
- Bullet charts.
- Way more.
On this instance, I wish to select a easy bullet chart so as to add to my CMO Overview web page. The purpose of this chart is to indicate if we met our month-to-month purpose of app installs.
Step one is to decide on the metric you’re measuring. On this case, I selected “Installs.”
To make this bullet chart efficient, it’s worthwhile to add your goal/purpose. Be certain that to verify the field that claims “Present Goal.”
Then, I enter completely different vary limits to indicate the progress.
I saved the final vary the identical because the goal worth. You can too put the final vary as the next worth than your goal, particularly when you exceed that focus on worth.
So, what does this chart say? It portrays that our purpose was 5,500 app installs for the month of November.
In line with the bullet chart, they have been near hitting their purpose however didn’t fairly make it.
Generally easy charts are all it’s worthwhile to symbolize the mandatory knowledge.
Like all different parts of Looker Studio, you possibly can modify the model of any chart, desk, or aspect as I did above.
The next choices can be found for sharing a Looker Studio report:
- Invite individuals.
- Schedule electronic mail supply.
- Get report hyperlink.
- Embed report.
- Obtain report.
If you wish to invite individuals to entry the report in actual time, it’s essential to verify the share settings.
So as to add somebody through electronic mail, it should be a Google account electronic mail. They are often added as a “Viewer” or an “Editor.”
One other knowledge security measure Looker Studio added was how hyperlinks to the report might be shared.
You’ll be able to select from:
- Restricted. Solely individuals who you could have shared the report with can open the hyperlink.
- Unlisted. Anybody on the web with the hyperlink can view (or edit – select this setting rigorously).
- Public. Anybody on the web with the hyperlink can discover and look at (or edit – select this setting rigorously).
One other cool characteristic Google added is the choice to restrict sharing within the following choices. Within the share settings, click on on the “gear” icon within the right-hand nook:
- Stop editors from altering entry and including new individuals.
- Disable downloading, printing, and copying for viewers.
I sometimes advocate checking the primary field to forestall editors from altering entry or including new individuals.
By doing so, it permits us to take care of management of the report settings and the integrity of report modifications.
Get Began With Looker Studio Now
Hopefully, this introduction to Google Looker Studio will empower you to really feel extra assured in creating personalised reviews on your shoppers and types.
Featured Picture: RomanR/Shutterstock