|
SM Research Software and Databases
SM Research Sampling Options
SM Research Record Options
SM Research Matching
SM Research Mapping
SM Research Census Data
SM Research Modelling Analyses
SM Research Service Quality
SM Database Count
Go to Top
|
|
SM Research Software and Databases
SM Research owns and manages a database of business and consumer lists which aid the company’s clients to focus their marketing and research efforts on targeted consumers.
SM Research prides itself on its ability to offer quick response and expertise in list selection.
At present, SM Research owns the following databases and software:
- Business Databases
- All companies with Canadian Stock listing
- Established businesses by SIC (Standard Industrial Classification) and Size
- New businesses
- Home businesses
- Professionals
- Ontario farmers
- Residential Databases
- Canadian households
- Canadian home buyers
- Ethnic databases
- Wealthy Canadians
- SM Research Software
- Parses names and addresses
- Adds gender and salutation
- Corrects addresses using SM Research’s correction program
- Checks for bad or incomplete records
- Merges and purges
- Coding
The software provides a number of scripting functions including the ability to add a province code to a record, change case, delete specified information, identify errant characters, parse telephone numbers and search and replace functionality.
- Parsing
The software parses names into first/middle/last/company components, has the ability to genderize information and can extract data components (i.e. initials, last names) from records.
- Load Data
The software has the ability to load data from other sources and databases into separate tables.
- Merge/Purge
The software provides the ability to take an extremely complicated process involving multiple input files from the customer and merge this information into one unique file. This process purges duplicated records and assists in the preparation of the file. This scripting also combines the ability to correctly address the files for Canada Post.
- Count Program
The software enables counts to be performed from databases to extract relevant numerical information. A count is a quick summary that matches records within a specific database.
Go to Top
|