Follow

Built-In Validation & Normalization

LeadConduit performs a variety of validation and normalization tasks on lead data as it enters the system.

Phone

Phone Numbers can be submitted in various formats such as:

  • 512.298.0978
  • (512) 298-0978
  • 512-298-0978
  • 512 298-0978

Extensions are also supported

  • 512.298.0978 ext. 99
  • 512.298.0978 x 99

LeadConduit can properly parse and normalize both United States and Canadian-based phone numbers to a proper 10 digits. LeadConduit also makes the following components of a phone number available.

  • Raw - the original, unaltered data
  • Area - the Area Code of the Number (512)
  • Exchange - the Exchange of the Number (298)
  • Line - the Line component of the Number (0978)
  • Extension - The Extension (when there is one)
  • Country Code - The Country Code of the Number (currently always "US")
  • Tollfree? - A true/false indicator of whether or not the Number is Toll-free (one of these area codes: 800, 844, 855, 866, 877, 888)

LeadConduit also uses a Google-produced library to determine if numbers are valid based on the Area Code. 

For example, 512-555-1212 is technically a validly formatted number. 

This does not guarantee the number is real, connected, or callable, just that the area code is valid and the overall format is correct.

For example, if you submit a lead with 555-555-1212, the library sees that the area code is bad and says it's an invalid number.

Recommended Acceptance Criteria

Requiring a valid phone number is a good start

screencapture-next-leadconduit-flows-59dbd146b75b0d4b1b000000-edit-sources-1507580001831.png

You might not want to accept Toll-Free numbers. If so, set this additional Acceptance Criterion:

screencapture-next-leadconduit-flows-59dbd146b75b0d4b1b000000-edit-sources-1507582831089.png

 

Email

Email can only be submitted in a singular, standard format: user@domain

LeadConduit can parse emails and makes the following components of an email available.

  • Raw - the original, unaltered data
  • User - Everything to the left of the @ symbol
  • Domain - Everything to the right of the @ symbol
  • Top Level Domain - A top-level domain (TLD) is one of the domains at the highest level in the hierarchical Domain Name System of the Internet. The top-level domain names are installed in the root zone of the namespace. (e.g. .com, .net, .org, .io)
  • Host - The Domain, excluding the Top Level Domain (e.g. gmail, aol)

LeadConduit will flag the email data if the user@domain format is not followed.

Recommended Acceptance Criteria

A valid email is, of course, the best place to start.

screencapture-next-leadconduit-flows-59dbd146b75b0d4b1b000000-edit-sources-1507580304908.png

You might also want to filter out emails with an unusually long username, as those have a higher tendency to be fraudulent.

screencapture-next-leadconduit-flows-578fdfe6fd00c845402ea663-edit-steps-1507584148406.png

The pattern shown in the screenshot is: "[a-zA-Z0-9\.]{20,50}"

//--//

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

You must be logged in to comment.