Sample ForIntel Cross-Surface Sentiment Audit — Three Stores, One Review Stream, Three Sentiment Stories

What this sample shows

This is a public sample of a ForIntel Cross-Surface Sentiment Audit, published by Foragentis to demonstrate the method. It reads a three-store CVS pharmacy portfolio across San Francisco, Palo Alto, and Berkeley — a public company's public locations, named throughout (consistent with the Foragentis Local Market Pulse sample on the same three CVS stores). There is no private buyer to redact: the subject of study is the store, not a confidential client, and every finding below describes a public review surface.

It demonstrates what the audit reads: a per-store review-sentiment read, with each store bound to its own public review stream so that no store's reviews, themes, or quotes appear under another store. Each store is scored on its lifetime rating and review base, the share of reviews at one or two stars, a weighted-mean derived sentiment posture recomputed from that store's own reviews, and the recurring complaint themes counted from that store only. Every finding carries an explicit confidence chip, and the one place where a true cross-surface comparison cannot be made — a structural property of how US retail-pharmacy stores are listed — is named as a deliberate boundary rather than inferred.

The verdict

One brand, three reputations — and the pharmacy counter is the common thread.

Read store-by-store, this is not one CVS but three. Berkeley is the clearest liability: a 2.5-star rating on the portfolio's largest review base, with nearly two-thirds of reviews at one or two stars and a recurring set of complaints about waits, locked-up merchandise, security, and being closed during posted hours. Palo Alto is polarized — a genuine base of five-star fans sitting alongside an equally large pole of one- and two-star reviews about pharmacy friction, long waits, and rude service. SF Downtown has the thinnest base, and its negativity concentrates on the pharmacy itself — refills, transfers, vaccines, and unanswered phones. The through-line across all three is the pharmacy and service experience. Each finding below is bound to its own store's review stream, so there is no cross-store mix-up: three stores, three distinct postures, three different moves.

1. Berkeley is the portfolio's sentiment problem — and it's in the reviews, not just the rating. Berkeley (1451 Shattuck Ave) carries a 2.5-star lifetime rating across 151 reviews and a recomputed 2.46-star posture on its captured stream — 64% of those reviews are 1–2 star, the worst share of the three. The recurring complaints are concrete: long lines and slow service, prescription / pharmacy friction, locked-up merchandise behind security, and the store being closed or locked during posted open hours. This is the store most customers find and the one most likely to disappoint them.
2. Palo Alto is a polarized store: a strong base of fans, and a recurring service-and-wait complaint cluster. Palo Alto (352 University Ave) splits almost evenly — 45% 1–2 star and 45% 4–5 star across its captured stream (3.1-star lifetime over 119 reviews; 2.96-star recomputed posture). The negative pole is dominated by pharmacy / prescription friction (16 reviews), long waits and understaffing (13), and rude or unhelpful service (10). The fans are real; so is a repeatable bad experience at the pharmacy counter.
3. SF Downtown is the thinnest review base — and its complaints center on the pharmacy itself. SF Downtown (789 Mission St) has the smallest captured stream (47 reviews) and a 3.1-star lifetime rating (3.06-star recomputed posture; 40% 1–2 star). Of its negative reviews, the dominant theme is pharmacy / prescription handling (9 reviews) — refill and transfer problems, vaccine and service breakdowns — followed by rude-service and unanswered-phone complaints. The thinner base means each review carries more weight, not less.

In one line: Three stores, three distinct sentiment stories — and all three share one driver: the pharmacy counter. Berkeley needs a reputation rescue, Palo Alto needs to convert its polarized base, and SF Downtown needs to fix the pharmacy experience its thin review base keeps flagging. Every theme below is bound to the store its own customers wrote it about.

How to read this report. This is a single-surface deep read of each store's public review stream — the surface where these stores actually have a customer voice. Each store's rating distribution, sentiment posture, and complaint themes are recomputed from that store's own reviews and bound to that store only; no store's reviews, themes, or quotes appear under another store. A High confidence chip means the read was re-checked on a second, independent capture of the same store's stream; a Medium chip applies where the store's captured base is thinner. Where we could not measure something — the cross-surface comparison is the main one — we name the boundary explicitly in Scope, Confidence & What a Deeper Engagement Adds rather than infer it. Quotes are customer reviews, lightly trimmed; no individual is identified.

01 · Portfolio sentiment scorecard — three stores, three postures

(Confidence: High.) The table reads each store on the signals that matter for reputation — the lifetime rating, the share of the captured review stream that is 1–2 star, the derived sentiment posture, and the store's single most-recurring complaint theme — with each store's data bound to its own review stream. The derived posture is the weighted-mean star rating recomputed across that store's captured reviews; it tracks each store's lifetime profile rating closely (3.1→3.06, 3.1→2.96, 2.5→2.46), which confirms each stream is the right store's. (Source: each store's public review stream, recomputed from the captured reviews and re-checked on a second independent capture.)

