Listware for Excel:Capabilities

From Melissa Data Wiki
Jump to: navigation, search

← 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

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
Personal tools
Namespaces

Variants
Actions
Navigation
Products
Support