COUNTIF in Excel

Practical functions in Excel: COUNTIF explained

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...

Heat map analysis: usability check for you web project

Heat map analysis: how to visualize your visitors’ behavior

By knowing the total number of unique visitors and purchases made on your website, you can quickly calculate the conversion rate for your online store. This figure, however, doesn’t reveal why a visitor made a certain purchase or deciding against buying a product. A heat map analysis, on the other hand, can shed some light on the matter and help you to increase the number of conversions.

A/B testing: statistic problems and other obstacles

Statistic problems and other obstacles with A/B testing

Website usability tests are a common method of optimizing your web project. A/B testing is especially popular and this method consists of comparing two variants of a page with each other. However, actually implementing and analyzing one of these tests isn’t easy, even with powerful tools. Statistic problems and poor decisions quickly lead to you defeating the purpose of the optimization.

A/B testing for website optimization

What is A/B testing?

Your product range is complete, the technical implementation is finished, and with the help of web designers and graphic designers, you have created the perfect visual concept for your online store. But what happens if clicks and conversions fail to materialize? Sometimes it’s down to a small aspect like a color, a button, or how single elements are arranged: any of these can dissuade website...

KPIs in online marketing

Key performance indicators (KPIs) in online marketing

In the world of online business there are various performance indicators which are used to measure the success or failure of a business. In the e-commerce and publishing sector, analytical tools enable you to develop various optimization measures based on KPIs as well as allowing you to get the most out of individual pages and campaigns. The tools can be used to uncover any weaknesses and show...

Tips for successful A/B testing

6 tips for significant A/B tests

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 machine learning? How machines learn to think

Self-learning systems: how does machine learning work?

Artificial intelligence has fascinated us for centuries: Countless books and films about robots and computers that behave like (or not like) humans testify to both the enthusiasm and concern we have for artificial intelligence. But how do machines get so smart? We explain how machine learning works, where it is already being used, and how self-learning systems can revolutionize the world of...

Personas

Personas: How to get closer to your customer

Every company wants to work close to the customer, to focus on the user. However, many companies only use averages and statistics as a basis. This is not how to reach the individual buyer. Personas are different. They are based on real people and reflect the heterogeneity of the target group. What do you have to pay attention to?

Attribution models in online marketing

Attribution models

Any marketer will tell you that getting your marketing strategy right is the most important thing for businesses online. To reach your potential target group as effectively as possible, it makes sense to have an ideal mix of different advertising channels. But how do you know that you’re spending your marketing budget in the right areas? Which ad channel is the best one for you to invest in? This...

WDF*IDF: The Formula for better Content

WDF*IDF: What can the SEO miracle formula really do?

One of the most important tasks when it comes to designing your own website is creating and publishing high-quality texts. They shouldn’t just be highly relevant and readable, they should be optimized for search engines to rank highly as well. While the days of using keyword density as a quick path to success are over, semantic analysis methods like WDF*IDF are becoming more and more important...

1