{"as_of":"2026-06-16","scope":"2026 year-to-date, auto-case focus","kpis":{"auto_wanted_leads":678,"auto_signed":644,"auto_lost":34,"auto_conversion_pct":95.0,"leads_ytd_all_intakes":2568,"signed_cases_ytd_all_case_types":681,"total_marketing_spend_ytd":781692,"ad_spend_only_ytd":483213,"sponsorship_spend_ytd":163841,"production_plus_mgmt_ytd":134637,"firm_net_attorney_fees_ytd":8290316,"marketing_attributed_net_fees_ytd":2184009,"return_on_marketing_spend_x":2.8,"spend_2024_total":1663236,"spend_2025_total":2499021,"spend_2026_ytd":781692,"yoy_same_period_pct":-35.0,"louisville_marketing_spend":46864,"lexington_marketing_spend":20081,"lou_attributed_fees":255603,"lex_attributed_fees":374588,"lex_market_fees_859_606":86500,"lex_roi_x":6.9,"lex_cost_per_marketing_case":839,"broadcast_total_ytd":288846,"tv_networks_ytd":257536,"radio_ytd":23144,"ott_ctv_ytd":8166,"lex_859_606_active":53,"lex_859_606_ytd_signed":35,"lex_859_606_total_fees":486518,"spanish_active":37,"spanish_signed_2026":26,"spanish_recent_settled_fees":283748,"spanish_avg_fee_paid":7959,"trucking_active":65,"trucking_signed_2026":25,"trucking_a_plus_or_a_active":48,"trucking_recent_fees_total":1614805,"counties_active":139,"phone_inbound_30d":1590,"phone_answered_pct":100.0,"phone_missed":0,"mtd_auto_signed":65,"mtd_auto_conversion_pct":96.8,"r30_auto_signed":135,"r30_auto_conversion_pct":96.9,"google_ads_spend_ytd":28625,"google_ads_signed_ytd":9,"google_ads_cost_per_signed":3181,"lsa_louisville_leads":107,"lsa_louisville_signed":20,"lsa_louisville_conversion_pct":18.7,"lsa_louisville_spend":21865,"lsa_louisville_cost_per_signed":1093,"lsa_lexington_leads":90,"lsa_lexington_signed":23,"lsa_lexington_conversion_pct":25.6,"lsa_lexington_spend":12354,"lsa_lexington_cost_per_signed":537,"television_leads":287,"television_signed":50,"television_conversion_pct":17.4,"television_spend":283061,"television_cost_per_signed":5661,"billboard_leads":82,"billboard_signed":20,"billboard_conversion_pct":24.4,"billboard_spend":169832,"billboard_cost_per_signed":8492,"google_ads_spend_30d":21922.28,"google_ads_conversions_30d":78.0,"google_ads_cpa_30d":281.05},"headline_kpis":{"auto_wanted_leads":570,"auto_signed":542,"auto_lost":28,"auto_conversion_pct":95.1,"total_marketing_spend_ytd":768659,"ad_spend_only_ytd":483441,"firm_net_attorney_fees_ytd":7434000,"marketing_attributed_net_fees_ytd":1872095,"return_on_marketing_spend":"2.4x (1.87M / 768.7K total) — 3.9x vs ad spend only","leads_ytd_all_intakes":2104,"signed_cases_ytd_all_case_types":572},"month_to_date_auto":{"window":"May 1 - May 22, 2026","signed":90,"lost":3,"conversion_pct":96.8},"rolling_30_days_auto":{"signed":124,"lost":4,"conversion_pct":96.9},"fees_by_source_2026_ytd":{"Word of Mouth":2252166,"Attorney Referral":2115966,"Employee (Attorney)":553901,"Television Ads":439960,"Returning Client":423840,"SEO":401533,"Google LSA (Lexington)":335825,"Billboard Ads":290968,"Employee (Non Attorney)":238625,"Google LSA (Louisville)":188519,"Social Media":84342,"Google Ads":68050,"AI Chatbot":24399},"spend_2026_ytd":{"total":768659,"by_type":{"Advertising":483441,"Sponsorship":150580,"Production_Cost":76524,"Management_Fee":58113},"by_month":{"Jan":229510,"Feb":203588,"Mar":221569,"Apr":82614,"May":31378},"yoy_totals":{"2024":1663236,"2025":2499022,"2026_YTD":768659}},"sponsorship_breakdown_2026_ytd":{"_total":150580,"NIL_marketing":65000,"Learfield_NOT_marketing":71556,"Community_sponsorships":9025,"Donations_NOT_marketing":5000},"social_media_breakdown_2026_ytd":{"_total":47121,"Organic_Social_Louisville_Claudia":24999,"Organic_Social_Lexington_Rose":7500,"Meta_Ads_standalone":6688,"Reddit_Ads_standalone":7934},"referrals_yoy":{"_note":"Total referrals OUT created per year (litify_pm__Referral__c count, all statuses). Accepted/settled split requires Status field query — pending.","2024":830,"2025":810,"2026_ytd":364},"counties_rollup_r365":{"_note":"Signed matters last 365 days rolled from client ZIP to county. Excludes Jefferson (Louisville) and Fayette (Lexington). Top counties only.","ky_non_lou_non_lex":{"Bullitt":{"signed":66,"top_zips":["40165","40047"]},"Hardin":{"signed":21,"top_zips":["42701","40160"]},"Shelby":{"signed":16,"top_zips":["40065"]},"Nelson":{"signed":12,"top_zips":["40004"]},"Oldham":{"signed":12,"top_zips":["40014","40031"]},"Bourbon":{"signed":8,"top_zips":["40361"]},"Jessamine":{"signed":6,"top_zips":["40356"]},"Madison":{"signed":6,"top_zips":["40403"]}},"southern_indiana":{"Clark":{"signed":56,"top_zips":["47130","47129","47111","47172"]},"Floyd":{"signed":17,"top_zips":["47150","47112"]}}},"open_data_quality_items":["Sponsorship attribution: $150,580 YTD shows zero source-attributed cases","Spend Category field is unused — see Marketing Spend Entry SOP","Primary Language ~17% populated — Spanish counts are a floor","CallRail excludes main-line calls","AI Chatbot source captures channel not upstream origin","Client ZIP lives in Account Billing Postal Code — should be residential","Meta Ads and Reddit Ads currently lumped under Social Media source — should be standalone","Claudia Fiorello and Rose Clemons tagged as Social Media source — should be Organic Social (Louisville/Lexington)"],"links":{"dashboard":"https://sail-wiki.onrender.com/marketing-center.html","marketing_spend_entry_sop":"https://sail-wiki.onrender.com/marketing-spend-entry-sop/"},"_sources":{"auto_signed":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","auto_lost":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Intake__c/list","auto_wanted_leads":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Intake__c/list","auto_conversion_pct":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Intake__c/list","mtd_auto_signed":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","r30_auto_signed":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","signed_cases_ytd_all_case_types":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","leads_ytd_all_intakes":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Intake__c/list","trucking_signed_2026":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","trucking_active":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","trucking_a_plus_or_a_active":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","trucking_recent_fees_total":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","spanish_signed_2026":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","spanish_active":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","spanish_recent_settled_fees":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","lex_859_606_active":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","lex_859_606_ytd_signed":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","lex_859_606_total_fees":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","lex_attributed_fees":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","lou_attributed_fees":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","counties_active":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","firm_net_attorney_fees_ytd":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","marketing_attributed_net_fees_ytd":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Matter__c/list","total_marketing_spend_ytd":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/Marketing_Expense__c/list","ad_spend_only_ytd":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/Marketing_Expense__c/list","sponsorship_spend_ytd":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/Marketing_Expense__c/list","referrals_out_yoy":"https://samaguiarinjurylawyers2.my.salesforce.com/lightning/o/litify_pm__Referral__c/list"},"_sf_instance":"https://samaguiarinjurylawyers2.my.salesforce.com","_litify_payload":{"url":"https://sail-marketing-dashboard.onrender.com/data/marketing.json","generated_at":"2026-06-16T11:49:22+00:00","scope":"2025-01-01 onward (event-date based)","window":"2026","updated_keys":["billboard_conversion_pct","billboard_cost_per_signed","billboard_leads","billboard_signed","billboard_spend","google_ads_cost_per_signed","google_ads_signed_ytd","google_ads_spend_ytd","leads_ytd_all_intakes","lex_859_606_ytd_signed","lsa_lexington_conversion_pct","lsa_lexington_cost_per_signed","lsa_lexington_leads","lsa_lexington_signed","lsa_lexington_spend","lsa_louisville_conversion_pct","lsa_louisville_cost_per_signed","lsa_louisville_leads","lsa_louisville_signed","lsa_louisville_spend","signed_cases_ytd_all_case_types","spanish_signed_2026","spend_2026_ytd","television_conversion_pct","television_cost_per_signed","television_leads","television_signed","television_spend","total_marketing_spend_ytd","trucking_signed_2026"],"carried_forward_note":"Some legacy Marketing Center KPIs remain from data_snapshot.json until the dashboard payload exposes matching fields."},"_freshness":{"data_as_of":"2026-06-16","generated_at":"2026-06-16T11:49:22Z","snapshot_age_hours":11.04,"stale":false,"stale_after_hours":24.0},"_litify_live":true,"_connectors":{"google_ads":{"configured":true,"via":"notfair","live":true,"last_30d_spend":21922.28,"last_30d_conversions":78.0,"last_30d_cpa":281.05,"campaign_rows":19,"total_rows_seen":19,"truncated":false,"scope":"LAST_30_DAYS via NotFair, non-LSA campaigns only"}},"_served_at":"2026-06-16T22:52:02Z","_spend_2025_same_period":1211579,"_refreshed_at":"2026-06-16T22:52:08Z","_refresh_errors":{}}