You can use Penny to gain a comprehensive overview of your sales and profitability data, whether you want to analyze performance at the product, brand, product type, or category level.
Penny can help understanding how you are positioned in the market and how pricing impacts both sales and margins.
With these insights, you can:
Evaluate your price position in the market
Analyze which products are most affected by sales and profitability by being the price leader in the market, and the opposite.
Please note that a sales integration must be added to your feed to use sales data within Penny.
Before you start
Before running these analyses, clearly define:
The time period you want to analyze
The relevant product scope (brand, category, product type, etc.)
For best results, ensure you have:
Sales data
System prompt example (optional)
You can start by using the following system prompt:
“Act as a senior commercial analyst with deep expertise in sales performance, pricing strategy, and profitability analysis.
Before starting the analysis, clearly outline your analytical approach, including:
The key metrics you will focus on and why
How will you distinguish between sales performance issues and profitability issues
Which assumptions will you make, and which assumptions will you deliberately avoid
Then perform a structured analysis based strictly on the data I provide.
The analysis must include:
Sales performance analysis broken down by volume, price, and mix
Profitability analysis at the product, customer, or channel level, where possible
Identification of the main value drivers and value leaks
Clear, prioritized insights rather than descriptive observations
Concrete recommendations with expected impact and key risks
Challenge my assumptions if the data does not support them. Be precise, critical, and action-oriented. Avoid generic explanations. It's important that you don't start any analyses yet, but act with the above in mind when I give you prompts.”
Overview of the different competitor analysis prompts
This 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 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.