Dynamic Pricing Strategy Modeler
Use this prompt to
Build a pricing analysis workflow that ingests your product catalog, cost structure, competitor pricing, and demand elasticity estimates to recommend optimal price points, bundling strategies, and promotional discount guardrails.
Pro tip
Use Code Interpreter to generate price sensitivity charts. Always include a minimum-margin floor constraint to prevent the model from recommending unsustainable prices. Test with A/B scenarios.
Prompt Variants by Model
Claude
Claude 4.x
FRESH APR 2026
You are a pricing strategist and revenue optimization consultant. Analyze my product catalog and recommend an optimal pricing strategy.
<product_data>
[PASTE PRODUCT CATALOG: Name, Current Price,...You are a pricing strategist and revenue optimization consultant. Analyze my product catalog and recommend an optimal pricing strategy.
<product_data>
[PASTE PRODUCT CATALOG: Name, Current Price, COGS, Monthly Units Sold, Category]
</product_data>
<competitive_context>
Top competitors and their pricing: [LIST]
Market positioning: [PREMIUM / MID-MARKET / VALUE]
Price sensitivity observations: [ANY KNOWN ELASTICITY DATA OR CUSTOMER FEEDBACK]
</competitive_context>
<constraints>
Minimum gross margin: [X]%
Maximum price increase tolerance: [X]% (without losing significant volume)
Strategic goals: [MARKET SHARE / MAXIMIZE MARGIN / PENETRATION]
</constraints>
Deliver:
1. **Price audit:** For each product, flag if it is underpriced, overpriced, or well-positioned vs. competitors and margins
2. **Optimal price recommendations:** New price per product with expected margin impact and volume sensitivity estimate
3. **Bundling strategy:** Identify 3 product bundles that increase AOV with suggested bundle pricing
4. **Promotional guardrails:** Maximum discount percentages per product that maintain profitability
5. **A/B test plan:** 3 pricing experiments to validate recommendations before full rollout
6. **Revenue impact projection:** Estimated monthly revenue change if recommendations are implemented
Show all margin calculations. Flag any recommendation where confidence is low due to insufficient data.
Notes: Upload your product catalog as CSV for cleaner parsing. Claude's reasoning transparency builds trust in pricing recommendations.
ChatGPT
GPT-5
FRESH APR 2026
You are a pricing optimization consultant. Analyze my product catalog and build a pricing strategy.
**Product Data:** [PASTE: Name, Price, COGS, Units/Month,...You are a pricing optimization consultant. Analyze my product catalog and build a pricing strategy.
**Product Data:** [PASTE: Name, Price, COGS, Units/Month, Category]
**Competition:**
- Competitors and prices: [LIST]
- Our positioning: [PREMIUM/MID/VALUE]
- Price sensitivity notes: [DESCRIBE]
**Rules:**
- Minimum margin: [X]%
- Max price hike customers will tolerate: [X]%
- Goal: [MARKET SHARE / MARGIN / PENETRATION]
**Analyze and deliver:**
1. Price audit: flag under/over-priced products vs. competitors and margins
2. Recommended new prices with margin impact and volume sensitivity
3. 3 product bundles to increase AOV (suggest bundle prices)
4. Promotional guardrails: max discounts per product that stay profitable
5. 3 A/B test plans to validate pricing changes
6. Revenue impact projection
Use Code Interpreter for calculations and charts. Show your math.
Notes: Upload product data as CSV. Code Interpreter generates margin analysis charts and sensitivity curves.
Gemini
Gemini 3 Pro
FRESH APR 2026
I need help optimizing the pricing for my product catalog.
**My products:** [PASTE: Name, Current Price, Cost, Monthly Units Sold, Category]
**Competitive...I need help optimizing the pricing for my product catalog.
**My products:** [PASTE: Name, Current Price, Cost, Monthly Units Sold, Category]
**Competitive landscape:**
- Competitors and their prices: [LIST]
- Where we sit in the market: [PREMIUM/MID-MARKET/VALUE]
- What we know about customer price sensitivity: [DESCRIBE]
**My constraints:**
- Minimum margin I need: [X]%
- Most I can raise prices without losing customers: [X]%
- My goal: [MARKET SHARE / MAXIMIZE PROFIT / GROW FAST]
**Please provide:**
1. A price audit — which products are underpriced or overpriced?
2. Recommended new prices with expected impact on margins and volume
3. 3 bundle ideas to increase average order value
4. Maximum safe discount per product for promotions
5. 3 pricing experiments to test before committing
6. Total projected revenue impact
Show your calculations.
Notes: Gemini can research competitor pricing in real-time via web grounding.
Copilot
Copilot (Microsoft 365)
FRESH APR 2026
I want to make sure I am pricing my products right. Help me analyze and optimize my pricing.
**My products:** [PASTE: Product Name, Current Price, What It Costs Me, How Many...I want to make sure I am pricing my products right. Help me analyze and optimize my pricing.
**My products:** [PASTE: Product Name, Current Price, What It Costs Me, How Many I Sell Per Month]
**My competitors:** [LIST NAMES AND THEIR PRICES]
**Where we fit:** [ARE WE PREMIUM, MIDDLE, OR BUDGET?]
**What I have noticed about price sensitivity:** [DESCRIBE]
**My rules:**
- I need at least [X]% margin on everything
- I do not want to raise prices more than [X]%
- My main goal is: [MORE CUSTOMERS / MORE PROFIT / BOTH]
**Tell me:**
1. Which products are priced wrong (too high or too low)?
2. What should each product cost instead and what that does to my margins?
3. 3 product bundles I could offer to get people to spend more
4. How much I can safely discount during sales
5. 3 ways to test new prices before committing
6. How much more money I could make with these changes
Notes: Copilot in Excel processes the product data natively.
Need Something Similar?
Request a prompt tailored to your specific use case.