{"ok":true,"schema":"spotlight_command_center.v1","generated_at":"2026-11-05T21:00:03.764Z","window":{"start_date":"2026-10-06","end_date":"2026-11-05","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":218,"finished":102,"fill_rate":0.468,"no_response_signals":357,"rich_signal_count":0,"top_owner_need":{"theme":"Visit stress and handling confidence","evidence_count":27,"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":"357 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":27,"confidence":"directional","paraphrased_examples":["Owners want the practice to understand handling needs before the visit starts."]},{"theme":"Cost clarity and decision confidence","evidence_count":11,"confidence":"directional","paraphrased_examples":["Owners are trying to make care decisions with clearer financial context."]},{"theme":"Medication, diet, and home-care uncertainty","evidence_count":32,"confidence":"directional","paraphrased_examples":["Owners describe home-care uncertainty that may not fit neatly in appointment notes."]},{"theme":"Convenience and communication expectations","evidence_count":1,"confidence":"exploratory","paraphrased_examples":["Owners are signaling preferences around reminders, scheduling, and follow-up."]}]},"clinical_product_themes":{"themes":[{"theme":"Visit stress and handling confidence surfaced during clinical intake","evidence_count":27,"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":11,"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":32,"confidence":"directional","paraphrased_examples":["Owners describe home-care uncertainty that may not fit neatly in appointment notes."]},{"theme":"Convenience and communication expectations surfaced during clinical intake","evidence_count":1,"confidence":"exploratory","paraphrased_examples":["Owners are signaling preferences around reminders, scheduling, and follow-up."]}]},"form_behavior_map":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":58,"finished":16,"no_response":42,"fill_rate":0.276,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":73,"finished":36,"no_response":37,"fill_rate":0.493,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":87,"finished":50,"no_response":37,"fill_rate":0.575,"friction_level":"high"},{"clinic":"Bryant Mobile Vet","appointment_type":"Emergency","sent":0,"finished":0,"no_response":18,"fill_rate":null,"friction_level":"high"},{"clinic":"Bryant Mobile Vet","appointment_type":"House Call Feline","sent":0,"finished":0,"no_response":1,"fill_rate":null,"friction_level":"watch"},{"clinic":"Bryant Mobile Vet","appointment_type":"Robin Work Task","sent":0,"finished":0,"no_response":2,"fill_rate":null,"friction_level":"watch"},{"clinic":"Bryant Mobile Vet","appointment_type":"Surgical","sent":0,"finished":0,"no_response":2,"fill_rate":null,"friction_level":"watch"},{"clinic":"Bryant Mobile Vet","appointment_type":"unavailable- personal appointment","sent":0,"finished":0,"no_response":1,"fill_rate":null,"friction_level":"watch"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Unknown type","sent":0,"finished":0,"no_response":36,"fill_rate":null,"friction_level":"high"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Surgery Appt.","sent":0,"finished":0,"no_response":1,"fill_rate":null,"friction_level":"watch"},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Tech Appt.","sent":0,"finished":0,"no_response":1,"fill_rate":null,"friction_level":"watch"},{"clinic":"Northwood Veterinary Hospital","appointment_type":"Unknown type","sent":0,"finished":0,"no_response":104,"fill_rate":null,"friction_level":"high"}],"clinic_appointment_matrix":[{"clinic":"Fort Mill Animal Hospital","appointment_type":"Wellness","sent":87,"finished":50,"fill_rate":0.575},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Sick Appt.","sent":73,"finished":36,"fill_rate":0.493},{"clinic":"Fort Mill Animal Hospital","appointment_type":"Recheck","sent":58,"finished":16,"fill_rate":0.276}],"product_reliability":{"writeback_success_rate":0.157,"writeback_successful":16,"writeback_failed":86,"extras_usage":{"pet_images":233,"supplement_images":2,"audio_notes":0}},"experiment_board":[{"title":"Test owner-centered SMS reminder language","reason":"357 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 28% 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 \"Visit stress and handling confidence\" into a practice-facing handoff","reason":"AI synthesis found 27 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 16%.","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":"357 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 Recheck intake flow","why_it_might_matter":"Recheck has a 28% fill rate for Fort Mill Animal 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 27 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 16%.","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":50,"read_only":true},{"key":"question_completion","endpoint":"/api/admin/reports/question-completion-summary","records":761,"read_only":true},{"key":"form_response","endpoint":"/api/admin/reports/form-response","records":220,"read_only":true},{"key":"form_reminders_distribution","endpoint":"/api/admin/reports/form-reminders-distribution","records":209,"read_only":true},{"key":"feedback","endpoint":"/api/admin/reports/feedback","records":64,"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":40,"read_only":true},{"key":"spotlight_appointment_coverage","endpoint":"/api/admin/reports/spotlight-appointment-coverage","records":55,"read_only":true},{"key":"spotlight_appointments","endpoint":"/api/admin/reports/spotlight-appointments","records":227,"read_only":true}],"last_refreshed_at":"2026-11-05T21:00:03.764Z","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."]}}