天瑞地安客户端车管家频道用户使用指数分析数据
收藏资源简介:
对本客户端的应用:基于频道使用指数及其变化程度,公司可以了解资客户端各个频道的历史使用情况与当前使用状况以及未来可能的变化趋势,有助于指导客户端功能的优化和迭代,还有助于在资源分配上提供帮助,例如可以根据频道的实用指数决定频道的留存,也能够保证客户端整体的稳定性和响应速度,有效地降低公司的运营成本;对相同类型客户端的应用:数据能够为同行分析了解类似频道或相似新闻类型的用户使用程度和使用变化程度,为同行在类似频道或相似新闻类型的使用上提供基础数据支撑。数据采集:从客户端后台数据库中提取反映每个频道的使用数据,包括日期、频道、频道ID、使用人数UV、使用频次PV、当日使用时长T、当日总活跃用户数UC等数据;数据处理:对采集的数据进行清洗,计算当日使用率US(US=UV/UC)以及日期权重q(基于整体的使用人数数据计算,工作日q为1.1,非工作日q为0.9);算法规则:计算加权使用时长Tq=T÷UV×q,计算用户活跃度指数UA=√[UV×(PV×q)],计算频道使用指数C=0.6US+0.2Tq+0.2UA(权重系数依据每个指标的重要度确定),统计过去30日和90日的使用指数,在此基础上分别除以30和90计算30天使用指数C1和90天使用指数C2,计算指数变化tC=C1/C2-1,再根据tC绝对值的数据区间确定频道使用指数变化程度(|tC|<=0.2为低,0.2<|tC|<=0.5为中,0.5<|tC|<=1为大,|tC|>1为极大)
Applications for this client: Based on the channel usage index and its variation degree, the company can acquire insights into the historical usage, current status and potential future trends of each channel of this client. This facilitates guiding the optimization and iterative updates of client functions, as well as supporting evidence-based resource allocation. For example, channel retention can be determined based on their channel usage index, which also helps maintain the overall stability and response speed of the client, effectively reducing the company's operating costs. Applications for peer clients of the same type: The dataset enables industry peers to analyze user usage levels and variation trends of similar channels or news categories, providing foundational data support for their operations related to such channels or news types. Data Collection: Extract usage-related data for each channel from the client's backend database, including date, channel name, channel ID, unique visitors (UV), page views (PV), daily usage duration T, total daily active users (UC), and other relevant metrics. Data Processing: Clean the collected dataset, calculate the daily usage rate US (defined as US = UV / UC) and the date weight q (calculated based on overall user volume data, with q = 1.1 for weekdays and q = 0.9 for non-weekdays). Algorithm Rules: Calculate the weighted usage duration Tq = T ÷ UV × q; calculate the user activity index UA = √[UV × (PV × q)]; calculate the channel usage index C = 0.6US + 0.2Tq + 0.2UA (the weight coefficients are determined according to the importance of each indicator). Collect the channel usage indexes over the past 30 days and 90 days, then divide the cumulative index by 30 and 90 respectively to obtain the 30-day usage index C1 and 90-day usage index C2. Calculate the index change rate tC = C1 / C2 - 1, then categorize the variation degree of the channel usage index based on the interval of |tC|: low when |tC| ≤ 0.2, medium when 0.2 < |tC| ≤ 0.5, large when 0.5 < |tC| ≤ 1, and extreme when |tC| > 1.




