Data Append Deliverables (Address or ZIP11)

Data Append Deliverables when input file included Address and/or ZIP11

Resonate will provide two output files as the deliverables for Data Append. We recommend using your data science or analytics resources who can help ingest these files internally in your environment.

The output file location is the same as the method used to send us input data

1. If the input data was sent using Snowflake; the output file is available under “Data Sharing” section of the account used to share the input table
   • The definition file will be shared with you by your Resonate customer contact
2. If the input data was sent using AWS; the output file is available in the same folder used to send input data

3. If the input data was sent using Box; the output file is available in Box.

4. If the input file was sent using SFTP; the output file will be available

Resonate Output File Deliverables

1a. Standard Append Output File

The Standard Append Output File will be in a .csv file format and will include 3 columns.

• Column 1 contains the list of matched Customer IDs from the input file.
  • This column includes your IDs that were matched to Resonate IDs.
  • Note: you will notice less IDs in the file as compared to what was originally sent. This is because we ONLY send back the IDs that were matched to Resonate IDs.
• Column 2 contains ID that we matched. You will see one of the following values
  • “Direct Match” - If we matched with HEM or MAID directly from the file with our ID graph
  • “Household” - If we provide predictions from relevant HEM found in the household
• Column 3 contains a comma separated list of keys.
  • These keys are attributes that are true for the ID in column 1.
  • Only keys corresponding to true attributes are included. The false are excluded.
  • The number of attributes included in the file depend on the clusters or attributes you choose.

1b. Pivoted Append Output Table

The Pivoted Append Output File will be in a .csv file format and will include a column for each attributes ordered.

• Column 1 contains the list of matched Customer IDs from the input file.

  • This column includes your IDs that were matched to Resonate IDs.

• Column 2 contains ID that we matched. You will see one of the following values

  • “Direct Match” - If we matched with HEM or MAID directly from the file with our ID graph

  • “Household” - If we provide predictions from relevant HEM found in the household

• Column 3 onwards contains the attribute key.

  • A 1 in the column indicates that attribute is true for the ID in column 1.

  • A 0 in the column indicates that attribute is false for the ID in column 1.

  • The number of attributes included in the file depend on the clusters or attributes you choose.

2. Key Definitions File

• The file provides definition of the keys. It provides the human readable name of the attribute tied to the key.
• The customer must map the keys from column 2 in the standard output file to “survey_value_keys” column in definition file

• The customer must map the keys from Column 3 onwards in the pivoted output file to “survey_value_keys” column in definition file

• This file lists all the clusters or attributes purchased by the customer and all possible attribute values tied to it.
• Example: If the output file contains a key = “422753," that means the ID containing this key is in the age group 18-24.

• The file also includes whether the question the attribute was derived from was a single-select or multi-select question. 

3. Summary Report

This document provides a summary of the contents in your Data Append Output file. It includes the following details:

• Columns A to E: Display the full taxonomy of each attribute value.
• SURVEYVALUEKEY: The survey_value_key corresponding to each attribute, as reflected in the output file.
• DISTINCT_COUNT: Represents the total number of IDs in the output file that are true for the given attribute value.
  • Example: If the DISTINCT_COUNT for "gender = female" is 188, this means we have predicted 188 female IDs in the customer output file.
• PERCENTAGE: The percentage of records that are true for the attribute value in each row.
  • Example: If the PERCENTAGE for "gender = female" is 94%, this means that 94% of the records in the customer output file are predicted to be female.

Use this file to verify that your Output and Definition files are correctly aligned. After ingesting the file from us and formatting it on your end, we recommend that you perform a QA check by comparing your formatted data with the metrics provided in the summary report. For example, confirm if the counts for demographic categories like males and females in your formatted data align with the values in the summary report. 

Joining the Output File Back to Your Customer Database

Resonate output files are easily ingested with the help of your analytics or data science team. Due to large file size and quantity of data, these files require more advanced technical resources and are difficult to interpret and analyze on tools like excel.

How to Read the Output Files

Below we’ve provided a simplified example to show how to interpret the file outputs.

In this example, your standard output file contains the following:

By referencing the Key Definitions File, you would interpret the keys as follows:

In the Standard Append File, we ONLY include the list of keys for which the attribute value = TRUE. If you want to understand the possible attribute values that the customer was False for; you can refer to the Key Definitions File. You will see all keys belonging to that attribute.

For example, below are the key options for the attribute age group.

So, a complete table of True and False Values for the example above would be shown as: