Skip to main content

Patient Feedback

The Patient Feedback Report unifies all your feedback data — from Solv NPS surveys, Solv custom surveys, Solv reviews and Google reviews — into a single, actionable report that helps you get visit-level insights into what drives loyalty and satisfaction.

K
Written by Kathy Silverman
Updated yesterday

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

(PRIMARY KEY)

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

When Booking ID Hash exists: Uses the case-sensitive booking ID hash from Solv. Solv NPS and Reviews always Booking ID Hash

When Booking ID Hash is null: Uses the Google Review ID for unmatched reviews

Matching Logic: Solv's automated algorithm attempts to link Google reviews to patient visits based on visit date and patient name. Successful matches populate booking ID hash and booking related data; unmatched reviews (more common) appear with Google review ID only.

Booking ID Hash: XaLdbo
Google Review ID: AbFvOqnZEfHmuv-CnRoIwODqd34LyP6AoiZpQ_Q6zo4wPMPLIKxqTp58FAyOH0AWg0ZLdm2rhz9HAA

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

Did this answer your question?