We use cookies to ensure the correct functioning of this website, to provide you with the best possible service, to improve the user experience and to optimise our website.

Decline

Explanatory video offer

Create now in only 2 minutes

Start now

20 October 2020

Google Data Studio - The first steps to the report

In September 2018, Google launched its Google Data Studio reporting tool. We show you how to create your first dashboard.

Calculate offer online

Google Data Studio - Google's data visualization tool, which was released in the fall of 2018, is becoming increasingly popular due to its relative ease of use. The tool, which is provided free of charge, belongs to the Google Analytics 360 suite family, which also includes well-known applications such as Google Analytics and Google Optimize.

Why the Google Data Studio?

If you work with data in your organization, you know how much work it can be to present the right metrics in a clear, concise, and visually appealing way. You like working with data, but you certainly don't like cluttered Excel spreadsheets. And while the standard Google Analytics dashboards are informative, they're not visually appealing and are pushing their limits.

Reports can get even more complicated if you want to combine data from different sources into a single view. Is your goal to analyze Google ads and Facebook ad campaigns side by side? A spreadsheet won't cut it in this case. Here's how you can use Google Data Studio to merge your data and create reports and dashboards.

The basics

Add data sources

To feed the Google Data Studio with data, so-called connectors are used. Google offers its own Connectors, with which you can pull data from common Google applications (e.g. Google Ads) or use data from your own MySQL databases or simply import CSV files.

These connectors offer you a great way to get data from your Google applications into Google Data Studio in seconds.

However, what if the data you want to analyze is not stored at Google or you don't have a central data warehouse where your data resides? For example, your marketing spend information might be on Facebook and LinkedIn, while your financial information might be in a separate accounting program like Debitoor or SevDesk.

In this case you have two options, either write your own script in Google Apps Script, or use one of the Available Partner Connectors. We will cover the former in a separate post on this, as it requires more patience and some experience in developing. With the Partner Connectors offering, you get a wide range of connectors (currently 180 providers) that allow you to easily and quickly get your data from Facebook Ads, LinkedIn Ads, and many more apps.

The first dashboard

Now that you have your data together, it's on to reporting. The Data Studio offers a great way to create your own reports with countless charts, tables, graphs, lines and much more. For those who, like me, don't have the patience to work on visual representations for a long time, there is also a large selection of ready-made templates. With these templates, you simply select your data source to bring the dashboard to life with your apps' data.

4 important questions you should ask yourself:

1. Who is the dashboard for?

Ask yourself who will be looking at the dashboard regularly and what numbers are important to that person. A marketing manager is certainly happy about a nice comparison of different marketing channels of your company, but the person responsible for finances can do relatively little with it.

**Which key figures are relevant?

Especially in Google Data Studio, there is a high risk of straying from the actual question. Therefore, always ask yourself how the current key figure or the diagram conveys important knowledge to the reader of the report. This is the only way to ensure that the dashboards bring real value to your company and are not just the excesses of someone who enjoys looking at nice colorful reports.

**How often is the dashboard used?

If the number of available data sets is relatively small, or there is not much data on your business in general, then there is no need to analyze the latest numbers every day. Especially with little data, the significance is low due to the small samples. However, if you bring a lot of traffic to your site or invest money in paid advertising, then it makes sense to look at the current changes at regular intervals.

**Is Google Data Studio right for me?

Google Data Studio, PowerBI or Tableau, the market of business intelligence applications is huge. Although Google Data Studio is free and easy to use, there are other applications, such as Microsoft's PowerBI , that should be considered. Especially if your company's data is largely on Microsoft's cloud service (Microsoft Azure), then the effort to visualize the data with PowerBI can be much more pleasant than it would be with other applications.

Conclusion

Google Data Studio shines with its ease of use and quick ability to provide nifty and meaningful dashboards for your business. With 17 of its own connectors and over 180 additional partner connectors, Google offers a great way to unify and visualize data from a wide variety of data sources - and it's free.

Just log in with your Google account and get your report created.

Get advice now Calculate price online

Your contact persons

My team and I are always available to answer any questions you may have about your explainer film project. Just call us spontaneously or send us an email!

+44 178 547 22 30

[email protected]

Sohail Khokhar

Our video expert for your questions

Contact now

Get started now

Step 1: Fill in the kick-off form

We are experts in our field - but when it comes to your idea, you are the real professional.

To understand your product and be able to present you with a tailor-made solution approach, we want to learn more about you and your product.

To do this, you will find the most important questions in our kick-off form.

To the kick-off form

Step 2 StartUp conversation

We will then present our ideas to you in a non-binding 30-minute meeting.
From the target group approach, to the content, to the design of the video and its use, your future project manager will advise you personally.

Step 3: We create your video.

In our four-stage production process, our entire team gets really creative for you - of course, you'll be there live during production.

We think about how to untie the knot in your customer's mind to help your product gain more attention and success.

Step 4 Integration of the video

The best explainer video in the world won't help you if it's not staged properly. We know exactly how effective a video can be and where it should be integrated so that it can unfold its full potential. Whether it's as a promotional tool in Facebook Ads or as a customer magnet on your website. We know what to do and are at your side as a competent partner as a matter of course.

Contact now

Latest blog posts

Always stay up to date - With the latest Videobakers blog posts.

6 August 2021

Flat Design Animation: Everything you need to know

22 February 2020

Progressive Web Applications (PWA) Revolutionize Apps

21 February 2020

Increase sales and higher conversion rates with video

13 April 2020

The dispatching software for driving services and transports

22 October 2020

The right explanatory video speaker for your project

12 July 2021

5 reasons why video marketing brings real success

18 July 2021

3 things you can do with an animated explainer video

21 February 2020

The 10 best explainer video tools for explainer videos

5 December 2020

How to get your corporate design right in video.

Unsere Bewertungen

Unsere Bewertungen von Google, ProvenExpert und co.

Markus Hauken

Sehr empfehlenswert, gute Qualität, faire und passende Preisgestaltung und vor allem sehr angenehmen Zusammenarbeit und Kommunikation. Kundenorientiert und flexibel, bedingt durch eine Umfirmierung mussten wir ein gerade fertig gestelltes Video nochmals anpassen, dies wurde sehr schnell und zu einem minimalen Aufpreis schnell und unkompliziert gelöst.

M. Oschmann

Wir sind absolut begeistert von den Videobakers.
Von der Projektabwicklung bis zum hervorragenden Ergebnis war alles Super. Wir wünschen dem ganzen Team weiterhin viel Erfolg. Herzlichen Dank!

Christian Kühn

Top Ergebnisse, super nette Ansprechpartner und stets professionell sowie flexibel. Ganz klare 5 Sterne! Weiter so Videobakers!