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

通过分析用户的价值，平台可以向用户推送个性化的知识产权检索建议、培训资源或增值服务，满足用户的特定需求。对于高频次、高价值的用户，平台可以提供更加专属和定制化的服务，如一对一专家咨询、高级检索功能等，以提升用户满意度和忠诚度。例如识别出那些频繁使用平台且消费金额较高的高价值客户。平台可以通过提供专属福利、优先服务等方式，增强这些用户的忠诚度。
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 meet users' specific needs. For high-frequency, high-value users, the platform can provide more exclusive and tailored services such as one-on-one expert consultations and advanced retrieval functions to enhance user satisfaction and loyalty. For example, identify high-value customers who frequently use the platform and have high consumption levels. The platform can strengthen the loyalty of these users by offering exclusive benefits, priority services, and other supportive measures.

1. Data Collection: Export relevant data of platform users in Zhejiang Province through the company's internal management platform, including basic user information, login records, and retrieval activities conducted on the platform.

2. Data Preprocessing: Take user ID as the unique identifier, clean the dataset, and remove invalid data entries.

3. Data Enrichment and Score Calculation: Calculate the latest login timestamp R of each user using the LOOKUP function; calculate the total number of logins F for each user via the COUNTIF function; calculate the total purchase amount M of the packages subscribed by each user via the SUMIF function; and calculate the total number of retrievals N for each user via the COUNTIF function. Count the most frequently occurring terms in the user's platform retrieval records, classify these terms by domain, and assign domain scores (5 points for strategic emerging fields, 0 points for all other fields). Calculate the user score T using the following formula: T = [(30 - (current timestamp - R)) / 30 * 10] + (N / F) + (M / average package purchase amount across all customers) * 10 + domain score. If 30 - (current timestamp - R) < 0, this term will be directly set to 0. Classify customers into four tiers: ordinary customers when T ≤ 10, potential customers when 10 < T ≤ 20, important customers when 20 < T ≤ 45, and high-value customers when T > 45.

搜集汇总

数据集介绍

特点

该数据集包含1553条浙江地区公司平台用户的价值评价数据，用于分析用户行为和价值，包括登入次数、消费金额、检索行为等。通过特定算法计算用户得分并分层，平台可据此提供个性化服务，如专属福利和优先服务，以提升用户满意度和忠诚度。