Why did we lose the customers we lost, and who looks like them now?

Asked: Why did we lose the customers we lost, and who looks like them now?

Saved: Sat 24 Oct 2026, 15:06 UTC

Figures as at: 2026-10-09

Table q: 4 rows from select lost_reason, sum(arr_lost) as arr_lost from (with lost as (select org_id, org_name, month_end, arr_bf as arr_lost from chat.arr_moves where type = 'lost'), d as (select org_id, lost_reason, close_date, row_number() over (partition by org_id order by close_date desc) as rn from chat.deals where stage = 'closed_lost' and deal_type = 'renewal') select l.org_id, l.org_name, l.month_end, l.arr_lost, coalesce(d.lost_reason, 'not recorded') as lost_reason from lost l left join d on d.org_id = l.org_id and d.rn = 1) group by lost_reason order by lost_reason LIMIT 1000

This view was drawn for a chat answer and is read-only. Click a mark to filter the others, use the slicers, open the rows behind any chart or download them as CSV.