Google Review Insights: Reputation Reports and Agency Leads

Turn Google Maps reviews into a one-row reputation report per business. Built for reputation-management and marketing agencies looking for businesses that need help, and for owners who want to see what customers keep complaining about.

What you get per business

• Rating trend: average stars in the recent period (default 90 days) against older reviews: falling, steady or rising
• Unanswered negative reviews: 1 and 2 star reviews the owner never replied to, plus the latest one quoted
• Owner reply rate: across all reviews and across negative ones, and the median days to reply
• Top complaints: rude staff, slow or long wait, late or no-show, overcharged or pricing, quality of work or product, dirty or smell, closed during open hours, billing or refund, communication, injury or safety. Each theme shows how many negative reviews mention it.
• 5-star bursts: the most 5-star reviews from first-time reviewers (1 or 2 reviews on their profile) within one week
• Detailed ratings when Google has them (for example Food, Service, Atmosphere)
• Reviews per month and the date of the latest review
• Lead score (0 to 100) and a plain-language summary

Lead score

Signal	Points
Unanswered negative reviews	8 each, up to 40
Rating falling (recent average 0.4+ stars below older)	25
Owner replies to under 20% of reviews	20
5-star burst of 4+ from first-time reviewers in one week	15

Example

On the newest 60 reviews of 12 Sacramento businesses (coffee and donut shops, a nail salon, a barber, plumbers):

• Dunkin' (lead score 65): "7 of 17 negative reviews unanswered; rating falling: 3.08 in the last 90 days vs 3.6 before; most common complaint: rude staff"
• A donut shop and a nail salon (60 each): every negative review unanswered (19 of 19 and 25 of 25), owner never replies; top complaints were product quality and rude staff
• Three 5-star plumbers: no negative reviews, but bursts of 4 to 7 five-star reviews from first-time reviewers within a week. That is often a business asking customers for reviews, which is allowed; it is shown so you can judge it.

How to use it

1. Run the Google Maps Reviews Scraper for the businesses you care about. Sort by newest and get at least 50 reviews per place for a good trend reading. You can feed it place URLs or the results of the Google Maps Scraper.
2. Open this actor and pick that run's dataset.
3. Optional: set Minimum lead score to 40 to get only businesses worth contacting.

Output

{
  "name": "Dunkin' Donuts.",
  "category": "Coffee shop",
  "google_rating": 3.5,
  "reviews_analyzed": 60,
  "lead_score": 65,
  "summary": "7 of 17 negative reviews unanswered; rating falling: 3.08 in the last 90 days vs 3.6 before; most common complaint: rude staff",
  "recent_rating": 3.08,
  "older_rating": 3.6,
  "rating_trend": "falling",
  "negative_reviews": 17,
  "unanswered_negative": 7,
  "owner_reply_rate_pct": 55,
  "median_reply_days": 23,
  "top_complaints": "rude staff (6); quality of work or product (3); closed during open hours (1); dirty or smell (1)",
  "five_star_burst": 0,
  "detailed_ratings": "Food 3.71; Service 3.59; Atmosphere 3.63",
  "reviews_per_month": 3.7,
  "latest_unanswered_negative": "...",
  "google_maps_url": "https://www.google.com/maps/..."
}

Good to know

• Complaint themes come from keyword rules checked by hand on real negative reviews, so they catch the common phrasings, not every one.
• The trend needs at least 5 recent and 5 older reviews; otherwise it says "not enough reviews".
• A 5-star burst is a pattern to look at, not proof of fake reviews.
• No reviewer names are needed or output.

Pricing

You pay per business analyzed, no matter how many reviews it has. Run it with no input to analyze a small built-in demo sample for free.

Made by KodaBloom LLC. Questions: info@kodabloom.com