Deliverables for First Visit, Unauthenticated Visitor Personalization

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

The output file location will be at your preferred destination AWS, Snowflake, or Box.

Resonate Output File Deliverables

1. IP Data File

The IP Data File will be a compressed .csv file and will include several columns.

• Column 1 contains the list of IP addresses. 
• Column 2+ will contain a key
  • These keys are attributes that you chose in the beginning of the process
  • The number of attributes included in the file depend on the attributes you chose.

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 columns 2+ in the output file to “survey_value_keys” column in definition file
• This file lists all the attributes purchased by the customer.
• Example: If the output file contains a key = “137912”, 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 

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:

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

Helpful Delivery Tips and Tricks

If you have any difficulties opening an install or POV file (specifically on a mac), you may be experiencing an “Archive Utility” issue, which sometimes cannot open a gzip compressed file depending on the software being used. We recommend using unzip utilities like 7zip or Keka if you are having trouble with Archive Utility. Note: Excel cannot load more than ~1M rows at a time.