Enhanced Conversions

  /// <summary> 
 /// Normalizes the email address and hashes it. For this use case, Campaign Manager 360 
 /// requires removal of any '.' characters preceding <code>gmail.com</code> or 
 /// <code>googlemail.com</code>. 
 /// </summary> 
 /// <param name="emailAddress">The email address.</param> 
 /// <returns>The hash code.</returns> 
 private 
  
 string 
  
 NormalizeAndHashEmailAddress 
 ( 
 string 
  
 emailAddress 
 ) 
 { 
  
 string 
  
 normalizedEmail 
  
 = 
  
 emailAddress 
 . 
 ToLower 
 (); 
  
 string 
 [] 
  
 emailParts 
  
 = 
  
 normalizedEmail 
 . 
 Split 
 ( 
 '@' 
 ); 
  
 if 
  
 ( 
 emailParts 
 . 
 Length 
 > 
 1 
 && 
 ( 
 emailParts 
 [ 
 1 
 ] 
  
 == 
  
 "gmail.com" 
  
 || 
  
 emailParts 
 [ 
 1 
 ] 
  
 == 
  
 "googlemail.com" 
 )) 
  
 { 
  
 // Removes any '.' characters from the portion of the email address before 
  
 // the domain if the domain is gmail.com or googlemail.com. 
  
 emailParts 
 [ 
 0 
 ] 
  
 = 
  
 emailParts 
 [ 
 0 
 ]. 
 Replace 
 ( 
 "." 
 , 
  
 "" 
 ); 
  
 normalizedEmail 
  
 = 
  
 $"{emailParts[0]}@{emailParts[1]}" 
 ; 
  
 } 
  
 return 
  
 NormalizeAndHash 
 ( 
 normalizedEmail 
 ); 
 } 
 /// <summary> 
 /// Normalizes and hashes a string value. 
 /// </summary> 
 /// <param name="value">The value to normalize and hash.</param> 
 /// <returns>The normalized and hashed value.</returns> 
 private 
  
 static 
  
 string 
  
 NormalizeAndHash 
 ( 
 string 
  
 value 
 ) 
 { 
  
 return 
  
 ToSha256String 
 ( 
 digest 
 , 
  
 ToNormalizedValue 
 ( 
 value 
 )); 
 } 
 /// <summary> 
 /// Hash a string value using SHA-256 hashing algorithm. 
 /// </summary> 
 /// <param name="digest">Provides the algorithm for SHA-256.</param> 
 /// <param name="value">The string value (e.g. an email address) to hash.</param> 
 /// <returns>The hashed value.</returns> 
 private 
  
 static 
  
 string 
  
 ToSha256String 
 ( 
 SHA256 
  
 digest 
 , 
  
 string 
  
 value 
 ) 
 { 
  
 byte 
 [] 
  
 digestBytes 
  
 = 
  
 digest 
 . 
 ComputeHash 
 ( 
 Encoding 
 . 
 UTF8 
 . 
 GetBytes 
 ( 
 value 
 )); 
  
 // Convert the byte array into an unhyphenated hexadecimal string. 
  
 return 
  
 BitConverter 
 . 
 ToString 
 ( 
 digestBytes 
 ). 
 Replace 
 ( 
 "-" 
 , 
  
 string 
 . 
 Empty 
 ); 
 } 
 /// <summary> 
 /// Removes leading and trailing whitespace and converts all characters to 
 /// lower case. 
 /// </summary> 
 /// <param name="value">The value to normalize.</param> 
 /// <returns>The normalized value.</returns> 
 private 
  
 static 
  
 string 
  
 ToNormalizedValue 
 ( 
 string 
  
 value 
 ) 
 { 
  
 return 
  
 value 
 . 
 Trim 
 (). 
 ToLower 
 (); 
 } 
 

  private 
  
 String 
  
 normalizeAndHash 
 ( 
 MessageDigest 
  
 digest 
 , 
  
 String 
  
 s 
 ) 
  
 throws 
  
 UnsupportedEncodingException 
  
 { 
  
 // Normalizes by removing leading and trailing whitespace and converting all characters to 
  
 // lower case. 
  
 String 
  
 normalized 
  
 = 
  
 s 
 . 
 trim 
 (). 
 toLowerCase 
 (); 
  
 // Hashes the normalized string using the hashing algorithm. 
  
 byte 
 [] 
  
 hash 
  
 = 
  
 digest 
 . 
 digest 
 ( 
 normalized 
 . 
 getBytes 
 ( 
 "UTF-8" 
 )); 
  
 StringBuilder 
  
 result 
  
 = 
  
 new 
  
 StringBuilder 
 (); 
  
 for 
  
 ( 
 byte 
  
 b 
  
 : 
  
 hash 
 ) 
  
 { 
  
 result 
 . 
 append 
 ( 
 String 
 . 
 format 
 ( 
 "%02x" 
 , 
  
 b 
 )); 
  
 } 
  
 return 
  
 result 
 . 
 toString 
 (); 
 } 
 /** 
 * Returns the result of normalizing and hashing an email address. For this use case, Campaign Manager 360 
 * requires removal of any '.' characters preceding {@code gmail.com} or {@code googlemail.com}. 
 * 
 * @param digest the digest to use to hash the normalized string. 
 * @param emailAddress the email address to normalize and hash. 
 */ 
 private 
  
 String 
  
 normalizeAndHashEmailAddress 
 ( 
 MessageDigest 
  
 digest 
 , 
  
 String 
  
 emailAddress 
 ) 
  
 throws 
  
 UnsupportedEncodingException 
  
 { 
  
 String 
  
 normalizedEmail 
  
 = 
  
 emailAddress 
 . 
 toLowerCase 
 (); 
  
 String 
 [] 
  
 emailParts 
  
 = 
  
 normalizedEmail 
 . 
 split 
 ( 
 "@" 
 ); 
  
 if 
  
 ( 
 emailParts 
 . 
 length 
 > 
 1 
 && 
 emailParts 
 [ 
 1 
 ] 
 . 
 matches 
 ( 
 "^(gmail|googlemail)\\.com\\s*" 
 )) 
  
 { 
  
 // Removes any '.' characters from the portion of the email address before the domain if the 
  
 // domain is gmail.com or googlemail.com. 
  
 emailParts 
 [ 
 0 
 ] 
  
 = 
  
 emailParts 
 [ 
 0 
 ] 
 . 
 replaceAll 
 ( 
 "\\." 
 , 
  
 "" 
 ); 
  
 normalizedEmail 
  
 = 
  
 String 
 . 
 format 
 ( 
 "%s@%s" 
 , 
  
 emailParts 
 [ 
 0 
 ] 
 , 
  
 emailParts 
 [ 
 1 
 ] 
 ); 
  
 } 
  
 return 
  
 normalizeAndHash 
 ( 
 digest 
 , 
  
 normalizedEmail 
 ); 
 } 
 

  private static function normalizeAndHash(string $hashAlgorithm, string $value): string 
 { 
 return hash($hashAlgorithm, strtolower(trim($value))); 
 } 
 /** 
 * Returns the result of normalizing and hashing an email address. For this use case, Campaign 
 * Manager 360 requires removal of any '.' characters preceding "gmail.com" or "googlemail.com". 
 * 
 * @param string $hashAlgorithm the hash algorithm to use 
 * @param string $emailAddress the email address to normalize and hash 
 * @return string the normalized and hashed email address 
 */ 
 private static function normalizeAndHashEmailAddress( 
 string $hashAlgorithm, 
 string $emailAddress 
 ): string { 
 $normalizedEmail = strtolower($emailAddress); 
 $emailParts = explode("@", $normalizedEmail); 
 if ( 
 count($emailParts) > 1 
 && preg_match('/^(gmail|googlemail)\.com\s*/', $emailParts[1]) 
 ) { 
 // Removes any '.' characters from the portion of the email address before the domain 
 // if the domain is gmail.com or googlemail.com. 
 $emailParts[0] = str_replace(".", "", $emailParts[0]); 
 $normalizedEmail = sprintf('%s@%s', $emailParts[0], $emailParts[1]); 
 } 
 return self::normalizeAndHash($hashAlgorithm, $normalizedEmail); 
 } 
 

  def 
  
 normalize_and_hash_email_address 
 ( 
 email_address 
 ): 
  
 """Returns the result of normalizing and hashing an email address. 
 For this use case, Campaign Manager 360 requires removal of any '.' 
 characters preceding "gmail.com" or "googlemail.com" 
 Args: 
 email_address: An email address to normalize. 
 Returns: 
 A normalized (lowercase, removed whitespace) and SHA-265 hashed string. 
 """ 
 normalized_email 
 = 
 email_address 
 . 
 lower 
 () 
 email_parts 
 = 
 normalized_email 
 . 
 split 
 ( 
 "@" 
 ) 
 # Checks whether the domain of the email address is either "gmail.com" 
 # or "googlemail.com". If this regex does not match then this statement 
 # will evaluate to None. 
 is_gmail 
 = 
 re 
 . 
 match 
 ( 
 r 
 "^(gmail|googlemail)\.com$" 
 , 
 email_parts 
 [ 
 1 
 ]) 
 # Check that there are at least two segments and the second segment 
 # matches the above regex expression validating the email domain name. 
 if 
 len 
 ( 
 email_parts 
 ) 
