// ====================================================================
// HQ REVIEW ANALYSIS, brand-wide Google Business Profile review summary.
// A corporate-level read on what customers are saying about FreshNest
// across all 700 Google Business Profiles: rating + volume trends,
// sentiment, the themes driving praise and complaints, representative
// quotes, and the locations pulling the brand average up or down.
// Aggregates the live 700-location portfolio so headline numbers
// reconcile with the Locations tab and the per-location detail pages.
// ====================================================================
(function () {
const { useState, useMemo } = React;
const T = (...a) => (window.toast || (() => {}))(...a);
const TONES = {
ok: { bg: 'var(--sage-soft)', col: 'var(--sage)' },
warn: { bg: 'var(--marigold-soft)', col: '#917200' },
bad: { bg: 'var(--terra-soft)', col: '#a12118' },
info: { bg: 'var(--sky-soft)', col: 'var(--sky)' },
neutral: { bg: 'var(--cream)', col: 'var(--ink-3)' },
};
function Pill({ tone = 'neutral', children, dot }) {
const t = TONES[tone] || TONES.neutral;
return (
{dot && }
{children}
);
}
const Stars = ({ n, size = 13 }) => (
{'★'.repeat(n)}{'★'.repeat(5 - n)}
);
const Label = ({ children, hint }) => (
{children}
{hint && {hint}}
);
const fmt = (x) => x >= 1000 ? (x / 1000).toFixed(x >= 10000 ? 0 : 1) + 'k' : '' + Math.round(x);
function HqReviewAnalysis({ data, portfolio = [], onOpen = () => {} }) {
const A = useMemo(() => {
const locs = portfolio.length ? portfolio : [];
const n = locs.length || 1;
const totalReviews = locs.reduce((a, l) => a + (l.reviewsCount || l.reviews || 0), 0) || 0;
// Brand rating is anchored to the network source of truth (4.6★); the sample
// portfolio only supplies review volume + distribution shape.
const sotRating = data && data.network && data.network.performance ? data.network.performance.avgRating : null;
const wRating = sotRating != null ? sotRating : (totalReviews
? locs.reduce((a, l) => a + (l.rating || 0) * (l.reviewsCount || l.reviews || 0), 0) / totalReviews
: 0);
// Star distribution, anchored to the brand average, brand-realistic skew.
const fiveShare = Math.min(0.74, Math.max(0.42, (wRating - 2.6) / 2.4));
const dist = {
5: fiveShare,
4: 0.22 - (fiveShare - 0.6) * 0.2,
3: 0.09,
2: 0.05,
1: 1 - fiveShare - (0.22 - (fiveShare - 0.6) * 0.2) - 0.09 - 0.05,
};
const distCount = Object.fromEntries(Object.entries(dist).map(([k, v]) => [k, Math.max(0, Math.round(v * totalReviews))]));
const positive = Math.round((dist[5] + dist[4]) * 100);
const neutral = Math.round(dist[3] * 100);
const negative = 100 - positive - neutral;
// 12-month review volume + rating trend (deterministic, seasonal).
const months = ['Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun'];
const baseMonthly = Math.round(totalReviews * 0.052);
const trend = months.map((m, i) => {
const seasonal = 1 + 0.18 * Math.sin((i / 12) * Math.PI * 2) + (i / 11) * 0.22;
return {
m,
vol: Math.round(baseMonthly * seasonal),
rating: Math.round((wRating - 0.25 + (i / 11) * 0.28) * 100) / 100,
};
});
const thisMonth = trend[trend.length - 1].vol;
const lastMonth = trend[trend.length - 2].vol;
const volDelta = Math.round((thisMonth - lastMonth) / lastMonth * 100);
// Themes, brand-scale, home-services-coherent. Counts proportional to footprint.
const positiveThemes = [
{ theme: 'Cleaning quality & thoroughness', share: 31, locs: 671, delta: +6, quote: 'They cleaned spots we never even think about, the baseboards are unreal.', city: 'Chicago Loop' },
{ theme: 'Friendly, attentive staff', share: 26, locs: 654, delta: +4, quote: 'Marcus at the counter remembered my refill order from last week. That kind of service is rare.', city: 'Austin Downtown' },
{ theme: 'Product value', share: 19, locs: 588, delta: +3, quote: 'One bottle of concentrate lasted two months. Fair price for the quality you get.', city: 'Denver LoDo' },
{ theme: 'Speed of service', share: 13, locs: 512, delta: +2, quote: 'In and out in under ten minutes on a refill run. Line moves fast.', city: 'Houston Galleria' },
{ theme: 'Office cleaning reliability', share: 11, locs: 401, delta: +5, quote: 'Cleaned our office overnight, crew arrived 15 minutes early, spotless by morning.', city: 'Atlanta Midtown' },
];
const negativeThemes = [
{ theme: 'Late arrivals at peak times', share: 34, locs: 392, delta: +3, quote: 'Crew ran 45 minutes late on a Saturday with no ETA updates.', city: 'Las Vegas Strip' },
{ theme: 'Hours inconsistency', share: 22, locs: 184, delta: -2, quote: 'Google said open till 10, got there at 8:45 and they were already closing down.', city: 'St. Louis Central' },
{ theme: 'Supplies out of stock', share: 18, locs: 246, delta: +1, quote: 'No concentrate, no refill pods, no sponges at 7pm on a Friday. Really?', city: 'Memphis Beale St.' },
{ theme: 'Parking & access', share: 15, locs: 142, delta: 0, quote: 'Lot was full with no signage for overflow. Circled for ten minutes.', city: 'Nashville Broadway' },
{ theme: 'Order accuracy', share: 11, locs: 168, delta: -1, quote: 'Third time my pickup order was missing an item. Check the bag, please.', city: 'Detroit Corktown' },
];
// Representative quotes (mixed) for the feed.
const feed = [
{ author: 'Jordan P.', city: 'Austin Downtown', stars: 5, when: '2h', theme: 'Cleaning quality', text: 'Best cleaning crew near the office, hands down. Fast, thorough, and the staff actually know my name.' },
{ author: 'Renee M.', city: 'Las Vegas Strip', stars: 2, when: '5h', theme: 'Wait times', text: 'The clean was great once the crew arrived, but a 40-minute wait is rough. Needs more hands at peak.' },
{ author: 'Sofia A.', city: 'Chicago Loop', stars: 5, when: '1d', theme: 'Office cleaning', text: 'Handled our 60-desk office flawlessly. On time, spotless, zero stress for me.' },
{ author: 'Will T.', city: 'St. Louis Central', stars: 3, when: '1d', theme: 'Hours', text: 'Decent store but the posted hours are never right. Showed up twice to a closed door.' },
{ author: 'Dana K.', city: 'Denver LoDo', stars: 5, when: '2d', theme: 'Value', text: 'Great value for the price and everything is actually non-toxic. My go-to store, twice a month.' },
{ author: 'Marcus D.', city: 'Memphis Beale St.', stars: 2, when: '3d', theme: 'Sold out', text: 'Ran out of half the refill line before close. Frustrating when you drive across town for it.' },
];
// Leaderboard, top & bottom by rating among locations with enough reviews.
const ranked = [...locs]
.filter(l => (l.reviewsCount || l.reviews || 0) >= 100)
.sort((a, b) => (b.rating || 0) - (a.rating || 0));
const top = ranked.slice(0, 5);
const bottom = ranked.slice(-5).reverse();
const responseRate = 91;
const avgResponseHrs = 3.2;
const unanswered = Math.round(totalReviews * (1 - responseRate / 100) * 0.04);
return { n, totalReviews, wRating, distCount, positive, neutral, negative, trend, thisMonth, volDelta,
positiveThemes, negativeThemes, feed, top, bottom, responseRate, avgResponseHrs, unanswered };
}, [portfolio]);
const maxVol = Math.max(...A.trend.map(t => t.vol));
const distMax = Math.max(...Object.values(A.distCount));
const kpis = [
{ v: A.wRating.toFixed(2), suffix: '★', l: 'Brand Google rating', sub: 'review-weighted, all GBPs', c: 'var(--marigold)' },
{ v: fmt(A.totalReviews), l: 'Total Google reviews', sub: A.n + ' profiles', c: 'var(--ink)' },
{ v: fmt(A.thisMonth), l: 'New this month', sub: (A.volDelta >= 0 ? '+' : '') + A.volDelta + '% vs last mo', c: A.volDelta >= 0 ? 'var(--sage)' : 'var(--terra)' },
{ v: A.positive + '%', l: 'Positive sentiment', sub: '4–5★ share', c: 'var(--sage)' },
{ v: A.responseRate + '%', l: 'Response rate', sub: A.avgResponseHrs + 'h avg reply', c: A.responseRate >= 85 ? 'var(--sage)' : 'var(--marigold)' },
];
return (
{/* AI brand summary */}
What customers are saying · brand-wide
Across {A.n} Google Business Profiles, FreshNest holds a {A.wRating.toFixed(2)}★ average on {fmt(A.totalReviews)} reviews, trending up. Customers consistently praise food freshness and friendly staff. The one recurring drag, wait times at peak hours, shows up at {A.negativeThemes[0].locs} locations and is the clearest system-wide opportunity.
{/* KPI band */}
{kpis.map((k, i) => (
{k.v}{k.suffix || ''}
{k.l}
{k.sub}
))}
Source: Google Business Profile
{/* Rating distribution + volume trend */}