Helen Purslow
Data Strategy & Marketing Planning
Technical Delivery

Delivering the planned marketing programmes often requires experience across a number of data resources - both old and new. And this knowledge is critical in the design as well as implementation to ensure any solution is pragmatic, deliverable and proven.
My experience enables me to direct you to those who can provide the most reliable support. And my ability to link the technical to the marketing ensures that those delivering any technical aspect understand the marketing requirement - and vice-versa. I can be your missing link between techies and marketeers.

Data Processing
Development of briefs for the preparation data for mailing, database development and identification of unique customers for Single Customer View build.
-
Merge, purge & de-dupe
-
Data Cleaning – goneaway, deads, PAF
-
Salutation creation
-
Selections including random, 1 in N or criteria driven
-
Mail sort

Database Development
Designing databases to support the delivery of marketing programmes. Ensuring they are fit-for-purpose, easy to change as requirements change and within budget.
-
Design & Functional Specification
-
Development using SQL, Access or SAS
-
On-going updates & running
-
DBA Services, selections & response tracking

Single Customer View
Design & briefing of the Single Customer View to create a unique record for each individual of interest. Bringing together all response data, purchase data & profile data to enable in-depth analysis, reporting or campaign delivery
-
Creating a unique customer ID using de-dupe
-
Developing derived data items to enhance customer understanding (e.g. length of time between purchases)
-
Developing update processes to enable speedy data re-fresh

Tracking Reports
Design of campaign & programme tracking reports based on the client requirements. Enabling performance review and programme modifications to be made at speed and so impact results in a timely manner.
-
Multi-channel performance reports
-
On-line access to view
-
Dashboard reporting