1999 May 01
Internet-Based Outsourcing
David M. Raab
Relationship Marketing Report
May, 1999
.

If relationship marketing gurus agree on anything, it’s that a company’s interactions with each customer must be coordinated to provide consistent, purposeful treatment. The obvious corollary is that the “touchpoint” systems executing these interactions must be tightly integrated, if not directly then at least by accessing another common system. Achieving this integration seems to require that the touchpoint and coordinating systems all run in-house. So it would appear that the days of vendors who maintain external database marketing systems must be numbered.

But, in fact, the outsourcing business is growing quite nicely, thank you. The key seems to be that most companies lack the internal resources to build the grand integrated systems of their marketers’ dreams. So they continue to use external resources to build non-integrated solutions quickly, with the hope that they will eventually either replace them with a comprehensive internal solution or find ways to link them together. The rapid progress in distributed technologies–which share processing among disparate systems–makes the latter goal seem increasingly plausible.

Nowhere is this trend more obvious than the Internet. Entire Internet companies like Pandesic (888-349-3249; www.pandesic.com) have been founded to sell access to core operational systems, such as complicated enterprise resource planning software, that would traditionally run in-house. The particular advantage of the Internet over traditional outsourcing is that the software can be run with only a Web browser on the user’s computer, so the complicated installation process is eliminated. This speeds implementation and frees companies to focus on the more important challenge of changing their business processes to take advantage of the new systems’ capabilities.

It might still seem that customer-contact systems would be an exception to the Internet-based outsourcing movement. After all, Internet customers are famously demanding about the quality and speed of service. So drawbacks of a non-integrated, external solution should be particularly painful when customer interactions are involved.

But in fact, the outsourcing approach seems especially attractive for Internet customer contact applications. Two of the major specialists in e-mail response software–Kana Communications (650-325-9850, www.kana.com) and eGain (408-737-7400, www.egain.com) both offer such services as an alternative to outright purchase. Similarly, in the fast-growing area of Internet campaign management, Responsys.com (408-919-6695. www.responsys.com) and CMG Direct PermissionPlus (978-657-7000, www.cmgdirect.com) software both run on computers operated by the vendors themselves. Responsys.com does offer to let its clients load the software on their own machines, but even then it expects to manage the system remotely.

What makes Internet-based outsourcing so attractive? Some of the benefits are the same as traditional outsourcing–faster implementation, lower initial investment, less risk of obsolescence, lighter burden on internal resources, and the perception of greater responsiveness from a vendor than in-house IT. But the Internet adds its own particular advantages as well. Installation costs less since access comes through a standard browser. Communications costs are also lower because there are no dedicated phone lines or network circuits.

Lower installation and operating costs make it much more practical to have large numbers of users run a remotely-hosted Internet system than a conventional remote environment. In the case of campaign management systems, the result is that marketers can operate the systems themselves. This is a sharp contrast to the traditional service bureau relationship, where marketers typically gave directions to a service bureau employee who did the actual job setup. As in other self-service situations, letting “customers” do the work themselves yields lower error rates and cost savings. These efficiencies can be passed on to the client in the form of lower prices.

One additional factor supports the pay-as-you-go pricing inherent in an outsourced solution. Traditional software developers often relied on the initial sales of their products to help finance their companies’ early growth. The need for cash led them to set high prices, which slowed their products’ adoption. But today, any Internet start-up worth its URL is funded by venture capitalists who are more than willing to buy market share in the form of initial installations. So vendors are able to forego the initial cash from an outright sale for the longer-term income stream inherent in a subscription model.

But while the cost and convenience of Internet-based outsourcing weigh in its favor, they do not change systems’ isolation from the rest of the enterprise–an obstacle to the tight coordination of interactions that is ultimately a customer management system’s main objective. Companies have several ways of dealing with this problem.

