Home / Affiliate marketing / Dormant Affiliate Finder + Email Generator

Dormant Affiliate Finder + Email Generator

Upload your affiliate list. Get everyone who has gone quiet, sorted by how long, with a reactivation email for each. Your file never leaves your browser.

Click to upload or drag a CSV here
Columns needed: name, last_active_date (YYYY-MM-DD). Optional: email

No file handy? Try it with sample data. Your name for signatures:

How it works

  1. Export your affiliate list from your network or platform (Impact, PartnerStack, ShareASale, Refersion, Tapfiliate, FirstPromoter...).
  2. Make sure it has a name column and a last_active_date column - the date of the partner's last click or sale.
  3. Upload it. Partners are grouped into 14, 30 and 60+ days of inactivity, each with an email tuned to that stage.

Privacy: the file is read by JavaScript in your browser. Nothing is uploaded to a server.

Why three tiers?

TierWhat is usually going onMessage angle
14+ daysJoined but never started, or stalled earlyRemove friction - offer creatives and help
30+ daysPromoted once, moved on to other offersShow what is working for top partners now
60+ daysMentally churnedHonest "should I keep your spot?" check-in

The "should I keep your spot open?" email works because it gives people permission to say no - which makes replying easy, and many reply with a yes.

Preparing your export

Most affiliate platforms can export a partner list as CSV. The tool needs two columns; extra columns are ignored.

ColumnWhat to put in itWhere to find it
namePartner name or companyPartner or publisher name field
last_active_dateDate of the last click or saleUsually "last click date", "last conversion" or "last activity"
email (optional)Contact emailPartner contact field

If your platform only reports total clicks, export clicks for the last 90 days and treat zero-click partners as 60+ days dormant.

Example: what the tiers look like

A program with 400 partners might split like this: 60 active in the last 14 days, 70 in the 14+ tier, 90 in the 30+ tier and 180 in the 60+ tier. The 14+ group is the cheapest win - they started recently and stalled. The 60+ group is the largest but needs the most honest message.

Writing reactivation emails that get replies

What to do with the replies

Log every reason a partner gives for going quiet. After 20 to 30 replies, patterns appear - low commission, no creatives, tracking doubts, an offer that does not fit their audience. Those patterns are the real fix list for your program, and they are worth more than any single reactivated partner. If you want the numbers behind the opportunity first, run the affiliate revenue leak calculator.

Frequently asked questions

Is my affiliate data uploaded anywhere?

No. The CSV is processed entirely in your browser and never sent to a server.

What date formats work?

YYYY-MM-DD is the safest. Most formats your browser can parse (like 04/02/2026) also work.

How often should I run this?

Monthly is a good rhythm. Partners move between tiers, and catching them at 14 days dormant is much easier than at 90.

Can I edit the generated emails?

Yes - they are starting templates. Add your program name, a real asset link and your own sign-off before sending.

Embed this calculator on your site

Free for blogs, newsletters and client sites. Paste this HTML where you want the calculator - it resizes itself and works on any device. Please keep the credit line.

Run an affiliate program that is not growing?

Traffic Goat audits affiliate programs and shows exactly where partners and revenue are leaking - with a fix plan.

See the audit
Get new calculators first

One short email when we add a tool or guide. No spam, unsubscribe any time.

Related tools

Affiliate marketingAffiliate Program Revenue Leak CalculatorFor program owners: what your dormant affiliates are costing you each month.Affiliate marketingAffiliate Commission & EPC CalculatorEstimate affiliate earnings, EPC and the traffic you need to hit a goal.SEO & trackingUTM Link BuilderBuild clean, consistent UTM tracking links for GA4.