Data Append Deliverables

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. For input data via Box or Throtle, the files will be delivered through a Box folder

Note that if you are doing Indirect Data Append, you will receive a third file from Throtle in addition to the two files below from Resonate.

Resonate Output File Deliverables

1. Append File

The Append File will be in a .csv file format and will include 2 columns.

• Column 1 contains the list of matched IDs from the input file. 
  • For Direct Data Append, this column includes your IDs that were matched to Resonate IDs.
  • For Indirect Data Append, this column includes Throtle IDs that were matched to Resonate IDs. You will separately receive a file from Throtle that matches your data to Throtle IDs.  You will need to join these files to tie your appended data to your 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 we were matched to Resonate IDs.

• Column 2 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 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 output file to “survey_value_keys” column in definition file

• This file lists all the clusters purchased by the customer and all possible attribute values tied to it.

• Example: If the output file contains a key = “137912”, that means the ID containing this key is in the age group 18-24.

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 output file contains the following: