ETO Results | Flattened vs Unflattened Data

BO 4.3 Platform

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 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 every few minutes.

Did this answer your question?