This article explains how you can use Penny for sales performance & profitability analysis in your day-to-day work. Each section below includes a table with:
Prompt: Example questions or instructions you can ask Penny
Requirement: The data needed for Penny to provide a reliable answer
Value Group: The business area or use case the prompt supports
Use these examples as inspiration and adapt them to your own workflows and data setup.
Sales Performance & Profitability
Explore sales trends, revenue drivers, and profitability across products, categories, or time periods. Penny can help you explain changes in performance and highlight areas that need attention.
Sales Data
Prompt | Requirement | Value Group |
Generate a 6-month sales performance report broken down by category, brand, and SKU. | Performance data |
|
Which brands contribute most to conversion rates and gross profit? | Performance data |
|
Highlight the top 20 SKUs with the highest sales growth and the bottom 20 with the sharpest decline over the last 90 days. | Performance data |
|
Identify my top 25 high-traffic products with low conversion rates and explain potential causes. | Performance data |
|
Analyze the relationship between price changes and sales performance over time. | Performance data |
|
Which product categories generate the highest revenue per visitor? | Performance data |
|
How much of our total sales are driven by our top 50 products? | Performance data |
|
Identify all products where we have stock, our price is the absolute lowest (no ties), the product sold at least 20 units in the last 90 days, and at least 4 competitors sell the same product. For these products, calculate the financial uplift if we raise the price to 2% above the cheapest competitor currently in stock. | Performance data |
|
Find products where we are the undisputed lowest price (no ties) with more than 4 competitors and at least 20 sales in the last 90 days. Calculate the financial uplift possible by raising the price to be 5% cheaper than the second-cheapest competitor currently in stock. | Performance data |
|
Looking back over the last 30 days, which products have generated the most profit? | Performance data |
|
Identify the 20 worst-converting products for the current month with at least 15 page views. Include page views, conversion rate, units sold, and current stock level. | Performance data |
|
Identify all products from Brand X and Brand Y where less than 20% of available stock was sold in the last 90 days, and there is a high risk of excess inventory. Include stock level, sell-through percentage, and excess inventory risk. | Performance data |
|
Create a list of products in Product Category X with high inventory value and sell-through below 25% over the last 90 days. Include stock quantity, inventory value, sell-through percentage, and excess inventory risk. | Performance data |
|
Analyze the top 30 products from Brand X where sales are underperforming compared to the same period last year (based on the last 90 days). Include current vs. last-year sales, growth/decline percentage, current stock level, and inventory risk. | Performance data |
|
Need help?
Contact your Customer Success Manager if you’d like to learn more about Penny or need guidance on how to use it.
Learn more about how to get access here.