Search

DAVE's Dirty Dozen Data Disasters: Junk Records



Paul McCartney had a song on his first post-Beatles solo album called ‘Junk’, which was good. But aside from that, junk records are bad. You don’t want junk records.


You know what causes them? The big three causes are: a lack of usable contact fields, what are known as anonymous prospects, and examples used as ‘test records’.


Now, test records are good if they’re being made by Steve Smith, but in an email sense? Not so much. Neither ‘Mickey Mouse’ nor ‘asfdggs’ ever made a quickfire ton against New Zealand on an up-and-down MCG pitch; they were the names you may have used to test the email system.


The resulting impact is that there will be too much clutter in the database, which can obscure other things, slow your system down, increase data carrying costs and generally cause a bunch of system-related headaches. You’ll wind up with increased data processing overheads, and an overstated marketing reach, all because you drafted a test email to the non-existent entity that is ‘asfdggs'.


DAVE flags these unusable records so that they can then easily be removed from your database. The solution, as always when DAVE is concerned, is easy. Not as easy as Adam Gilchrist did against England in Perth in 2006-07, but easy nonetheless.


Check out some examples


(For the record, DAVE’s favourite Beatle is George, and favourite test match cricketer is Ricky Ponting).

11 views
DFI Logo.jpg