MonitoringanalysisloopShippedVerified by us

Weekly Sales Retro

Closed week → comparison with the previous period

A robot compares indicators of two weeks and highlights a sales anomaly

In short

To understand the week's dynamics, one has to manually collect indicators and recall past values.

Outcome

A read-only process calculates several key indicators, compares them with the last completed week, and highlights anomalies.

How the automation runs

Trigger

A full calendar week has ended

Automation steps

  1. Read data only for the completed period
  2. Calculate an agreed set of indicators
  3. Compare with the snapshot of the previous period
  4. Compile a short card with changes and anomalies

Human check

The owner checks anomalies and decides if actions are needed; the process does not change sales, prices, or campaigns.

Outcome

A read-only process calculates several key indicators, compares them with the last completed week, and highlights anomalies.

Automation diagram

The overall logic is public
Input
TriggerA full calendar week has ended
System
Step 1Read data only for the completed period
System
Step 2Calculate an agreed set of indicators
System
Step 3Compare with the snapshot of the previous period
System
Step 4Compile a short card with changes and anomalies
Human
Human controlThe owner checks anomalies and decides if actions are needed; the process does not change sales, prices, or campaigns.
Outcome
Observable outcomeA read-only process calculates several key indicators, compares them with the last completed week, and highlights anomalies.

Using it

When to use it

When sales are already stored in a table or database, but a regular weekly comparison is not done.

How to verify

A dry-run on a historical week matches manual calculation and does not send messages or change the snapshot.

Tools

pythonsqltelegram

Recipe details

Time1 eveningDifficulty2 of 5Steps5Prerequisites3
Access to the whole library

Open every recipe through @venturehunter

We ask for no phone number, no password and no Telegram login on the site. @penioza_bot checks your subscription inside Telegram and brings you back here with access to every kit, not just this one recipe.

No emailNo site loginOne check for the whole libraryBuildable starter

Need help putting this in place?

We will walk through your process and build this loop around your data, your limits and your people.

Message me — I will help