Today's AI Tip
← All posts

Open rate "fell 7.9%". It also fell 3 points. Say both.

· View on Instagram · View on Facebook

Open rate "fell 7.9%". It also fell 3 points. Say both.
What most of us do. We paste the month's table and ask for the percent change for each metric. Our fictional Harbor Lane Bakery table has seven metrics, September versus October. Open rate went from 38% to 35%.

What most of us do

We paste the month's table and ask for the percent change for each metric. Our fictional Harbor Lane Bakery table has seven metrics, September versus October. Open rate went from 38% to 35%.

Every number was right. One misleads.. The math is correct, but "down 7.9%" on its own can read like 38% minus 7.9, which is 30.1%.

Every number was right. One misleads.

Real output · GPT-5.5 (OpenAI API) · Oct 2026

… - Conversion rate improved from 2.4% to 3.0%, up 25.0% - Email open rate decreased from 38% to 35%, down 7.9% …

The math is correct, but "down 7.9%" on its own can read like 38% minus 7.9, which is 30.1%.

Two honest numbers, one metric. Percent change is (new − old) ÷ old × 100. For a rate, 38% to 35% is down 3 percentage points, and also a 7.9% drop relative to 38.

Two honest numbers, one metric

Percent change is (new − old) ÷ old × 100. For a rate, 38% to 35% is down 3 percentage points, and also a 7.9% drop relative to 38.

Source: BLS; ONS Service Manual

Ask for the work, then the email. Remove names, account numbers and other personal details first, and check the tool's data policy or your employer's approved tools before uploading real documents. Swap in your own month names.

Ask for the work, then the email

Write a short monthly update email to our client from this table. Before the email, show a check table: for every metric, write the calculation (October minus September) divided by September, times 100, rounded to one decimal. For metrics that are already percentages, give the change in percentage points first, then the percent change, and label which is which. In the email, use only numbers from your check table.

Tested in GPT-5.5 (OpenAI API), Oct 2026

Remove names, account numbers and other personal details first, and check the tool's data policy or your employer's approved tools before uploading real documents. Swap in your own month names.

Try it: Paste last month's table and compare the check table with your own spreadsheet.

Now the rate shows both numbers. The check table lists points and percent separately (pp = percentage points), and the email carries both forward for the open rate.

Now the rate shows both numbers

Real output · GPT-5.5 (OpenAI API) · Oct 2026

… | Email open rate | Percentage-point change: 35% − 38%; percent change: (35 − 38) ÷ 38 × 100 | **−3.0 pp; −7.9%** | … Email open rate declined **3.0 pp** (**−7.9%**), and average order value was down **4.0%**, so those are worth watching. On the efficiency side, ad spend decreased **12.5%**, while newsletter subscribers grew **5.0%**. …

The check table lists points and percent separately (pp = percentage points), and the email carries both forward for the open rate.

We recomputed all seven by hand. GPT-5.5 got all seven right with both prompts (one run each). The math wasn't the problem. The unlabeled percent was.

We recomputed all seven by hand

GPT-5.5 got all seven right with both prompts (one run each). The math wasn't the problem. The unlabeled percent was.

Source: Our recomputation, Oct 2026

It still isn't send-ready. The email wrote "pp", which a client may not know; ONS style is percentage points in full. It still shows −7.9% without saying it's relative, and groups ad spend and subscribers under "the efficiency side", a stretch.

It still isn't send-ready

The email wrote "pp", which a client may not know; ONS style is percentage points in full. It still shows −7.9% without saying it's relative, and groups ad spend and subscribers under "the efficiency side", a stretch.

Try it: Run the prompt on last month's table and recompute one rate by hand.

Source: ONS Service Manual

Sources and assumptions

Assumptions:

The short version

Follow @todaysaitipSave this post on Instagram

More posts