塘栖古镇省内旅客分析数据

分析省外旅客的来源地对于旅游行业及相关企业而言不仅有助于提升服务质量、优化市场策略，还能设计更符合目标客群需求的旅游产品和服务，提高营销活动的有效性和回报率，进而促进区域经济的繁荣和文化的交流。(1)数据采集：利用杭州市临平区塘栖古镇运营平台系统导出2024年1月到6月省内旅客数据。
(2)数据处理：对数据进行清洗、去除无效数据和极限数据等操作，根据旅客购票信息标注旅客来源城市。
(3)数据加工：利用SUMIFS函数和COUNTIFS函数计算当月省内各市旅客数A和当月省内总旅客数B，利用LOOKUP函数查询上月省内各市旅客数C。根据A、B核算出当月省内各市旅客占比D及上月省内各市旅客占比E，根据A、C核算出省内各市旅客数月环比X，根据D、E核算出省内各市旅客占比月环比Y。对省内不同城市进行综合评估，评估值M=IF(X>0,1,0)+IF(Y>0,1,0)，M取值范围[0，2]。
(4)数据应用：X、Y值越大当月该市的旅客数增长及市场占比越大，结合时间绘制折线图可直观查看省内各市不同时间点的旅客增长趋势，为后续优化市场策略提供数据参考。

Analyzing the origin locations of in-province tourists not only helps tourism industries and related enterprises improve service quality, optimize marketing strategies, design tourism products and services tailored to the needs of target customer groups, enhance the effectiveness and return on investment (ROI) of marketing campaigns, but also promotes regional economic prosperity and cultural exchanges.
(1) Data Collection: Data was exported from the operation platform system of Tangqi Ancient Town, Linping District, Hangzhou, to obtain in-province tourist data from January to June 2024.
(2) Data Processing: Data cleaning was performed, including removing invalid and outlier data, and the origin cities of tourists were labeled based on their ticket purchase information.
(3) Data Refinement: The SUMIFS and COUNTIFS functions were used to calculate the number of tourists from each city in the current month (A) and the total number of in-province tourists in the current month (B). The LOOKUP function was applied to query the number of tourists from each city in the previous month (C). Then, the proportion of tourists from each city in the current month (D) and that in the previous month (E) were calculated using A and B. The month-on-month growth rate of tourists from each city (X) was calculated based on A and C, while the month-on-month change in the proportion of tourists from each city (Y) was calculated using D and E. A comprehensive evaluation score M for each city, with a value range of [0, 2], was defined as M = IF(X>0,1,0) + IF(Y>0,1,0), where IF is the logical judgment function.
(4) Data Application: Larger values of X and Y indicate more substantial growth in tourist volume and market share of the corresponding city in the current month. Line charts plotted against time can intuitively demonstrate the tourist growth trends of each city in the province at different time points, providing data references for subsequent optimization of marketing strategies.

搜集汇总

数据集介绍

特点

该数据集记录了2024年1月至6月塘栖古镇省内旅客的详细信息，包括来源地、人数、月环比等关键指标，用于旅游市场分析和策略优化。