The first, and by far most common so far, is simply to decide that interaction coordination really isn’t that important after all. Businesses just accept that they will have an independent set of business rules in the channels controlled by the outsourced systems. This is far from ideal, but not totally insane, either: companies can argue that the rules governing, say, e-mail customer service are so distinct that they would be defined separately even if the system were tightly integrated with everything else. Certainly it is possible to import basic customer information on a regular basis–maybe even every few minutes–so the treatments applied can match each customer’s actual current status.

The underlying justification for this approach is that the quality of service provided by the outsourced system will be superior to the service that would otherwise be provided, and this itself has considerable benefit. Certainly in most cases, a company’s real choice is not between an integrated and non-integrated system, but between a new non-integrated system and an existing non-integrated system with many other disadvantages–or maybe even no existing system at all.

The opposite extreme is to process all interactions on the same outsourced system, so the integration can take place externally. Whether a truly comprehensive system exists is debatable, although firms like Pivotal (425-455-4230; www.pivotal.com), Silknet (603-625-0070; www.silknet.com) and Portfolio Technologies (510-226-5600; www.ilux.com) are moving in that direction. But, so far as I know, none of these products are currently offered on an outsourced basis.

A third option is to integrate the outsourced system with the company’s internal systems. At a minimum, this requires letting the outsourced product read internal databases to get current information as a transaction progresses–a function that Responsys.com does in fact provide. There are some practical limits to this approach: security and performance considerations will lead most companies to strictly limit the access they give any external system to their internal data. But a company with a proper customer management infrastructure will already have built a common reference database to serve all its touchpoint systems. Allowing an outsourced system to read this database is not much harder than making it available to an internal touchpoint system.

A more intimate degree of integration would share actual processes between the internal and outsourced systems–such as rules to pick cross-sell offers or make credit decisions. Today’s outsourced solutions are not built for this sort of interaction. But it is technically feasible and could probably be done on a custom basis.

Less elegant but still reasonable alternatives to true integration also exist. For example, a screen in an outsourced system could open an internal application–say, an order tracking system–without actually passing any data back and forth. Similarly, Web pages and e-mail messages generated by an outsourced system could point to an internally-maintained Web site without any direct communication between the two. And even if real-time access is not possible, customer data can be sent to an outsourced system in frequent batch updates.

In short, it turns out that coordinated customer management does not require that all touchpoint systems run in-house. Given the practical advantages of outsourcing solutions–particularly in the form of Internet-based remote hosting–many marketers will find outsourcing an attractive alternative for years to come.

* * *

David M. Raab is a Principal at Raab Associates Inc., a consultancy specializing in marketing technology and analytics. He can be reached at draab@raabassociates.com.

1999 Feb 01
Adapting Customer Management to the Internet
David M. Raab
Relationship Marketing Report
February-April, 1999
.

After years of ballooning excitement, the Internet is due for debunking. In fact, it has already begun: Internet stocks are widely seen as overpriced; Internet sales are recognized as still a minuscule portion of the economy; Internet versions of traditional applications are reported to sell slowly. So, some will argue, perhaps the Internet isn’t quite as important as everyone said it was.

This questioning is a normal phase in the technology development life cycle: after an initial round of excitement, people get disillusioned when the promised benefits do not appear immediately. A few dissonant voices soon swell to a chorus of “over hyped”, “Emperor’s New Clothes” and “Where’s the beef?”. Although Internet-bashing is still at the voice-in-the-wilderness stage, this could change quickly. A sudden collapse of Internet stock prices seems particularly likely to produce a large, angry mob in a very short time.

While deflated expectations are generally a good thing (unless you own the stock), the coming period of Internet disillusion holds perils of its own. The chief danger is that people will mistake the temporary delay in achieving the Internet’s potential for a permanent inability to deliver on its promises. They forget the reason that disillusionment sets in: because the implications of a new technology become apparent much faster than the technology can be matured and deployed. So what happens after initial excitement wears off is that the technology develops steadily, until it eventually appears in a stable form that does truly fulfill its promise. This takes several years, even at Internet speed. But when it happens, anyone who decided they could safely ignore the new technology becomes suddenly, irreparably obsolete.

