Mailing List Data Cleanup — ZoomInfo Column Alignment

Overview

During the final stand-up of 2025, Karly identified a data merge error in the Bluepoint mailing list that needed to be resolved before the list could be sent to the print vendor. The list is being prepared for a variable-data direct mail test targeting stadiums and arenas.

Background

Bluepoint's ZoomInfo account had two separate exports of the stadiums/arenas list — the result of a credits dispute in which a prior user had consumed most of the monthly credits before the current team pulled their export. Because the two exports were done separately, their column structures did not align when merged. This caused company address data to land in the personal address column rather than the company address column.

The direct mail test itself is intentionally small (~373 records) to validate the variable-data approach before scaling it to future campaigns.

The Problem

• Two ZoomInfo exports were copy-pasted together into a single sheet
• The exports had misaligned columns — one export had a column deleted or reordered, shifting all subsequent fields
• As a result, company street addresses appeared in the personal address column (column R), leaving the company address column empty for a portion of the records
• This was not immediately obvious because the data was present — just in the wrong column

The Fix

Karly identified that the data was not missing, only misplaced. The resolution:

1. Write a script to detect the column shift and move company address data from the personal address column into the correct company address column
2. Hide (not delete) the personal address columns to reduce confusion for the print vendor, while preserving the raw data
3. Strip unnecessary columns — the final deliverable only needs: first name, last name, company name, and company mailing address

Deliverable

The cleaned list will be used for a variable-data direct mail piece that personalizes:
- First name
- Last name
- Company name

Only business addresses are to be used — no personal/residential addresses. The target audience is large venues (NHL stadiums, arenas, etc.).

Action Items

Related

• ^[1]
• ^[2]