Figure — Star-rating distribution, share of each store's stream. Berkeley is 64% one- and two-star — majority negative; Palo Alto and SF Downtown are more polarized, with a sizeable five-star base sitting alongside a large one-star pole. Each distribution is computed from that store's own reviews only.

Figure — Derived sentiment posture, weighted-mean star rating per store. The recomputed posture (3.06 / 2.96 / 2.46) matches each store's lifetime rating (3.1 / 3.1 / 2.5), confirming each stream is bound to the correct store — and Berkeley trails the other two.

02 · Berkeley — the reputation rescue

(Confidence: High.) Berkeley (1451 Shattuck Ave) is the portfolio's clearest sentiment liability: a 2.5-star rating across 151 reviews, the largest and lowest-rated base of the three, with a recomputed 2.46-star posture and 64% of its reviews at one or two stars. The complaints are specific and recurring — this is not diffuse unhappiness but a small set of repeatable failures. (Source: the store's review stream, re-checked on a second capture — high confidence.)

The recurring 1–2 star themes, each counted from Berkeley's own reviews: pharmacy / prescription friction (18 reviews), long waits and slow service (16), rude or unhelpful staff (11), and a distinctive "closed / locked during posted hours" cluster (10) tied to locked entrances, locked-up merchandise, and security presence. Representative customer reviews:

• "Long lines, always, due to incompetent employees. Every other transaction seems to require a supervisor to weigh in." (1 star)
• "Nice pharmacists, but telephone hold times are insanely long… the management clearly doesn't care about the community." (1 star)
• "The deodorant is in a locked case. I pushed the button for help to unlock it, waited, tried again, still no response, a third time…" (1 star)
• "There is a feeling of suspicion and unwelcome at this site. Today there were two armed guards at the front door and much of the merchandise is locked up." (2 star)
• "Came at 9:45 PM. The sign says closes at 10 PM. Door is locked." (1 star)

The leverage here is concentrated: the complaint set is short and operational, which means a focused fix (staffing the counter at peak, a faster help-button response on locked merchandise, accurate posted hours) addresses the bulk of the negative volume. The rating is the symptom; these four themes are the cause.

03 · Palo Alto — the polarized store

