We work with it every day. It now even determines what we consume, think, know or perhaps even feel. And yet, very few people actually know what the Internet is. The word “Internet” is derived from the English “Inter+network”. A network that establishes a common connection between many computers. Each computer can connect to any other computer.

The origins of the Internet go back a long way

When the first households and companies installed their own telephone systems, the world suddenly grew much closer together. At that time, you had to be connected to the other line via a central telephone exchange in order to call someone. Each telephone had its own fixed address, so the employees of the switching systems could connect the plugs with each other.

Related image

An old telephone exchange – Source: troeger.eu

Why the Internet was developed

At that time, universities and research institutions wanted to exchange information faster and more efficiently. Back then, there were still mainframes that filled entire rooms. The first Internet thus emerged from the networking of these mainframes. The fact that it had a purely military purpose is only a legend.

A large-capacity computer – Source: Techpinions

How has the Internet developed so far?

The Internet has undergone several great transformations. These transitions are also called Web 1.0, Web 2.0 and soon Web 3.0.

Web 1.0 describes the beginnings of the still young Internet. It stands for the collection of websites that were completely connected by so-called “hyperlinks”. In general, Web 1.0 was about static websites that did not provide interactive content yet. A hyperlink is a simple link that redirects a user to another website.

Web 2.0 is also often equated with the beginnings of social networks. It describes an environment where non-experts, user-generated content, and media could be made available in a simple and uncomplicated way.

The web now is entering a new phase of evolution. Recently there have been many discussions about how to call this new phase. Some would prefer not to name everything, while others suggest continuing to call it “Web 2.0”. However, this new phase of evolution has a very different focus than what Web 2.0 means.


The smarter Web 3.0

The threshold to the third generation web has already been crossed. The web is becoming more networked, more open and more intelligent. It becomes a seamless and interoperable whole. Semantics, the meaning of signs, will play an increasingly important role. The Internet will become a gigantic database that will hopefully be equally available to everyone.

Web 3.0 will, therefore, be more networked, open and intelligent, with semantic web technologies, distributed databases, natural language processing, machine learning, machine thinking, and autonomous agents.

The future is Web 4.0! No it is not science fiction, it happens and it is a natural process

Signs that we already notice today when we talk about artificial intelligence and smart chat bots. In the future, the Internet will provide intelligent assistants, who search and find information for you. We are also talking about the new “Web OS – Operating System”. Perhaps the Internet is the birth of a higher intelligence that might enrich our lives.

We determine ourselves what we make from it. For this reason, digitalization should be taken more seriously. You have to deal with it or decide to stand still and wait and see what happens.

A part of the internet that has been visualized – Source Wikipedia (The Opte Project)





tablet on the airpi

I recently arrived from New York after a long journey and was surprised how far the digitalization in the USA has evolved compared to Germany. A nice example can be found at one of the international airports of New York (EWR). I noticed that in the USA self-service really matters. There is hardly any service personnel left at the checkout, you scan the products yourself and usually pay by credit card or at the cash machine. You can order with tablets that have been placed at almost every table. Banner advertising also makes it clear where artificial intelligence is currently being used.

In American schools, it has become common for parents to be able to view their children’s grades at any time via an app. It is said that Asians tend to copy concepts from the western world. I’m afraid that Europe, especially Germany, tends to copy digital concepts from the USA. There are enough examples of this, starting with social networks through to e-commerce models. In Silicon Valley, people also talk about German copycats. The best example of the German “digital success” is Rocket Internet and the Samwer brothers at the forefront.

Where’s all this heading? Are we on the threshold of one of the highly praised German inventor nations? And yet most of the new patent applications originate from medium-sized German companies. But the future of digitization is determined not by patents, but by start-ups. Unfortunately, I have to say on the basis of my own experience that Germany does not play a major role in digitization. The largest Internet companies come from the USA, with Google, Microsoft, Facebook, etc. leading the way.

In New York, I noticed many posters for AI products that are already in use.

In my opinion, Germany has the following problem: Too many consultants, too few makers. There is much talking, even less action. The politics and start-up scene in this country is firing up supposedly innovative companies and often blinds itself. Education and a basic understanding of digital concepts are barely present in the population. It already starts with the most popular terms ” digitalization “, ” Big Data ” and recently also ” AI “. These terms are used for almost everything that has to do with innovative digital concepts.

I had achieved more business in the 5 weeks of my USA trip than in the last 5 years in Germany. Why? Unfortunately, German investors and decision makers from many companies often seem helpless when it comes to understanding digital concepts. They only tend to follow the press and current trends which are hotly discussed.

In the USA it’s about making life easier, not more complicated with tools.

