GMS Generate Template for Merchant - Daily Opeartion Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAV
1
เป้ายอดขายของธุรกิจ
สีเหลืองคือช่องที่กรอกได้
2
GMS (ยอดขาย)UU (คนเข้าเว็บหรือ Visits)OrderCVRAOV
วิธีการใช้งานชาร์ตนี้
3
DateTargetActual% ทำได้TargetActual
% ทำได้
GAPTargetActualTargetActualTargetActual1
กำหนดยอดขายที่ต้องการ Target GMS และ CVR, AOV
4
Total5,000,0009,121,070182.42%1,90032016.84%323,1851209010.00%28.13%1,700101,345
GMS = ยอดขายที่อยากจะได้
5
05-01-2019161,2901000000620.00%10,00010.01%9,9994310.00%300.00%1,700333333
CVR (Conversion) = ยอดเปลี่ยนจากผู้ชมเป็นผู้ซื้อ มาจาก Order/UU ดูจากเดือนก่อนๆ
6
05-02-2019161,2901000000620.00%6334.74%10,0594310.00%100.00%1,700333333
AOV (Average Order Value) = มูลค่าเฉลี่ยราคาการสั่งต่อ Order มาจาก GMS/Order
7
05-03-2019161,2901000000620.00%6334.74%10,1204010.00%0.00%1,700#DIV/0!2
กรอก GMS, UU, Order ที่ได้ในแต่ละวันลงไป
8
05-04-2019161,2901000000620.00%6346.32%10,1794010.00%0.00%1,700#DIV/0!
UU (Unique User or Visits) = ยอดคนเข้าเว็บไซต์ ดูได้จาก Google Analytics
9
05-05-2019161,2901000000620.00%63711.05%10,2354110.00%14.29%1,7001000000
Order = จำนวนรายการสั่งซื้อ
10
05-06-2019161,2901000000620.00%6346.32%10,2954210.00%50.00% 500000
รบกวนสอบถามได้ไหมครับ^^
11
05-07-2019161,2901000000620.00%632336.32%10,3354210.00%8.70% 500000
Remarks
คุณยูนิคอร์น
12
05-08-2019161,2901000000620.00%631320.53%10,3854410.00%30.77% 250000
13
05-09-2019161,2901000000620.00%631930.00%10,4304510.00%26.32% 200000
14
05-10-2019161,290136508.46%631523.68%10,4784910.00%60.00% 1517
15
05-11-2019161,29034002.11%631117.37%10,5304210.00%18.18% 1700
16
05-12-2019161,29000.00%6334.74%10,5914010.00%0.00% #DIV/0!
17
05-13-2019161,29069604.32%631117.37%10,6434610.00%54.55% 1160
18
05-14-2019161,29092805.75%631218.95%10,6944510.00%41.67% 1856
19
05-15-2019161,29000.00%6369.47%10,7524010.00%0.00% #DIV/0!
20
05-16-2019161,29075904.71%631320.53%10,8024410.00%30.77% 1898
21
05-17-2019161,2908900.55%63812.63%10,8574110.00%12.50% 890
22
05-18-2019161,29066004.09%6357.89%10,9164210.00%40.00% 3300
23
05-19-2019161,2908900.55%6311.58%10,9784110.00%100.00% 890
24
05-20-2019161,29042802.65%631117.37%11,0304310.00%27.27% 1427
25
05-21-2019161,29041902.60%631117.37%11,0834210.00%18.18% 2095
26
05-22-2019161,29076704.76%633352.11%11,1134510.00%15.15% 1534
27
05-23-2019161,29058903.65%631625.26%11,1604310.00%18.75% 1963
28
05-24-2019161,29050003.10%631422.11%11,2104210.00%14.29% 2500
29
05-25-2019161,29058903.65%631523.68%11,2584310.00%20.00% 1963
30
05-26-2019161,29000.00%6334.74%11,3184010.00%0.00% #DIV/0!
31
05-27-2019161,290116807.24%631320.53%11,3694510.00%38.46% 2336
32
05-28-2019161,290108906.75%631117.37%11,4214510.00%45.45% 2178
33
05-29-2019161,29093705.81%631218.95%11,4724610.00%50.00% 1562
34
05-30-2019161,29044502.76%631218.95%11,4724510.00%41.67% 890
35
05-31-2019161,29025001.55%63711.05%11,5294110.00%14.29% 2500
36
37
ยอดคนเข้าที่หายไป4,121,07011,529
2กล่อง/คน
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Marketing Channel and Budgeting
66
Channel%GMSUUCPCBudget
67
Facebook20%1,000,00038051,900
68
Instragram20%1,000,00038051,900
69
LINE@5%250,00095
70
SEM15%750,00028551,425
71
Natural40%2,000,000760
72
Sum100%5,000,0001,9005,225.00000.10%
73
74
75
Marketing Tracking
76
Facebook 20%Instragram 20%@Line 5%SEM 15%Natural 40%
77
DateVisit TargetActual%GMS TargetActual%Cost
(Plan)
Actual%C/GMS TargetActual%Visit Target%GMS TargetActual%CostActual%C/GMS TargetActual%Visit TargetActual%GMS TargetActual%Visit TargetActual%GMS TargetActual%CostActual%C/GMS TargetActual%Visit TargetActual%GMS TargetActual%
78
113150011842.11%33333490014.70%6320003157.89%0.00190.4121482.28%13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
79
2130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
80
3130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
81
4130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
82
5130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
83
6130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
84
7130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
85
8130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
86
9130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
87
10130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
88
11130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
89
12130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
90
13130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
91
14130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
92
15130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
93
16130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
94
17130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
95
18130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
96
19130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
97
20130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
98
21130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
99
22130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
100
23130.00%333330.00%630.00%0.0019#DIV/0!#DIV/0!13#REF!33,3330.00%630.00%0.00#DIV/0!#DIV/0!30.00%8,3330.00%9.50.00%250000.00%480.00%0.00#DIV/0!#DIV/0!250.00%66,6670.00%
Loading...