关于拼貂批发意向分析数据
收藏资源简介:
通过收集和分析批发商对拼貂类产品相关数据,了解批发商的采购水平和意向度,从而了解该产品是否畅销,从而为本行业的所有企业制定生产策略,更好地为批发商提供个性化的产品和服务1、数据处理:对采集到的数据进行降噪、清洗、脱敏、聚集、分析。 2.数据加工:重复率评分=满分上限100-(ROUND(重复批发排名/总记录数(931)*100,2);单笔评分=满分上限100-(ROUND(单笔批发最大金额排名/总记录数(931)*100,2);平均分=(RFM评分+重复率评分+单笔评分)/3;综合得分=ROUND(SQRT(((RFM评分-平均分)^2+(重复率评分-平均分)^2+(单笔评分-平均分)^2)/3),2);得到的综合评分:0-10分标记为“高意向度批发商”,11-25分区间内标记为“中意向度批发商”,25分以上标记为“低意向度批发商”。
This dataset is developed by collecting and analyzing wholesaler-related data for mink blend products, aiming to grasp the purchasing capabilities and purchase intentions of wholesalers, assess the market sales popularity of the products, and formulate targeted production strategies for all enterprises in the industry to better provide personalized products and services for wholesalers. 1. Data Processing: Perform denoising, cleaning, anonymization, aggregation and analysis on the collected raw data. 2. Data Scoring Calculation: - Repeat Rate Score = 100 (full score upper limit) - ROUND( (Ranked number of repeated wholesale orders / Total records (931)) * 100, 2 ) - Single Transaction Score = 100 - ROUND( (Ranked maximum single wholesale transaction amount / Total records (931)) * 100, 2 ) - Average Score = (RFM Score + Repeat Rate Score + Single Transaction Score) / 3 - Comprehensive Score = ROUND( SQRT( ((RFM Score - Average Score)^2 + (Repeat Rate Score - Average Score)^2 + (Single Transaction Score - Average Score)^2) / 3 ), 2 ) Wholesalers are categorized based on their comprehensive scores: - Marked as "High-intent Wholesalers" for those with a comprehensive score of 0-10 - Marked as "Medium-intent Wholesalers" for those with a comprehensive score ranging from 11 to 25 - Marked as "Low-intent Wholesalers" for those with a comprehensive score above 25




