Difference between revisions of "Listware for Excel:Capabilities"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "<h3>'''What can Listware do?'''</h3> <h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3> <span style="color:#0000...")
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<h3>'''What can Listware do?'''</h3>
[[Listware for Excel|&larr; Listware for Excel]]
{{CustomTOC}}


<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>
See individual product pages' documentation or Result codes for a complete description of their respective capabilities.


<span style="color:#0000FF">Domestic US and Canada </span><br>
==Domestic US and Canada==
* '''Check''' - Standardize and correct
===Check===
** Names
Standardize and Correct
** Addresses
** Phone Numbers
** Email Addresses
** Append geocoordinates


*Names
*Addresses
*Phone Numbers
*Email Addresses
*Append Geo-coordinates


<span style="color:#0000FF">Domestic US only </span><br>
===MatchUp===
* '''Verify''' - correlate the above data types, ie. do they actually belong together
*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


* '''Move''' - check to see if a Name or associated Company has moved to a new address
===SmartMover NCOA===
Check to see if a Name or associated Company has moved to a new address.


* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)


==Domestic US Only==
===Personator Verify===
Correlate the above data types, E.G. Do they actually belong together?


'''Report'''
===Personator Move===
* Result Codes, the quality and errors associated with each piece
Check to see if a Name or associated Company has moved to a new address.
* Processing Summary, the summary of each action


===Personator Append===
If a record is verified or data sources may be able to append missing data (fill in the blanks.)


<span style="color:#0000FF">For International Data (non US or Canada)</span> <br>
===Express Entry===
'''Global Check''' - Standardize and  correct
*Real time data entry for any field type
* Addresses
*Real time auto-complete and validation for US addresses
* Append geocoordinates


'''Report'''
===Reporting===
* Result Codes, the quality and errors associated with each piece
*Result Codes, the quality and errors associated with each record; appended to each record.
* Processing Summary, the summary of each action
*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.




'''In Development''' <br>
==For International Data (Non US or Canada)==
'''MatchUp'''
===Global Check===
* Record Matching (Are there any duplicate records?)
Standardize and Correct
'''Express Entry'''
* Real time data entry address validation and auto-complete


*Addresses
*Append Geo-coordinates


[[Listware for Excel|Back to Listware Main Page]]
===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]]

Revision as of 19:50, 15 September 2016

← 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