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.

How do you know you are in control of your data?

Want to find out whether you are really in control of your own data? In this short YouTube-Video we dive into the topic of data ownership.

As a decisionmaker, Data Quality is probably the one topic that is holding you back most on a day to day basis. If you want to be able to judge whether data is truly clean, you need to know where it came from. In our opinion you need to understand how data is collected to determine the quality of your data.

Therefore the first simple question we generally ask when we get started on a project is: Who do we need to go to for the insights that we need to be able to help you?  In this short video we dive into the answers we get and some straightforward implications of poor data ownership.

„How do you know you are in control of your data?“ weiterlesen

Data-driven sourcing and inventory management for fashion retailers

Sourcing is one of the most important success factors for a fashion retailer. The main challenge in sourcing is of course to buy the right styles and high quality collections that suit your customer base. 

Sourcing is by far the most crucial element of a healthy retail business. Therefore it deserves a good bit of strategic senior management attention.

Fashion Retailers have a number very industry specific challenges on their hands. For starters: the relatively short product life cycles paired with long production times and lead times make it very hard to plan. Understanding your inventory risk at an early stage in the season or even before placing your orders, is absolutely essential. „Data-driven sourcing and inventory management for fashion retailers“ weiterlesen

Things to think about in your marketing plan

If you are setting up your marketing plan, you will most definitely want to take these things into consideration. Planning can be painstaking and difficult at times, but essential if you want to make an impact.

The most important thing about planning, is that you do it. Often enough it is quicker and easier to simply do what others have come up with, or what agencies propose. Yet you should definitely know your customer base better than that. You know what works and what does not. And if you don’t (just yet), plan it into your budget to find out what will work and what doesn’t.

These things will help you put together a solid marketing and budget plan:
„Things to think about in your marketing plan“ weiterlesen

How To Secure Data Integrity in Google Analytics

Data Integrity should be a strategic asset for any digital business. If you make “clean data” a priority, it opens a lot of doors to insights that will fuel your business’ success.

Knowing how to work with tools and data on a daily basis has become essential for any performance marketeer. Digital businesses and multi channel digital businesses rely on great data visualization tools that help optimize campaigns and streamline operations.

One of the most commonly used tools is Google analytics. Even in the free version of Google analytics, users are able to see a large number of insights of their business. These insights can be very helpful in understanding your customer base and campaign success.

However, what many do not know is that all tracking tools need to be fed correctly. Tracking tools such as Google analytics, ECONDA and Adobe omniture site catalyst, understand a lot of your data from the get go. But if you format your data correctly it becomes a lot easier to work with. „How To Secure Data Integrity in Google Analytics“ weiterlesen

Life Hack: Fix Tableau HDPI Problem On Your Windows PC

Today I would like to share a life hack with you that will really have a big impact on your work and quality if you work with tableau on a high resolution screen and Windows computer.

At GANDT Ventures we use Tableau as our main analysis and Data visualization tool. Tableau is absolutely fantastic, this sheer power it has in dealing with large data sets combined with its ease of use is unparalleled. Each of our employees works with data visualization tools on a daily basis to give our customers and partners the insights  they need to do a good job.

„Life Hack: Fix Tableau HDPI Problem On Your Windows PC“ weiterlesen