{"ok":true,"schema":"spotlight_command_center.v1","generated_at":"2026-09-07T20:15:00.462Z","window":{"start_date":"2026-08-08","end_date":"2026-09-07","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":362,"finished":160,"fill_rate":0.442,"no_response_signals":482,"rich_signal_count":0,"top_owner_need":{"theme":"Visit stress and handling confidence","evidence_count":21,"confidence":"directional","paraphrased_examples":["Owners want the practice to understand handling needs before the visit starts."]},"next_experiment":{"title":"Test owner-centered SMS reminder language","reason":"482 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":"Visit stress and handling confidence","evidence_count":21,"confidence":"directional","paraphrased_examples":["Owners want the practice to understand handling needs before the visit starts."]},{"theme":"Cost clarity and decision confidence","evidence_count":16,"confidence":"directional","paraphrased_examples":["Owners are trying to make care decisions with clearer financial context."]},{"theme":"Medication, diet, and home-care uncertainty","evidence_count":34,"confidence":"directional","paraphrased_examples":["Owners describe home-care uncertainty that may not fit neatly in appointment notes."]}]},"clinical_product_themes":{"themes":[{"theme":"Visit stress and handling confidence surfaced during clinical intake","evidence_count":21,"confidence":"directional","paraphrased_examples":["Owners want the practice to understand handling needs before the visit starts."]},{"theme":"Cost clarity and decision confidence surfaced during clinical intake","evidence_count":16,"confidence":"directional","paraphrased_examples":["Owners are trying to make care decisions with clearer financial context."]},{"theme":"Medication, diet, and home-care uncertainty surfaced during clinical intake","evidence_count":34,"confidence":"directional","paraphrased_examples":["Owners describe home-care uncertainty that may not fit neatly in appointment notes."]}]},"form_behavior_map":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Euthanasia","sent":1,"finished":0,"no_response":1,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":2,"finished":0,"no_response":2,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":4,"finished":0,"no_response":19,"fill_rate":0,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":9,"finished":1,"no_response":15,"fill_rate":0.111,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":28,"finished":9,"no_response":39,"fill_rate":0.321,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":82,"finished":29,"no_response":54,"fill_rate":0.354,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":105,"finished":46,"no_response":60,"fill_rate":0.438,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":2,"finished":1,"no_response":2,"fill_rate":0.5,"friction_level":"watch"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":128,"finished":73,"no_response":55,"fill_rate":0.57,"friction_level":"high"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":1,"finished":1,"no_response":5,"fill_rate":1,"friction_level":"watch"},{"clinic":"Bryant Mobile Vet","appointment_type":"Emergency","sent":0,"finished":0,"no_response":30,"fill_rate":null,"friction_level":"high"},{"clinic":"Bryant Mobile Vet","appointment_type":"House Call Canine","sent":0,"finished":0,"no_response":13,"fill_rate":null,"friction_level":"high"}],"clinic_appointment_matrix":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":128,"finished":73,"fill_rate":0.57},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":105,"finished":46,"fill_rate":0.438},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":82,"finished":29,"fill_rate":0.354},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Wellness","sent":28,"finished":9,"fill_rate":0.321},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Follow Up & Recheck Apts","sent":9,"finished":1,"fill_rate":0.111},{"clinic":"Northwood Veterinary Hospital","appointment_type":"sick appointments","sent":4,"finished":0,"fill_rate":0},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":2,"finished":1,"fill_rate":0.5},{"clinic":"Northwood Veterinary Hospital","appointment_type":"New Client/Patient Sick","sent":2,"finished":0,"fill_rate":0},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Euthanasia","sent":1,"finished":0,"fill_rate":0},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Drop Off Appointments","sent":1,"finished":1,"fill_rate":1}],"product_reliability":{"writeback_success_rate":0,"writeback_successful":0,"writeback_failed":160,"extras_usage":{"pet_images":225,"supplement_images":3,"audio_notes":0}},"experiment_board":[{"title":"Test owner-centered SMS reminder language","reason":"482 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 sick appointments intake flow","reason":"sick appointments has a 0% 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 \"Visit stress and handling confidence\" into a practice-facing handoff","reason":"AI synthesis found 21 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":"482 no-response signals in the current window.","evidence_level":"directional","next_read_only_check":"Fill rate and completed forms per reminder cohort","related_theme":"Visit stress and handling confidence"},{"id":"hypothesis_2","hypothesis":"Simplify sick appointments intake flow","why_it_might_matter":"sick appointments has a 0% fill rate for Northwood Veterinary Hospital.","evidence_level":"directional","next_read_only_check":"Completion rate, time-to-submit, question-level dropoff","related_theme":"Visit stress and handling confidence"},{"id":"hypothesis_3","hypothesis":"Turn \"Visit stress and handling confidence\" into a practice-facing handoff","why_it_might_matter":"AI synthesis found 21 evidence points for this deeper owner need.","evidence_level":"directional","next_read_only_check":"Practice usefulness rating and owner satisfaction follow-up","related_theme":"Visit stress and handling confidence"},{"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":"Visit stress and handling confidence"}],"source_health":{"status":"live","errors":[],"sources":[{"key":"forms_activity","endpoint":"/api/admin/reports/forms-activity-summary","records":81,"read_only":true},{"key":"question_completion","endpoint":"/api/admin/reports/question-completion-summary","records":1147,"read_only":true},{"key":"form_response","endpoint":"/api/admin/reports/form-response","records":330,"read_only":true},{"key":"form_reminders_distribution","endpoint":"/api/admin/reports/form-reminders-distribution","records":310,"read_only":true},{"key":"feedback","endpoint":"/api/admin/reports/feedback","records":111,"read_only":true},{"key":"spotlight_extras_usage","endpoint":"/api/admin/reports/spotlight-extras-usage","records":9,"read_only":true},{"key":"writeback_success_rate","endpoint":"/api/admin/reports/writeback-success-rate","records":63,"read_only":true},{"key":"spotlight_appointment_coverage","endpoint":"/api/admin/reports/spotlight-appointment-coverage","records":90,"read_only":true},{"key":"spotlight_appointments","endpoint":"/api/admin/reports/spotlight-appointments","records":335,"read_only":true}],"last_refreshed_at":"2026-09-07T20:15:00.462Z","ai_synthesis":{"status":"ai_error_fallback","model":"claude-sonnet-4-6","pattern_matching":"deterministic_fallback","error":"Anthropic synthesis failed: 401"}},"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."]}}