How to Use This Report
Set date filter: "Last Feedback Date" to see feedback received across all sources for the time period
You can use report filters to focus on feedback responses from a specific source (e.g. has NPS) or clinic location
Download data as CSV by clicking three dots and selecting "all results"
Data Dictionary
Column Name | Description | Example Data |
Report Fields |
|
|
Feedback ID | Unique identifier created using COALESCE(booking_id_hash, review_google_id). Unique within each file. Any updates (e.g. additional feedback or updates to reviews) will appear in future files | Booking ID Hash: XaLdbo |
Last Feedback Date | The most recent date when any form of feedback (NPS, Google review, Solv review) was received from this patient for this visit. | 2025-07-13 |
Solv NPS (Net Promoter Score) |
|
|
NPS Response Date | The most recent date when the patient submitted their Net Promoter Score (NPS) survey response for this visit. | 2025-07-13 |
NPS Score | Numerical rating (0-10) given by the patient in response to the question "How likely are you to recommend this practice to a friend or colleague?" Used to calculate Net Promoter Score. | 0-10 |
NPS Category | Classification of the NPS score into standard categories: Detractor (0-6), Passive (7-8), or Promoter (9-10), used for NPS analysis and reporting. | detractor, passive, promoter |
NPS Comment | Free-text feedback provided by the patient in text message after responding to the NPS score |
|
Google Reviews |
|
|
Google Review Date | Date when the patient posted their review on the practice's Google Business Profile, providing public feedback about their experience. | 2025-07-13 |
Google Review Rating | The star rating (1-5 stars) given by the patient in their Google review, representing their overall satisfaction. | 1-5 |
Google Review | Free-text feedback visible to the public. |
|
Solv Reviews |
|
|
Solv Rating Left Date | Date when the patient posted their review on Solv platform |
|
Solv Rating | The star rating (1-5 stars) given by the patient in their Solv review, representing their overall satisfaction. | 1-5 |
Solv Review | Free-text feedback visible to the public. |
|
Rating Wait Time | Star Rating for "Wait Time" | 1-5 |
Rating Quality of Care | Star Rating for "Quality of Care" | 1-5 |
Rating Bedside Manner | Star Rating for "Bedside Manner" | 1-5 |
Rating Ease of Scheduling | Star Rating for "Ease of Scheduling" | 1-5 |
Rating Staff Friendliness | Star Rating for "Staff Friendliness" | 1-5 |
Rating Office Cleanliness | Star Rating for "Office Friendliness" | 1-5 |
Practice Location |
|
|
Practice Name | Primary name, or brand name, for the clinic | Clear Care |
Clinic Name | Secondary name, or site name, for the clinic | Bronx 149th |
EMR Clinic ID | Electronic Medical Record system clinic ID code | ZNY01 |
EMR Clinic Name | Electronic Medical Record system clinic identifier name | 0404149TH |
Patient Details |
|
|
Patient ID EMR | Patient identifier in Electronic Medical Record system captured time of booking creation | 948890 |
Patient First Name | Patient's first name captured at time of booking creation | Jose |
Patient Last Name | Patient's last name captured at time of booking creation | Pinales |
Patient Birth Date | Patient's date of birth captured at time of booking creation | 1982-11-06 |
Patient Email | Patient's email address captured at time of registration | |
Patient Mobile Phone Number | Patient's mobile phone number captured at time of booking creation | (212) 999-9999 |
Booking |
|
|
Booking ID Hash Solv | Hashed booking identifier from Solv system | XaLdbo |
Booking ID EMR | Booking identifier from Electronic Medical Record system |
|
Appointment Date | Local date of the scheduled appointment | 2025-07-31 |
Appointment Time | Local date and time of the scheduled appointment | 2025-07-31 19:45:00 |
Arrived Time |
|
|
In Exam Time |
|
|
Discharged Time | Local date and time when patient was discharged | 2025-07-31 10:45:35 |
Staff |
|
|
Staff Provider Name | Name of healthcare provider associated with the visit. Possible sources of this data from Solv telemed platform or EMR integration. If Solv is manually importing provider data from EMR, there may be up to a 2 week lag in seeing provider names matched based on the visit date and EMR patient number or phone. | Alicia Jackson |
Staff Front Office Name | Name of the clinic staff member who updated the patient's status during their visit (arrived, here, ready, in exam, or discharge). When multiple staff are involved, we report staff member who made the earliest status update in the workflow. | Ethan Black |