This is directly relevant to marketing software developers. Most of their present attention is dedicated to battling for sales of conventional customer management systems. The developers are aware of Internet-based applications, but see no substantial demand in their core markets. At most, they see Internet applications in peripheral segments like business-to-business marketing. So it feels like they can safely ignore the Internet for the time being.

They couldn’t be more wrong. The major premise of conventional customer management is that marketers should coordinate all messages to an individual, particularly those delivered through operational “touchpoints”. As these touchpoints increasingly migrate to the Internet in general and the World Wide Web in particular, the ability to manage Internet interactions becomes increasingly central. This will apply specifically in the traditional core industries of database marketing–financial services, retail, travel and telecommunications–where Internet-based interactions are already of growing importance. If customer management system developers turn their back on Internet-based applications, then suppliers of other types of systems will develop the necessary capabilities themselves. And when the customer management vendors later decide to extend to the Internet, they will find the territory already occupied.

Obviously this is important if you’re a vendor. But should marketers really care? Does it matter which vendors provide the services for customer management over the Internet?

Most definitely. On a purely practical level, marketers make big investments in customer management systems–in acquisition cost, in systems integration, and in training. They want to extend those investments to the Internet, not to discard them and start all over again. Systems not engineered for Internet marketing won’t be able to make the transition.

Perhaps even more important, today’s customer management systems embody a great deal of sophisticated knowledge on how customer marketing should be done. Advanced targeting, campaign definition, testing, and response analysis techniques have been refined through years of practice and generations of software releases. Systems developed from a different background will not provide the same capabilities, making marketers’ lives more difficult and their promotions less effective.

Before trying to define the requirements for Internet-based customer management, it is worth looking at software developed for related Internet applications. These systems fall into three broad categories:

personalized Web site vendors like Broadvision (650-261-5100; www.broadvision.com) and Smart Technologies (800-362-7947; www.smartdna.com) help companies give each customer a Web experience tailored to their particular needs and interests. This involves gathering information about customer preferences and then creating custom-generated Web pages with relevant content. These products usually include personalized online catalogs and order processing.

automated service vendors like Brightware (800-532-2890; www.brightware.com), Silknet Software (888-745-5638; www.silknet.com), Kana (650-325-9850; www.kana.com) and eGain (408-737-7400; www.egain.com) focus on responding to customer requests for information or technical assistance. These systems rely heavily on “knowledge bases” of common questions and replies. They typically combine fully automated response to simple questions with tools to improve the productivity of human operators who must respond to more complex queries. These products are generally more focused on e-mail than Web interaction, although they are starting to do both.

marketing automation vendors like MarketFirst (408-261-6950, www.marketfirst.com), MarketSoft (781-674-0000; www.marketsoft.com) and Rubric (650-513-3870; www.rubricsoft.com) focus primarily on business-to-business lead management, while Annuncio (650-3314-6000; www.annuncio.com), Imparto (650-937-1200; www.imparto.com) and Paradigm Ovation (813-287-0028; www.paradigmovation.com) encompass most traditional customer management functions. All allow users to create Web-based campaigns that respond to site visitors’ actions as they occur. Most provide substantial profiling, segmentation, response analysis and reporting as well.

Despite the functional breadth of the best marketing automation systems, they are still mostly limited to Internet contacts. This means they cannot provide the cross-medium coordination that is at the heart of the customer management concept, let alone integrate with operational systems for full-scale relationship management. The Web site and automated service vendors are also largely limited in this way–although some of the automated service systems are beginning to look at telephone call center integration.

But, before expanding their reach to additional media, the Internet systems will first need full control of the Internet relationship. Today, the three classes of systems all offer slightly different capabilities, so that a truly comprehensive solution would probably require one product from each group. But this is awkward and expensive to implement, not to mention confusing and inconvenient for customers. Since all three sets of vendors aspire to providing a comprehensive, integrated Internet experience, they will have to either expand their products to encompass the others, or find ways to integrate them easily. The approaches they use to solve this problem will later allow them to expand to non-Internet media as well.

