Posted on

How to make sure that addresses are quality ones

Introduction

You need to keep your addresses clean because its always about quality over quantity. It’s worth doing because it…

  1. Save money on distribution
  2. Reduces number of ‘return to sender’
  3. Improve your metrics
  4. Marketing list service providers don’t necessarily clean up addresses, so you need to!
Cleaning up – the manual way
  1. Identify typos in addresses and correct them
  2. Find duplicate addresses to delete
  3. Manually work out what County the address belongs to
  4. Move data into different fields to get the first line of address and street info correct
  5. Make sure that postcodes have spacing in the right place
  6. Remove non-address data like email addresses
Cleaning up steps – the DataWand way

We use our magical ‘Address cleaner’ wand, it does all the manual work for you, in seconds.

  1. It auto formats the address into its different components (house number, street, place, town, county, postcode)
  2. It auto corrects the case
  3. It automatically works out County and Country info if missing
  4. Formats postcodes
  5. Deletes email addresses found in the address

And hey presto! all your addresses are cleaned up within seconds ready for your next post mail campaign.

By the way, we speak from experience as we saved ourselves 4 hours by using DataWand to clean up a data list containing 5,000 UK addresses.

P.S. If your mailing labels only support 5 lines of address data you can use DataWand to easily merge address fields together and if you want to remove records because the postcode is incomplete, DataWand’s got an action for that too.

Posted on

Merging street address data example

Last week we were asked to merge street address data from two different fields into one because the email campaign software importer that was going to be used only allowed a single street address field.

Microsoft Excel could have done this using a macro but if you don’t have Microsoft Excel or you do and don’t want to write macros (like us), luckily there’s DataWand to the rescue.

We just use DataWand’s ‘Merge columns’ wand, we specify the two fields that we want to merge (e.g. B,C) and hey presto! your preview shows the merged info.

Here’s it in action; before and after:

example_address_merge

 

Simples.