Name: Local SEO Dentist GMB Reviews - Newport
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Local SEO Dentist GMB Reviews - Newport

Context
This dataset contains 49 cleaned customer reviews for a local dental clinic in Newport News, VA, USA. The data was scraped from a single Google My Business (GMB) listing in October 2025 using Apify.

This dataset was prepared as the first step in a portfolio project to demonstrate Aspect-Based Sentiment Analysis (ABSA) for local SEO and reputation management.

Content

The file cleaned_gmb_reviews.csv contains three columns:

clinic_name: (text) The name of the GMB listing.
rating: (integer) The star rating given by the user (1-5).
review_text: (text) The full text of the review.

Data Cleaning Process

The raw data (100 rows) was programmatically cleaned using Python and the pandas library to:

Select only the essential columns (title, stars, text).
Rename columns for clarity (e.g., stars to rating).
Extract the clean integer (e.g., 5) from the text-based rating (e.g., "5 stars").
Remove 51 rows that had no written review text, as they are not usable for text analysis.

Inspiration

This dataset is ideal for answering several key business questions:

What is the overall sentiment (Positive, Negative) of the reviews?
What specific topics (e.g., "pricing", "wait time", "Dr. Ali") do customers mention most often?
What are the primary pain points for this clinic's customers?

Tables

Cleaned Gmb Reviews

@kaggle.mehreensiraj_local_seo_dentist_gmb_reviews_newport.cleaned_gmb_reviews

10.87 kB
49 rows
3 columns

CREATE TABLE cleaned_gmb_reviews (
  "clinic_name" VARCHAR,
  "rating" BIGINT,
  "review_text" VARCHAR
);