Data Merge

/ about the project

At Total wine, we had a twice-yearly promotional period called Yellow Tag, where customers can save money on products by activating special coupons through our app or website.

These coupons were market specific and required several versions of each asset.

/ The process

I streamlined production by creating an automated workflow using Data Merge in Adobe InDesign. I first structured a master spreadsheet containing all variable data fields, then built a flexible InDesign template with clearly defined data placeholders for all variable elements. Then, I generated all asset variations in a single automated batch.

After a QA check to ensure accuracy, the assets were exported for production. This process improved accuracy across versions and cut production turnaround time by 60%.

/ The Request

To create 10 different assets that would go in 12 markets, for a total of 180+ assets. Each asset having multiple deals per market.