江西地区公司平台用户价值评价数据

通过分析用户的价值，平台可以向用户推送个性化的知识产权检索建议、培训资源或增值服务，满足用户的特定需求。对于高频次、高价值的用户，平台可以提供更加专属和定制化的服务，如一对一专家咨询、高级检索功能等，以提升用户满意度和忠诚度。例如识别出那些频繁使用平台且消费金额较高的高价值客户。平台可以通过提供专属福利、优先服务等方式，增强这些用户的忠诚度。 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 push 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, the platform can identify high-value customers who frequently use the platform and have high consumption amounts, and enhance their loyalty by providing exclusive benefits, priority services and other measures. 1. Data Collection: Export relevant data of platform users in Jiangxi Province via the company's management platform, including user basic information, login status, and retrieval data generated on the platform, etc. 2. Data Processing: Take user IDs as unique identifiers, and perform operations such as data cleaning and removal of invalid data. 3. Data Processing and Calculation: Use the LOOKUP function to calculate the time of the user's latest login (denoted as R); use the COUNTIF function to calculate the total number of user logins (denoted as F); use the SUMIF function to calculate the total amount of user-purchased packages (denoted as M); use the COUNTIF function to calculate the total number of user retrievals (denoted as N). Count the most frequently occurring terms in the user's platform retrieval records, classify these terms into domains, and assign domain scores: 5 points for strategic emerging industries, and 0 points for other fields. 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. When 30-(current time - R) < 0, the value of this term is directly set to 0. Perform customer segmentation based on the score T: ordinary customers for T ≤ 10, potential customers for 10 < T ≤ 20, important customers for 20 < T ≤ 45, and high-value customers for T > 45.

搜集汇总

数据集介绍

特点

该数据集包含2195条江西地区公司平台用户的价值评价数据，涵盖用户登入情况、检索行为和消费金额等信息。通过特定算法对用户进行分层评价，旨在为平台提供个性化服务推荐和用户忠诚度提升策略支持。