Carraig IT Solutions

Pricing


USPS® CASS™ Address Processing And Canada Post SERP Certified Address Processing	Address Correction, Standardization and Validation

	Mailing Address Correction, Standardization and Validation with Reports for USPS and Canada Post

	Number of Input Records	Price Per 1000 Input Records (plus tax) USD / CAD		Files Combined and Processed	Cost to Load Each Extra File (plus tax) USD / CAD
	1 - 100,000	$12.00	$14.00	2	$45.00	$55.00
	100,001 - 250,000	$11.00	$13.00	5	$45.00	$55.00
	250,001 - 500,000	$10.00	$12.00	5	$45.00	$55.00
	500,001 - 750,000	$9.25	$11.00	5	$45.00	$55.00
	750,001 - 1,000,000	$8.50	$10.00	10	$45.00	$55.00
	1,000,001 - 2,500,000	$7.75	$9.00	10	$45.00	$55.00
	2,500,001 - 5,000,000	$7.00	$8.00	10	$45.00	$55.00
	Over 5,000,000 Input Records Please Call for Quote
	The minimum charge for address correction and validation processing is $168 USD plus tax (14,000 input records) OR $196 CAD plus tax (14,000 input records).

	Sample Cost Calculation for Processing 318,471 Raw Records for a US Client: (318471/1000) * $10 = $3184.71
	Note A: The above price list is for simultaneous processing of all files in a single process, with a single output file. This is necessary in order to ensure identification of duplicates within the data.

	Note B: Messy Address Data and Data Anomalies/Errors*

	Note C: In order to streamline the processing time for processing files only the following fields should be included. See Special Notes below.

	Suggested List of Fields/Columns for Input Files
	Field Name (or Similar)	Is Field Required or Optional?	Notes First Name, Last Name and Company Name are required in order to do proper deduplication processing based on the mail recipient's name(s) and address. If deduplication is to be done using just the address then name selection would be based on other factors/filtering. Also, although it is ideal to have individual address elements in their own fields we can usually handle address data in almost any format. This includes having all of the address elements in one field. Please note that consistency with the structure of the data is still very important.
	Unique Record ID**	Required
	Address 1	Required
	Address 2***	Required / Optional
	City	Required
	Province or Territory	Required
	Postal Code	Required
	First Name	Required
	Last Name	Required
	Company Name	Required / Optional
	Salutation	Optional
	Additional Fields****	Optional


USPS® NCOALink® And Canadian NCOA, Deceased, and CMA Do Not Mail Processing	Carraig IT Solutions Signature NCOA Processing

	Please note: NCOA processing must be done following address correction and validation. Therefore, address correction and validation charges will be added to NCOA charges. Please see above for address correction and validation pricing.

	Carraig IT Solutions Signature Canadian NCOA Processing Includes The Following:
	NCOA Processing
	Deceased Suppression
	Canadian Marketing Association Do Not Mail Suppression

	NOTE: USPS® NCOALink® processing does not include Deceased Suppression or Canadian Marketing Association Do Not Mail Suppression

	Number of Input Records	USD Price Per 1000 Input Records (plus Tax)	CAD Price Per 1000 Input Records (plus Tax)
	1 - 100,000	$4.33	$5.09
	100,001 - 250,000	$3.84	$4.52
	250,001 - 500,000	$3.37	$3.96
	500,001 - 1,000,000	$2.88	$3.39
	1,000,001 - 2,000,000	$2.41	$2.83
	For record quantities greater than 2,000,000 please contact Carraig IT Solutions for a quote.
	The minimum charge for USPS® NCOALink® processing is $155.88 plus tax (36,000 input records).
	The minimum charge for Canadian NCOA processing is $183.24 plus tax (36,000 input records).


General IT Services

