Understanding Databases for Personalized Direct Marketing and Variable Data Printing

All forms of one-to-one marketing require information about customers and their interests, first to identify those who are likely to be interested in the product or service being offered, and then to personalize the promotion in ways that are likely to be appealing. to each client.

This information may already exist within the client company, as a result of sales calls, customer surveys and other market research, or disclosed during past transactions, or may be acquired from business data providers. To support an effective personalized marketing campaign, the data must be relevant and complete.

Analysis of credit card purchases might indicate that a customer has children and regularly shops at a particular children’s clothing store, for example. The card company could use that information to build loyalty by offering discounts on children’s clothing or toys. As long as customers feel that the offers they receive are appropriate and useful, they will be happy that the information collected about them is used to their advantage.

There is a delicate balance that marketers must strike between collecting information about customers and giving the impression that they are spying on them. There are also legal restrictions on what data can be collected and how it can be used. These vary by country, even within the EU, and it is the laws of the country in which the recipient is located that generally apply. It is the responsibility of the ‘publisher’, who is often the printer’s client, to ensure that these laws are followed, but printers planning to maintain or develop databases for their clients should be aware.

Customer information is stored in a database, which could be just an Excel spreadsheet, a desktop application like FileMaker Pro, a larger corporate resource like those from Oracle or SAP, or a customer relationship management system. the customer (CRM). Data can be entered manually or from other computerized operations such as call centers, websites, field service, or sales activities.

The databases are made up of records, one per customer, that contain fields corresponding to individual data elements such as first and last name, address, telephone or email elements, age, gender, previous purchases and any other information that may be useful. to select customer types. . Product information can also be stored in a database: A car dealer may maintain a database that lists the cars in its inventory, along with the model, year, and features of each. Relational databases allow links to be made between pieces of information in different fields and records, allowing vehicle types to be matched to customers in the car dealership example.

Images can also be stored in a dedicated database, often known as a digital asset management (DAM) system, which can be automatically queried at the time the print document is assembled, or simply placed in a folder specific to which the database can refer.

It is not essential that the printer has a database application, as the customer information required for a VDP job can be exported from the database as a CSV (Comma Separated Values) file, where each record is separated by a return line and field values ​​are separated by commas. These can be opened in Excel, most word processors, or taken directly into the VDP authoring software. In Excel, each row represents a record and each column is a field. Printers who do not wish to manage databases themselves should indicate which fields are required and specify how the data is to be delivered.

In simple VDP applications, each record may include only the recipient’s name and address, but the more graphically rich marketing documents made possible by digital printing may also include a selection of images that are relevant to different customers. The most sophisticated authoring software can combine images and variable text in visually stunning ways, such as inserting the customer’s name into an image in a photorealistic way, to generate custom images on the fly and then combine them with the template according to the business rules that apply. they specify which variable content to use and where to place it in the document. These rules, which are written or programmed in the VDP authoring application, use conditional formatting to select text and image content based on information in the database.

The designers who create the design templates used to generate the pages containing the variable data may be at the print shop, an outside agency, or within the client’s organization. Wherever you are, it’s important that you understand how this works and design with variable content in mind, whether you’re using desktop publishing or word processing software or dedicated VDP/cross-media authoring tools.

The information in the fields of the database records is used to populate placeholders in the template, so the designer needs to know what they are and take into account how much the content will vary, although more sophisticated software will handle not only the flow of text but also the location of the image. and climb too. Some solutions can even vary the number of pages depending on the content.

For printers new to VDP, even starting with simple jobs will enhance your offering to existing customers, as well as help attract new ones. The sophistication of VDP projects undertaken can grow naturally as the printer’s database skills and VDP experience develop.

Leave a Reply

Your email address will not be published. Required fields are marked *