The most likely approach will be to split their systems into two major layers. One will control the presentation of materials to the customer–whether this happens by Web page, e-mail, or, later, in a telephone call center or retail point of sale. Obviously the presentation methods will be specific to the medium involved.

The second layer will involve common services used to accept inputs from the presentation layer, decide how to respond, and then communicate the decision back to the presentation layer for delivery.

This model applies all three groups of Internet-based systems. That is, delivering personalized Web sites, responding to customer questions, and executing interactive marketing campaigns all involve the same general tasks of evaluating a customer input and determining how to respond. This suggests that a single system might well be able to control all three functions.

Of course, the specifics of the process will vary with the type of decision. The automated service systems in particular have advanced techniques for classifying unstructured customer inquiries, such as text messages, and trying to find appropriate responses. The other two groups of systems rely more on structured interactions, such as filling out forms and executing fairly simple sets of if/then rules. But so long as the flow of the interaction process is generally the same, it should be possible to embed different decision-making methods in the same general structure. The Web site and marketing automation products already use this type of approach to integrate specialized tools such as affinity recommendations or statistical model scores. All that’s really required is a set of Application Programming Interfaces (APIs) to structure the transfer of information back and forth. Object-oriented technology standards like COM, DCOM and CORBA make this feasible, if not necessarily easy.

The common services layer will have one other critical function: to keep track of previous contacts with the same customer. The Internet is inherently “stateless”, meaning it deals with each input without memory of what has happened before–sort of the computer equivalent of Alzheimer’s Disease. This is obviously not acceptable when the goal is to manage a continuous relationship. To overcome the problem, systems must record interactions in a database and look up past history when deciding how to react to a current situation. The systems also need information that originated outside of the Internet, including sources within the company–such as purchases and customer service requests–and external databases such as demographics, lifestyle and credit information. This uses pretty standard technology, although doing it in real time for individual customers requires structures resembling traditional online transaction processing systems. This contrasts with conventional marketing databases, which use structures designed for group-oriented analysis. Since analysis is still needed as well, some data will probably be stored in both formats.

While the general picture here seems simple enough, the details surely are not. One issue is how to manage the translation between the presentation and common services layers–that is, how do you take inputs from different formats and put them in a common language so they can be handled consistently? Today’s vendors of single medium systems sometimes argue this is neither necessary nor desirable: instead, they maintain a separate “knowledge base” should serve, say, the human operators in the telephone call center and the form-based queries generated on the Web, given the differences in the mode of interaction. But this seems more like a translation problem than a need for different underlying databases–it is hard to believe a customer should get different answers to the same question depending on how she asks it, or that anybody would voluntarily accept the requirement to keep separate knowledge bases in synch. As vendors develop cross-media solutions they will undoubtedly decide that unified knowledge bases are in fact superior.

The translation problem is a tricky one, since it is not even clear where the translator should reside. If it is in the presentation layer, then it will be automatically “aware” of the capabilities of whichever presentation system (Web, e-mail, call center, etc.) it belongs to. This is good, but means that each presentation system will have to independently maintain compatibility with the language used by the central system. That is, introducing a new category in the central system would require adding it separately to each presentation system–an obvious invitation to confusion. But if there is one central translation system, then that system must be kept aware of the specifics of each presentation system that will address it. Perhaps an industry standard will evolve to allow this type of cross-medium translation, but I am not aware of any being created to date. (If any readers know otherwise, please tell me about it.)

