{"ok":true,"schema":"spotlight_command_center.v1","generated_at":"2026-05-12T19:45:10.922Z","window":{"start_date":"2026-04-12","end_date":"2026-05-12","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":784,"finished":396,"fill_rate":0.505,"no_response_signals":713,"rich_signal_count":0,"top_owner_need":{"theme":"Financial Accessibility and Cost Transparency","evidence_count":14,"confidence":"high","paraphrased_examples":["Owner indicated finances are constrained and cost of care is a concern at a recheck visit","Pet owner flagged limited budget ahead of a sick appointment involving skin and ear issues","Multiple owners across both sick and recheck visit types noted financial limitations in the same intake session as clinical symptom disclosures"]},"next_experiment":{"title":"Test owner-centered SMS reminder language","reason":"713 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 Accessibility and Cost Transparency","evidence_count":14,"confidence":"high","paraphrased_examples":["Owner indicated finances are constrained and cost of care is a concern at a recheck visit","Pet owner flagged limited budget ahead of a sick appointment involving skin and ear issues","Multiple owners across both sick and recheck visit types noted financial limitations in the same intake session as clinical symptom disclosures"]},{"theme":"Anxiety and Behavioral Management Support","evidence_count":28,"confidence":"high","paraphrased_examples":["Owner described pet as somewhat nervous ahead of a routine recheck for ear concerns","Pet flagged as very anxious with a note that calming medication may be needed prior to examination","Owner indicated pet can become reactive and requires special handling during sick visits"]},{"theme":"Home Treatment Difficulty and Medication Compliance","evidence_count":5,"confidence":"medium","paraphrased_examples":["Owner disclosed difficulty administering home treatments for a pet with widespread skin irritation","Owner of an anxious pet noted challenges with giving medications at home, flagging need for simpler or alternative delivery methods","Owner indicated pet has sensitive areas that complicate at-home care routines"]},{"theme":"Time Constraints Affecting Visit Scope","evidence_count":3,"confidence":"low","paraphrased_examples":["Owner noted limited availability at a recheck appointment alongside a tight budget disclosure","Time constraint flagged in conjunction with skin and paw-related recheck visit"]},{"theme":"Owner Uncertainty About Symptom Origin or Exposure","evidence_count":6,"confidence":"medium","paraphrased_examples":["Owner unsure of cause but disclosed possible environmental or contact exposure ahead of a GI sick visit","Owner indicated uncertainty about what triggered current symptoms while also noting possible toxic or infectious exposure","Owner selected 'not sure' for multiple intake questions, suggesting limited clinical observation confidence"]}]},"clinical_product_themes":{"themes":[{"theme":"Ear Disease (Otitis) — Recurring and Active","evidence_count":18,"confidence":"high","paraphrased_examples":["Ear discharge noted at both initial sick visit and follow-up recheck, suggesting ongoing or incompletely resolved otitis","Head shaking and ear scratching reported across multiple sick appointments, some paired with skin odor","Recent water exposure such as bathing or swimming reported prior to recheck for ear symptoms"]},{"theme":"Allergic and Inflammatory Skin Disease","evidence_count":22,"confidence":"high","paraphrased_examples":["Pet presented with itching, paw chewing, skin redness, and odor across multiple body regions including ears, back, tail base, and face","Owner reports licking and chewing of paws and skin alongside ear scratching, consistent with atopic pattern","Scabs and skin sores noted at sick visit with prior use of both OTC products and prescription medications"]},{"theme":"Gastrointestinal Illness — Acute Presentation","evidence_count":12,"confidence":"high","paraphrased_examples":["Vomiting and loose stool described together at sick visit, with stool consistency described as soft and shapeless","Owner reported nausea-like behaviors alongside vomiting and diarrhea at a sick appointment","Possible ingestion or infectious exposure noted concurrently with GI symptoms"]},{"theme":"Urinary Tract Dysfunction","evidence_count":7,"confidence":"medium","paraphrased_examples":["Owner reported combination of increased urination frequency, straining, blood-tinged urine, and stronger urine odor at a single sick visit","Increased water intake noted alongside urinary changes, raising suspicion for systemic or metabolic involvement","Indoor accidents and reduced urine output reported together, suggesting possible obstruction or infection"]},{"theme":"Ocular Signs — Discharge and Cloudiness","evidence_count":4,"confidence":"low","paraphrased_examples":["Owner noted visible cloudiness in one or both eyes at a sick appointment","Eye discharge reported alongside cloudiness at a separate sick visit, suggesting possible conjunctival or corneal involvement"]},{"theme":"Wound and Skin Trauma — Including Bite Injuries","evidence_count":6,"confidence":"medium","paraphrased_examples":["Open skin wound on the neck reported at a sick visit with owner having applied a bandage prior to arrival","Bite or fight wound described involving the head, face, and front limbs with open skin noted","Scab or crust on a paw pad reported at a recheck, with prior use of both OTC and veterinary pain medications"]},{"theme":"Oral Pain and Feeding Behavior Changes","evidence_count":2,"confidence":"low","paraphrased_examples":["Owner noted pet has shifted to soft food and is pawing at the mouth or face, suggesting oral discomfort","Facial pawing reported alongside food texture preference change at a sick appointment"]},{"theme":"Respiratory Signs — Cough","evidence_count":1,"confidence":"low","paraphrased_examples":["Coughing reported at a sick appointment without additional respiratory details provided in the intake"]}]},"form_behavior_map":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":1,"finished":0,"no_response":2,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Surgical Appointments","sent":1,"finished":0,"no_response":15,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Technician Appointments","sent":1,"finished":0,"no_response":45,"fill_rate":0,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":66,"finished":18,"no_response":49,"fill_rate":0.273,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":31,"finished":10,"no_response":21,"fill_rate":0.323,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":3,"finished":1,"no_response":2,"fill_rate":0.333,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":59,"finished":21,"no_response":39,"fill_rate":0.356,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":128,"finished":59,"no_response":71,"fill_rate":0.461,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":111,"finished":53,"no_response":58,"fill_rate":0.477,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":209,"finished":121,"no_response":102,"fill_rate":0.579,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":174,"finished":113,"no_response":62,"fill_rate":0.649,"friction_level":"high"},{"clinic":"Bryant Mobile Vet","appointment_type":"Emergency","sent":0,"finished":0,"no_response":37,"fill_rate":null,"friction_level":"high"}],"clinic_appointment_matrix":[{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":209,"finished":121,"fill_rate":0.579},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":174,"finished":113,"fill_rate":0.649},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":128,"finished":59,"fill_rate":0.461},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":111,"finished":53,"fill_rate":0.477},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":66,"finished":18,"fill_rate":0.273},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":59,"finished":21,"fill_rate":0.356},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":31,"finished":10,"fill_rate":0.323},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":3,"finished":1,"fill_rate":0.333},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":1,"finished":0,"fill_rate":0},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Surgical Appointments","sent":1,"finished":0,"fill_rate":0},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Technician Appointments","sent":1,"finished":0,"fill_rate":0}],"product_reliability":{"writeback_success_rate":0.823,"writeback_successful":326,"writeback_failed":70,"extras_usage":{"pet_images":188,"supplement_images":10,"audio_notes":3}},"experiment_board":[{"title":"Test owner-centered SMS reminder language","reason":"713 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 Recheck intake flow","reason":"Recheck has a 27% fill rate for Fort Mill Animal Hospital.","evidence":"Form behavior map","status":"read_only_candidate","metric":"Completion rate, time-to-submit, question-level dropoff"},{"title":"Turn \"Financial Accessibility and Cost Transparency\" into a practice-facing handoff","reason":"AI synthesis found 14 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 82%.","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":"713 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 Accessibility and Cost Transparency"},{"id":"hypothesis_2","hypothesis":"Simplify Recheck intake flow","why_it_might_matter":"Recheck has a 27% fill rate for Fort Mill Animal Hospital.","evidence_level":"directional","next_read_only_check":"Completion rate, time-to-submit, question-level dropoff","related_theme":"Financial Accessibility and Cost Transparency"},{"id":"hypothesis_3","hypothesis":"Turn \"Financial Accessibility and Cost Transparency\" into a practice-facing handoff","why_it_might_matter":"AI synthesis found 14 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 Accessibility and Cost Transparency"},{"id":"hypothesis_4","hypothesis":"Audit failed writebacks before product experiments","why_it_might_matter":"Writeback success is 82%.","evidence_level":"operational","next_read_only_check":"Writeback success rate","related_theme":"Financial Accessibility and Cost Transparency"}],"source_health":{"status":"live","errors":[],"sources":[{"key":"forms_activity","endpoint":"/api/admin/reports/forms-activity-summary","records":154,"read_only":true},{"key":"question_completion","endpoint":"/api/admin/reports/question-completion-summary","records":2201,"read_only":true},{"key":"form_response","endpoint":"/api/admin/reports/form-response","records":520,"read_only":true},{"key":"form_reminders_distribution","endpoint":"/api/admin/reports/form-reminders-distribution","records":484,"read_only":true},{"key":"feedback","endpoint":"/api/admin/reports/feedback","records":297,"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":123,"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":833,"read_only":true}],"last_refreshed_at":"2026-05-12T19:45:10.922Z","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."]}}