Database maintenance

By Linda Forrest
Arguably one of the least favourite tasks that we PR folks must do is database maintenance, ensuring that media and analyst contacts and corresponding contact information (phone number, fax, email, address, etc.) are kept up to date. This is one of those “invisible to the client” tasks that we undertake on your behalf that greatly impacts the effectiveness of your campaign or program, but cannot be seen by the naked eye.
There is a wide variety of database programs that media relations practitioners can use, from software solutions like Filemaker Pro and ACT! to online solutions like Salesforce. One attribute they all share is that the inputted data needs to be kept relevant and up to date in order to be of real value.
Inevitably, people change roles or publications or leave the field entirely while new outlets appear and need to be added to your database. Keeping on top of these changes can be difficult if left for too long. Best practices would suggest that routine maintenance is the best way to stay on top of changes that affect your database.
Because we at inmedia never assume that we have the right contacts already in our database for a new client, we do extensive research at the outset of our engagement to build a relevant media and analyst list, with current contacts and accurate contact information. Still, despite our best efforts, a few of the emails may bounceback when we initially send out the release. We immediately get on the phone to find out whether the contact has moved on, whether the outlet has ceased publication or if there’s a new email address that we should be using. By inputting the new data as soon as we learn that what is currently in the database is out of date, and resending the materials to the corrected address, we ensure that we’re keeping on top of this activity before the task becomes unwieldy.
There is no easy, one-step solution to maintaining one’s database. Even the online media databases that purport to be comprehensive are wildly out of date in areas and unreliable. It’s absolutely imperative that your agency does the legwork to maintain its database so that your materials are reaching the intended recipients in a timely fashion. If there’s a new relevant outlet or contact, they should be added promptly so that the appropriate contact details are in place for when your agency sends out your next news release, is looking for suitable story pitch targets or scanning editorial calendars for pertinent opportunities. It’s not glamorous, but it’s important.

