E-commerce quick prototyping for customer segmentation, sentiment analysis and review processing automation. Includes presentation in video and PowerPoint together with the ERD of the database used. Serves as Business Case example impacting several business units and providing opportunities to improve Customer Success, Sales, Marketing and Supply Chain.
git clone https://github.com/DataRaul/retail-ecommerce_customer-voice-sales-and-behaviour-prediction.gitE-commerce quick prototyping for customer segmentation, sentiment analysis and review processing automation. Includes presentation in video and PowerPoint together with the ERD of the database used. Serves as Business Case example impacting several business units and providing opportunities to improve Customer Success, Sales, Marketing and Supply Chain.
No install command available. Check the GitHub repository for manual installation instructions.
git clone https://github.com/DataRaul/retail-ecommerce_customer-voice-sales-and-behaviour-predictionCopy the install command above and run it in your terminal.
Launch Claude Code, Cursor, or your preferred AI coding agent.
Use the prompt template or examples below to test the skill.
Adapt the skill to your specific use case and workflow.
Act as an e-commerce business intelligence consultant. Analyze the following [DATA] from [COMPANY], an online retailer in the [INDUSTRY] sector. Perform customer segmentation, sentiment analysis, and review processing. Identify sales and behavior patterns. Present findings in a PowerPoint and video format, including an ERD of the database used. Highlight opportunities to improve Customer Success, Sales, Marketing, and Supply Chain.
# E-commerce Customer Insights Analysis ## Executive Summary Based on the analysis of [COMPANY]'s customer data, three distinct segments have been identified: 1. **Loyal Enthusiasts** (35% of customers) - High purchase frequency - Positive sentiment in reviews - Interested in premium products 2. **Budget Conscious Shoppers** (40% of customers) - Price-sensitive - Moderate purchase frequency - Mixed sentiment in reviews 3. **Impulse Buyers** (25% of customers) - Low purchase frequency - Positive sentiment in reviews - Interested in trending products ## Key Findings - **Sales Patterns**: Loyal Enthusiasts contribute to 60% of total sales. - **Behavior Trends**: Budget Conscious Shoppers are most active during sales events. - **Sentiment Analysis**: Overall customer sentiment is positive, with a net promoter score of 75. ## Recommendations - **Customer Success**: Implement a loyalty program for Loyal Enthusiasts. - **Sales**: Target Budget Conscious Shoppers with personalized discounts. - **Marketing**: Create campaigns highlighting customer reviews and testimonials. - **Supply Chain**: Stock more premium products to meet Loyal Enthusiasts' demand. ## ERD Overview The database schema includes tables for Customers, Orders, Products, Reviews, and Segments. Relationships are established to link customer data with their purchase history and reviews.
Take a free 3-minute scan and get personalized AI skill recommendations.
Take free scan