Bill Singleton

Bill Singleton
5 Steps to Prevent Data Append Mistakes

There are several best practices you can follow to maximize the data append process by getting the right data, improving the match rate of third party customer data, and having it come out in a format that you will be able to use successfully and immediately.

Data Visualization for Nonquantitative Marketers

You have lots of questions and lots of data, and you want to know how to get answers to those questions. What do you do next? Consider this step-by-step process to help a nonquantitative marketer visualize data to reach conclusions without complicated statistical techniques. Before you start getting all the figures you can find on your company’s systems, understand that there are several steps to take that can make your task easier. If you follow them in order, you might find you can relieve a lot of your anxiety about diving into tables of units, dollars and dates. 1. Define your question: what, when,

Watch Three Key Fields To Keep Your Data Clean

You may be surprised to learn that just three key fields in your customer database will contain most of the mistakes in your file. They are the name, address and date fields. This information often is entered by people not trained in data accuracy and is subject to mangling when reformatted. Why do these fields deserve your attention? Because mistakes will cost you in undeliverable, wasted materials, postage and lost sales. Name Field: Names are subject to phonetic misspellings and typos. Even if they’re wrong, they’re still deliverable. However, an incorrect name does little to build a relationship with a customer and can result

Database: The Missing Link

Does your marketing execution pursue strategy or tactics? Do you have the tools to help you pursue both to success? First you must know the difference between strategy and tactics. Strategy: the grand design, the plan for obtaining a specific goal, such as learning how to sell trucks. Tactics: a set of actions, devices or methods in service of the strategy, such as each day’s coursework in a sales class about how to sell trucks. The Goal The most effective marketers focus successively on their strategy and their tactics. Accomplishing this ideal approach requires the development and execution of a strategy through the well-organized and efficientperformance

Lists: A Little B-to-B Cooperation

Why should you consider B-to-B cooperative databases? Because they reduce the complexity of finding good prospects to mail. There are two kinds of cooperative databases available today: Abacus’ B2B Alliance and Experian’s B2B Base, which are of the membership type, and Direct Media’s Data Warehouse and Merit Direct’s MeritBase, which are list-specific options. It is important to put these prospecting sources into perspective. A few definitions and figures will give us a framework. As of January 2007, there are 301 million people living in the United States. From that total, 146 million are employed: 115 million work in non-farm, private sector jobs, and 22

Signs That You Need a Data Warehouse

How do you know when you need a data warehouse, a data mart or at least an extracted set of files for marketing analysis? If the thought of pulling together any or all of the following analytics projects in the course of one day makes you want to throw up your hands in exasperation, then you’re a prime candidate: Task No. 1: Run a report of how many unique 12-month buyers you have. Try this in a leading enterprise resource planning (ERP) system, and you will arrive at a number. But do you have a way to check if each record is a unique account