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 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:
This is the name of the location where the rating was received at.
This is a unique ID given to each location.
The unique ID of the device that captured the rating (you can also find this on the back of your device(s)).
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.
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.
The NPS segment that the NPS belongs in (Promoter, Passive or Detractor).
This is the verbatim comment question that was asked (e.g. "Is there anything else you'd like to tell us?).
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.
The email address given by the customer.
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).
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.
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.
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).
The date the user responded to the rating/comment.
The user that responded to the rating/comment.