Action Mail

View Original

Database Errors, an overview of mistakes

When we process databases we scrub the data to look for incorrect addresses and moved addresses to correct any errors or mistakes in the database. We can correct a lot of different database errors but we cannot identify or fix them all.

What we can fix or identify:

Incorrect addresses or addresses that do not match the United States Postal Service database of addresses. Many times this includes spelling mistakes, incorrect suite numbers, inccorrect abbreviations, incorrect street numbers, etc.

Moved addressess. We can identify moved addresses only if a change of address form has been provided to the USPS within the last 48 months or if the address has been reported as

Duplicates. If you would like to remove duplicates please inform us and let us know how you would like to remove them. Please let us know if you want to remove one per person or one per an address and if you would only like to remove exact matches. Since there are so many variations and each person has different strategies with their databases we typically only remove duplicates if requested.

What we cannot fix:

Incorrect names. If the wrong name is associated with address we will not be able to correct this issue. Many times we see issues like this when a cell is deleted and the entire data is shifted. Unfortunately there is no way for us to know if the name is correct without trying to append names to the data and comparing them with the list, but even then this would be difficult.

Moved address that did not file a change of address. We cannot fix moved addresses that have not filed a change of address or have moved over 48 months ago.