度量值計算公式列表:
1.訪客數(shù)合計 = sum('XX電腦自營旗艦店'[訪客數(shù)(UV)])
2.瀏覽量合計 = sum('XX電腦自營旗艦店'[瀏覽量(PV)])
3.新訪客數(shù)合計 = sum('XX電腦自營旗艦店'[新訪客數(shù)])
4.訪問次數(shù)合計 = sum('XX電腦自營旗艦店'[訪問次數(shù)])
5.跳失次數(shù)合計 = sum('XX電腦自營旗艦店'[跳失次數(shù)])
6.收藏人數(shù)合計 = sum('XX電腦自營旗艦店'[收藏人數(shù)])
7.加入購物車人數(shù)合計 = sum('XX電腦自營旗艦店'[加入購物車人數(shù)])
8.支付人數(shù)合計 = sum('XX電腦自營旗艦店'[支付人數(shù)])
9.新訪客占比 = [3.新訪客數(shù)合計] / [1.訪客數(shù)合計]
10.平均訪問深度 = [2.瀏覽量合計] / [4.訪問次數(shù)合計]
11.跳失率 = [5.跳失次數(shù)合計] / [4.訪問次數(shù)合計]
12.收藏人數(shù)占比 = [6.收藏人數(shù)合計] / [1.訪客數(shù)合計]
13.加入購物車人數(shù)占比 = [7.加入購物車人數(shù)合計] / [1.訪客數(shù)合計]
14.支付人數(shù)占比 = [8.支付人數(shù)合計] / [1.訪客數(shù)合計]
15.關(guān)鍵指標 = switch([指標選擇 值],1,[1.訪客數(shù)合計],2,[2.瀏覽量合計],3,[3.新訪客數(shù)合計],4,[4.訪問次數(shù)合計],5,[5.跳失次數(shù)合計],6,[6.收藏人數(shù)合計],7,[7.加入購物車人數(shù)合計],8,[8.支付人數(shù)合計],9,[9.新訪客占比],10,[10.平均訪問深度],11,[11.跳失率],12,[12.收藏人數(shù)占比],13,[13.加入購物車人數(shù)占比],14,[14.支付人數(shù)占比],0)








暫無數(shù)據(jù)