Tracking the 2026–27 school year from day one, live.

The district's own Earned Media ROI one-pager values its 19 confirmed TV/print stories at a combined $141,000 (reach × local-news CPM × a 3× credibility premium). Dividing that: $141,000 ÷ 19 = $7,421 average value per verified outlet story. This tab applies that same average to every site's own verified outlet-story count.

• This is circular by design, not hidden. Granite Bay's 19 outlet stories land at almost exactly $141,000 because that average was derived from a 19-story, $141,000 baseline in the first place — that's expected, not a coincidence to read into.
• Read $898K as a ceiling, not a point estimate — this is the most important caveat on the page. The Aug 17 broadcast sweep took verified outlet stories from 68 to 121, and most of the additions are short Friday Gameday and Game of the Week highlight reels. A 90-second flag-football highlight is not worth the same as a full KCRA news feature, but the flat $7,421 average values them identically. A rough sanity check: if the ~40 highlight-reel segments are discounted to a quarter of a feature's value, the total lands near $880K — still a large increase over the prior $488K, and a more defensible number to cite.
• The earlier Nielsen station-weighting still holds directionally. Using Sacramento DMA audience data (Adults 25-54, Final Overnights 12/30/24–12/28/25), KCRA's early-news audience runs 2.05× the local four-station average, CBS13 0.89×, FOX40 0.63×, ABC10 0.43×. That weighting isn't re-applied to the expanded set here because the new items are mostly short-form and station-mixed; the practical takeaway is unchanged — a KCRA feature is worth roughly twice an average placement.
• Print/digital stories still use the flat $7,421 average — Nielsen only measures broadcast, so there's no equivalent audience data to weight a Sacramento Bee or Gold Mountain CA News article by.
• Award/recognition records and self-published items are excluded from the dollar row — they're real and counted in "Total verified items," but they didn't earn independent press pickup, so there's no reach/CPM basis to value them the same way.
• Social follower counts aren't part of this estimate at all. Valuing social reach requires per-post view/reach data that only exists inside Meta Business Suite — still not accessible here. Followers are shown as the best available public proxy, not folded into the dollar figure.

Per the "positive only" brief, the research excluded: safety/lockdown incidents, a gender-policy dispute story, boundary-change controversy framing, graduation-relocation backlash coverage, and any CIF loss framed primarily as a loss. A few leads were dropped entirely rather than risk misattribution — an unverifiable West Park state-championship claim, an Adult School citizenship-milestone story with no confirmable source link, and an AVID-recognition hit that turned out to reference a different "Roseville" district in Minnesota.

The Press Coverage and ROI by Site tabs reflect a second, deeper pass run per school — broadened lookback to Jan 2023–Aug 2026, added CIF Sac-Joaquin official results, MaxPreps, Cal-Hi Sports, Lenaea/CHSSA award records, and CDE state recognitions on top of the original outlet sweep. That pass added 29 items to the original 55 (84 total) and turned Roseville Pathways from zero coverage to a genuine state-level honor. Every agent flagged its own search-budget limits — a few threads (Lincoln HS news, additional DECA/robotics/alumni angles) are marked as needing a further follow-up pass rather than reported as "nothing exists."

• RJUHSD Law Enforcement Social Media Monitor — an hourly cloud routine checking Roseville PD, Sacramento County Sheriff, and Placer County Sheriff's public social accounts for any mention of an RJUHSD site, positive or otherwise (this one intentionally does not filter to positive-only — it's safety monitoring, not a press digest).
• RJUHSD News & Outlet Monitor — runs hourly, checks RSS feeds for 5 outlets first (FOX40, ABC10, Sacramento Bee, Roseville Today, Placer Sentinel — faster and more reliable than search), then falls back to keyword search for outlets with no feed (KCRA, CBS13, Gold Mountain CA News). Also comprehensive, not positive-filtered — email alerts fire on anything new, with safety/reputational items flagged first.
• Both routines only touch public web content — no logins, no Meta Business Suite access, no personal data collection — and both are snapshot checks with real detection lag (likely an hour or more), not real-time feeds.

A dedicated accuracy and completeness check: 5 parallel agents re-swept every RJUHSD site plus the district for anything published Aug 14–17 across all tracked outlets and each outlet's own social accounts, and a 6th agent spot-checked 24 of the 85 press links (roughly 1 in 4) against their actual page content.

• Genuinely nothing new in that 3-day window — confirmed independently by all 5 agents, not a search failure. Fall sports don't start until Aug 28, which explains the quiet stretch for most sites.
• 24/24 sampled links resolve and substantively match their claims. No dead links, no fabrications. 5 items had minor wording overreach — a date stated more precisely than the source confirmed, a dollar figure that couldn't be re-verified, an award name only visible in a headline not the body — all corrected in place and marked with a note.
• One real find: Roseville Adult School posted a new "Certified Water Systems Operator" program story on its own site Aug 14 — added as a district release; the exact article URL couldn't be confirmed, so the link points to the school's news listing instead of guessing a slug.
• RSS feeds discovered and verified live for FOX40 (education-specific), ABC10, Sacramento Bee, Roseville Today, and Placer Sentinel — now wired into the hourly monitor as the primary check, ahead of search. KCRA, CBS13, and Gold Mountain CA News have no usable feed and still rely on search.
• Confirmed outlet social handles for CBS13, ABC10, FOX40, and Sacramento Bee across all three platforms. KCRA's site blocks this session's fetch tools entirely — its handles are search-corroborated only. Gold Mountain CA News has no unified account; its legacy Roseville Press-Tribune handle is the closer substitute.

