How can we create reports based on web contents in Google Data Studio? | Precognox

How can we create reports based on web contents in Google Data Studio?

 

Data Studio is Google’s own Business Intelligence tool for analyzing and visualizing databases. With this easy-to-use tool, we mostly analyze the data available within the corporate structure.
With the app, we can easily work with data that can be accessed with other Google products, such as:
– Analytics
– AdWords
– Search Console.

You can also visualize data that comes from the following solutions:
– YouTube Analytics
– Twitter
– eBay.

But how can we display additional content from the Web in Data Studio?

 

Using TAS Data Collector, a service developed by Precognox, it is possible to use further contents available on the Internet within Google Data Studio.

 

How?

We show this process with a step-by-step guide.

 

1. Selecting and downloading a particular web page (as a data source)

 

In the first step, we download the selected web data (in our example, the content of the Keresővilág Blog website) using the TAS Data Collector service. However, in the case of unstructured data (text content) on the web, downloading is accompanied by a number of tasks (data cleaning, validation) that are accomplished by our data specialists. As a result of these workflows, a structured database is created, which will be continuously updated in the future, so that the data is always available and usable.
The user gets access (server data, user name and password) to the structured database through a secured, password-protected channel.

 

The following steps are required in the Google Data Studio interface:
2. Select the data source by clicking Data sources, then click “+” (in case of first use, accept the terms of use)

 

3. Click the Developers button on the pop-up page

 

4. Enter the Deployment ID you received from us previously, then press Validate and Select button

 

5. Press Authorize to accept the community connector

 

6. After entering the Key you received from us earlier, click the Submit button

 

7. After selecting the data table, click the Connect button

 

8. Data analysis and visualization can begin

 

Example of completed visualization

 

In addition to providing insight into the content of the web-based data source (chosen website), the visualization is a great business asset as it can be a part of presentations, business reports, evaluations, or even competitive analyzes. In this way, the potential of huge amounts of data on the Internet can be exploited.

Are you also a Google Data Studio user? Do you want to know more about our text analytics solutions?
Contact us!

Péter Hódi
phodi@precognox.com
+36 20/416-74-79

Read more about TAS Data Collector on the TAS Text Analytics System page.

Structured databases provided by TAS Data Collector – thanks to integration – can be visualized with most known business intelligence tools (Tableau, RapidMiner, Power BI, IBM SPSS).

 

Pictures: Google Data Studio interface and visualization