山东地区公司平台用户价值评价数据

通过分析用户的价值，平台可以向用户推送个性化的知识产权检索建议、培训资源或增值服务，满足用户的特定需求。对于高频次、高价值的用户，平台可以提供更加专属和定制化的服务，如一对一专家咨询、高级检索功能等，以提升用户满意度和忠诚度。例如识别出那些频繁使用平台且消费金额较高的高价值客户。平台可以通过提供专属福利、优先服务等方式，增强这些用户的忠诚度。
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 demands. For high-frequency and high-value users, the platform can offer more exclusive and customized services, such as one-on-one expert consultations and advanced retrieval functions, to boost user satisfaction and loyalty. For instance, the platform can identify high-value customers who frequently use the platform and have high consumption levels, and enhance their loyalty through exclusive benefits, priority services and other measures.
1. Data Collection: Export relevant data of platform users in Shandong Province via the company's management platform, including users' basic information, login status, retrieval records generated on the platform, and other related data.
2. Data Processing: Take the user ID as the unique identifier, and conduct operations such as data cleaning and removal of invalid data.
3. Data Enrichment: Calculate the last login time R of each user using the LOOKUP function; use the COUNTIF function to calculate the user's total number of logins F; use the SUMIF function to calculate the total purchase amount M of the user's subscribed packages; use the COUNTIF function to calculate the user's total number of retrieval times N. Count the most frequent entries in the user's platform retrieval records, classify these entries by industry domain, and assign domain scores (5 points for strategic emerging fields, 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. Note that when 30-(current time - R) < 0, the value is directly set to 0. Then perform customer tiering: ordinary customers for T ≤10, potential customers for 10<T≤20, important customers for 20<T≤45, and high-value customers for T>45.