Data Cleaning Calculator
Data Cleaning Calculator
Standardize and correct your addresses through Address Accuracy
Validate the key mailing elements of your address records (address, city, province/territory and Postal Code) against our database of Canadian addresses. We'll correct any errors or omissions by providing you a file that that contains your original addresses with the new address information appended to each record. We'll also provide you with an Address Accuracy report that you can submit with your mailing. Note: The Address Accuracy service is mandatory and included in the base price. Expected Match Rates 4-7% of your records are likely to be incomplete or inaccurate.
Identify movers through National Change of Address
Gives you access to 72 months' worth of mover information—including residential and business moves and deceased individuals. We'll provide you with the current address on file and the type of move. Expected Match Rates: 2-4% of your records are likely to be identified through NCOA, depending on the age and type of list you are cleaning. Canada Post's master file contains approximately 70% of all movers in Canada.<p class="strong">NOTE: Names MUST be included in input file for NCOA matching. </p>
Suppress Canadian Marketing Association "Do Not Contact" addresses
Identifies the addresses of people who do not wish to receive unsolicited mail-those on the Canadian Marketing Association's 'Do Not Contact' List. Suppressing these records helps you focus your advertising efforts on individuals who offer better potential as leads or prospects. We'll create a new field within your original file allowing us to flag any matched records we detect. Expected Match Rates Up to 3% of your records are likely to be identified as 'do not contact'.
Identify duplicates
Identifies whether your list contains multiple records for the same person, or for different people at the same residential/business address. Where duplicates exist, choose whether you want to retain one record per household or one record per individual. Within each set of duplicates, we'll identify the 1 record that should be retained in your list (called the survivor record) and mark the others with a duplicate flag. Expected Match Rates About 5% of your records are likely to be identified as duplicates
Website feedback 
Website feedback 



