Analyze Weekly Sales Data and Spot Trends
Use this prompt weekly after exporting sales data from Square, Shopify, or a Google Sheet. Paste the prompt first, then paste your copied sales data directly below it in the same message to get a plain-language weekly sales report.
The Prompt
I run a [type of business — e.g., retail gift shop, coffee shop, online apparel store]. The data below covers sales from [start date] to [end date]. Please analyze this data and tell me: 1. Total revenue for the week and how it compares to any prior period in the data 2. My top 5 products or services by total revenue 3. My 3 slowest-selling products or services 4. Which day of the week had the highest and lowest sales 5. Average transaction value 6. Any refunds or voids and their total value 7. One thing I should consider changing based on this data Format your response as a bullet-point summary I can read in under 3 minutes. Do not include customer names or personal information in your response. [Optional: Note any promotions or unusual events that week, e.g., "We ran a 20% off sale on Thursday."] [PASTE YOUR SALES DATA HERE]
From the guide
How to use AI to build a simple weekly report from your sales data that tells you what's working and what isn't →Related Prompts
Write a Grant Application Budget Justification
Use this prompt to draft the budget justification section of a grant application. Replace the placeholders with your actual requested amount and itemized costs before running it.
Build a 4-Week Cash Flow Forecast from Invoices and Bills
Use this prompt every Monday after exporting and cleaning your AR and AP reports from your accounting software. Paste your cleaned data above the prompt, then paste the prompt itself to generate a 4-week cash flow forecast, a risk summary, and a list of overdue invoices to chase.
Rewrite Price Increase Letter for a Trade Business
Use this as a follow-up instruction when the AI's draft sounds too corporate or formal for a trade or hands-on service business. Swap in your own business type as needed.
Shorten a Price Increase Letter Draft
Use this as a follow-up instruction when the AI's first draft of the price increase letter is too long and needs to be trimmed.