Analytics & Data Insights
You have the data. You just don't know what it means. Shopify gives you endless reports, but it doesn't give you insights. This prompt book turns AI into your Chief Data Officer. It provides the specific queries you need to upload your spreadsheets and get back actionable advice on inventory, pricing, and profitability.
Who This Is For
- Founders who hate Excel but love profit.
- Media buyers analyzing attribution.
- Inventory managers trying to forecast demand.
Pattern Recognition
Humans are bad at spotting trends in 10,000 rows of data. AI excels at it. These prompts guide the AI to look for "Basket Analysis" (what products are bought together?) and "Cohort Analysis" (do customers from Black Friday come back in January?).
Analysis Workflows Included
Uncover hidden profit with prompts for:
- Profitability Audits: Calculating the true net profit after COGS, shipping, and ad spend.
- Bundling Opportunities: "Analyze this CSV and tell me which 2 products are most frequently bought together."
- Churn Prediction: Identifying the time window when a customer is most likely to leave or rebuy.
- Inventory Forecasting: Predicting how much stock you need for Q4 based on last year's Q4 data (with growth adjustments).
- Discount Analysis: Determining if your 20% off coupon actually increased profit or just eroded margins.
Related Prompt Libraries
Next Steps for Data
- Export "Sales by Product": Get the CSV from Shopify Analytics.
- Paste into AI: Use a tool that supports file upload.
- Run the Prompt: "Act as a Data Scientist. Analyze this file and identify the top 20% of products driving 80% of revenue."