What is the difference between Flattened and Unflattened Data in ETO Results?

#Results

Updated over a week ago

Flattened Data is information stored in Individual records.

Flattened Data should be used when reporting on specific answers to questions.

In some cases, Flattened Data is not updated live. Two examples of Flattened Data that are not updated live are:

  1. Custom Demographics—these update in an overnight job.

  2. Weighted values associated TouchPoint responses—this data is populated by a queue system that feeds updated TouchPoint responses through every few minutes.

Unflattened Data is all data in an enterprise stored in "Question/Answer" pair format.

Unflattened data should be used when aggregating (totaling) data. Unflattened demographic data is available in real time.

Unflattened TouchPoint responses are not available in real time. They are populated by a queue system that feeds updated TouchPoint responses through every few minutes.

Did this answer your question?