Narrative

About

Description

MD5 of a normalized email, `MD5(NORMALIZE_EMAIL(email))`: lowercase hex, 32 characters. Hashes of un-normalized emails won't join. The MD5 of an empty string, `d41d8cd98f00b204e9800998ecf8427e`, isn't a hash of any email and reads as NULL.

Unique Name

md5_hashed_email

Type

object

Properties

type

No Description

View

value

No Description

View

context

No Description

View

Related Attributes

SHA-256 Hashed Email

SHA-256 of a normalized email, `SHA2(NORMALIZE_EMAIL(email), 256)`: lowercase hex, 64 characters. Hashes of un-normalized emails won't join. The SHA-256 of an empty string, `e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855`, isn't a hash of any email and reads as NULL.

View

SHA-1 Hashed Email

SHA-1 of a normalized email, `SHA1(NORMALIZE_EMAIL(email))`: lowercase hex, 40 characters. Hashes of un-normalized emails won't join. The SHA-1 of an empty string, `da39a3ee5e6b4b0d3255bfef95601890afd80709`, isn't a hash of any email and reads as NULL.

View

Unique Identifier

A catch-all field for any miscellaneous identifier.

View

Normalized Email

An attribute representing a standardized email address, following Narrative's prescribed normalization process. NQL exposes a function to make this easy: `NORMALIZE_EMAIL(field)`. This normalization removes periods and any content after the '+' sign for Gmail addresses, converts all characters to lowercase, and trims whitespace around the email. This ensures consistent formatting for email addresses for querying and data processing. For more information, see https://www.narrative.io/knowledge-base/how-to-guides/how-to-normalize-emails-prior-to-hashing. This is the canonical input form for the hashed email attributes (74, 75, 76): hash the normalized email, never the raw one.

View

SHA-256 Hashed Phone Number

A SHA-256 hashed representation of a phone number, normalized to E.164 international format including the leading plus sign (e.g. the SHA-256 of '+12127855334') prior to hashing. The hash is lowercase hexadecimal, 64 characters. Produced in NQL as SHA2(NORMALIZE_PHONE('E164', phone, 'US'), 256), substituting the appropriate default country code. Distinct from sha256_hashed_msisdn (379), which hashes the same number without the leading plus, and from sha256_hashed_phone_number_nsn (369), which hashes the national significant number with no country code. Hashes produced under those conventions will not join against this attribute.

View

Related Datasets