(Confidence: High.) Palo Alto (352 University Ave) is the most polarized of the three: 45% of its captured reviews are 1–2 star and 45% are 4–5 star (3.1-star lifetime over 119 reviews; 2.96-star recomputed posture). It has a real base of advocates — and an equally large pole of frustrated customers whose complaints cluster tightly. (Source: the store's review stream, re-checked on a second capture — high confidence.)

The recurring 1–2 star themes from Palo Alto's own reviews: pharmacy / prescription friction (16 reviews), long waits, understaffing, and turnover (13), and rude or unhelpful service (10). Several reviews explicitly tie the wait problem to staffing levels rather than individual employees. Representative customer reviews:

• "Terrible pharmacy… the service is soooo slow. Someone please for the love of god disrupt the pharmacy industry." (1 star)
• "The people who work here are all nice, but they are overwhelmed. The store needs to hire more staff… constant turnover." (2 star)
• "Received a message that prescribed medications are ready, came in store, line was 20 mins, just to learn that medications are actually not ready." (1 star)
• "The woman who works in customer service at the pharmacy has a terrible attitude; she's horrible at serving customers." (1 star)
• "They never want to deal with people who need help with photos… I called ahead to ensure I would be able to be helped and made the trip down there and they turned me away." (1 star)

Because the store already has a deep base of five-star reviews, the opportunity is conversion rather than rescue: the same pharmacy-counter and staffing fixes that calm the negative pole let the existing advocacy carry the rating up. The polarization says the store can be very good — when it is staffed for it.

04 · SF Downtown — thin base, pharmacy-centered complaints

(Confidence: Medium.) SF Downtown (789 Mission St) has the thinnest captured review base in the portfolio (47 reviews), a 3.1-star lifetime rating, a 3.06-star recomputed posture, and 40% of reviews at one or two stars. The thinner base is itself a signal: with fewer reviews, each new one-star review moves the rating more, so the store is more exposed to a bad streak. (Read on a smaller base — medium confidence; the read was re-checked on a second capture, but the underlying volume is thin.)

SF Downtown's negativity concentrates on the pharmacy itself. The recurring 1–2 star themes from its own reviews: pharmacy / prescription handling (9 reviews) — refills, transfers, vaccines — followed by rude or unhelpful service (4) and unanswered-phone complaints (4). Representative customer reviews:

• "They cancelled my refill request for my prescription, and they refused to transfer my prescription to the new CVS location that I requested." (1 star)
• "Staff mumbles inaudibly, zero communication skills. Wasted my entire morning where they took 40 minutes to repackage 3 boxes into 1." (1 star)
• "I made an appointment for vaccine. They wouldn't tell me there was no vaccine available until I got there." (1 star)
• "Service over the phone was not pleasant. Got an attitude and the representative did not make an effort to support me with contacting my doctor." (1 star)
• "Patient privacy violations. They have a camera with a screen that people behind you can see that shows the pharmacy computer." (1 star)

The pattern is narrower than the other two stores — almost entirely a pharmacy-operations story rather than a front-of-store one. That focus is an advantage: the fix has a clear address (the pharmacy counter, its phone handling, and refill/transfer reliability), and a small number of recovered reviews moves this thin base quickly.

05 · The common thread — one driver across three stores

(Confidence: High.) Read across the three stores — without ever moving a theme from one store to another — one driver recurs in every store's top complaints: the pharmacy and service experience. Pharmacy / prescription friction is the #1 or tied-#1 negative theme at all three stores (9 reviews at SF Downtown, 16 at Palo Alto, 18 at Berkeley), and long waits / understaffing is close behind at the two larger-volume stores. Where the stores differ is in the secondary themes: Berkeley adds a distinctive security / locked-merchandise / closed-during-hours cluster that the other two do not carry; SF Downtown adds an unanswered-phone theme; Palo Alto's secondary load is squarely on staffing and turnover. (Source: each store's own review stream, themes counted per store.)

Figure — Recurring 1–2 star complaint themes, count per store. Each bar counts reviews from that store's own stream only. The shared driver is the pharmacy counter and wait times; Berkeley's security / closed-hours cluster is unique to that store, and SF Downtown's unanswered-phone theme is unique to it.

The practical implication: a portfolio-level pharmacy-and-staffing program addresses the common driver at all three stores at once, while two store-specific moves — Berkeley's security / hours experience and SF Downtown's phone handling — close the divergent secondary themes. One shared fix, two targeted ones.

Scope, confidence & what a deeper engagement adds

This audit is a single-surface deep read of each store's public review stream — the surface where these retail-pharmacy stores actually have a customer voice — with each store bound to its own listing and each theme counted from that store's own reviews. The Berkeley and Palo Alto reads carry High confidence (re-checked on a second capture of the same store's stream); SF Downtown is Medium (thinner base). The boundaries below are named as deliberate edges, not findings.

• The cross-surface comparison cannot be made for these stores — a structural boundary, not a missing pull. A genuine cross-surface audit would compare each store's review-stream sentiment against other consumer review surfaces. For US retail-pharmacy stores, those surfaces do not carry the store as an entity: the major business-review directory (Yelp) lists businesses by corporate web domain — the brand as a whole — not by individual pharmacy location, and the leading travel-review directory (Tripadvisor) indexes hotels, restaurants, and attractions, not pharmacies. Neither lists these three stores as rateable entities, so there is no second-surface sentiment to compare against. This is a structural property of how those surfaces are organized; it held across every attempt in this engagement and is reported as a fixed boundary of the subject, not a gap to be pulled again.
• A canonical map-directory profile could not be resolved for the SF Downtown address. The address-keyed business-profile lookup returned no result for 789 Mission St, so that store was bound to its review stream by a brand-plus-address match rather than a directory profile record. The binding was confirmed by checking that the store's recomputed posture (3.06) matches its lifetime profile rating (3.1) — the streams line up — but the profile-record path itself did not resolve for this one address. The boundary is specific to the SF Downtown directory record, not to the review read.
• The broader web- and social-sentiment surface did not return a usable per-store read. A general web-sentiment pass would test whether the wider conversation about each store converges with its review stream. That pass did not return a per-store-attributable result in this engagement, so no broader-web sentiment is reported. We do not infer it from the review stream.
• Review base depth varies by store; SF Downtown is thin. SF Downtown's captured base (47 reviews) is materially smaller than Palo Alto's and Berkeley's (roughly 100 each), so its read is reported at medium confidence and its themes carry a smaller absolute count. The captured stream is each store's most recent reviews; the strict trailing-90-day slice is too sparse to characterize on its own, so the read is built on the captured recent stream and the lifetime rating it reproduces.

This is a single-surface sentiment audit on each store's public review stream, with each store bound to its own listing. The natural next step is the deeper engagement: (1) a quarter-over-quarter sentiment trend per store to see whether the pharmacy-counter complaints are improving or worsening; (2) an operational mapping of each recurring theme to a specific fix and owner; and (3) a competitor-pharmacy reputation read in each city to set the bar each store is being measured against. To commission it, reach the ForIntel desk directly at forintel@foragentis.com.

This is a public sample of a ForIntel Cross-Surface Sentiment Audit, published by Foragentis to demonstrate the method. CVS is a public company and its three Bay Area pharmacy locations are named as the subject of study; each store's ratings, posture, and complaint themes are bound to its own listing and counted from its own reviews. The Berkeley and Palo Alto reads are High confidence (re-checked on a second capture); SF Downtown rests on a thinner base (medium confidence). The cross-surface comparison is a structural boundary — the other consumer review surfaces do not list these retail-pharmacy stores as entities — and is carried as a named scope edge by design rather than presented as a multi-surface finding. Quotes are customer reviews; no individual is identified.