Exporting data from the RateIt Portal
Exporting the data from the RateIt Portal couldn't be easier!
Here's a step by step guide to show you how:
2. Select your preferred data criteria using the Filters on the left panel
3. Click the Export button towards the upper right corner of the screen
4. The system will then email you a link to download your CSV export.
Note: The exporter will export the data based on the criteria you currently have active at the time of exporting.
Here's a summary of the columns you'll find in the CSV:
- Location name
This is the name of the location that 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.
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).
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.
- Multi Choice 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.