How To Build and Maintain a Masterfile
Technology Review sees a 10 percent jump in digital subscriptions.
Want to hear someone get excited about a database? (Yes, a database.) Hereâ€™s Heather Holmes marveling over the master file she oversees at Technology Review.
â€śI LOVE, LOVE, LOVE to talk about our new spiffy database,â€ť she says. â€śWeâ€™re still building it, but Iâ€™m delighted to sing its praises based on Phase I.â€ť
Why all the love? For the first time, Technology Review has a gigantic, unified, real-time database the company employs for e-commerce transactions, market analysis, content creation, newsletter creation, Webinars and RSS feeds among other uses, says Holmes, who serves as senior vice president of audience development.
Across the industry, publishers increasingly are selling across many different products and channels, including print, digital, events and research. Technology Reviewâ€™s early success with its new database may provide a case study for other publishers as they, too, move to build master files.
Until October 2010, when Technology Review launched its database, the magazine was pulling data from multiple sources: newsletter lists, events lists, international partners, content databases, newsletter databases, RSS feeds, a Webinar database, and others. Some of the databases were housed at Technology Reviewâ€™s office in Cambridge, others at the magazineâ€™s fulfillment provider in California. And none of those databases was connected.
Requirements for a Single Database
About a year ago, Technology Review began discussions with ESP Computer Systems in North Hollywood, Calif., a fulfillment company already hosting some of Technology Reviewâ€™s systems and databases.
Together, the two companies created requirements for the project. They had to devise a system that would allow Technology Review to use a single database for its Web site paywall strategy, events sign-ups, products, subscriptions and security maintenance. â€śThere are a lot of moving parts and a tremendous amount of data whizzing back and forth,â€ť says Holmes. â€śThe customer has no idea the data is flying across the country.â€ť
Maintaining the platform requires careful coordination. Holmes said she has monitoring in place so that if Technology Reviewâ€™s systems go down, or if ESPâ€™s systems go down, there is a Plan B.
â€śItâ€™s centralized and real-time,â€ť Holmes said. â€śWe truly use that one database for everything from database transactions to market analysis.â€ť
The database offered an almost immediate financial pay-off. â€śThis is tremendously helpful to our bottom line,â€ť she says. â€śI can instantly go online and do queries and cross-hatch reports that tell me, for instance, how many of my newsletter subscribers donâ€™t get the print magazine. Then I can immediately blast them a newsletter upsell.â€ť
Before, Holmes said, she would have had to merge and purge several customer lists and databasesâ€”a process that would have taken three to four weeks of planning. â€śMy time to market is now instant,â€ť she said.
Digital Subscriptions Up 10 Percent
In October, the magazine moved 11 of its e-mail newsletters to the new database; in late November, the Web site registration process went live; and in December Holmes moved the event registration process to the new database.
Users can register online at technologyreview.com, subscribe, pay with a credit card, gain immediate access to its premium contentâ€”and appear in the database in mere seconds.
Digital subscriptions increased 10 percent in just the first two weeks of the paywallâ€™s existenceâ€”the first time in the six years Holmes has worked at Technology Review that growth was noticeable in a short time period. â€śThat was a statistic I got goosebumps over,â€ť she says.