Difference between revisions of "Listware for Excel:Capabilities"
Jump to navigation
Jump to search
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[Listware for Excel|← Listware for Excel]] | |||
{{CustomTOC}} | |||
See individual product pages' documentation or Result codes for a complete description of their respective capabilities. | |||
==Domestic US and Canada== | |||
===Check=== | |||
Standardize and Correct | |||
*Names | |||
*Addresses | |||
*Phone Numbers | |||
*Email Addresses | |||
*Append Geo-coordinates | |||
===MatchUp=== | |||
* | *Record Matching using basic datatype matching strategies. | ||
*Processed lists can be evaluated in many ways… | |||
**Result Codes. Group Identifier and Group Count appended to each record allow you to easily analyze, group or remove identified duplicate records | |||
**The Processing Results output window allows you to redefine records as Output or Duplicate status | |||
**Choose to output cell color for alternating duplicate groups | |||
**Commit identified groups to a new sheet or append to the existing sheet | |||
===SmartMover NCOA=== | |||
Check to see if a Name or associated Company has moved to a new address. | |||
==Domestic US Only== | |||
===Personator Verify=== | |||
Correlate the above data types, E.G. Do they actually belong together? | |||
===Personator Move=== | |||
Check to see if a Name or associated Company has moved to a new address. | |||
===Personator Append=== | |||
If a record is verified or data sources may be able to append missing data (fill in the blanks.) | |||
===Express Entry=== | |||
*Real time data entry for any field type | |||
*Real time auto-complete and validation for US addresses | |||
===Reporting=== | |||
*Result Codes, the quality and errors associated with each record; appended to each record. | |||
* | *General Processing Summary, the details of processed job. | ||
* | *Processing Results Summary, summary table and charts of each action performed. | ||
*US Check & Verify State Distribution Summary (US only.) | |||
*SmartMover NCOA State & Province Distribution Summary (US & CAN.) | |||
*Result Code Summary, Table of total counts for each possible output action. | |||
==For International Data (Non US or Canada)== | |||
===Global Check=== | |||
Standardize and Correct | |||
*Addresses | |||
* | *Append Geo-coordinates | ||
* | |||
===Reporting=== | |||
*Result Codes, the quality and errors associated with each record; appended to each record | |||
*General Processing Summary, the details of processed job | |||
*Processing Results Summary, summary table and charts of each action performed | |||
*Result Code Summary, Table of total counts for each possible output action | |||
[[Category:Listware for Excel]] | |||
[[Listware for Excel | |||
Revision as of 19:50, 15 September 2016
See individual product pages' documentation or Result codes for a complete description of their respective capabilities.
Domestic US and Canada
Check
Standardize and Correct
- Names
- Addresses
- Phone Numbers
- Email Addresses
- Append Geo-coordinates
MatchUp
- Record Matching using basic datatype matching strategies.
- Processed lists can be evaluated in many ways…
- Result Codes. Group Identifier and Group Count appended to each record allow you to easily analyze, group or remove identified duplicate records
- The Processing Results output window allows you to redefine records as Output or Duplicate status
- Choose to output cell color for alternating duplicate groups
- Commit identified groups to a new sheet or append to the existing sheet
SmartMover NCOA
Check to see if a Name or associated Company has moved to a new address.
Domestic US Only
Personator Verify
Correlate the above data types, E.G. Do they actually belong together?
Personator Move
Check to see if a Name or associated Company has moved to a new address.
Personator Append
If a record is verified or data sources may be able to append missing data (fill in the blanks.)
Express Entry
- Real time data entry for any field type
- Real time auto-complete and validation for US addresses
Reporting
- Result Codes, the quality and errors associated with each record; appended to each record.
- General Processing Summary, the details of processed job.
- Processing Results Summary, summary table and charts of each action performed.
- US Check & Verify State Distribution Summary (US only.)
- SmartMover NCOA State & Province Distribution Summary (US & CAN.)
- Result Code Summary, Table of total counts for each possible output action.
For International Data (Non US or Canada)
Global Check
Standardize and Correct
- Addresses
- Append Geo-coordinates
Reporting
- Result Codes, the quality and errors associated with each record; appended to each record
- General Processing Summary, the details of processed job
- Processing Results Summary, summary table and charts of each action performed
- Result Code Summary, Table of total counts for each possible output action