Updating Your Marketing Database
Because this process involves technology, has a lot of moving parts and involves several steps, it's generally set up as an automated process and allowed to run on a schedule. Moreover, because the process involves overwriting an entire database (even though it is automated) it requires having IT staff around to supervise the process in a best-case scenario, or jump in if something goes wrong and it blows up completely. Not surprisingly, because we're dealing with large files, multiple stakeholders and room for technology meltdowns, most marketers tend to shy away from running a batch update more than once per month. Some even run them quarterly. Needless to say, given the current pace of change many feel that's not frequent enough.
It's interesting to note that not very long ago, sending database updates quarterly via FTP file dump was seen as state-of-the-art. Not any longer, you see, FTP is soooo 2005. What's replaced FTP is what we call a "transactional" database update system. Unlike an FTP set-up, which requires physically transferring a file from one server and onto another, transactional data updates rely on an Application Programming Interface, or API, to get the data from one system to another.
For those of you unfamiliar with the term, an API is a pre-established set of rules that different software programs can use to communicate with each other. An apt analogy might be the way a User Interface (UI) facilitates interaction between humans and computers. Using an API, data can be updated in real time, either on a record-by-record basis or in bulk. If a Company A wants to update a record in their CRM with fresh data from Company B, for instance, all they need to do is transmit a unique identifier for the record in question over to Company B, who will then return the updated information to Company A using the API.
Who’s Your Data? is a blog that aims to disseminate thought-provoking tips and techniques involving the use of data and database marketing to direct marketing professionals. Why should you care? Because implementing data best practices has been shown to lift response rates, improve analytics and enhance overall customer experience. Reader participation is encouraged!
Rio Longacre is a Sales & Marketing Professional with more than 10 years of experience in the direct marketing trenches. He has worked closely with businesses across many different vertical markets, helping them effectively leverage the use of data, personalization technologies and tracking platforms. Longacre is currently employed as a Managing Consultant, Marketing, Sales & Service Consulting at Capgemini Consulting, a premier management consulting firm. He is based in the company's New York City office, which is located in Midtown Manhattan. He has also previously worked as an online media buyer and digital marketing strategist.
Email Longacre below, or you can follow him on Twitter at @RioLongacre. Any opinions expressed are his own.