The translation problem exists in both directions: not only must presentation layer inputs be converted to a common language, but responses must be transformed into formats needed for presentation back to the customer. Again, this needs a choice of location: where do you store the media-specific items such as HTML pages, telemarketing scripts, direct mail text messages, etc.? As with inputs, there is a trade-off between the complexity of making one central system serve all presentation media, and the administrative challenge of keeping separate presentation systems aware of what the central system might send them. Again no standard exists, although some vendors have developed proprietary solutions that embed output in different formats within a single, all-purpose document.

Just to add to the confusion, the business decisions themselves will almost certainly depend in part on the medium being used–you might choose to ask more survey questions on a Web page than during a telephone call. So even if a translation system could put inputs in a common language, the decision engine would still need to know the original medium.

A second critical issue is the degree of detail to be contained in each communication from the central system. (The IT folks would probably refer to this as “granularity”, a wonderfully scientific-sounding word that means, well, degree of detail.) At one extreme, each user entry might be sent to the central system for a decision–a solution that maintains close central control, but requires a great deal of communication. At the other extreme, the central system might simply tell the presentation layer to execute an entire communications script or complete business process–for instance, turning control over to an order entry system. This minimizes the load on the network and the central system, but requires that the presentation-level processes be defined in detail in advance. As with translations, the more done independently in the presentation systems, the greater the challenge of keeping the different systems synchronized. A reasonable guess would be that different situations will call for different levels of central control.

A third wrinkle is that systems will actually make multiple decisions while preparing a single response–say, first a campaign management decision to send a cross selling message, and then a product affinity decision about which product to offer. This is quite compatible with object-oriented technology, although it may be a performance challenge to get several systems to render decisions quickly enough to give a fast reply. In fact, the need for quick response is just one of several constraints on the technology of the decision engines–they must function with relatively limited amounts of data (to keep down communication and storage costs); must deal gracefully with incomplete or unexpected values; must adjust automatically as the real world changes (or, at least, inform users when predictions fall below an acceptable standard of accuracy); and, must be able to balance multiple goals (such as balancing likelihood of response against the cost of making a promotion) as well as valuing multiple alternatives simultaneously. Some technologies–in particular neural nets and Bayesian networks–are better at this than others, although as ever the right tool will depend on the task at hand. The issues of multiple goals and values lead to the murky depths of optimization management, which is not unique to the Internet and thus can be set aside for the moment.

The need for multiple decisions also raises a fourth issue: how will the decision sequences get designed in the first place? Must they be hand-crafted to meet each situation, or will there be ways to create and evolve them automatically over time? The question applies both to the structures of the decision-making processes, and to the specific responses they have available to choose from. Today’s systems rely almost exclusively on manual design for both of these, but in the long run the sheer volume of options means that some sort of automated approach seems essential. Some of the automated service systems are moving in this direction with methods that “learn” appropriate responses by watching results over time, and sometimes even assemble their own responses from existing components. But even their developers are generally modest in the claims they make for the systems’ performance.

So where does all this leave today’s customer management system vendors? Must they suddenly enter a race across unfamiliar terrain to solve all these problems before the Internet vendors get there first? And if they decline the contest, have they ceded control over Internet touchpoints and condemned themselves to inevitable marginalization as Internet technology engulfs the rest of the organization? It seems quite clear that whoever solves the problems just described will have no real difficulty duplicating the functions provided by today’s customer management systems. After all, while today’s systems are indeed very sophisticated, they are ultimately just decision engines that work at a lower speed with fewer alternatives than their Internet-based counterparts.

Happily, the future isn’t quite so bleak. The first piece of good news is that the Internet vendors themselves are far from solving these problems. They must first fight their own battles to determine who controls the Internet touchpoints, in which the most expeditious strategy will be to develop closed solutions that combine the presentation and central layers in unified, proprietary systems. This will help individual vendors to serve individual clients, but will also require an all-or-nothing commitment that slows the widespread adoption of any one product. It will also slow the Internet vendors’ move into the non-Internet world, since they will have to custom-build translators for each new medium.

