{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["推广类营销活动配置类","资费套餐配置类","电子渠道类","BOSS CRM开发类需求指标","通用后评估模板"],"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":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,4,0]]}
["需求类型","指标名称","具体取值","口径","备注"]
["推广类营销活动配置类","发展用户数",null,"截止N月，发展新入网客户数，截止N月末，仍在用"]
[null,"订购用户率",null,"截止N月，订购用户数，截止N月末，仍在用"]
[null,"订购业务人均ARPU",null,"截止N月，订购业务人均ARPU"]
[null,"活动有效性",null,"用于衡量开发的营销活动的合理有效性，是指在一个开发需求中，可能包含Ｍ个营销活动，Ｎ个月后，其中M1个活动有发展用户，其余M-M1个营销活动没有用户订购","活动有效性= M1/M*100%。其百分比越高，说明本次活动的需求有效性越高。"]

{"sheet":"资费套餐配置类","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,4,12,4],[1,0,12,0],[1,2,2,2],[1,4,2,4],[3,2,9,2],[3,4,9,4],[1,1,2,1],[1,3,2,3],[3,1,9,1],[3,3,9,3],[11,1,12,1],[11,3,12,3],[11,2,12,2]]}
["需求类型","指标名称","具体取值","口径","备注"]
["资费套餐配置类","发展客户数",null,"截止N月，发展新入网客户数，截止N月末，仍在用"]
[]
[null,"订购用户数",null,"截止N月，订购用户数，截止N月末，仍在用"]
[]
[]
[]
[]
[]
[]
[null,"订购业务人均ARPU",null,"截止N月，订购业务人均ARPU"]
[null,"套餐有效性",null,"用于衡量开发的套餐是否合理有效性，是指在一个开发需求中，可能包含Ｍ个套餐，Ｎ个月后，其中M1个套餐有发展用户，其余M-M1个套餐没有用户订购。","套餐有效性= M1/M*100%。其百分比越高，说明本次开发的套餐的需求有效性越高。"]

{"sheet":"电子渠道类","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[3,1,5,1],[1,0,5,0]]}
["需求类型","需求子类型","指标","具体取值","口径"]
["电子渠道类","新增","功能使用量",null,"截止N月，累计功能使用量"]
[null,null,"人均功能使用量",null,"人均点击量=功能使用量/累计使用人数"]
[null,"优化","功能使用量",null,"截止N月，累计功能使用量"]
[null,null,"使用提高率",null,"使用提高率=优化后使用量/优化前使用量"]
[null,null,"人均功能使用量",null,"人均点击量=功能使用量/累计使用人数"]

{"sheet":"BOSS CRM开发类需求指标","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[3,1,5,1],[1,0,5,0]]}
["需求类型","需求子类型","指标","具体取值","口径"]
["Boss/Crm类","新增","功能使用量",null,"截止N月，累计功能使用量"]
[null,null,"人均功能使用量",null,"人均点击量=功能使用量/累计使用人数"]
[null,"优化","功能使用量",null,"截止N月，累计功能使用量"]
[null,null,"使用提高率",null,"使用提高率=优化后使用量/优化前使用量"]
[null,null,"人均功能使用量",null,"人均点击量=功能使用量/累计使用人数"]

{"sheet":"通用后评估模板","index":4,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,4,0],[5,0,13,0],[14,0,16,0],[17,0,18,0]]}
["分类","指标名称","具体指标值","口径","备注"]
["用户数","拉新的用户数",null,"例如校园迎新需求预计开户3000户","同步考虑老客户开新卡情况"]
[null,"上线后某一类新增开户数",null,"例如优化网上开户流程，使网上开户从月1000笔提升为2000笔","同步考虑老客户开新卡情况\n包括集团、宽带、固话和个人"]
[null,"渠道开户",null,"例如新增旗舰店开固话功能，统计旗舰店开通固话数"]
[null,"保有，针对某一类用户的销户减少",null,"例如针对目标客户群的低价值套餐营销，客户群的保有率"]
["arpu","新增附加资费、产品产生收入",null,"例如新增10元假日流量包的办理量、新增一款魔百和会员业务的办理量"]
[null,"新增主资费产生收入",null,"例如新增一款98元不限量主套餐，办理用户数以及办理用户月均消费提升"]
[null,"流量收入提升",null,"例如该需求使某一类用户的流量使用提升多少"]
[null,"营销收入提升",null,"例如需求的营销活动产生的直接受益"]
[null,"渠道激励",null,"例如新增一个资费的酬金策略后，渠道业务办理量是否有变化"]
[null,"新增受理渠道",null,"例如新增电视营业厅办理魔百和vip包的办理量"]
[null,"业务、产品优化",null,"例如优化集团产品属性，观察集团产品的办理量变化"]
[null,"减少损失",null,"例如因限制高套餐向低套餐转，增加业务限制，从而减少了损失"]
[null,"其他收入",null,"例如调整sim卡收费，直接产生的sim费用收入"]
["客户服务","客户自服务",null,"例如新增集团客户联系人账单查询功能，统计功能使用量"]
[null,"客户投诉",null,"例如优化业务办理二次确认和扣费提醒短信流程，统计相关业务的不知情定制投诉是否减少\n例如优化业务办理流程，增加前向校验，减少订单落地失败情况，减少因办理不成功的投诉"]
[null,"投诉、咨询处理",null,"例如新增客服人员查询用户限速状态及触发接触限速的功能，统计派单到业支的相关投诉量","针对客服、客户经理等使用人员"]
["使用体验","新增功能",null,"新增报表、查询功能等管理功能的使用量","针对营业员、客户经理等使用人员"]
[null,"流程优化",null,"例如简化开户流程，统计开户平均时长；例如简化专线开户流程，统计专线开户流程的平均处理时长","针对营业员、客户经理等使用人员"]
["其他","指标类的",null,"例如集团要求volte数指标，新增需求对于volte用户数的增加"]