Global Finalist2026 Amazon Ads Partner Awards

Developer API · Prompt library · 01 of 10

Weekly client report in Slack

Every Monday, each client gets spend, sales, ACoS and the three biggest movers, in the channel they already read.

Key scope
RRead-only key
Build time
30 to 45 minutes
Stack
Python script on a weekly cron, posting to a Slack incoming webhook

For: Agencies that still assemble Monday reports by hand.

Paste this into Claude, ChatGPT or Cursor

Read https://www.sellermate.ai/api-docs first. It documents the SellerMate Public API: REST over HTTPS, X-API-Key auth, and every tool with its parameters is on that page. Every tool is POST https://api.sellermate.ai/public/v1/tools/{name} with a JSON body.

Build me a weekly client report that runs every Monday at 8am and posts one Slack message per Amazon account.

Each message should show, for the last 7 days versus the 7 before:
- Spend, sales, ACoS and orders, with the percentage change
- The three campaigns whose spend or ACoS moved most, with the numbers
- A one-line plain-English summary a client can read in ten seconds

Use get_user_context to list accounts, get_marketplace_summary for the account totals, and get_campaign_performance with sort_field set to cost for the movers. Post to the Slack webhook in SLACK_WEBHOOK_URL. Give me a --dry-run flag that prints the messages instead of posting.

[Optional: only include accounts whose name contains "Client".]

Rules:
- My key is in the SELLERMATE_API_KEY environment variable. Send it as the X-API-Key header. Never hard-code it or log it.
- Call get_user_context first and use the accounts it returns. Don't invent account ids.
- Report tools are paginated (page, page_size up to 500, pagination.hasMore). Walk every page.
- On a 429, wait for the Retry-After header and retry. On a 401 or 403, stop and tell me.
- Show me the plan and the code before running anything that writes.

Stack: Python 3 with requests, no framework. Include a README with the cron line.

Fill in anything in [brackets] before you paste, or leave it and the assistant will ask. The first line sends it to the docs, where every tool is listed.

What you get

  • One Slack message per client account every Monday, no login needed
  • Week-over-week spend, sales, ACoS and orders with percentage changes
  • The three biggest campaign movers, so the message answers "what changed"
  • A dry-run flag to preview before it posts

Before you paste

  • A read-only key is enough. Create one from Profile → API Keys and limit it to client accounts if you like.
  • Set SLACK_WEBHOOK_URL to an incoming webhook for the channel you want.
  • Run it with --dry-run once to check the numbers against SellerMate before trusting the cron.

Make it yours

Once it works, ask the assistant for one of these.

  • Send one message per client to their own channel instead of one channel for all.
  • Add TACoS using get_retail_product_performance for total sales.
  • Post to WhatsApp or email instead of Slack.
Book Demo