As the Internet vendors compete among themselves, standards will eventually emerge. These may either be de facto standards defined by the APIs of the most popular Internet customer management vendors, or industry-wide standards imposed by users or standards organizations. Either way, the standards will provide an opportunity for customer management systems to adapt themselves to work within the Internet vendors’ frameworks.

But what role will the customer management systems play in this new structure? This will depend largely on the talents and ambitions of the individual firms. Still, it seems the truly unique capability these vendors offer is the ability to define, manage and measure long-term customer strategies. This is something quite foreign to the Internet systems, which are focused on giving customers what they ask for, in terms of personalized Web sites or answers to questions, or on executing specific marketing campaigns such as lead management programs. The customer management systems focus on identifying and encouraging profitable customer behavior, which is rather different. In more concrete terms, it means the customer management systems become decision engines that determine which actions are most likely to increase the value of the over-all customer relationship. This leads directly back to the issue of optimization–a difficult challenge in itself, but at least one where customer management vendors are on familiar turf.

The role as a decision engine does not place customer management at the center of the interactive architecture. In fact, one might argue that no system is really central in a world of multiple, distributed components. Nor is it clear that a “central” system would reap the greatest financial rewards–fees charged by credit scoring vendors and product recommendation tools already illustrate how profitable it can be to offer a specialized decision engine.

But if there is a controlling position in the new architecture, it probably belongs to whatever component determines how the decision engines are strung together–that is, whatever builds the decision sequence. Customer management vendors could attempt to provide this function, either through manual definition or automated optimization. Indeed, sequence creation is arguably an extension of their current functions for campaign definition. Whether the customer management vendors can assume the role of sequence definition depends on their ability to interact with the various supporting systems, both within the central layer and across to the presentation layer. This, in turn, will depend on their own technical prowess and, perhaps even more important, on whether appropriate standards become available.

Whatever role a customer management vendor hopes to play in the Internet environment, certain technical approaches will be the price of entry. System buyers concerned about the long-term adaptability of their purchases should keep an eye on how the vendors handle these as well. Important approaches include:

- Separate the system from specific data models. Most of today’s major vendors have already developed a “metadata” layer that lets their system communicate with underlying databases in different structures and formats. This is critical if their systems are to handle the increasing variety of data sources that will become available. Ideally, the metadata layer itself would be use industry standard, although no dominant metadata standard yet exists and system-specific extensions will probably be needed in any case. Object-oriented approaches may provide an alternative, although performance could be an issue.

- Extend metadata to encompass campaign information. Despite the widespread use of metadata to access customer and transaction data, many systems still rely on fixed data structures to hold the data they generate internally–such as campaign attributes and contact history. This greatly simplifies routines that create the data and report against it, since the system knows exactly what to expect. But it will be unacceptable in a world where multiple systems are generating contacts and analyzing the results. So a more flexible approach is essential.

- Decouple the system from specific scoring techniques. Ironically, tight integration of campaign management with statistical modeling and scoring is one of the major improvements to become available in the past year or so. It provides substantial productivity and performance benefits that would be hard to give up. But the new architecture will include many decision engines including multiple scoring tools, each suited for a particular purpose. So systems will need to accommodate many different scoring inputs, presumably through standard APIs. Vendors who have integrated tightly with a single scoring system can of course leave the integration in place, but should eventually rebuild it to work through an API as well.

- Engineer for real-time interaction. Much of the ability to handle real-time, individual customer interactions depends on the underlying data structure, which should be isolated from the customer management system by a metadata layer. But even metadata lauyers makes some assumptions about how the data will be accessed, so it is important that the system be designed to handle one-customer-at-a-time transactions rather than multi-customer batch selections. In particular, the system must be able to manage real-time dialogues without waiting for an update cycle to decide on each response. This probably means breaking large, conventional campaign trees into several smaller branches, which can be executed in whatever sequence makes sense based on a particular customer’s behavior.

