Generate a detailed weekly ecommerce report with Gemini

Generate a comprehensive weekly ecommerce report for an online store, aimed at providing stakeholders with a clear overview of the store's performance metrics and actionable insights. The report should be structured in a professional format that highlights key data points, analyses, and recommendations to enhance future performance.

**Data Inputs for Analysis:**

1. **Sales Data:**
- Total Sales: $25,300
- Number of Orders: 340
- Average Order Value (AOV): $74.41

2. **Traffic Data:**
- Total Visitors: 15,000
- Conversion Rate: 2.27%
- Traffic Sources:
- Organic Search: 40% (6,000 visitors)
- Paid Search: 25% (3,750 visitors)
- Social Media: 20% (3,000 visitors)
- Email Campaigns: 15% (2,250 visitors)

3. **Top-Selling Products:**
- Product A: 120 units sold, $4,800 revenue
- Product B: 95 units sold, $3,325 revenue
- Product C: 75 units sold, $2,250 revenue

4. **Inventory Data:**
- Product A: 40 units remaining
- Product B: 10 units remaining (low stock alert)
- Product C: 100 units remaining

5. **Marketing Campaign Performance:**
- Email Campaign Open Rate: 28%
- Email Campaign Click-Through Rate (CTR): 12%
- Social Media Engagement Rate: 3.8%

6. **Issues Identified:**
- 2 broken links in the email campaign landing page (identified via QA).
- High cart abandonment rate: 65%.

**Specific Instructions for Report Structure:**

1. **Overview Section:** Begin with a brief summary that outlines the report's purpose and highlights key insights, including overall performance and standout metrics for the week.

2. **Sales and Traffic Analysis:** Provide a detailed breakdown of total sales, conversion rates, and traffic sources. Analyze which traffic source contributed the most to sales, and include relevant insights.

3. **Product Performance:** Identify and evaluate the top-selling products, discussing their revenue contributions and noting any inventory concerns, such as low stock levels.

4. **Marketing Campaign Performance:** Assess the results of email and social media campaigns, focusing on engagement metrics and suggesting areas for potential improvement.

5. **Actionable Recommendations:** Based on the analysis, offer 3-5 specific recommendations aimed at enhancing performance in the upcoming week, such as restocking products, addressing broken links, and optimizing strategies to reduce cart abandonment.

6. **Report Formatting:** Ensure the report is formatted professionally with clear headings and bullet points, making the data easily digestible for team members and decision-makers.

Prompt Perfect is designed to work where you do.

Perfect your prompts across the leading chatbots: ChatGPT, Gemini, Claude, Perplexity, Copilot .

With one-click rewrites, you can turn vague instructions into clear, effective prompts.

Or, get feedback in seconds to make your prompts even better.

Prompt Perfect ensures you get the best responses, no matter the platform.

Plus, manage your favorite prompts with the built-in Prompt Library, saving you time and keeping your best ideas accessible at any moment.

How to use it:

1. Add the extension (Google Chrome Only)

2. Visit your favorite chatbot

3. The buttons show up automatically

4. Type in a prompt and click Perfect