About Services Tools Blog Contact us

School Milestone Emails

Emails a school when its list views or downloads pass a set number. Emails go out hourly at a limited rate, and a test mode keeps them from reaching schools.

  • Email Automation & Analytics
  • Education
  • Scheduled worker
  • Product
  • Cloud
  • 2026

The problem

A school will not keep its list up to date unless someone can show that parents opened it. Writing that note by hand for every school does not scale.

What it does

The job compares each school's view and download totals with fixed milestones. It sends at most one email per milestone per metric, waits at least 30 days between emails to the same school, and skips any school mailed inside that window. In test mode it sends only to the test address.

Outcomes

  • A school hears when parents are using its list.
  • The same milestone is never emailed twice.
  • A 30 day gap and an hourly cap limit how many emails go out.
  • Test mode never mails a school.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Milestone emails

Settings

Next mail goes to the test inbox only. The school is not mailed.

View milestone 100
10 25 50 100 250 500 1,000

Rows at or above this, and outside the 30 day window, are due. A school mailed 10 days ago stays dimmed.

3 due at 100 views · 1 inside the 30 day window · 4 of 20 sent this hour

Schools
SchoolViewsDownloadsLast mailNextStatus
Harbour View Primary142383 Jul100 views Due
Elm Walk School5208830 Sep500 views Inside 30 days
Oakfield High10411Never100 views Due
Northgate College53012025 Aug500 views Due
Redcliff Academy9662 50 dueNever50 views Under
Quarry Lane Primary489Never25 views Under
Fernhill Community183Never10 views Under
Pebble Hill School126Never10 views Under

Send log

One row per milestone per metric. The same milestone is not mailed twice.

WhenSchoolMilestoneModeTo
30 Sep 2026Elm Walk School250 viewsLive[email protected]
25 Aug 2026Northgate College250 viewsLive[email protected]
3 Jul 2026Harbour View Primary50 viewsLive[email protected]

How it works

  1. Read view and download totals per school.
  2. Match each total to the school and its owner's email address.
  3. Skip schools emailed in the last 30 days.
  4. Pick out schools that have passed a milestone.
  5. Send at most one Mailgun email per milestone per metric, within an hourly limit.
  6. In test mode, send only to the test address and record what was sent.

Pipeline

flowchart LR
  A[Counts] --> B[Threshold]
  B --> C[Window]
  C --> D[Skip]
  C --> E[Compose]
  E --> F[Cap]
  F --> G[Log]