{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["销售数据名词解释"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"销售数据名词解释","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[25,9,25,12],[26,9,26,12],[27,9,27,12],[28,9,28,12],[29,9,29,12],[20,9,20,12],[21,9,21,12],[22,9,22,12],[23,9,23,12],[24,9,24,12],[15,9,15,12],[16,9,16,12],[17,9,17,12],[18,9,18,12],[19,9,19,12],[10,9,10,12],[11,9,11,12],[12,9,12,12],[13,9,13,12],[14,9,14,12],[5,9,5,12],[6,9,6,12],[7,9,7,12],[8,9,8,12],[9,9,9,12],[0,9,0,12],[1,9,1,12],[2,9,2,12],[3,9,3,12],[4,9,4,12],[21,1,21,8],[23,1,23,8],[36,1,36,8],[37,1,37,8],[0,1,0,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[1,1,1,8],[2,1,2,8],[3,1,3,8],[4,1,4,8],[5,1,5,8],[46,1,46,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[41,0,41,8],[42,1,43,8],[44,1,44,8],[45,1,45,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[22,1,22,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[38,9,38,12],[39,9,39,12],[40,9,40,12],[41,9,41,12],[28,1,28,8],[35,9,35,12],[36,9,36,12],[37,9,37,12],[30,9,30,12],[31,9,31,12],[32,9,32,12],[33,9,33,12],[34,9,34,12],[42,9,43,12],[44,9,44,12],[45,9,45,12],[46,9,46,12]]}
["指标","解析",{"$nulls":7},"计算公式"]
["PV","PV(page view)，即页面浏览量，或点击量，一个访问者在24小时看了网站内几个页面。"]
["UV","UV是unique visitor的简写，是指不同的、通过互联网24小时内访问、浏览这个网页的自然人数。"]
["转化率","全店成交转化率=成交用户数/访客数。单日“全店成交转化率” 指 单日成交用户数占访客数的百分比",{"$nulls":7},"成交人数/访客数（UV）"]
["页面访问深度","访问深度即所有用户每次访问店铺内页面数量的平均值。",{"$nulls":7},"浏览量（PV）/访客数（UV）"]
["流量价值","一段时间内平均每个访客产生的利润。",{"$nulls":7},"单位时间内的总利润/单位时间内的总UP"]
["整体投入产出比ROI","单位时间内的销售总额与推广费用的比值。",{"$nulls":7},"单位时间内的销售总额/单位时间内的推广费用"]
["直通车ROI","单位时间内的直通车带来的销售额与费用的比值。",{"$nulls":7},"单位时间内的销售总额/单位时间内的推广费用[单位时间内直通车产出10000元，花费5000元那ROI为1:2]"]
["钻展ROI","单位时间内的钻展带来的销售额与费用的比值。",{"$nulls":7},"单位时间内的销售总额/单位时间内的推广费用"]
["硬广ROI","单位时间内的硬广带来的销售额与费用的比值。",{"$nulls":7},"单位时间内的销售总额/单位时间内的推广费用"]
["客单价","平均每个成交用户带来的销售额。",{"$nulls":7},"销售额/成交用户数"]
["人均店内停留时间（秒）","平均每个访客在店铺内的访问时间。"]
["询单率","总访客数与询单人数的比值。"]
["收藏量","访文后收藏店铺或者单品的次数，一个人收藏多个单品按多次记数。"]
["静默下单率","总访客数与静默下单人数的比值。（可延伸出静默下单成功支付率既页面转化率）"]
["浏览回头客","指前6天内访问过店铺当日又来访问的用户数。"]
["浏览回头率","浏览回头客占总访客数的比例。",{"$nulls":7},"浏览回头客/整店访客数"]
["退款率","退款定单数在单位时间内占总定单数与的比例。",{"$nulls":7},"退款定单数/总定单数  [单位时间内总定单为100，退款3笔，那退款率为3%]"]
["新增顾客数","单位时间内的第一次下单客户数。"]
["老顾客成交数","单位时间内老顾客成交数量。"]
["成交用户数","成功拍下并完成支付宝付款的人数。单位时间内同一个人的多个定单按1计算。"]
["成交回头客","曾在店铺发生过交易，再次发生交易的用户称为成交回头客数。"]
["成交回头率","成交回头客占成交用户数的百分比。即成交回头率 = 成交回头客 / 成交用户数"]
["支付宝成交金额","通过支付宝付款的定单总金额"]
["支付宝成交件数","通过支付宝付款的宝贝总件数"]
["支付率","支付宝成交笔数占拍下笔数的百分比，即支付率 = 支付宝成交笔数 / 拍下笔数",{"$nulls":7},"支付宝成交笔数 / 拍下笔数 [单位时间内定单总数为100，支付90，那支付率为90%]"]
["支付宝成交笔数","通过支付宝付款的交易总次数（一次交易多件宝贝，算成交一笔）"]
["周环比增长","例：（本星期五支付宝成交金额-上星期五支付宝成交金额）/上星期五支付宝成交金额 *100%"]
["人均成交件数","平均每用户购买的宝贝件数，即人均成交件数 = 支付宝成交件数 / 成交用户数"]
["人均成交笔数","平均每用户购买的交易次数，即人均成交笔数 = 支付宝成交笔数 / 成交用户数"]
["当日拍下-付款件数","当日拍下、且当日通过支付宝付款的宝贝件数"]
["当日拍下-付款笔数","当日拍下、且当日通过支付宝付款的交易次数"]
["当日拍下-付款金额","当日拍下、且当日通过支付宝付款的金额"]
["询单转化率","咨询后下单付款的客户数占总咨询客户数量的比例。",{"$nulls":7},"咨询付款数/咨询客户数 [单位时间内100个人咨询，60个人下单并付款，那询单转化率为60%]"]
["客件数","单位时间内平均每个顾客购买的商品件数。",{"$nulls":7},"成交顾客数/总售出商品数量 "]
["最终付款成功率","无时间范围，付款成功的定单数占总拍下笔数的比例。",{"$nulls":7},"拍下笔数/付款笔数 [单位时间内总拍下定单100个，付款90个，那最终付款率为90%]"]
["旺旺响应率","回应接待数量占总咨询客户数量的比例。"]
["平均响应时间","单位时间内客服首次回应顾客和每次回应顾客的平均所需时间。"]
["下单成功率","咨询后下单的客户数占总咨询客户数量的比例。",{"$nulls":7},"咨询下单数/咨询客户数 [单位时间内100个咨询，80个人下单，那下单成功率为80%]"]
["付款成功率","咨询后下单付款的客户数占咨询下单客户数量的比例。",{"$nulls":7},"咨询付款数/咨询下单数 [单位时间内100个咨询客户下单，90人付款，那付款成功率为90%]"]
[]
["                                                数据源"]
["新增顾客","数据魔方专业版-店铺分析"]
["老顾客"]
["人均店内停留时间（秒）","量子恒道统计-流量概况"]
["周环比增长","上面有公式，自己计算"]
["其它数据","量子恒道统计-销售总揽"]