questions.yml

- report: sales_by_traffic_referrer 
  questions:
  - Which referrer source created the most sales in 2024?
  - What was the Sales generated by referrer source email in 2023?
- report: average_order_value 
  questions:
  - Which month and day had the highest order value?
  - Which month and day had the lowest order value?
  - How did the average order value change over 2023?
  - What is the growth of average order value between 2023 and 2024?
- report: sales_by_product 
  questions:
  - Which product sold the most in the last 6 months?
  - Which product sold the least in 2024?
  - How did the sales of Moon Dust change over 2023?
  - What where the sales of Arabian Desert in August 2024?
  - Which product sold the most quantity in 2023?
  - Which product sold the least quantity in 2023?
  - Which product has the most discount? 
  - Which product has the least discount?
  - Which product had the most returns?
  - Which product had the most net sales after discounts?
- report: sales_by_customer_name 
  questions:
  - What where the sales of Customer Aya Elsherbiny over 2023?
  - How many orders did Aya Elsherbiny make in the last quarter of 2023?
  - Which customer has the most sales in period 2024?
  - Which customer has the least sales in period 2024?
  - How did the sales of Aya Elsherbiny change over 2023 and 2024?
- report: sales_by_product_vendor
  questions:
  - Which product vendor sold the most in 2023?
  - Which product vendor sold the least Jan-June 2023?
  - How did the sales of vendor Worood change from 2023 to 2024?
  - What where the sales of product vendor Worood in the last 6 months?
  - Which product vendor sold the most quantity in 2023?
  - Which product vendor sold the least quantity in 2023?
  - Which product vendor has the most discount?
  - Which product vendor has the least discount?
  - Which product vendor had the most returns?
  - Which product vendor had the most net sales after discounts?
- report: sales_by_product_variant 
  questions:
  - Which product variant SKU sold the most in 2023?
  - Which product variant SKU sold the least in 2023?
  - How did the sales of product SKU PL-Pink-Modal change over 2023?
  - What where the sales of product SKU PL-Pink-Modal in 2023?
  - Which product SKU sold the most quantity in 2024?
  - Which product SKU sold the least quantity in 2024?
  - Which product SKU has the most discount?
  - Which product SKU has the least discount? 
  - Which product SKU had the most returns? 
  - Which product SKU had the most net sales after discounts? 
- report: sales_by_discount
  questions:
  - Which discount name had the most net sales?
  - Which discount name had the least net sales?
  - Which discount type had the most net sales?
  - Which discount type had the least net sales?
  - Which discount class had the most net sales?
  - Which discount class had the least net sales?
  - Which discount method had the most net sales?
  - Which discount method had the least net sales?
  - Which discount name had the most orders?
  - Which discount name had the least orders?
  - Which discount type had the most orders?
  - Which discount type had the least orders?
  - Which discount class had the most orders?
  - Which discount class had the least orders?
  - Which discount method had the most orders?
  - Which discount method had the least orders?
  - Which discount name had the most discount?
  - Which discount name had the least discount?
  - Which discount type had the most discount?
  - Which discount type had the least discount?
  - Which discount class had the most discount?
  - Which discount class had the least discount?
  - Which discount method had the most discount?
  - Which discount method had the least discount?
  - How did the discount name X change 2023?
  - How did the discount method X change 2023?
  - How did the discount type X change 2023?
  - How did the discount class X change 2023?
- report: sales_by_checkout_currency 
  questions:
  - Which currency had the most sales in 2023?
  - Which currency had the least sales in 2023?
  - Which currency had the most orders in 2023?
  - Which currency had the least orders in 2023?
  - How much sales were made in EGP in 2023?
  - How many orders were made in USD?
  - did the orders and sales by EGP change over 2023?
- report: sales_by_channel # TESTED
  questions:
  - Which sales channel sold the most in 2023?
  - Which sales channel sold the least in 2023?
  - How did the sales of sales channel web change over 2023?
  - What where the sales of channel web in 2023?
  - Which sales channel sold the most quantity in 2023?
  - Which sales channel sold the least quantity in 2023?
  - Which sales channel has the most discount?
  - Which sales channel has the least discount?
  - Which sales channel had the most returns? 
  - Which sales channel had the least returns?
  - Which sales channel had the most net sales after discounts?
