Skip to main content

Assessing the impact of poor data on retail: The 1-10-100 rule

As we approach the holidays, and particularly the new year, our thoughts turn to how we can make improvements to our personal life — for example, clean living with better food and more exercise. But how many of us are planning to make improvements to our business? Maybe we should be thinking about our New Year’s work resolutions as well as our personal ones.

For example, what vital improvements can you make to your business to ensure that your deliveries and communications make it to the right customer at the right time? Regardless of the time of year, data is one of the most valuable assets a company owns. This is particularly important as globalization becomes more prevalent and more and more companies have international data in their systems.

So, why do so many businesses neglect to focus on keeping their data clean? When you really think about it, how much does inaccurate data cost your business? And is this just a financial issue, or does it have other consequences?

Too many companies overestimate the quality of their data, believing it to be just fine, when in reality it’s costing them more than they imagine. And by the same token, many companies underestimate the power of validating data at the point of entry, worrying about cost — when in fact, in the long run, this initial cost is minor in comparison to the alternative.

Much like a resolution to lead a cleaner lifestyle personally — businesses need to follow that same mantra — clean data in, clean data out.

Make clean data your New Year’s resolution

To help you put this “clean data” resolution into practice, a useful rule to follow when assessing the impact of your address data quality is the 1-10-100 rule, which was first proposed by George Labovitz and Yu Sang Chang in the early ’90s. Here, I’ll explain exactly what that means for businesses.

In the 1-10-100 rule, there are three phases, each of which explains the cost of maintaining data quality. In the first phase, the “prevention” stage, $1 represents the amount it costs to verify accurate data at the point of capture. This is the simplest and least expensive way of gathering data and ensuring its accuracy and validity.

This is the best possible solution for businesses storing data, as it means communication and deliveries are received the first time, and better business decisions can be made, leading to increased efficiency and growth. Tools like address or email verification ensure you don’t have to worry about dirty data in the future.

However, as we move into the second phase, the “correction” phase, we see that the initial $1 rises exponentially to $10. This $10 represents the increased cost that an incorrect address will have on your business down the line. Without an effective prevention method, dirty data can start to have a serious impact on business efficiency, and companies wanting to resolve the issue will find themselves paying much more than if they had validated their data in the beginning.

And as we head into phase 3, the “failure” phase, we see that the amount increases tenfold to $100. This $100 represents the amount companies will pay for doing nothing about their poor data.

Unfortunately, it isn’t just a simple financial issue, either. Bad data too often leads to more bad data, which eventually leads to bad business decisions and poor efficiency. This can also cause failed deliveries, missed marketing opportunities, a poor level of customer service and lack of compliance.

We all know the golden rule of customer service: “A customer may forget what you said, but they’ll never forget how you made them feel.” This goes for bad experiences too — fail to deliver that all-important Christmas gift and the reputational damage is magnified. On average, consumers tell approximately eight people about their good experiences and more than twice as many people about their bad experiences, according to the American Express Global Customer Service Barometer.

According to our recent research, a massive two-thirds (66 percent) of retailers say the accuracy of address details is critical to their business, but 80 percent of retailers say that customers often don’t realize that failed deliveries are due to the fact that they mistyped their address. If customers are entering incorrect address data into your forms, and you aren’t aware that these are incorrect, this can only lead to issues.

This emphasizes the importance of validating your customer data from the very beginning, rather than leaving it to chance or having to clean it at a later date. Though the costs mentioned in the 1-10-100 rule are not exact, they are a great indication of how much costs increase the longer you leave dirty data in your database.

So rather than resorting to an expensive and time-consuming process of trying to correct poor data in your system, it really does pay to validate at the point of capture. Not only will this ensure that you won’t be spending more than necessary on cleaning data, it also helps you ensure that relationships with customers and brand reputation remain strong. Remember, quality data is for life, not just for the holidays.

via Marketing Land


Popular posts from this blog

How to Get SMS Alerts for Gmail via Twitter

How do you get SMS notifications on your mobile phone for important emails in your Gmail? Google doesn’t support text notifications for their email service but Twitter does. If we can figure out a way to connect our Twitter and Gmail accounts, the Gmail notifications can arrive as text on our mobile via Twitter. Let me explain:Twitter allows you to follow any @user via a simple SMS. They provide short codes for all countries (see list) and if you text FOLLOW to this shortcode following by the  username, any tweets from that user will arrive in your phone as text notifications. For instance, if you are in the US, you can tweet FOLLOW labnol to 40404 to get my tweets as text messages. Similarly, users in India can text FOLLOW labnol to 9248948837 to get the tweets via SMS.The short code service of Twitter can act as a Gmail SMS notifier. You create a new Twitter account, set the privacy to private and this account will send a tweet when you get a new email in Gmail. Follow this account …

Instagram Story links get 15-25% swipe-through rates for brands, publishers

Instagram may arrived late as a traffic source for brands and publishers, but it’s already showing early signs of success, driving new visitors to their sites and even outperforming its parent company, Facebook.For years brands, publishers and other have tried to push people from the Facebook-owned photo-and-video-sharing app to their sites. Outside of ads and excepting a recent test with some retailers, Instagram didn’t offer much help to companies looking to use it to drive traffic. So they had to find workarounds. They put links in their Instagram bios. They scrawled short-code URLs onto their pictures. And they typed out links in their captions.Then last month Instagram finally introduced an official alternative to these hacky workarounds: the ability for verified profiles to insert links in their Instagram Stories.Almost a month after the launch, 15% to 25% of the people who see a link in an Instagram Story are swiping on it, according to a handful of brands and publishers that h…

Five great tools to improve PPC ads

Every digital marketer wants to reach the top position on the search engine results. However, if you’ve recently launched a new website or your niche is saturated, starting with paid search ads sounds like a good idea.Strategically created PPC campaigns can drive leads, sales or sign-ups to your websites. You know what? In fact, businesses earn an average of $8 for every dollar they spend on Google Ads.Optimizing PPC campaigns is not easy, but it’s very powerful if you do it properly. Just like SEO, it is essential to conduct extensive keyword research, optimize ad copy, and design high-converting landing pages.Fortunately, there are a lot of effective PPC tools that will help you analyze your competitors’ PPC strategies, figure out tricks in their campaigns, and improve your PPC campaigns.If you are ready to take an evolutionary leap in your PPC advertising, take a look at my list of five amazing tools to save you time, give you crucial insights, and raise money for your business.Fiv…