Data Validation and Standardization
There is no excuse anymore for marketing in the entering of bad or incomplete data. Market2Lead offers you the ability to validate and standardize data, rejecting data that does not measure up.
Watch this short video to see our data validation features 'in action'
To maximize data quality, and richness over time, Market2Lead offers on-form capabilities to:
- Validate the combination of city, state, and postal code in North America
- Validate email formats and real time domain validation
- Validate telephone number format for many countries
- Validate postal code format for many countries
- Rejection of companies or domains you specify
- Optionally reject public domain email addresses on a form by form basis
Market2Lead also rejects form responses that contain any of 600+ common junk words and expletives when they are found in the first or last name fields.
When it comes to importing data, Market2Lead offers validation and error handling for field formats such as email, dates, Boolean, and picklist fields so that you can avoid introducing suspect data into your database.
Standardization of data is achieved partially through rejecting data that is not in the correct format, and partially through augmenting data. Market2Lead offers the ability to derive new values (attribute) based on data submitted in a web form. This can be used for many purposes including assigning sales territories to leads, or converting state abbreviations into full length state names. One can create a flag to indicate if the person used a public domain in their email address, or automatically tag registrants as competitors based on their email domain. One can recognize new leads from existing customers and flag them so they are sent to the account owner without delay.
After the data validation and standardization is done, leads are scored and routed. With strict data standards, documented process, and automation to prevent bad data from getting into the system, your marketing campaigns will be more successful, and your sales people will be more appreciative of the data they get from marketing.