NP — LL152 Campaign Builder

Borough quotas

Default: 4K Brooklyn / 1K each Manhattan / Queens / Staten Island = 7,000 total.

Brooklyn 112,532 LL152 properties total in brooklyn

Manhattan 39,144 LL152 properties total in manhattan

Queens 83,069 LL152 properties total in queens

Staten Island 15,158 LL152 properties total in staten island

Bronx 37,042 LL152 properties total in bronx

Total target: 7,000 (at Click2Mail letter rate ≈ $0.85, that's $5,950)

Filters

Max distance from office

10 mi

Office: 6923 8th Ave, Brooklyn 11220

Deadline preference

Exclusions

Skip properties on the suppression list Skip properties with no owner name on file Skip properties with no lat/lng (radius applies anyway)

Selected properties

BIN	Address	Borough	Owner	Cycle 2 deadline	Distance

Edit letter

Edits update the preview live. Click Save to keep them across page reloads. {TOKENS} get merged with each recipient's data.

Company info

Licensed Master Plumber name

NYC license #

Phone

Scheduling URL (no https://)

Logo URL

Bump ?v=N after re-uploading to bust browser caches.

Signature block (bottom of letter)

Signer name

Signer title

Signature image (handwritten)

Upload a transparent-background PNG (or JPG/WebP). It gets embedded inline in the letter — works in Click2Mail. ~100KB max for clean rendering.

The LMP credentials in the header stay separate — that's a legal signal. The signer is who personally writes to the customer.

Headline (re-line)

Re-line text (left of dash)

Renders as: " — Due {CYCLE2_DEADLINE_LONG}"

Opening paragraph (lede)

HTML allowed. Use <strong> for bold. Tokens like {CYCLE2_DEADLINE_LONG} merge per recipient.

Penalty callout (red box)

"Why us" section

Section title

Bullet 1 (HTML allowed)

Bullet 2 (HTML allowed)

Bullet 3 (HTML allowed)

CTA box (orange)

CTA title

CTA promise (italic line at bottom)

P.S. (urgency closer)

Don't include the "P.S." prefix — it's added automatically.

Compliance disclosure

Required for compliance. Don't remove the "We are not affiliated with the NYC DOB" sentence.

Live preview · merges with selected sample

Campaign results

Every outreach_lists row with letter counts, mail-attributed leads, and response/win rates.

include archived

Campaigns

—

Letters sent

—

Responses

—

Won

—

Campaign	Sent	Boroughs	Window	Responses	Response rate	Won	Win rate	Pipeline $
Loading…

How responses are matched

Leads are matched to campaigns using a time-window + UTM heuristic, since leads doesn't (yet) have a source_campaign_id column. For each campaign we count rows from public.leads where:

utm_source = 'click2mail' OR utm_medium = 'mail' OR utm_campaign ILIKE 'll152%'
created_at is between the campaign's created_at and the next campaign's created_at (or now if it's the latest).

"Sent" comes from filter_criteria.counts_by_borough on each row. "Won" is leads with status = 'won' in the same window. Pipeline $ sums est_value across matched leads.

To make matching exact going forward, encode the campaign ID into utm_campaign at letter-render time and capture it on the landing page into leads.source_detail.

LL152 Campaign Builder