Location name
This is the name of the location where the rating was received at.

Location ID
​This is a unique ID given to each location.

Device ID
​The unique ID of the device that captured the rating (you can also find this on the back of your device(s)).

Device Label
​The device label is usually used to help you more easily determine which area of the business each rating has come from when you have more than one device (e.g. "Floor Stand" or "Register 1").

Rating Capture Date
The date the rating was submitted on the device. The timezone will mirror where the device is physically located, regardless of where you were during the exporting process. (E.g. You were in Singapore when you exported the data but the device is physically located in Melbourne, then the timezone of the ratings will take Melbourne's).

Rating Capture Time
​The time the rating was given on the device. The timezone will mirror where the device is physically located, regardless of where you were during the exporting process.

CX
The smiley that was selected on the first screen.

CX Score
The corresponding Numeric CX scores for the Smileys on the first screen (Awesome = 10, Good = 7, Not Great = 4, Awful = 0).

NPS
The Net Promoter Score (NPS) the customer picked.

NPS Segment
​The NPS segment that the NPS belongs in (Promoter, Passive or Detractor).

Question Asked
​This is the verbatim comment question that was asked (e.g. "Is there anything else you'd like to tell us?).

Customer Response
​The response the customer gave to the verbatim comment question that was asked.

Response Sentiment Analysis
​This is the Sentiment Analysis assigned by Google (e.g. whether the comment is positive, negative or neutral).

Response Sentiment Magnitude
​This score indicates the overall strength of emotion of the comment, between 0 and infinity. The higher the number, the stronger the feeling.

Email Address
​The email address given by the customer.

Phone Number
The phone number given by the customer.

Extended Contact Signup/Mailing List
​Whether or not the customer selected the "Sign up to newsletter" checkmark (indicating that they have given you permission to be added to your mailing list).

Staff Member
The staff member or other option ("No one" or "I don't know") that was selected for the staff activity
​Note: This field is only applicable if your profile has the staff selection activity included.

MultiChoice Results
​Lists each multi-choice question and chosen responses (we will only show multi-choice questions if they have responses attached to them).
​Note: These fields are only applicable if your profile has multi-choice questions included.

Category Activity Results
​The category question is given as the column title, while the response is listed below. The possible responses are Awesome, Good, Not Great and Awful (we will only show category questions if there are ratings that have responses to them).
​Note: These fields are only applicable if your profile has category questions included.
​

System Estimated Age
​This is the estimated age of the person giving the rating if biometrics is turned on.
​Note: We are still fine-tuning this system and do not guarantee age estimations for every rating.

System Estimated Gender
​This is the estimated gender of the person giving the rating if biometrics is turned on.
​Note: We are still fine-tuning this system and do not guarantee gender estimations for every rating.
​

Response Sent
​The column will say Yes if a member of your team has sent a response to that rating, No if they have not yet sent a response and will be blank/null if they are unable to respond (e.g. if the rating is missing an email address and a comment).

Response Date
​The date the user responded to the rating/comment.

Response User
​The user that responded to the rating/comment.