{"ok":true,"schema":"spotlight_command_center.v1","generated_at":"2026-07-10T20:00:50.182Z","window":{"start_date":"2026-06-10","end_date":"2026-07-10","primary_days":30},"access":{"audience":["Robert","Alie"],"access_boundary":"approved_spotlight_leadership_only","read_only":true,"writes_enabled":false,"aggregate_only":true},"evidence_board":{"sent":879,"finished":443,"fill_rate":0.504,"no_response_signals":730,"rich_signal_count":0,"top_owner_need":{"theme":"Financial Constraint Awareness","evidence_count":18,"confidence":"high","paraphrased_examples":["Owner indicated they are working within a tight financial budget when seeking care","Budget concerns noted alongside high-anxiety pet requiring special handling","Financial limitation flagged concurrently with ongoing prescription medication use"]},"next_experiment":{"title":"Test owner-centered SMS reminder language","reason":"730 no-response signals in the current window.","evidence":"No-response buckets and reminder distribution","status":"read_only_candidate","metric":"Fill rate and completed forms per reminder cohort"}},"owner_need_intelligence":{"themes":[{"theme":"Financial Constraint Awareness","evidence_count":18,"confidence":"high","paraphrased_examples":["Owner indicated they are working within a tight financial budget when seeking care","Budget concerns noted alongside high-anxiety pet requiring special handling","Financial limitation flagged concurrently with ongoing prescription medication use"]},{"theme":"Pet Anxiety and Stress Management at Clinic","evidence_count":22,"confidence":"high","paraphrased_examples":["Owner reported pet is mildly anxious heading into a sick visit","Pet flagged as very anxious, requiring calming medication prior to exam","Owner noted pet needs special handling due to elevated stress levels"]},{"theme":"Home Treatment Attempts Before Visiting Clinic","evidence_count":9,"confidence":"high","paraphrased_examples":["Owner applied an over-the-counter topical ointment to a skin wound before coming in","Wound area was cleaned at home prior to the appointment","Owner had already been using a medicated shampoo bath to manage skin symptoms"]},{"theme":"Uncertainty About Symptom Cause or Classification","evidence_count":21,"confidence":"high","paraphrased_examples":["Owner was unsure what triggered the current episode or which category best described symptoms","Multiple 'none of these' responses suggest owner could not identify a clear cause or exposure","Owner selected 'not sure' when asked about potential contributing factors"]},{"theme":"Time Pressure During Appointments","evidence_count":2,"confidence":"low","paraphrased_examples":["Owner indicated they have limited time available for the visit","Time constraint flagged alongside mild pet anxiety and urinary symptoms"]},{"theme":"Difficulty Administering Treatments at Home","evidence_count":1,"confidence":"low","paraphrased_examples":["Owner expressed difficulty giving the pet medications or treatments in the home environment"]},{"theme":"Grief or Life Disruption as a Contextual Factor","evidence_count":1,"confidence":"low","paraphrased_examples":["Owner noted a recent loss of a person or companion animal as a possible contextual stressor around the time symptoms began"]}]},"clinical_product_themes":{"themes":[{"theme":"Dermatological Conditions — Skin and Coat","evidence_count":28,"confidence":"high","paraphrased_examples":["Pet presenting with generalized itching, self-directed chewing, and redness across multiple body regions including paws, belly, and back","Skin findings include hair thinning, crusting, bumps, and a notable odor","Redness and scabbing localized to tail base and groin area"]},{"theme":"Ear Disease — Otitis and Recurrent Ear Issues","evidence_count":14,"confidence":"high","paraphrased_examples":["Pet showing persistent head shaking and ear scratching at a recheck appointment","Ear odor reported alongside active ear scratching during a sick visit","Owner already using a prescription ear medication when presenting for recheck"]},{"theme":"Gastrointestinal — Vomiting, Diarrhea, and Nausea","evidence_count":18,"confidence":"high","paraphrased_examples":["Pet experiencing very watery, mostly liquid diarrhea during a sick visit","Nausea signs observed along with vomiting and concurrent diarrhea","Stool described as loose cow-patty consistency with visible blood and mucus at a recheck"]},{"theme":"Wound and Trauma — Cuts, Bites, and Skin Injuries","evidence_count":8,"confidence":"high","paraphrased_examples":["Paw pad injury presenting as a scraped or raw wound with visible discharge","Bite or fight wound on a hind leg now showing a scab at recheck","Scab formation and discharge noted on the back during wound follow-up"]},{"theme":"Urinary Changes","evidence_count":3,"confidence":"moderate","paraphrased_examples":["Owner noted the pet is urinating noticeably less than normal","Changes in urination frequency or volume flagged during a sick visit","Reduced urine output described without an obvious identifiable cause"]},{"theme":"Respiratory — Coughing and Sneezing","evidence_count":2,"confidence":"moderate","paraphrased_examples":["Pet presenting with both active coughing and frequent sneezing episodes","Respiratory signs noted alongside mild owner-reported anxiety in the pet"]},{"theme":"Neurological — Seizure-Like Episode","evidence_count":1,"confidence":"low","paraphrased_examples":["Owner described an episode involving falling over, rigid body posture, repetitive limb movements, and drooling, consistent with a possible seizure event"]},{"theme":"Musculoskeletal — Limping or Stiffness","evidence_count":1,"confidence":"low","paraphrased_examples":["Pet observed limping or moving with noticeable stiffness at the time of the sick visit"]}]},"form_behavior_map":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":1,"finished":0,"no_response":3,"fill_rate":0,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech","sent":2,"finished":0,"no_response":3,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Wellness","sent":1,"finished":0,"no_response":5,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":63,"finished":21,"no_response":45,"fill_rate":0.333,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":23,"finished":8,"no_response":16,"fill_rate":0.348,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":68,"finished":24,"no_response":46,"fill_rate":0.353,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":119,"finished":52,"no_response":67,"fill_rate":0.437,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":167,"finished":74,"no_response":93,"fill_rate":0.443,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":6,"finished":3,"no_response":3,"fill_rate":0.5,"friction_level":"watch"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Orthopedic Consult","sent":2,"finished":1,"no_response":1,"fill_rate":0.5,"friction_level":"watch"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":212,"finished":119,"no_response":93,"fill_rate":0.561,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":215,"finished":141,"no_response":89,"fill_rate":0.656,"friction_level":"high"}],"clinic_appointment_matrix":[{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":215,"finished":141,"fill_rate":0.656},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":212,"finished":119,"fill_rate":0.561},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":167,"finished":74,"fill_rate":0.443},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":119,"finished":52,"fill_rate":0.437},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":68,"finished":24,"fill_rate":0.353},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":63,"finished":21,"fill_rate":0.333},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":23,"finished":8,"fill_rate":0.348},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":6,"finished":3,"fill_rate":0.5},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech","sent":2,"finished":0,"fill_rate":0},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Orthopedic Consult","sent":2,"finished":1,"fill_rate":0.5},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":1,"finished":0,"fill_rate":0},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Wellness","sent":1,"finished":0,"fill_rate":0}],"product_reliability":{"writeback_success_rate":0,"writeback_successful":0,"writeback_failed":443,"extras_usage":{"pet_images":212,"supplement_images":9,"audio_notes":0}},"experiment_board":[{"title":"Test owner-centered SMS reminder language","reason":"730 no-response signals in the current window.","evidence":"No-response buckets and reminder distribution","status":"read_only_candidate","metric":"Fill rate and completed forms per reminder cohort"},{"title":"Simplify Follow Up & Recheck Apts intake flow","reason":"Follow Up & Recheck Apts has a 33% fill rate for Northwood Veterinary Hospital.","evidence":"Form behavior map","status":"read_only_candidate","metric":"Completion rate, time-to-submit, question-level dropoff"},{"title":"Turn \"Financial Constraint Awareness\" into a practice-facing handoff","reason":"AI synthesis found 18 evidence points for this deeper owner need.","evidence":"AI-paraphrased owner need synthesis","status":"read_only_candidate","metric":"Practice usefulness rating and owner satisfaction follow-up"},{"title":"Audit failed writebacks before product experiments","reason":"Writeback success is 0%.","evidence":"Writeback success-rate report","status":"reliability_first","metric":"Writeback success rate"}],"hypothesis_drawer":[{"id":"hypothesis_1","hypothesis":"Test owner-centered SMS reminder language","why_it_might_matter":"730 no-response signals in the current window.","evidence_level":"directional","next_read_only_check":"Fill rate and completed forms per reminder cohort","related_theme":"Financial Constraint Awareness"},{"id":"hypothesis_2","hypothesis":"Simplify Follow Up & Recheck Apts intake flow","why_it_might_matter":"Follow Up & Recheck Apts has a 33% fill rate for Northwood Veterinary Hospital.","evidence_level":"directional","next_read_only_check":"Completion rate, time-to-submit, question-level dropoff","related_theme":"Financial Constraint Awareness"},{"id":"hypothesis_3","hypothesis":"Turn \"Financial Constraint Awareness\" into a practice-facing handoff","why_it_might_matter":"AI synthesis found 18 evidence points for this deeper owner need.","evidence_level":"directional","next_read_only_check":"Practice usefulness rating and owner satisfaction follow-up","related_theme":"Financial Constraint Awareness"},{"id":"hypothesis_4","hypothesis":"Audit failed writebacks before product experiments","why_it_might_matter":"Writeback success is 0%.","evidence_level":"operational","next_read_only_check":"Writeback success rate","related_theme":"Financial Constraint Awareness"}],"source_health":{"status":"live","errors":[],"sources":[{"key":"forms_activity","endpoint":"/api/admin/reports/forms-activity-summary","records":164,"read_only":true},{"key":"question_completion","endpoint":"/api/admin/reports/question-completion-summary","records":2363,"read_only":true},{"key":"form_response","endpoint":"/api/admin/reports/form-response","records":536,"read_only":true},{"key":"form_reminders_distribution","endpoint":"/api/admin/reports/form-reminders-distribution","records":480,"read_only":true},{"key":"feedback","endpoint":"/api/admin/reports/feedback","records":326,"read_only":true},{"key":"spotlight_extras_usage","endpoint":"/api/admin/reports/spotlight-extras-usage","records":8,"read_only":true},{"key":"writeback_success_rate","endpoint":"/api/admin/reports/writeback-success-rate","records":133,"read_only":true},{"key":"spotlight_appointment_coverage","endpoint":"/api/admin/reports/spotlight-appointment-coverage","records":76,"read_only":true},{"key":"spotlight_appointments","endpoint":"/api/admin/reports/spotlight-appointments","records":922,"read_only":true}],"last_refreshed_at":"2026-07-10T20:00:50.182Z","ai_synthesis":{"status":"live_ai","model":"claude-sonnet-4-6","pattern_matching":"ai_synthesis"}},"artifact_render_contract":{"renderer":"claude_artifact","default_view":"evidence_board","artifact_title":"Spotlight Command Center","visual_priority":["evidence_board","owner_need_intelligence","form_behavior_map","clinic_appointment_matrix","experiment_board"],"collapsed_by_default":["hypothesis_drawer"],"invariants":["Facts first; hypotheses hidden below the fold or behind a collapsed drawer.","No raw owner text, owner names, pet names, emails, phone numbers, or media URLs.","Read-only controls only. Do not expose mutation buttons.","Show source freshness, source errors, and AI synthesis status plainly.","Use the packet as the full artifact data source; do not fetch browser-side credentials."]}}