You don’t need a big marketing team or expensive tools to figure out what’s working in your business. You likely already have the data. Now you can use ChatGPT to turn that data into a short weekly report that shows what’s performing, what’s not, and what to try next.
According to Thryv Holdings, Inc.’s 2025 survey of small businesses, AI use among small businesses has grown from 39 % in 2024 to 55 % in 2025. Among AI users, 62 % say they are using it for data analysis. That means you and your business are not behind. You are in step with a trend.
This guide will show you how to:
- Gather your marketing and sales data
- Feed it into ChatGPT
- Use a ready-to-copy prompt
- Review and act on the results
Step 1: Gather Your Marketing Data
Start with what you already track. Collect your sales and marketing numbers for the week. Here’s where you can look:
- Point of Sale (POS): Export your weekly sales summary from Square, Clover, or the system you use. Capture total sales, bestselling items, repeat customer counts.
- Website Analytics: In Google Analytics check traffic, referral sources, and conversion pages.
- Ad Platforms: In Meta Ads Manager (Facebook/Instagram) export data on impressions, clicks, cost per result.
- Email Campaigns: From Mailchimp or your email tool check open rates, click-through rates, unsubscribe trends.
Download your data if you can (often as a CSV file) or copy the key numbers into a spreadsheet. Try to cover one full week so you have a consistent period for comparison.
Step 2: Use ChatGPT (Free Tier or Paid)
Open ChatGPT and upload your data or paste it in. Official documentation from OpenAI shows that file uploads are now available to Free users but with stricter usage limits than paid plans. ChatGPT Paid Plan Help
What that means for you:
- If you are using the free version: You can upload files, but you may hit daily limits or other usage restrictions.
- If you subscribe (for example ChatGPT Plus): You’ll get higher usage limits and more flexibility for file uploads and analysis.
- In either case: Before you upload make sure your file does not contain customer names or personal identifiers. You want the marketing metrics only.
Step 3: Copy This Prompt
Here is a prompt you can paste into ChatGPT each week after uploading or pasting your data:
You are my marketing data assistant. I’ve uploaded my weekly marketing and sales data from my small business. Please analyze it and give me a short, conversational summary that includes:
- What marketing channels or campaigns brought in the most customers
- Which sources performed the best
- Where ad spend under-performed
- Clear suggestions on what to expand and what to consider stopping next week
Keep it simple and conversational, like you are explaining it to a busy small business owner who just wants to know what is working and what is not.
Paste this prompt, then let ChatGPT do the rest. Within seconds you’ll get a summary: your best channels, weak spots, and actions to try next week.
Step 4: Review and Act on the Report
When you receive the summary from ChatGPT:
- Highlight what’s working and keep doing it.
- Note what’s under-performing and either fix it, reduce spend, or pause it.
- Choose one or two of ChatGPT’s suggestions and test them next week.
- Repeat this weekly. Over time you’ll start to spot patterns and make more informed marketing decisions.
Why This Matters
You do not need a large analytics team. With ChatGPT you can get insights from your data each week just like larger companies do but without hiring an analyst.
This routine of exporting data, uploading or pasting it into ChatGPT, running the prompt, and acting on the insights can make your marketing clearer, faster, and more effective.
The time you save can go into growing your business instead of sorting through spreadsheets.
Start this week.
Download your most recent sales or ad report, upload or paste it into ChatGPT, use the prompt above, and see what your numbers are really saying.
