Listware for Excel:Capabilities: Difference between revisions

From Melissa Data Wiki
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===

Latest revision as of 00:30, 29 June 2023

← Listware for Excel


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

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