In online marketing today, one thing matters most: data, data, data. But what use is all this diverse information that you have been collecting and evaluating if you only use it to address a vague group of people? A better way is to identify the individuals behind the data and...
In online marketing today, one thing matters most: data, data, data. But what use is all this diverse information that you have been collecting and evaluating if you only use it to address a vague group of people? A better way is to identify the individuals behind the data and put the focus on them. Creating concrete buyer personas helps to ensure that your carefully planned-out marketing measures...
When we shop online, book vacations, and search for gift ideas, we hardly give a second thought to the fact that each search entry leaves behind a trail of our identity. Busy web bots are never far behind and sweep up this information. The result of all of this is Big Data: massive volumes of data that are analyzed and used for a variety of reasons. But is there reason to be wary of leaving behind...
If large amounts of data have to be indexed and structured, the license-free engine, Elasticsearch, is a popular solution. The Kibana web interface is often used to present the processed data in an appealing form. Together with Elasticsearch and Logstash, this forms the so-called ELK stack. In our Kibana tutorial, we explain step by step how to get the server application Kibana up and running and...
Excel pivot tables can considerably ease the evaluation of data. Data analysis can be especially time-consuming and tedious with complex numerical series, but with Excel pivot, this doesn’t have to be the case. Simply place your data in the right context and filter the essential information in just a few clicks. The pivot table allows you to create expressive diagrams in no time. Find out all you...
Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.
Do you find that lots of the traffic that arrives on your site comes from suspicious sources? There’s no need to worry since website operators encounter inconsistencies in reports from analysis tools (such as Google Analytics, Piwik, or etracker). The reason: referral spam falsifies visitor statistics. Learn how hackers can manipulate referrer information and traffic data, as well as which...
Your website or online store is finally ready, but you still need to adapt and optimize it. Even small changes, such as the position of a form or CTA buttons, can have a positive impact on your business. Running simple A/B tests enable you to check certain hypotheses and test them accordingly. But if you decide to use A/B testing to help your company succeed, you need more than just the right...
What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...
Website tracking is very important in online marketing to be able to see how users are interacting on your site. The first choice is normally the tracking tool offered by the search engine, Google. But for data protection reasons, more and more users are looking for alternatives to Google Analytics. There’s a great selection of web analytics tools – we will examine applications with similar...
Tracking tools can provide website operators with a useful indication on how to adapt an online project to suit a target group. These tools focus on user profiles, which reveal how users find the website, and which content provokes interactions. This information is based on user data, which can be subject to stringent data protection guidelines in some countries within the European Union. Find out...
