← Back to work

Case Study · Campaign Operations

Campaign & Pipeline Operations

Two campaigns, one habit: clean the list first, then build the system that keeps outreach moving. A regional sponsorship push and a client reactivation campaign, both run on pipelines I set up, filled, and kept clean.

Client

The AEA Institute

Campaigns

A regional sponsorship campaign for a college athletics event series, and a client reactivation campaign

My role

Pipeline setup, lead research, list hygiene, scheduled sends, automation, and reporting

Tags

Campaign operations, data hygiene, email operations, automation, reporting

1,018
contacts researched and loaded into a sponsor pipeline
1,070+
emails over two weeks, sent in scheduled batches
57
calls and 17 donation forms and applications in one week
168K
contacts and 904 lists audited to get real counts

Campaign 1 · Sponsorship pipeline

A big goal and nothing to track it with

Leadership set a four-week goal to land local sponsors. Each point person had daily targets for calls, personal emails, and group sends. The starting list was about 360 contacts in a spreadsheet, with no shared way to see who had been contacted, who had answered, or who was due for a follow-up.

Before

About 360 contacts, no shared tracking

A list in a spreadsheet, with no stages, no follow-up dates, and no record of who had already been contacted.

After week one

1,018 contacts in one pipeline

654 new leads researched and loaded, each with a stage, a follow-up date, and a log of every touch.

What I did

Built the pipeline, then kept it moving

Data hygiene

Clean lists before every send

Bad data makes a campaign look bigger than it is and lands it in spam. So I count at the contact level, remove duplicates, and keep only addresses that should get the email.

931
unique emails in a cleaned handoff list, with do-not-contact and bounced addresses flagged
653
leads split into 15 scheduled batches of 42 to 45
904
lists in a 168K-contact email database, audited to get true counts by state and role
  • Counted people, not lists. List totals in the email platform overcounted, because lists overlapped and many covered several states at once. I pulled every contact and matched each one by state and job title instead.
  • Caught the hidden inflation. Misspelled list names, mixed-role lists, and unsubscribed contacts would have padded the numbers. I removed them before anyone made a decision on them.
  • Kept contact data private. Summaries went into shared files. Contact-level data stayed out of link-shared documents.

Campaign 2 · Client reactivation

Four spreadsheets, into one automated engine

Years of prospect and customer data sat in four overlapping spreadsheets. There was no safe way to tell who was active, who had lapsed, or who was mid-conversation with sales, and every new signup was onboarded by hand.

Before

Four overlapping spreadsheets

No clean way to run a campaign without emailing the wrong people.

After

One deduplicated list and an automated funnel

80+ teams consolidated and checked against live activity, segmented messages, a landing page, and instant onboarding.

01

Outreach

The right message to the right segment.

02

Landing page

The offer, then a short form.

03

They register

Name, email, and who they are.

04

The engine

One trigger fires three actions.

The moment they submit

Saved

The lead is recorded in the database.

Onboarded

The right onboarding email and resources go out instantly.

Team alerted

Client success gets a notification with the details.

The only human step: client success follows up to make sure it's working. A daily digest and a live dashboard show who came in and who needs a nudge.

Selected assets

The reactivation campaign, as it shipped

What the systems achieved

Outreach that ran every weekday, on lists that were clean

Contact

Let's talk.

Download résumé More work