How MarketWide Helps You Build a Better Database

 


MarketWide's ability to calculate its own variables has an astounding impact on database design. While many competitive products force you to precalculate variables such as "total sales 0-3 months, total sales 3-6 months," and so on, MarketWide can operate directly against "raw" transactional data, so is much faster to implement. DSI estimates that a MarketWide database build takes anywhere from 50% to 25% of the time it takes to integrate other solutions. 


Take, for example, a simple RFM campaign of ten cells. Let's say each of these cells needs three pieces of data: a monetary field (dollars accumulated within a given time period), a frequency field (number of occurrences within the same time period), and a date indicating the most recent event.



Many campaign management systems require over TWENTY (20) fields to satisfy this query: a single "recency" field, ten "frequency" fields (one for each date range), and ten "Monetary" fields (again one for each date range). For example:


RECENCY, FREQUENCY_0_3, FREQUENCY_3_6, ., FREQUENCY_27_30, MONETARY_0_3, . 


In contrast, all that MarketWide needs to perform this campaign is two (2) fields: a recency field and an amount field!


The "frequency" field is computed by simply counting how many records fall within the "recency" range.) This translates into an amazing time and cost savings for you. Not only can MarketWide databases be deployed more quickly, but due to their inherently simpler design, they are maintained and updated much easier.


More and more companies are learning that there are a many hidden costs in implementing campaign management systems. Here at DSI we've gotten numerous calls lately from companies who've been burned with other products.