- Redefine outbound campaigns in terms of customer interaction. Traditional campaign management is mostly about sending unsolicited messages, and even conventional customer management is largely implemented by delivering predefined messages through touchpoints. But the Internet model is focused on reacting to customer inputs. If Internet system become the primary customer management mechanism, then outbound campaigns must be redefined to fit this approach. This is not conceptually difficult–it simply requires a batch process to initiate interactions instead of the customer. In fact, the Internet marketing automation products already have this capability. But conventional customer management systems may require considerable reengineering to fit the new structure.

- Refine optimization, segmentation and analysis techniques. These are the unique strengths that conventional customer management vendors bring to the Internet world. They include all the classic database marketing skills for strategy definition, test design, response measurement, and program evaluation. Vendors must be sure these capabilities are part of any Internet-compatible offerings they develop, and should in fact develop new ways to apply them in the Internet context. More than anything else, it will be these features that lead marketers to make conventional customer management vendors a part of their Internet solution.

This last point brings us back to the beginning: the Internet will be the central focus for customer management because the Internet controls the touchpoints, and the touchpoints are the critical medium for customer management. This means that conventional customer management systems will have to live within an Internet structure or become isolated and, eventually, irrelevant. It will take several years–possibly a decade–for this to happen. But vendors who don’t prepare now won’t have time to do it later.

* * *

David M. Raab is a Principal at Raab Associates Inc., a consultancy specializing in marketing technology and analytics. He can be reached at draab@raabassociates.com.

1999 Jan 01
Technologies for Complex Segmentation
David M. Raab
Relationship Marketing Report
January, 1999
.

Today’s state-of-the-art customer management involves many long-term, multi-step campaigns, tailored to different customer segments and executed daily. Although the concept is widely understood, it’s still hard to find companies who are actually doing it. Among other things, this means that the software offered for this task has not necessarily been tested in full scale, high volume operations. In fact, given the haste with which most vendors launch products, you can almost guarantee that most systems will have problems the first few times they try to do this for real.

So just how do you design a system to handle really complicated, large scale contact management programs? Vendors have taken widely different approaches–a sparkling display of creativity unfettered by experience (in the sense that when these systems were designed, no one had run marketing programs on the scale now envisioned). Still, it’s roughly possible to place their approaches on a continuum between two extremes.

The first extreme is to evaluate each customer once, running its data through a complicated selection tree to find all the branches and outputs that apply. This approach has the great merit of loading the customer’s data one time only, thereby minimizing the volume of data access–which is often the greatest bottleneck in system performance. This is the oldest segmentation technique, one that came quite naturally when records were stored on tapes and necessarily read in sequence. Many early database marketing systems, both on mainframe computers and PC’s, worked this way: all data relating to a customer was physically stored together in a hierarchical data structure, and selections were made by loading the block of data associated with a customer, processing it through all the segmentation rules, storing the results, and then reading the next customer’s data block and repeating the process. On the big service bureau systems, dozens or even hundreds of separate selections might be made simultaneously during one nightly pass of the file. This is still the approach used by most large data vendors to fulfill their customers’ orders. Among modern database marketing systems, Decision Software Inc.’s TopDog uses the technique in almost pure form, except that it first runs a relational database query to pull together the necessary information from separate tables. TopDog then steps through the resulting file one customer at a time, reading the data and executing the actual selection logic outside of the relational database itself. As an extra bonus, this lets TopDog use its own logic to execute all those annoying functions–like random sampling and calculations within groups–that are difficult or impossible within the standard relational database query language, SQL.

Of course, relational database purists find the idea of working outside SQL to be anathema. They occupy the other extreme of the design continuum, where each segment is selected directly from the relational database with its own SQL query. This approach has the virtue of consistency with other SQL-based systems, and, of more practical importance, lets the system benefit from performance-enhancing capabilities built into the relational database software and associated hardware. As a result, users get on-line queries and fast execution of campaigns that involve small numbers of records, so long as SQL can find them without having the read the entire database. With a small number of unrelated selections, using separate queries can be faster than running one big sequential pass. But when segments are linked in a hierarchy–with one segment being the subset of another, either due to a sequence over time or to splits based on customer characteristics–selecting each segment with an independent query against the main database is horribly inefficient.