Is there a way out of this “German” dilemma? In my opinion, it will be difficult, because why should people here in Germany admit that they do make mistakes? This time not only the inventive talent plays an important role, but the society as a whole. A change is tough and uncertain. A country can only master digital change by joining forces. The German government must create an ecosystem for start-ups that can’t sustain themselves on their own but pursue interesting concepts. You have to stop tearing ideas apart verbally and get more involved with the concepts. Anything else would only be a distraction from one’s own ignorance. This will be paid dearly if a collective rethinking does not take place in time.

The future in Germany belongs to the lateral thinkers, not to the business administration university graduates

As a company founder, it wasn’t always easy for me. Especially with my Asian origins, I don’t feel recognized here. You always have to justify yourself and present evidence. That’s what my team and I have accomplished. Within three years we have developed and successfully launched a highly complex analysis software in the cloud without financial investments.

Many companies have already failed here. Our startup is the proof that money alone can’t make a difference. It is about the vision and the belief to change the world.



Consider 5 important questions before creating your google analytics KPI dashboards

You have been given the task of creating one or more dashboards for the online marketing team using Google Analytics as their primary data source. You’ll also need to compare different Google Analytics Views (Websites) in one comprehensive report? To perform this task, you may have the following tools at your disposal: Excel, Tableau, Power BI, Looker or any other business intelligence tool. For example, you decide to create your reporting from Google Analytics in Excel first and then, after successful internal reconciliation, implement your logic from excel in an online dashboard. The following questions play an important role and should, therefore, be carefully considered before each dashboard creation:

  • What data from Google Analytics do I need as a starting point for my reports?
  • How do I import the data from Google Analytics into my Excel, Tableau or Power BI project?
  • How do I aggregate or calculate my most important Google Analytics Management KPIs?
  • How do I continuously enter the data without creating additional manual effort for dashboard maintenance?
  • How do I organize my dashboards and for which user groups should I create them?
  • Some general information about Google Analytics in advance

Google Analytics is the most commonly used web analytics tool to track and analyze user data on a website. In general, Google Analytics is free of charge for websites with small to medium traffic. For websites with e.g. more than 100.000 sessions per day it can cost a lot. Google calculates so-called hits, i.e. every time a user performs an action on the website, an event is transmitted to Google Analytics Server. In addition, they should definitely pay attention to data sampling in Google Analytics. Further details and how to fix it can be found in our article: Avoid Google Analytics Data Sampling in reporting.

Question 1: What data from Google Analytics do I need as a starting point for my reports?

To answer this question you should first think about the structure of your output table. Google divides the data into metrics and dimensions. This is briefly explained by a small example: Thomas’ dog wears a GPS collar which transmits data about the current location and other information to Thomas’ smartphone every second. Let’s assume that Thomas wants to receive a message when his dog moves more than 1,000 meters from the property. The collar transmits in second intervals the current GPS coordinates and the absolute distance to the property. Now the current distance can be regarded as the measuring point. The coordinates and the current time are dimensions that describe a measuring point. A metric or measuring point is determined by its dimensions such as time and location. Using the Google Analytics Metrics Explorer: To determine your output table, use the following tool, the Google Analytics Metrics Explorer. Activate the field “Only show allowed in segments” to select only dimensions and metrics that are valid for the data model. Background: Valid combinations – Not all dimensions and metrics can be queried together. Only certain dimensions and metrics can be used together to create valid combinations. Select a dimension or metric check box to display all other values that can be combined in the same query. Also, switch to UI Names mode to get the same naming as in Google Analytics. Next, you can select your metrics and dimensions and directly check if they are valid. Limit for a Google Analytics query result: A maximum of 7 dimensions and 10 metrics can be used in one query. There are a few tricks on how to increase this number. Read more in one of our later articles. In our example we use the following query:

  • Dimensions: ga:date, ga:landingPagePath, ga:fullReferrer, ga:deviceCategory, ga:channelGrouping, ga:medium
  • Metrics: ga:users, ga:sessions, ga:bounces, ga:timeOnPage, ga:newUsers, ga:pageviews, ga:goalCompletionsAll

Google Analytics dimensions and metrics explained:


  • ga:date = Date with the format YYYY-MM-DD
  • ga:landingPagePath = The URL of the starting page in a user web session on your website. For example, the first page a user has entered on the website e.g. via a Google search.
  • ga:fullReferrer = The exact referring URL, including the parameters of an external source which a user used to get to his own page. Extract the source of your traffic here.
  • ga:deviceCategory = To which user device the session was conducted. The subdivision is Mobile, Tablet or Desktop.
  • ga:channelGrouping = Traffic sources from Google’s fullReferrer are already pre-categorized and grouped here. Here you can find: Organic Search Engine, Direct, Paid Search Engine, Referral or Social.
  • ga:medium = The UTM medium describes the type of source itself, e.g. organic, pay-per-click (paid ads), etc.


  • ga:users = The number of unique users identified by a cookie in the browser. Problems can arise if the users use several devices, i.e. it is actually one and the same user. However, this can only be differentiated in a complex way. In a later article, we will resolve this topic in more detail.
  • ga:sessions = The number of sessions on the website. A session begins when a user enters a home page of the Website. If the user does not perform an action within the next 30 minutes, it expires and is counted as a new session again. A session can be equated with a visit. The customer enters the store and leaves it after a certain period of time after viewing the product range.
  • ga:bounces = The number of direct jumps after entering or starting a session without an action having been performed beforehand. The user enters the website and leaves it without performing any action beforehand. E.g. click on a website element or follow another subpage.
  • ga:timeOnPage = The time a user was active on the site, i.e. when he or she conducted a session.
  • ga:newUsers = New visitor sessions within 30 days or after deleting the cookie in the browser. Only new sessions are counted.
  • ga:pageviews = The number of all page views during a session.
  • ga:goalCompletionsAll = All goal completions on your website. These can be defined in advance in Google Analytics.

