哈尔滨海宁皮革城旅行社合作情况数据

通过对旅行社游客组团的数据分析，可评估该旅行社在特定地区的收客能力，并通过不同旅行社收客能力的数据判断，对调整与旅行社的合作模式和合作预算，实现优胜劣汰。根据创建时间判定，取出本年度数据，然后通过字段"旅行社名称"、"状态"进行数据聚类，计算总有效人数=人工有效人数+系统判定有效人数，总无效人数=人工无效人数+系统判定无效人数，团体总人数=人工有效人数+系统判定有效人数+人工无效人数+系统判定无效人数，结算费用=（人工有效人数+系统判定有效人数+额外补贴人数）*团体单价，按照上述公式，计算出该旅行社本年度的实际结算费用，并根据省份、城市、县区进行费用叠加，计算得出该旅行社游客占某地区的总游客占比，以判断该旅行社在某地区的收客能力，并根据本年度实际情况，调整下年度旅行社的合作模式和合作预算。

By analyzing the group tour booking data of travel agencies, one can evaluate the tourist acquisition capability of a given travel agency in specific regions. Moreover, by comparing the tourist acquisition capability data across different travel agencies, it is possible to adjust the cooperation models and cooperation budgets with travel agencies to implement a survival-of-the-fittest mechanism.
First, filter the data of the current year based on the record creation time. Next, conduct data clustering using the fields "Travel Agency Name" and "Status". Calculate the following metrics:
1. Total Valid Tourists = Manually Validated Tourists + System-validated Tourists
2. Total Invalid Tourists = Manually Invalidated Tourists + System-invalidated Tourists
3. Total Group Members = Total Valid Tourists + Total Invalid Tourists
4. Settlement Fee = (Manually Validated Tourists + System-validated Tourists + Additional Subsidy Recipients) × Group Unit Price
Subsequently, calculate the actual settlement fee for each travel agency in the current year using the aforementioned formulas. Then aggregate the settlement fees by province, city and district/county to compute the proportion of tourists from the target travel agency in the total tourist volume of a specific region, so as to assess the travel agency's tourist acquisition capability in that region. Finally, adjust the cooperation models and cooperation budgets with travel agencies for the next fiscal year based on the actual performance of the current year.