PromptBase
🤖 GPT
Automaticaly extract important features for doing business analysis from a snippet of a dataset.
...more
$3.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago
Prompt Details
Model
Completion - GPT-3.5 (text-davinci-003)
Token size
969 ($0.01940 / call)
Example input
{
"products": [
{"product_id": 1, "product_name": "Moisturizer", "description": "A hydrating moisturizer for all skin types", "price": "$24.99", "number_of_orders": 500, "margin": "20%"},
{"product_id": 2, "product_name": "Serum", "description": "A rejuvenating serum to reduce fine lines and wrinkles", "price": "$34.99", "number_of_orders": 300, "margin": "25%"},
{"product_id": 3, "product_name": "Cleanser", "description": "A gentle foaming cleanser for sensitive skin", "price": "$19.99", "number_of_orders": 250, "margin": "15%"},
{"product_id": 4, "product_name": "Eye Cream", "description": "An anti-aging eye cream to reduce puffiness and dark circles", "price": "$29.99", "number_of_orders": 200, "margin": "20%"},
{"product_id": 5, "product_name": "Sunscreen", "description": "A broad-spectrum sunscreen with SPF 30", "price": "$14.99", "number_of_orders": 150, "margin": "10%"},
{"product_id": 6, "product_name": "Toner", "description": "A refreshing toner to balance skin's pH", "price": "$17.99", "number_of_orders": 100, "margin": "12%"},
{"product_id": 7, "product_name": "Face Oil", "description": "A nourishing face oil for dry skin", "price": "$39.99", "number_of_orders": 75, "margin": "30%"},
{"product_id": 8, "product_name": "Face Mask", "description": "A detoxifying clay mask for all skin types", "price": "$24.99", "number_of_orders": 125, "margin": "18%"},
{"product_id": 9, "product_name": "Body Lotion", "description": "A lightweight body lotion with shea butter and aloe vera", "price": "$19.99", "number_of_orders": 300, "margin": "15%"},
{"product_id": 10, "product_name": "Hand Cream", "description": "A moisturizing hand cream with vitamin E and jojoba oil", "price": "$9.99", "number_of_orders": 200, "margin": "10%"},
{"product_id": 11, "product_name": "Lip Balm", "description": "An ultra-moisturizing lip balm with SPF 15", "price": "$7.99", "number_of_orders": 150, "margin": "8%"},
{"product_id": 12, "product_name": "Shampoo", "description": "A volumizing shampoo with biotin and keratin", "price": "$14.99", "number_of_orders": 100, "margin": "12%"},
{"product_id": 13, "product_name": "Conditioner", "description": "A nourishing conditioner with argan oil and jojoba", "price": "$16.99", "number_of_orders": 75, "margin": "15%"}]}
Example output
Metrics that can be retrieved from the full json:
- Total number of products
- Average price of products
- Average number of orders per product
- Average margin per product
- Total number of orders
- Total revenue
- Total margin
- Average revenue per product
- Average margin per product
- Average price per order
- Average margin per order
- Average revenue per order
- Average revenue per margin
- Average margin per revenue
- Ratio of orders to products
- Ratio of revenue to margin
- Ratio of margin to revenue
- Ratio of orders to revenue
- Ratio of orders to margin
- Ratio of revenue to orders
- Ratio of margin to orders
- Most popular product (by number of orders)
- Most profitable product (by margin)
- Least popular product (by number of orders)
- Least profitable product (by margin)
- Most expensive product
- Cheapest product