云南地区公司平台用户价值评价数据

通过分析用户的价值，平台可以向用户推送个性化的知识产权检索建议、培训资源或增值服务，满足用户的特定需求。对于高频次、高价值的用户，平台可以提供更加专属和定制化的服务，如一对一专家咨询、高级检索功能等，以提升用户满意度和忠诚度。例如识别出那些频繁使用平台且消费金额较高的高价值客户。平台可以通过提供专属福利、优先服务等方式，增强这些用户的忠诚度。
1、数据采集：利用公司管理平台导出云南地区平台用户相关数据，包括用户基本信息，登入情况，在平台上进行的检索数据等。2、数据处理：以用户编号作为唯一标识，对数据进行清洗、去除无效数据等操作。3、数据加工：通过LOOKUP函数计算出就用户最近一次登入的时间R，COUNTIF函数计算就用户的总登入次数F，SUMIF函数计算就用户购买套餐的总金额M，COUNTIF函数计算就用户的总检索次数N，统计用户在平台检索记录中频率最高的词条，对词条进行领域分类，领域得分（战略新兴领域的得分5分，其他领域不得分），计算用户得分T=(30-(当前时间-R))/30*10+N/F+M/客户购买套餐平均金额*10+领域得分，其中当30-(当前时间-R）＜0时，直接计为0，对客户进行分层，T≤10为普通客户，10<T≤20 为潜力客户，20<T≤45 为重要客户，T＞45 为高价值客户。

By analyzing user value, the platform can deliver personalized intellectual property retrieval suggestions, training resources or value-added services to users to meet their specific needs. For users with high usage frequency and high value, the platform can provide more exclusive and customized services, such as one-on-one expert consultation, advanced retrieval functions, etc., to improve user satisfaction and loyalty. For example, identify high-value customers who frequently use the platform and have high consumption amounts. The platform can enhance the loyalty of these users by providing exclusive benefits, priority services and other means.
1. Data Collection: Export relevant data of platform users in Yunnan Province using the company's management platform, including basic user information, login status, retrieval records generated on the platform, etc.
2. Data Processing: Take the user ID as the unique identifier, and perform operations such as data cleaning and invalid data removal.
3. Data Processing & Enrichment: Use the LOOKUP function to calculate the user's latest login time R; use the COUNTIF function to calculate the user's total login times F and total number of retrievals N; use the SUMIF function to calculate the total amount M of the user's purchased packages. Count the most frequent entries in the user's platform retrieval records, conduct domain classification on these entries, and calculate the domain score (5 points for strategic emerging fields, 0 points for other fields). Then calculate the user score T using the formula: T=(30-(current time - R))/30*10 + N/F + (M / average package purchase amount of all customers)*10 + domain score. If 30 - (current time - R) < 0, the value is directly set to 0. Afterwards, classify customers into four tiers: ordinary customers (T ≤ 10), potential customers (10 < T ≤ 20), important customers (20 < T ≤ 45), and high-value customers (T > 45).

搜集汇总

数据集介绍

特点

该数据集包含1565条云南地区公司平台用户的价值评价数据，用于分析用户价值并推送个性化服务。通过特定算法规则，用户被分为普通客户、潜力客户、重要客户和高价值客户，以提升用户满意度和忠诚度。