 | The Operator's Log No. 006 · Oct 9, 2026 |
The monthly sales report, on autopilot.
The exact setup my AI employee uses for a client's online store. Paste the prompt and yours does it too.
$39.9K August | $63.1K September |
September was up 58% from August and 21% from last September.
WHAT IT PULLED FOR SEPTEMBER
- $63,058 in sales from 46 orders
- 1,264 units sold, average order $1,172
- Top seller alone brought in $29,689
- 27 orders came from brand-new customers
WHY THE STORE, NOT GOOGLE ANALYTICS
Google Analytics was never set up to record sales on this store. The store's own order records are the real numbers. Check your tracking before you trust a dashboard.
WHAT IT DOES
- Pulls every order from last month, straight from the store
- Compares it to the month before and the same month last year
- Builds a one-page PDF with a simple chart
- Drafts a short email to the client and waits for a person to approve it
THE PROMPT
Viktor, connect to my online store (WooCommerce or Shopify).
On the 1st of every month at 9am:
1. Pull every order from last month: total sales, orders, units, average order, top 3 products, new vs returning customers.
2. Compare it to the month before and the same month last year.
3. Build a one-page PDF report with a simple bar chart.
4. Draft a short, friendly email to [owner or client] with the 5 headline numbers and the PDF attached.
5. Post it all to me in Slack. Do not send anything until I approve it.
YOUR TURN
Viktor connects to your store and sends you this report on the 1st of every month. Paste the prompt above to set it up.
Talk next week,
Scott
Written by Scott Bishop, founder of Up And Social, a family and estate planning law marketing agency. Sponsored by Viktor, the AI employee behind every workflow here. Affiliate link: I earn a referral fee and would recommend it either way. |