{"table":"Fact_Deals","schemaType":"STAR_SCHEMA_FACT","recordCount":5,"lastRefreshAEST":"2026-09-28T16:02:50.388Z","data":[{"deal_id":501,"person_id":1042,"person_name":"Lachlan Evans","phone_e164":"+61 412 839 201","deal_title":"Double-Storey Custom Build - Cottesloe Lot 14","deal_value_aud":485000,"stage":"SMS_QUALIFYING","assigned_sales_rep":"Liam K. (Senior Sales Consultant)","ai_conversation_state":"ACTIVE","lead_score":85,"intent_tier":"HOT","sms_consent_status":true,"last_activity_date":"2026-09-14 08:04"},{"deal_id":502,"person_id":1043,"person_name":"Sarah Jenkins","phone_e164":"+61 423 710 492","deal_title":"Coastal Modern Villa - Scarborough Beach Rd","deal_value_aud":360000,"stage":"NEW_INQUIRY","assigned_sales_rep":"Chloe T. (Design & Feasibility Rep)","ai_conversation_state":"ACTIVE","lead_score":62,"intent_tier":"WARM","sms_consent_status":true,"last_activity_date":"2026-09-14 07:30"},{"deal_id":503,"person_id":1044,"person_name":"Dean O'Connor","phone_e164":"+61 434 982 115","deal_title":"Multi-Unit Triplex Development - Subiaco","deal_value_aud":920000,"stage":"SALES_HANDOVER","assigned_sales_rep":"Shaun M. (Head of Growth - Perth)","ai_conversation_state":"HANDOVER_PENDING","lead_score":94,"intent_tier":"HOT","sms_consent_status":true,"last_activity_date":"2026-09-14 08:12"},{"deal_id":504,"person_id":1045,"person_name":"Jessica Taylor","phone_e164":"+61 405 621 884","deal_title":"Luxury Single Storey Renovation - Applecross","deal_value_aud":240000,"stage":"LOST","assigned_sales_rep":"Mark D. (Inbound Lead Qualifier)","ai_conversation_state":"OPTED_OUT","lead_score":28,"intent_tier":"COLD","sms_consent_status":false,"last_activity_date":"2026-09-14 07:42"},{"deal_id":505,"person_id":1046,"person_name":"Marcus Vance","phone_e164":"+61 419 330 771","deal_title":"Duplex Investment Package - Joondalup","deal_value_aud":620000,"stage":"CONSULTATION_BOOKED","assigned_sales_rep":"Liam K. (Senior Sales Consultant)","ai_conversation_state":"PAUSED_REP","lead_score":74,"intent_tier":"HOT","sms_consent_status":true,"last_activity_date":"2026-09-13 16:20"}]}