ระบบ Sales
Intelligence
เต็มรูปแบบ

// คำนวณ RFM Score แต่ละลูกค้า const today = new Date(); const transactions = items[0].json.transactions; const customers = {}; transactions.forEach(tx => { const id = tx.customer_id; if (!customers[id]) customers[id] = { orders:[], total:0 }; customers[id].orders.push(new Date(tx.date)); customers[id].total += tx.amount; }); return Object.entries(customers).map(([id, data]) => { const lastOrder = Math.max(...data.orders); const R = Math.floor((today - lastOrder) / 86400000); // วัน const F = data.orders.length; const M = data.total; // Score 1-5: R ยิ่งน้อยดี, F และ M ยิ่งมากดี const rScore = R<=7?5:R<=30?4:R<=60?3:R<=90?2:1; const fScore = F>=10?5:F>=6?4:F>=3?3:F>=2?2:1; const mScore = M>=50000?5:M>=20000?4:M>=10000?3:M>=5000?2:1; const segment = getSegment(rScore,fScore,mScore); return { json:{ customer_id:id, R, F, M, rScore, fScore, mScore, segment } }; });