RFM得分计算器Excel模板.pdf

昵称R值F值M值R值得分F值得分M值得分RFM总分11752224.74239 24112238.632237 3515149.482114 46701219.762136 546129.95117 63502384.533238 7557119.912114 8411148.52114 95081632114 105121202.592136 116621204.082136 123441131.83126 13463283.553311 143413431.123339 15576188.632114 161430195.81113 179841138.671124 187291176.921124 1954615002136 20746159.81113 212111164.13126 2239163.95117 2311111155.651124 241016149.11113

R值分段得分F值分段得分M值分段得分90天未购买5购买1次1100元以下1

90-180天未购买4购买2次2100-200元2 180-360天未购买3购买3次3200-500元3 360-720天未购买2购买4次4500-1000元4 720天以上未购买1购买≥5次51000元以上5

不同店铺请根据自己行业规则修改↓↓↓并且复制下面函数并加“=”号即可

R的函数：IF(B2<=90,5,IF(B2<=180,4,IF(B2<=360,3,IF(B2<=720,2,1))))

M的函数：IF(D2<=100,1,IF(D2<=200,2,IF(D2<=500,3,IF(D2<=1000,4,5))))