Question 2: How do I import my data from Google Analytics into my Excel, Tableau or Power BI project?

When you are ready and know exactly which dimensions and metrics you want to load from Google Analytics, you can go to the step and load the data into your Analytics tool. Many business intelligence tools offer ready-to-use interface editors. For all tools, you should pay attention to the sampling level. More about this in the following article: Avoiding Google Analytics Data Sampling in Reporting So that no data sampling occurs, I recommend using the Google Analytics Custom Reports and create a table there. This can then be downloaded as an “Unsampled Report” in the form of a CSV. This CSV document can be used as an Excel data source. You can also use plugins like Next Analytics to load the data directly into your Excel sheet.

Question 3: How do I aggregate or calculate my most important Google Analytics Management KPIs?

So that you can distinguish different domains or properties, I recommend adding another column with the web page URLs or property IDs to your Excel sheet. Then you can aggregate all data from the different accounts. Once you have loaded your data into Excel or another tool, you can calculate your most important KPIs. In Excel, it is best to use “Calculated Metrics” in the Pivot section. The following KPIs can be calculated from the above data set.

  • Bounce Rate [percent] = ga:bounces / ga:sessions

The ratio of direct jumps and sessions indicates whether a user interacts with their content after entering the site or not. This KPI can provide information about the targeting of users and the attractiveness of the content. A good bounce rate can be between 10 – 30%. If this is well below 10%, you should check whether the tracking has been validated at this point. Average session duration [minutes] = ga:timeOnPage / ga:sessions / 60 This Google Analytics KPI shows the average duration a user runs an active session on the site. Determine the average session duration for your shop or website that correlates with a high conversion rate. This session duration can now serve as a benchmark for further sessions from certain entry pages.

  • Average page views per session [decimal] = ga:pageviews / ga:sessions

Also called page depth. A user navigates through different numbers of pages until he successfully makes a purchase or otherwise converts.

  • Conversionrate [percent] = ga:goalCompletionsAll / ga:sessions

Shows the percentage of users who have successfully completed sessions. Normally this rate is between 2% – 5% in some shops even higher, sometimes even 17% – 20%. The conversion rate depends among other things strongly on the quality of the shop, in addition, the industry and the product portfolio.

  • Percentage of new visitors to sessions [percent] = ga:newUsers / ga:sessions

A KPI to evaluate how high the proportion of new visitor sessions is.

  • Sessions per user = ga:sessions / ga:users

Helpful to determine whether users are more likely to make a single or multiple purchase or deal on the site. This KPI also depends on the product range and the industry. Note: Make sure that there are no zero values in the denominator. This can be the case if you filter the data in a certain level of detail.

Question 4: How do I continually enter the data without creating additional manual effort for maintaining the dashboards?

It is best to create a kind of import process of your downloaded CSV file. This can be easily created in Excel with Power Pivot. Most BI tools also offer an automated update. At this point try to keep the steps as small as possible and if possible work with an ETL tool. For example, if you need the calendar weeks, months and years in addition to the date. This has already been integrated automatically in one of the newer Excel versions. If not, simply create a kind of help table and link it to the date. It is best to create a Power Pivot data model for this.

Question 5: How do I organize my dashboards and for which user groups should I create them?

You already know very well your dashboard users and the needs of the department or the teams? All the better, then this task is easy for them. The best way to organize your target groups is to define exactly one Google Analytics query per group, see step 1. The following groups might be interesting for you:

  • Traffic Channel Report: This web report gives you an overview of the performance of traffic sources.
  • Device Report: With this report, you can analyze the performance of your users’ devices such as mobile, desktop and tablet.
  • Landingpage Report: Get an overview of the most important key figures for all your subpages.
  • Conversion Report: Here you get all the important information about your online sales, leads, and deals.

The whole thing sounds pretty cumbersome and time-consuming. I agree with you, but there are alternatives where this effort can be saved 100%. Because if you don’t feel like doing all these steps manually, you can simply take a close look at our ABIS software solution. We offer a Cloud Business Intelligence platform, which makes it possible to install reporting apps very easily and to receive finished dashboards with your data directly without additional work.