Despite the drawbacks of independent SQL queries, they are used by most of today’s leading campaign management tools including Exchange Application’s ValEx, Prime Vantage and Recognition Systems Inc.’s Ideas Solution. None relies on SQL exclusively, since tasks like sampling must still be handled externally. These systems also can all flag a set of records and select against that set in a subsequent segment–thus limiting the SQL query to a small universe rather than the entire database. This saves much effort, but introduces its own drawbacks: flagging must be specified manually, the flagged sets take time to build and space to store, and each segment still generates the overhead of a separate SQL query. In reality, vendors tend to rely on other methods–including as parallel processing, powerful hardware, and splits made outside of the actual campaign selection–to get the throughput they need. Even then, it is not unusual to hear of large systems that need 10 or 12 hours to finish each nightly run.

A less critical problem with independent queries is the need to write increasingly complex queries to execute a multi-level selection. That is, each query must contain SQL code to exclude records selected in other segments, or to include only records belonging to its “parent”. Recognition Systems and Prime Response generate much of this code automatically, limiting the burden on the user and the potential for error. Exchange Applications relies more on limiting the complexity of the campaigns themselves–allowing only one level of segments defined by SQL queries, plus a separate level of splits. While this does impose some limits on the user, Exchange would probably argue that they can still accomplish pretty much whatever they might want.

Other vendors have take an approach between the two extremes. Paragren Technologies extracts the required data from the underlying relational database, using special techniques that let it execute a single pass no matter how complicated the original selection. The data is placed in a flat file, where the user can then sort and segment records without requerying the main database. Marketing Synergy accepts separate SQL queries for each segment but then evaluates them together, running them in the appropriate sequence and automatically excluding records in prior segments from later segments. Marketing Synergy also can build a separate, non-relational database using bit-based indexes, and query against that instead of the relational database.

Whatever a vendor’s current approach to segmentation, it will be challenged as nightly updates are replaced by online interactions. Most current systems do not provide a real-time solution: instead, they generally produce a static file of current and planned messages for each customer, which is read by online systems as transactions progress. The messages are typically updated as part of nightly or weekly batch process, although sometimes the interval is shorter. Still, even updating every few minutes is not the same as reacting to a transaction as it happens–say, deciding what supplemental product to offer in conjunction with a new purchase. This requires that the system actually accept new inputs, make a decision, and feed back the result.

The flow of such a decision-making process looks a lot like a conventional, branching campaign tree. Since one record at a time is run through the system, the underlying technology is probably closer to the old-style sequential access than to multiple independent SQL queries. But while the old sequential products executed the entire tree from start to finish, an interactive system will start and stop within the tree as the transaction progresses. So even vendors using the sequential approach will need to make adjustments.

One intriguing question is whether vendors who develop single-record processing for interactive applications will later change their batch processes to use the same technique. So far, the vendors who started with batch selects and added interactive–Recognition Systems and Paragren–appear to have kept the two processes separate. On the other hand, systems that started with an interactive focus, like “marketing automation” vendors Rubric and MarketFirst, appear to use the same technology for both. While the scalability of the “marketing automation” systems is even less tested than scalability of conventional campaign managers, it does seem likely that most vendors will eventually use a single method for batch and interactive processes.

So what does all this mean for marketers? First, if your daily campaigns have more than a hundred segments, you need to take a close look at the technical details of how a proposed campaign manager would run them. Second, if you want to mix batch and interactive campaigns, you’d best wait until the vendors figure out how to do it–and even then, be ready to do some careful testing to make sure you know what you’re really getting.

* * *

David M. Raab is a Principal at Raab Associates Inc., a consultancy specializing in marketing technology and analytics. He can be reached at draab@raabassociates.com.