- report: sales_by_billing_location 
  questions:
  - Which location sold the most in 2023?
  - Which location sold the least in 2023?
  - How did the sales of location Egypt change over 2023?
  - What where the sales of location Egypt 2023?
  - Which location sold the most quantity in 2023?
  - Which location sold the least quantity in 2023?
  - Which location has the most discount? 
  - Which location has the least discount? 
  - Which location had the most returns?
  - Which location had the most net sales after discounts?
- report: profit_by_product_variant 
  questions:
  - Which product variant SKU had the highest gross margin?
  - What is the gross margin of product variant SKU PR-Emerald-Queen-Modal?
  - how did the gross margin of product variant SKU PR-Emerald-Queen-Modal change
    over 2023 and 2024?
- report: profit_by_product 
  questions:
  - Which product had the highest gross margin?
  - What is the gross margin of product Emerald Queen?
  - how did the gross margin of product Emerald Queen change over 2023?
- report: sales_attributed_to_marketing 
  questions:
  - Which marketing channel sold the most in 2023?
  - Which marketing channel sold the least in 2023?
  - What where the sales of marketing channel https://l.instagram.com/ in 2023?
  - Which marketing channel had the most orders in 2023?
  - Which marketing channel had the least orders in 2023?
  - Which marketing channel has the most discount? 
  - Which marketing channel has the least discount?
  - How did the sales of marketing channel https://l.instagram.com/ change over 2023?
  - How did the number orders of marketing channel https://l.instagram.com/ change over 2023?
- report: sessions_attributed_to_marketing 
  questions:
  - Which marketing channel had the most visitors in 2023?
  - Which marketing channel had the least visitors in 2023?
  - Which marketing channel had the most sessions in 2023?
  - Which marketing channel had the least sessions in 2023?
  - Which marketing channel had the most sessions converted in 2023?
  - Which marketing channel had the least sessions converted in 2023?
  - Which referring channel had the most visitors in 2023?
  - Which referring channel had the least visitors in 2023?
  - Which referring channel had the most sessions in 2023?
  - Which referring channel had the least sessions in 2023?
  - Which referring channel had the most sessions converted in 2023?
  - Which referring channel had the least sessions converted in 2023?
  - What where the sessions of marketing channel https://l.instagram.com/ in 2023?
  - What where the converted sessions of marketing https://l.instagram.com/ in 2023?
  - How did the sessions of marketing channel https://l.instagram.com/ change over 2023?
  - How did the visitors of marketing channel https://l.instagram.com/ change over 2023?
  - How did the converted sessions of marketing channel https://l.instagram.com/ change over 2023?
- report: sessions_by_location 
  questions:
  - Which country had the most visitors in 2023?
  - Which country had the least visitors in 2023?
  - Which country had the most sessions in 2023?
  - Which country had the least sessions in 2023?
  - Which region had the most visitors in 2023?
  - Which region had the least visitors in 2023?
  - Which region had the most sessions in 2023?
  - Which region had the least sessions in 2023?
  - Which city had the most visitors in 2023?
  - Which city had the least visitors in 2023?
  - Which city had the most sessions in 2023?
  - Which city had the least sessions in 2023?
  - What where the sessions from country Egypt in 2023?
  - What where the sessions from region Giza in 2023?
  - What where the sessions from city Cairo in 2023?
  - What where the visitors from country Egypt in 2023?
  - What where the visitors from region Giza in 2023?
  - What where the visitors from city Cairo in 2023?
  - How did the sessions of country Egypt change over 2023?
  - How did the sessions of region Giza change over 2023?
  - How did the sessions of city Cairo change over 2023?
  - How did the visitors of country Egypt change over 2023?
  - How did the visitors of region Giza change over 2023?
  - How did the visitors of city Cairo change over 2023?
- report: sessions_over_time
  questions:
  - Which time period had the most visitors?
  - Which time period had the least visitors?
  - Which Which time period had the most sessions?
  - Which Which time period had the least sessions?
  - What where the visitors in 2023?
  - What where the sessions in 2023?
  - How did the number of sessions change over 2023?
  - How did the number of visitors change over 2023?