中文版：请根据我提供的客户销售数据，制作一份客户销售分析Excel表格。

请按照客户维度统计客户销售额、订单数量、平均订单金额、最近购买日期、购买频率、产品数量和累计贡献金额。

按照客户价值将客户划分为重点客户、成长客户、普通客户、低活跃客户和流失风险客户。

计算每类客户的数量、销售额占比、客户贡献度和平均客单价。

建立客户排行榜，并通过条件格式突出TOP客户和长期没有购买的客户。

增加客户价值分析表和客户分层分析表，帮助销售团队决定下一步应该重点维护哪些客户、开发哪些客户以及挽回哪些客户。

英文版：Based on the customer sales data I provide, create a customer sales analysis Excel workbook.

For each customer, calculate sales revenue, order count, average order value, most recent purchase date, purchase frequency, number of products purchased, and cumulative contribution.

Segment customers into key accounts, growth customers, regular customers, low-activity customers, and churn-risk customers based on customer value.

Calculate the number of customers, revenue share, customer contribution, and average order value for each segment.

Create a customer ranking and use conditional formatting to highlight top customers and customers who have not purchased recently.

Add customer value analysis and customer segmentation worksheets to help the sales team determine which customers to retain, develop, or win back.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI