Extract hidden product flaws, feature requests, and top praised benefits from raw batches of customer reviews
Customize Prompt Variables
Type your specific product details or store requirements into the fields below. Watch your customized prompt update automatically in the right pane.
You are a Chief Product Officer and Customer Experience Analyst for a high-volume Shopify e-commerce brand. We need to extract actionable business intelligence from raw batches of customer reviews to improve our physical product design, update customer support guidelines, and extract winning quotes for ad copy. ### PRODUCT: Smart Heated Travel Coffee Mug 14oz with App Temperature Control ### RAW CUSTOMER REVIEWS BATCH: 1. "Love that it keeps my coffee at exactly 140 degrees during my 1 hour commute! But the charging coaster cord is way too short, barely reaches my desk outlet." - 4 stars 2. "Best mug ever. Battery lasts about 75 minutes on high heat which is perfect for my morning meeting. App paired instantly with iPhone." - 5 stars 3. "The matte black finish started scratching off around the rim after 3 weeks of hand washing. Still works great but looks worn." - 3 stars 4. "Incredible gift for my husband. He uses it every single day. Wish the lid had a completely leak-proof lock instead of just a slider." - 5 stars 5. "Coffee tastes way better than microwaving when it cools down. Only complaint is the charging pad feels lightweight and slips around." - 4 stars ### YOUR ASSIGNMENT: Analyze the reviews above and produce a structured Customer Intelligence Report: 1. **Executive Sentiment Breakdown**: - Provide an overall sentiment score out of 10 and a brief summary of the emotional consensus of verified buyers. 2. **Top 3 Praised Benefits (The "Ad Copy Goldmine")**: - What exact outcomes do customers love most? List the top 3 and include exact, compelling verbatim customer phrases that we should put into our Facebook/TikTok ad headlines right now. 3. **Top 3 Frustrations & Product Flaws (Action Items for Manufacturing)**: - What exact defects, design shortcomings, or friction points are costing us 5-star ratings? Provide specific engineering/design recommendations to fix each. 4. **Quick Support & FAQ Updates Needed**: - Based on customer confusion or common issues in these reviews, what 2 specific clarifying points should we immediately add to the product page description and support knowledge base?
How to Use This Prompt
- 1
Export or copy a batch of raw customer reviews from your Judge.me, Loox, Yotpo, or Shopify Reviews app.
- 2
Paste them into the reviews box and run in Claude to get immediate product and ad insights.
Run directly inside Claude Code
If you have installed our Shopify AI Toolkit scopes, Claude can connect directly to your Shopify store via GraphQL. Paste this customized prompt into your terminal and let Claude read/write products, metafields, or theme files autonomously.
Explore More AI Prompts
Discover related Claude workflows for Store Operations and beyond.
Helpdesk & AI Chatbot Knowledge Base Structuring Builder
Convert messy shipping and return policies into structured knowledge base rules for Gorgias, Zendesk, and AI chatbots
AI customer support agents and human agents need structured, unambiguous policy logic. This prompt converts raw store policies into exact decision trees and macro templates.
Shopify Discount & Margin Protection SKU Modeling Prompt
Model complex BOGO, bundle, and tiered discounting scenarios across your SKUs to prevent accidental negative profit margins
Aggressive discounting during sales can silently wipe out profitability. This prompt analyzes SKU costs, shipping fees, and discount codes to verify net margin safety before launching sales.
SEO Product Title & Meta Description Optimizer
Turn thin vendor copy into high-ranking, keyword-targeted product titles and descriptions tailored for Google & organic CTR
Ideal for dropshipping imports and new SKUs. Researches search intent, formats high-conversion H1 titles, and writes clean HTML body descriptions with scannable bullet points.
Want us to install these Claude workflows directly on your Shopify store?
We configure the Shopify AI Toolkit scopes, connect Claude Code sessions, build custom Liquid sections, and train AI assistants on your exact brand voice.