Prompted by a single missing segment — Good Day Sacramento's West Park girls flag football story — a targeted broadcast-only sweep found that TV coverage had been systematically under-counted across every site. Verified press items went from 85 to 135; verified broadcast segments went from 28 to 81. The gap was not random.

• Why it was missed: the station websites (kcra.com, abc10.com, fox40.com) block automated reading, so earlier passes relied on general search, which under-indexes TV video. The unlock was querying YouTube channels directly and mining the Wayback Machine's CDX index for archived station URLs, then verifying each one live. That method found segments plain search never surfaced.
• The district's own log is the other half of the problem. RJUHSD's Media Coverage page holds 30 items (not the 36 previously recorded) and has not been updated since roughly May 2026 — which is exactly why the July 2026 flag football segment is absent from it. It also carries one structurally broken entry (the Sierra College item has no link at all), one item that survives only as a Google Drive file, and three filed under a broadcaster but linking to YouTube.
• Granite Bay is the only campus with its own "In the News" page, and its 10 items have never been absorbed into the district-level log. The other seven sites have no media-coverage page; four have a "News & Media" section that carries only student-produced media.
• Good Day Sacramento runs a recurring franchise at our campuses — Friday Gameday visits, first-day-of-school remotes, program features. This is a standing, predictable booking opportunity rather than occasional luck.
• Spanish-language TV has covered RJUHSD and was a complete blind spot — six segments across Univision 19 and Telemundo 33. Every Telemundo hit is crisis coverage with no proactive story to balance it, and Telemundo names the district in print as "El Distrito Escolar Unificado de Roseville," an entity that does not exist. Supplying correct Spanish-language boilerplate is a cheap fix.
• Two things I got wrong and corrected: I had published a Sierra College dual-enrollment link that was never verified — the district's page has no link there at all. I removed it as fabricated, then a later pass located the real segment, so it is now restored with a verified URL. Separately, the "Awesome Culinary Program" segment never names a school on air; it is Oakmont, confirmed through Oakmont's own Facebook post.
• The reposted-segment archive doesn't exist. The district's published YouTube URL (youtube.com/user/RJUHSDNews) returns a hard 404 while still being listed on two district pages. The only active district-adjacent channel posts board meetings. Reviving it to host segments with station permission would create the durable per-school asset this dashboard has been approximating.

Cataloguing 180+ broadcast assets revealed something more useful than a bigger number: stations already have standing franchises that visit our campuses on a predictable schedule, and they are visiting some sites repeatedly while never visiting others. These are not cold pitches — they are established relationships with an uneven distribution.

• Good Day Sacramento broadcast its entire morning show live from Woodcreek on Nov 17, 2023 — five to six segments across one morning, covering the football team, the Commercial Music Production program, cheer, and the cast of Grease. That is the proven template for what a campus remote looks like.
• West Park has never hosted one. This was verified rather than assumed — nine different slug variants were probed against the CBS archive and all returned genuine 404s. The station that has covered West Park cheer, flag football, stunt team and student photographers has never been invited for a morning remote.
• ABC10's Mark S. Allen has visited Woodcreek five or more times and West Park zero times. He is the single warmest recurring positive-coverage relationship in the file, and half the district has no contact with him.
• Woodcreek's 2025 section championship drew ABC10 and CBS but zero KCRA or FOX40. West Park's first-ever state cheer title drew Good Day Sacramento alone. Championship moments are being under-pitched even when they happen.
• Real stories that got no broadcast coverage at all: TEDxWoodcreek, Woodcreek's volleyball state final run, West Park's highest-graduation-rate-in-South-Placer distinction, and the Niko Dockery wrestling story (ABC10 ran an article, no video). Each is a segment that didn't happen.
• Named contacts worth keeping warm: KCRA's Melanie Wingo personally posts RJUHSD live shots to her own channel — segments that exist nowhere on kcra.com. That is a reporter actively invested in this district.

• 1. Connect Meta Business Suite exports per school Page/Profile — views, reach, interactions — refreshed monthly, to fill in the RJUHSD Schools tab.
• 2. Stand up a media log (spreadsheet or CRM) tagging every TV/print/digital hit by site and outlet, so earned-media totals can be sliced per school.
• 3. Set a refresh cadence — monthly pulls keep this dashboard current without manual rebuilds each time.
• 4. Decide scope on Placer County — confirm which neighboring districts/schools are worth tracking and whether public data (Google Alerts, public page stats) is sufficient or a paid monitoring tool (e.g. Muck Rack, Meltwater) is warranted.