> 1 
 and 
 is_gmail 
 : 
 # Removes any '.' characters from the portion of the email address 
 # before the domain if the domain is gmail.com or googlemail.com. 
 email_parts 
 [ 
 0 
 ] 
 = 
 email_parts 
 [ 
 0 
 ] 
 . 
 replace 
 ( 
 "." 
 , 
 "" 
 ) 
 normalized_email 
 = 
 "@" 
 . 
 join 
 ( 
 email_parts 
 ) 
 return 
 normalize_and_hash 
 ( 
 normalized_email 
 ) 
 def 
  
 normalize_and_hash 
 ( 
 s 
 ): 
  
 """Normalizes and hashes a string with SHA-256. 
 Private customer data must be hashed during upload, as described at: 
 https://support.google.com/google-ads/answer/7474263 
 Args: 
 s: The string to perform this operation on. 
 Returns: 
 A normalized (lowercase, removed whitespace) and SHA-256 hashed string. 
 """ 
 return 
 hashlib 
 . 
 sha256 
 ( 
 s 
 . 
 strip 
 () 
 . 
 lower 
 () 
 . 
 encode 
 ()) 
 . 
 hexdigest 
 () 
 

  # Returns the result of normalizing and then hashing the string using the 
 # provided digest.  Private customer data must be hashed during upload, as 
 # described at https://support.google.com/google-ads/answer/7474263. 
 def 
  
 normalize_and_hash 
 ( 
 str 
 ) 
  
 # Remove leading and trailing whitespace and ensure all letters are lowercase 
  
 # before hasing. 
  
 Digest 
 :: 
 SHA256 
 . 
 hexdigest 
 ( 
 str 
 . 
 strip 
 . 
 downcase 
 ) 
 end 
 # Returns the result of normalizing and hashing an email address. For this use 
 # case, Campaign Manager 360 requires removal of any '.' characters preceding 
 # 'gmail.com' or 'googlemail.com'. 
 def 
  
 normalize_and_hash_email 
 ( 
 email 
 ) 
  
 email_parts 
  
 = 
  
 email 
 . 
 downcase 
 . 
 split 
 ( 
 "@" 
 ) 
  
 # Removes any '.' characters from the portion of the email address before the 
  
 # domain if the domain is gmail.com or googlemail.com. 
  
 if 
  
 email_parts 
 . 
 last 
  
 =~ 
 /^(gmail|googlemail)\.com\s*/ 
  
 email_parts 
 [ 
 0 
 ] 
  
 = 
  
 email_parts 
 [ 
 0 
 ]. 
 gsub 
 ( 
 '.' 
 , 
  
 '' 
 ) 
  
 end 
  
 normalize_and_hash 
 ( 
 email_parts 
 . 
 join 
 ( 
 '@' 
 )) 
 end