-
Customer segmentation:How many customers are from each region? -
Regional performance:What’s the average order total per region? -
Product mix analysis:Which product categories have the highest average price? -
Trend analysis:Find the total revenue generated per month. -
Product performance:List the top 10 products by total sales quantity. -
Customer loyalty / retention:Which customers placed more than 5 orders in the past 6 months? -
Pricing analysis:Find product categories whose average order item discount is greater than 10%. -
Regional target checking:Which regions have generated more than $50,000 in total sales? -
RFM-style segmentation:Identify customers whose average order value is above the overall average. -
Catalog management:Which products have never been sold? -
Regional sales by segment:Find the total revenue per category and region for the last quarter, showing only categories with total revenue above $10,000. -
Cross-category affinity:Which customers bought products from more than 3 categories? -
Promotion performance:Calculate the average discount applied per product category, but only include categories with at least 50 items sold. -
Campaign analysis:Identify the top 5 customers who spent the most during an active promotion period. -
Promo ROI :For each promotion, calculate the total incremental revenue (total sales of that product during the promotion period). -
Post-campaign diagnostic:Find products that had a promotion but still generated less than the average sales of their category. -
Trend evaluation:List regions where the average order value increased month over month. -
Cross-sell / market basket:Find customers who bought both Electronics and Sports products. -
Market penetration:Compute the total number of unique customers per category and identify categories that have at least 40 unique buyers. -
Pricing / margin impact:Find the most discounted products (by total discount amount applied) in each category.