What this sample shows
This is a redacted public sample of a single monthly Local Market Pulse issue — the June 2026 issue for a three-location operator in the San Francisco Bay Area. The buyer brand, its exact locations, the named competitive set, and the surrounding proximity cohort are redacted as [BUYER BRAND], [Competitor A], [Nearby Restaurant …], and so on. What is preserved is everything a prospective subscriber actually needs to evaluate the product: the per-location analytical structure, the statistical-significance discipline applied to every claim, and the limitations transparency that characterises the live engagement.
A Local Market Pulse subscription delivers this depth for every location in a portfolio, every month — listing health monitored, review velocity tracked against a cumulative baseline with formal significance testing, Q&A surfaces audited for owner-response engagement, local search rank assessed against high-intent category queries, and five evidence-grounded content recommendations per location.
Portfolio Summary
Three operating locations span the San Francisco Bay Area — Union Square, Fremont, and Oakland — with cumulative ratings ranging from 3.8 to 3.9 stars and listing-claim status varying by location. One location operates without active listing control. One location's live Google Business Profile fetch was unavailable this issue and is rendered from a recent reference snapshot, transparently disclosed inline.
Figure 3 — Geographic spread of the three [BUYER BRAND] locations and the three named competitive entities across the SF Bay Area metro.
Headline Finding
Two signals dominate this issue.
The Fremont listing is unclaimed. The Fremont profile is publicly active and accumulating customer feedback — nearly six hundred reviews — but the owner-administration toggle is off. Responses to negative reviews, Google Posts, hours updates, photo uploads, and Q&A administration cannot be performed from the [BUYER BRAND] side. Claiming the listing through Google is free and typically completes within 5 to 14 days.
Trailing-90-day ratings are running well below cumulative averages at all three locations. Union Square's last-90-day window averages 2.0 stars (n=26, confidence 0.557); Fremont's averages 1.0 stars (n=22, confidence 0.539); Oakland's averages 1.0 stars (n=14, confidence 0.491). All three are below the 30-sample reliability threshold and should be read as directional. Formal Mann-Kendall non-parametric trend testing produced p-values of 0.575, 0.500, and 0.244 — all above 0.05 — meaning these shifts are not yet statistically validated trends. Operationally actionable, but the underlying data supports vigilance rather than certainty.
Figure 1 — Cumulative vs trailing-90-day rating per location, with sample-size and confidence-score disclosure inline. Figure 6 — Mann-Kendall p-values per location; all three fall above the 0.05 significance threshold.
Competitive Position
Competitive position is assessed two ways: against three named San Francisco halal and Mediterranean operators in the same cuisine category, and against the five physically nearest restaurants within 5 km of each location regardless of cuisine — the foot-traffic-competitive set.
| Location / Operator | Cumulative rating | Reviews | Category | Claim status |
|---|---|---|---|---|
| Union Square (buyer) | 3.8–3.9 | 2,154 | Halal restaurant | Claimed |
| Fremont (buyer) | 3.8–3.9 | ~600 | Halal restaurant | Unclaimed |
| Oakland (buyer) | 3.8–3.9 | — | Halal restaurant | Unknown / reference snapshot |
| [Competitor A] | 4.4 | — | Mediterranean restaurant | — |
| [Competitor B] | 4.1 | 104 | Halal restaurant | — |
| [Competitor C] | 4.4 | — | Mediterranean restaurant | — |
All three named competitors carry higher cumulative ratings (4.1 to 4.4 stars) than any [BUYER BRAND] location, though their review volumes are substantially smaller. [Competitor B] is the only competitor that self-identifies as a Halal restaurant on its Google Business Profile.
Figure 2 — Rating by review volume for all 21 entities (buyer + named competitors + proximity cohort). [BUYER BRAND] locations cluster at high volume but lower ratings than named competitors and most resolved cohort members.
Customer Engagement
Google Business Profile Q&A data is captured for all three locations. Total absolute Q&A counts are low (2, 2, and 1 answered questions respectively). Critically, no business-owner responses exist on any captured question across all three locations — 0 of 20 captured questions has an owner response.
| Pattern | Locations affected | Operational note |
|---|---|---|
| "What kind of special offers are available?" — identical across all 3 | Union Square, Fremont, Oakland | Likely a Google auto-generated question; one templated owner response can address all three at once |
| Zero owner-response engagement on any captured question | All 3 | Owner response is a high-leverage trust signal currently going unused |
| Q&A coverage stable across capture and verification pass | All 3 | No new questions appeared between initial capture and the counter-signal verification pass; volume is genuinely low |
Figure 5 — Answered vs unanswered question counts per location.
Local Search Visibility
Across the four high-intent local search queries assessed for the SF City tier, no [BUYER BRAND] location appears in the top 20 results in any query. The three named competitors are also absent from the top 20 in all queries. The local SERP is dominated by [Local Restaurant A–D], with composition skewing heavily toward Reddit, Yelp, Tripadvisor, and Facebook user-generated content rather than individual restaurant websites.
| High-intent query | [BUYER BRAND] rank |
Named competitors in top 20 |
|---|---|---|
| halal food near me | Not in top 20 | None of 3 |
| gyro san francisco | Not in top 20 | None of 3 |
| shawarma san francisco | Not in top 20 | None of 3 |
| best halal restaurants san francisco | Not in top 20 | None of 3 |
The combined monthly search volume across all four queries is approximately 6,060 in the SF City tier. The "halal restaurant near me" query alone accounts for 4,400 of that, at low competition (keyword-difficulty index 18) and a $0.28 CPC. The local pack composition shows no restaurant-affiliated direct results dominating; user-generated-content platforms hold the top positions.
Figure 4 — Monthly search-volume distribution across the four high-intent SF City queries. Google Ads competition index is low across all measured terms (12–25).
Content Recommendations
Five content recommendations per location are drawn from this month's findings. Each names a specific theme, a recommended channel, and the data point it addresses. One Fremont recommendation was held this month because the original draft referenced data from a different location; it will return next month, corrected. Fourteen recommendations are ready to publish this issue — and the held count is itself reported as a quality signal (see Evidence Grounding below).
For Multi-Unit Operators & Franchise Systems
The substrate underlying this report scales linearly with location count. A franchise system or multi-unit operator with twenty or two hundred locations receives the same per-location depth shown here, with comparative dashboarding across the portfolio: listing health monitored monthly, review velocity tracked against a cumulative baseline with formal significance testing, Q&A surfaces audited for unanswered questions and owner-response engagement, local search rank assessed against high-intent category queries, and five content recommendations per location per month, each tied to a specific finding and ready to publish.
Looking Forward
The June 2026 issue is the first of the monthly cadence. The July issue tracks the deltas.
| Signal | Current state | What changes month over month |
|---|---|---|
| Listing claim status per location | 2 claimed, 1 unclaimed (Fremont) | Watched until claim count reaches 3 of 3 |
| Trailing-90-day rating + Mann-Kendall significance | All 3 directional (p>0.05); not yet validated | Rating direction and p-value trajectory tracked monthly; the significance threshold becomes meaningful as sample sizes accumulate |
| Q&A owner-response engagement | 0 owner responses across all 3 locations | Each owner response logged as engagement uplift |
| Local SERP rank presence | 0 of 4 high-intent queries | Any movement onto the local pack or top 20 surfaces as a finding |
| Held content recommendations | 1 (Fremont) | Re-grounding and return; held count tracked as a quality signal |
| Content recommendations published | 14 ready this issue | Publication confirmation and engagement metrics reported next issue |
Methodology & Data Lineage
Every quantitative figure in this report traces to a specific data source and finding identifier. The substrate underlying this issue was captured 2026-06-14 between 00:15 and 00:25 UTC.
Data sources. Google Business Profile listing data, Google Maps customer reviews, Google local search rankings, Google keyword search volume, and Google Trends category direction. All facts about ratings, review counts, claim status, categories, and price level come from live Google Business Profile data. Where a live fetch was unavailable for one location this issue, recent reference data is used and disclosed inline.
- Google Business Profile listing data per location and competitor (rating, review count, claim status, categories, hours, photos)
- Google Maps customer reviews captured across the trailing-90-day window for each location and the proximity cohort
- Local search ranking data for four high-intent halal and Mediterranean restaurant queries in the San Francisco area
- Google search volume and competition index for the same four query terms
- Google Business Profile customer questions for each location
- Independent statistical-significance testing (Mann-Kendall non-parametric trend test) applied to each location's review trajectory
Statistical-significance testing. Trend findings carry Mann-Kendall non-parametric trend p-values. The conventional significance threshold (α=0.05) governs whether a finding is reported as a confirmed trend versus a directional indicator. Sample-size and effective-confidence scores are surfaced inline with each rating-velocity claim, and findings below the 30-sample reliability threshold are explicitly flagged as directional.
Population-bias disclosure. Review data carries known motivated-reviewer skew: extreme experiences (5-star and 1-star) are overrepresented relative to intermediate ratings (2–4). True customer sentiment is likely closer to cumulative averages than to trailing-window means. This bias affects all review-source data and is disclosed for transparency rather than removed by upstream weighting.
Evidence grounding. Every content recommendation references a specific finding about the location it addresses. Recommendations that draw evidence from the wrong location are held rather than published, and the number of held recommendations is reported each issue as a quality signal.
Geographic scope. San Francisco City for local search rank assessment; Bay Area metro for keyword volume; a 5 km radius for proximity-cohort discovery per buyer location. For dense urban anchors this captures a broader set than typical foot-traffic competition; the methodology surfaces in-radius density as competitive context.
Reporting cadence. Monthly. Each issue covers the trailing 90 days for review velocity, trends data at city resolution when available, and current state for listing health and search rank. Quarter-over-quarter delta on share of local attention surfaces in the third issue and each subsequent issue, as the historical baseline accumulates.