First-Party Data File Formatting Guidelines & Best Practices (HEMs or MAIDs Only)

How can you send us data?

Resonate accepts data via following methods

• Box
• AWS
• Snowflake Direct Share
• Snowflake Cleanroom
• SFTP

Data Formatting Guidelines when sending file that has HEMs or MAIDs

This document outlines the best practices and file format for append processing. Please fully review the file requirements specified below so that we can process your data as quickly as possible. 

Use Resonate’s hashing script for optimal match rates. Resonate’s hashing script automatically removes any leading or trailing spaces and changes all email addresses to lower case prior to hashing to provide the highest possible match rates.

Best Practices for Optimal Match Rates

1. Email hashing

• Ensure the emails are as up to date as possible. Old emails that are no longer active tend to generate low match rates.  
• Ensure all email addresses are from the US. Resonate’s data is US only and we are not able to match against international emails.  
• Emails must all be in lower case before hashing (Resonate’s script will do this for you)
• Trim all leading and trailing spaces from email addresses (Resonate’s script will do this for you)
• After hashing ensure that your hashes are comprised of alpha numeric characters
  • Examples:
    • MD5 (preferred): 32-character hexadecimal number. For example, ec55d3e698d289f2afd663725127
    • SHA-1: 40-character hexadecimal number. For example, A94A8FE5CCB19BA61C4C0873D391E987982FBBD3
    • SHA-256: SHA 256 is a part of the SHA 2 family of algorithms, and generates a 64-character hexadecimal number. For example, 051f26bd6cde782239bf52e56854d3feeca75ae5a84508d1ff9a1868ba167ee5

2. Mandatory IDs

• HEM - this includes the following columns
  • HEM
  • HEM Type
• MAID

3. Please reference the file format example and details on each column here.

4. Once your file is in the correct format, please save with the following name: