← Listing Legends

Team Pulse Digest

Status
done
Tier
Tier 1 — Operating business
Owner
Ryan Colston
Started
2026-04-21
Target launch
2026-04-21

Two weekly email digests (Tue + Fri 8 AM CT) replacing daily Sheet checks for goals, reflections, missing submissions, stale listings, and off-pace agents. Routes on pos-reports Cloud Run.

Why

Daily check-ins on a Google Sheet drift fast and don't show patterns. The team accumulates signal across the week — who set goals, who reflected, whose listings are stale, who's off-pace mid-week. Two emails replace daily Sheet visits with structured rollups Ry can read in under two minutes.

Tuesday is a kickoff (last week's reflections + new commitments). Friday is a pace check (off-pace alert + on-pace + no-commitment + missing reflections + stale listings). All numbers computed in BigQuery SQL using DATE_TRUNC(CURRENT_DATE('America/Chicago'), WEEK(MONDAY)) to avoid the UTC datetime.weekday() bug.

Current state

Shipped 2026-04-21. Two routes on pos-reports Cloud Run service (not standalone CFs — repo mid-migration). Schedulers pos-reports-team-pulse-week-kickoff (Tue 8 AM CT) and pos-reports-team-pulse-pace-check (Fri 8 AM CT). Recipient: ry@rycolston.com. Wrapped in ExecutionLogger for monitoring dashboard.

First real Tuesday send 2026-04-27. First real Friday send 2026-05-01.

Next 3 actions

  1. Watch the first 2-week cycle (4/27 - 5/9) for false positives in pace-check buckets.
  2. Decide if the SOI-only agent tagging is worth building (currently those agents land in "No Commitment" — flagged future work).
  3. Phase 2: add UC + closings columns to pace check once weekly actuals exist in agent_hub.

Decisions log

Open issues

References