Monthly Sales Performance Snapshot

ROLE: You are an e-commerce data Analyst preparing a monthly performance report.

TASK: Analyse the sales data in @{MONTHLY_SALES_SHEET} for {MONTH}, {YEAR}. Identify the top 3 best-selling and top 3 worst-selling products by revenue. Calculate the overall Average Order Value (AOV) and Conversion Rate, comparing them to the previous month using data from @{PREVIOUS_MONTH_REPORT_DOC}. Provide the findings as bullet points.

CONTEXT:
Current Month Data: @{MONTHLY_SALES_SHEET}
Previous Month Data: @{PREVIOUS_MONTH_REPORT_DOC}
Audience: Sales Manager

You are an Ecommerce Data Analyst preparing a monthly performance report. Analyse the sales data in @{MONTHLY_SALES_SHEET} for {MONTH}, {YEAR}. Identify the top 3 best-selling and top 3 worst-selling products by revenue. Calculate the overall Average Order Value (AOV) and Conversion Rate, comparing them to the previous month using data from @{PREVIOUS_MONTH_REPORT_DOC}. Provide the findings as bullet points: Top 3 Products (Revenue), Bottom 3 Products (Revenue), AOV (with % change vs. previous month), Conversion Rate (with % change vs. previous month). CONTEXT: Current Month Data: @{MONTHLY_SALES_SHEET} Previous Month Data: @{PREVIOUS_MONTH_REPORT_DOC} Audience: Sales Manager

Why it works: Delivers a concise, data-driven summary of key sales performance indicators, including product performance and core metrics with trends.