GANDT Ventures GmbH
Company Builder & Digital Consultancy

general news

How to fix UTF-8 issues in csv-files

This is one simple life hack for anyone who works with .csv files and excel. It can be tricky to fix encoding issues, especially with german characters (ö, ä ü). This quick tutorial shows you exactly how you can resolve this problem. The solution is a simple, but effective work around.

We first encountered this problem when exporting a product feed from one of our customers magento backend. Although the file did not seem to be corrupt and it worked in Notepad++, it did not seem to work well in Excel. The encoding issue made it impossible for us to use the product feed (see below).

How to fix UTF-8 issues in csv-files

Background information: What is a product feed? 

A Product feed is essentially a list of products in your shop. This list usually comes in the form of a .csv-file or .xml-file. Either one of the two can be used for up,-  and downloading product information in bulk. Many affiliate marketing publishers work with product feeds (such as Google Shopping, Amazon, or Awin).  

If you have any further questions about this life hack, or need some help with your own data-issues: feel free to reach out to us by using the contact form.

Management coaching: Learn from Google

Google as a data driven company has spent years studying and observing the attributes of effective management and has been sharing these information internally in trainings. During my time at Google I have always been very grateful for having the access to these information and found it always a pity that these insights were only available for Google managers.

What makes a great manager?

Time has changed and Google has presented recently a platform called re:Work where they share their insights on people development, organisational research results and handy guides and tools on many other team development topics.

Here’s is an example of what you can find on re:Work:

Giving and receiving feedback as a manager can sometimes be hard. Find here a guide which gives you a framework for effective feedback. Guide: Give feedback to managers Continue Reading

How to: Cohort Analysis in Tableau

 

Cohort Analysis are used to study the behaviour within your customer group and gives you the ability to understand your customer preferences, causes and even actions on changes to your product or strategy.

We love Tableau!

Are you running an ecommerce business, offering services through digital channels where you interact regularly with your clients? You definitely need to have a look at your cohorts!

It shows you exactly which marketing activities led to wich amount of commercial success and breaks down your clients buying activities into a meaningful fraction and shows you exactly the amount of days/ weeks your client took to repurchase or reorder.

 

An example of Churn Rates with newly acquired customers within a period:

Continue Reading