Bill Singleton

Show Me The Data: Two Aspects of Direct Marketing Frequency

| Bill Singleton

I recently gave a talk to a business group and described recency, frequency, and monetary (RFM) models. One of the questions I got at the end was to distinguish between the frequency of RFM and the frequency of business contacts and to say which was more important. I explained that there are two equally important dimensions to direct marketing frequency. There is one definition based on data of historical transactions and another depending on the amount of communications a business creates and sends out.

Show Me the Data: Slim Down Your Customer File

| Bill Singleton

Many people gain holiday weight. Your customer file can also gain weight that can make it sluggish and less efficient. The start of a new year is a great time to trim your customer information for two significant reasons.

Show Me The Data: When Did You Last Talk To Your Customers?

| Bill Singleton

Some customer data systems have wonderful table structures listing accounts and the contacts that make them up: items, orders taken, and orders shipped. The wonderful table missing from some elaborate, enterprise resource planning systems is the one that will tell the company how many times they have contacted their customers since those customers

Show Me the Data: Ask Questions First and Deduplicate Later

| Bill Singleton

Duplicate records in a database can dilute a mailing and discourage response. But they can also provide valuable information about customer behavior. Asking several questions before deduplicating your data can let you gain knowledge that you might otherwise lose in normal processing.

Show Me The Data: If Your Database Is Right, Is Your Customer Wrong?

| Bill Singleton

Our data is carefully input, validated, audited and we have every reason to believe it is right. But if a customer disagrees with the data, should we automatically assume she is wrong?

As database professionals we need to be prepared for discrepancies and errors as well as customers changing their minds or deliberately misstating the facts. But sometimes the problem will be with our database in how we recorded or failed to record the order and its details.

Show Me The Data: The Fine Points of Business and Government Matching

| Bill Singleton

Business-to-business (b-to-b) and business-to-government (b-to-g) mailers face greater list processing challenges than consumer marketers. These challenges include: the churn of business contacts at titled positions and within companies and more address elements with which to deal. The complexity of business and government addresses can, as I will show, make the tasks of matching customer and prospect files more challenging to match and deduplicate than consumer addresses.