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”
- Data inserted into your CRM database has an invalid picklist value for a specific field.