What is malformed data?

Malformed data is data that cannot be used in the course of business operations due to one or more errors.

Examples of malformed data are:

• Email addresses
  • Missing username (e.g.   @sampledomain.com)
  • Bad syntax (no @ sign or top-level domain (e.g., .com, .net, .org))
  • Misspelled domains (e.g., gmial.com and yahooo.com)
• Typos
  • Misspelled states, countries, and street identifiers (e.g., Avwnue, Streeet)
• Unwanted text
  • Account names containing words or phrases like formerly known as (fka), doing business as (dba), delete, dupe, old, gone, city or region of the business
• Addresses
  • Incomplete zip or postal codes
• Phone numbers
  • Incomplete or incorrectly formatted numbers (e.g., 303555129_, (30)35551298)
• Picklist fields
  • Data inserted into your CRM database has an invalid picklist value for a specific field.
    • For example, your picklist values are “Red, Yellow, Green” and the data inserted into your database is “Yello”