根据给定的数据和分析维度,我们可以进行如下核心分析:
为了更深入地了解引流效率,可以进一步计算每个直播间实际带来的销售额。例如:
# 假设数据框 df 包含以下列:'video_views', 'sales'
import pandas as pd
df = pd.DataFrame({
'video_views': [2579] * 50, # 举例,假设所有直播间平均视频观看人数为2579
'sales': [3846] * 50 # 举例,假设所有直播间平均销售额为3846元
})
df['CVR'] = df['sales'] / df['video_views']
avg_cvr = df['CVR'].mean()
print("Average Conversion Rate (CVR):", avg_cvr)
结论:
top_3_views = 18493 + 12033 + 11178
total_views = sum(df['video_views'])
percentage_top_3 = (top_3_views / total_views) * 100
print("Percentage of views for TOP3:", percentage_top_3, "%")
结论:
结论:
df['followers'] = [25970] * 50 # 假设所有直播间平均粉丝数为25970
avg_followers = df['followers'].mean()
print("Average Followers:", avg_followers)
结论:
以上分析数据来源:互联岛