Listware for Excel:Capabilities: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
*Email Addresses | *Email Addresses | ||
*Append Geo-coordinates | *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=== | ===SmartMover NCOA=== | ||
| Line 53: | Line 61: | ||
*Processing Results Summary, summary table and charts of each action performed | *Processing Results Summary, summary table and charts of each action performed | ||
*Result Code Summary, Table of total counts for each possible output action | *Result Code Summary, Table of total counts for each possible output action | ||
[[Category:Listware for Excel]] | [[Category: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