Service	Description				Price CAD	Price USD
Data Analysis	Analysis of any data used or stored by the organization including customer, order, product, services, sales history, projected sales, socio-economic, demographic, geocoding, third-party rental lists, etc.				$55.00/hr	$45.00/hr
Data Cleansing	Identification and correction of bad data including improperly formatted phone numbers, email addresses, etc.				$55.00/hr	$45.00/hr
Householding	Combining of an unlimited number of records under one unique customer ID based on customer specified field linking. For instance a group of records, representing three customer numbers, might indicate the following . . . a) Two of the customer numbers might have the same contact phone number. b) Two other records have the same email address. c) All three records have different first names but share the same last name. d) All three billing records have the same postal code. e) Two of the shipping records have the same postal code but the third postal code is different and is the postal code of a specific university. When these records are linked together using the required data linking iterations it becomes clear that these three customer numbers represent one household/family, and that one of the members of that family is, or has been, attending university. This data can then be used for analysis to determine the household’s spending patterns and for targeted messaging based on previous purchasing behavior. Householding at the address level is only possible after the address data has been corrected and validated through our address correction and validation process. Address correction and validation costs are listed above in this web page.				$55.00/hr	$45.00/hr
Business Analysis	Gathering and documenting specific business needs and processes in order to scope the business requirements of an IT project. The resulting business requirements documentation will form the foundation for the entire project and what is considered in-scope and out-of-scope for the project.				$55.00/hr	$45.00/hr
Database Development	Database development includes everything from adding a new table, view, stored procedure, function, etc.				$55.00/hr	$45.00/hr
Software Development	Software development includes any standalone code development that produces a functioning solution. This could be a complex system or a standalone component to be used with other programs.				$55.00/hr	$45.00/hr
ETL Processes	ETL (Extract Transformation and Load) includes the development of processes that take data from one or more tables, manipulates the data as needed, and then loads it into a downstream data store (database, data warehouse, etc.). It also includes simple data migrations.				$55.00/hr	$45.00/hr
Change Requests	Once requirements for a project, product or service have been signed off by the customer any change requests will be billed. A minimum of two hours will be charged for analyzing a change request to determine the impact to the scope of the work agreed upon, the delivery timeline(s) and the cost for delivery.				$55.00/hr	$45.00/hr
Miscellaneous	In general, IT services and product requests will be billed at the standard hourly rate. However, there may be times when a very special request might result in a lower or higher hourly rate. These would be special circumstances that do not fit into the basic product/service categories outlined above.				$55.00/hr	$45.00/hr


Special Notes
* Messy Address Data and Data Anomalies/Errors For files where the data is unexpectedly messy (i.e. data in the wrong fields) or there are data anomalies (i.e. tab characters or other types of field delimiters mixed with field values, invalid special characters, etc.) there will be an extra charge per hour for correction of the problem data, where it has been identified, if the customer has requested that the erroneous data be cleaned-up. If problems with the data are identified the problems will be reported to the customer as quickly as possible and the customer will be given the option of correcting the data at the customer site with their own resources OR request that Carraig IT Solutions correct the data (to the best of the ability of Carraig IT Solutions). Our standard hourly rate will apply for correcting the problems in the data that have been identified and reported to the customer.
** Unique Record ID The Unique Record ID must be unique for each record. This could be a customer number or some other ID but it must be unique to the record. If there are multiple customer numbers for the same customer, that's fine. Deduplication will enable elimination of duplicate records. However, for data and process auditing requirements each record must have a unique ID. Without a unique ID for each record QA testing is not possible for Carraig IT Solutions or the customer.
*** Address 2 (Required or Optional) Some customers save street and suite address information in two separate fields, Address 1 and Address 2. Other customers save this information in Address 1 only. Carraig IT Solutions can process a variety of record formats which includes records that contain Address 1 and Address 2. This is dependent on the format of your data.
**** Additional Fields Additional fields may be included in the raw input files provided to Carraig IT Solutions by the customer. However, if the file sizes are large and/or the number of records is high this will add significant time to the processing. Therefore, in certain cases where there are many records or many fields, or both many fields and many records, Carraig IT Solutions will simplify the input files to only the fields necessary for address processing. However, the processed address data (the final output file) will be reconstituted with all of the other extra fields originally provided by the customer through the use of the Unique Record ID. It is considered a normal procedure to separate and reconstitute data for the purpose of streamlining the processing of the address data. When submitting address data for processing to Carraig IT Solutions the customer is acknowledging that they are supportive of this procedure when it is deemed necessary by Carraig IT Solutions.
File Types Our address correction and validation process can handle several different file types including delimited flat files and unformatted flat files (text files). If you're not sure if your file type can be supported by our systems and processes feel free to contact us. We would be happy to verify if your file type is usable in our systems and processes.