Audience Bridge
Base Sending Segment Workshop · Thursday, September 17 · 1:00pm ET
Pre-workshop worksheet

Your four numbers

Pull these from your ESP before Thursday. It takes about ten minutes, and the four of them add up to one figure most publishers have never put a dollar sign on. Bring the result to the workshop.

Open your ESP and fill these in

Everything calculates as you type, in your browser. Nothing is sent anywhere unless you choose to at the end.

1

Active list size

What you're billed for. Subscribed contacts, before any suppression.

2

Clicked in the last 30 days

Unique subscribers who clicked anything at least once. Not total clicks — people.

3

Opener bloat

Build one segment, read the count. All three conditions:
  • opened in the last 30 days
  • AND never clicked, ever
  • AND added 30+ days ago

How to build it is below.

4

Monthly ESP bill

What the platform charges you. If you're billed annually, divide by 12.

$

Building number 3 — opener bloat

One segment, three conditions: opened in the last 30 days, never clicked, ever, and added 30+ days ago. That third condition is what keeps new subscribers who haven't had a fair run yet out of the count.

A

Opened in the last 30 days

Some platforms express this as an activity window, others as a "last opened" date. Either is fine.

B

Never clicked, ever

Not "hasn't clicked recently" — never, across their whole history. If your tool counts rather than filters, the equivalent is unique clicks, all time, equals zero.

C

Added more than 30 days ago

Usually a signup or subscribed date, set to "is before" 30 days ago. Keeps new subscribers who haven't had a fair run out of the count.

If your platform won't combine all three — and several won't, particularly around condition A — export your subscriber list to CSV and apply the three filters in a spreadsheet. It takes a few minutes and the number is the same. Bring the question to Thursday if you get stuck; it's a good one for the Q&A.

What that adds up to

Three of these you already suspected. The fourth is the one that usually lands.

Fill in all four numbers above and your result appears here.