Español
Resources

Your agent office · Ep. 1, the sales agent

Three prompts to set up Rosa, the agent that reads your sales and tells you what each problem costs you.

Keyword
OFICINA
Type
Agents and business
Published
Contents
3 pieces

Rosa is an agent with your sales data and one job. Three prompts for Claude Code, in this order: you export, analyze and turn what it finds into tasks.

  • Export the orders and, if you can, the cart visits. The CSV from your online store is fine as it is.
  • Don't tell it what to look for. Ask it to compare each group with the rest and say what is out of the ordinary.
Step 1 of 3

Read the data

83 words
In this folder I've left the data from my online shop: [orders.csv] and, if I have it, [carts.csv] with the basket visits.

1. Open them and tell me how many rows and columns each one has, what period they cover and what each column means.
2. Flag anything missing or odd: empty dates, negative amounts, sizes or regions written in different ways.
3. Don't change the original files. If something needs cleaning, do it on a copy and tell me what you changed.
Step 2 of 3

Find what is failing

165 words
Analyse the sales the way an experienced analyst would and tell me what we're doing wrong. I don't know what you'll find, so don't stop at the obvious. Write the analysis as a script so it can be run again.

At the very least, check:
- Products that stop selling for several days in a row (possible stockout) and how much in sales was lost.
- Returns by product and by size compared with the shop average, and the most common reason.
- Delivery times by region and from which day they get worse.
- The checkout funnel: at which step customers leave, by device, channel and payment method, and whether something started failing on a specific day.
- Coupons or discounts used by people who shouldn't have them.

For each problem give me: what's happening, since when, the figure that proves it and how much it costs per month. Sort them from most to least expensive. If a figure is an estimate, say so.
Step 3 of 3

From the report to tasks

86 words
With what you've found:

1. Make me a report as an HTML page: key figures at the top, a chart of revenue by day marking where the problems are, and the list of problems with their cost.
2. Below it, a task list: what needs to be done about each problem, who should do it (shop, development, logistics, customer service) and which figure we'll check to know it's fixed.
3. Draft the message you'd send to each owner, short and with just the data they need.

From the Reel “A day at our agent office · Ep. 1”

The store in the video is made up. We generated its orders with five hidden problems and the analysis found them without knowing which they were.

Watch the Reels on Instagram