Skip to main content
All CollectionsRateIt by ZiplineRatings
Exporting data from the RateIt Portal
Exporting data from the RateIt Portal
Ian James S. Pagulayan avatar
Written by Ian James S. Pagulayan
Updated over a week ago

Exporting the data from the RateIt Portal couldn't be easier! Here's a step by step guide to show you how:

1. Log in to the RateIt Portal and then head to the Ratings tab

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:

  • 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.

Did this answer your question?