Expected output
The deliverable should include Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, and Expand or discontinue recommendation.
IntermediateData, Profit & Decision AI
Product and Category Analytics | Diagnostic Analysis Prompt
Product and Category Analytics | Diagnostic Analysis Prompt is a copyable AI prompt for ecommerce sellers. Use it to evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase from verified business inputs. Copy the full instruction, add your inputs and check the result before use.
- Views
- 0
- Uses
- 0
- Favorites
- 0
How the Product and Category Analytics | Diagnostic Analysis Prompt works
Evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase from verified business inputs. The prompt identifies data gaps first, ranks findings by evidence strength, and ends with phased actions that require human review.
Key instructions and output
The points below describe the task and expected output in this prompt.
Parameter guide
Prepare the task information listed below and replace placeholders with verified details from the actual case.
[SKU sales]
Replace this placeholder with verified, task-specific information before running the prompt.
[Cost]
Replace this placeholder with verified, task-specific information before running the prompt.
[Inventory]
Replace this placeholder with verified, task-specific information before running the prompt.
[Returns]
Replace this placeholder with verified, task-specific information before running the prompt.
[Advertising and basket data]
Replace this placeholder with verified, task-specific information before running the prompt.
Copy the complete prompt
The complete source is shown below. Copy it from the top right to use it.
You are an ecommerce assortment and profitability analyst. Your objective is to evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase. Analyze the following real inputs: [SKU sales], [Cost], [Inventory], [Returns], [Advertising and basket data]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, Expand or discontinue recommendation; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Do not rank only by revenue. Include contribution profit, cash tied up, returns, and strategic role.Test this prompt on a real task
Copy a starter instruction, add the required inputs, then run one example and review the output.
01Product and Category Analytics | Diagnostic Analysis Prompt
The deliverable should include Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, and Expand or discontinue recommendation. Diagnose product and category analytics issues and prioritize evidence-backed action
Show prompt and variablesHide prompt and variables
Product and Category Analytics | Diagnostic Analysis Prompt
The deliverable should include Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, and Expand or discontinue recommendation. Diagnose product and category analytics issues and prioritize evidence-backed action
You are an ecommerce assortment and profitability analyst. Your objective is to evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase. Analyze the following real inputs: [SKU sales], [Cost], [Inventory], [Returns], [Advertising and basket data]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, Expand or discontinue recommendation; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Do not rank only by revenue. Include contribution profit, cash tied up, returns, and strategic role.Inputs to replace in this prompt
[SKU sales]- Replace this placeholder with verified, task-specific information before running the prompt.
[Cost]- Replace this placeholder with verified, task-specific information before running the prompt.
[Inventory]- Replace this placeholder with verified, task-specific information before running the prompt.
[Returns]- Replace this placeholder with verified, task-specific information before running the prompt.
[Advertising and basket data]- Replace this placeholder with verified, task-specific information before running the prompt.
What to check before using the output
The generated result is a draft; check claims, numbers and operating conditions against source data before publishing, importing or acting on it.
Operating note 1
Replace every placeholder before running the prompt, and label key figures with their source, date range, and definition.
Operating note 2
Do not rank only by revenue. Include contribution profit, cash tied up, returns, and strategic role.
Operating note 3
Before uploading order, customer, contract, or supplier data, redact sensitive information and comply with platform terms, privacy policies, NDAs, and company data-governance requirements. Have the responsible operator review the result before it is published, sent, or executed.
Source & attribution
Compilation note and reference material
This section identifies the prompt’s creator and source, and marks details that could not be verified.
Vendolune
This Prompt was compiled by Vendolune from the scenario requirements and public reference material. The reference-page author is not credited as this Prompt's author.
Reference materialGraas
This link is reference material and does not establish its page author as the author of this Prompt. The article offers prompts for ecommerce data analysis and recommends starting with an overall diagnosis before narrowing into products, channels, cohorts, and time periods.
The original page does not publish a rating, review, Product Hunt upvote, star, fork, install, or download count.
Content checked:
No reviews yet.