RESEARCH — CASE STUDY

4,118 producer records were public all along. Nobody had organised them.

A coffee producer matching platform (name withheld)

4,118producer records organised into one sheet, one tab per website, all pulled without a single login
4,118producer records in the finished database
983records in the biggest tab, the Kenya factory listings
761records from the USDA organic integrity database
80sources mapped in the targets tab
7countries covered after Kenya was added
27verified coffee farmer reports held in the same sheet

How it worked

STEP 1

One tab per website, 4,118 records, no logins used

STEP 2

Three dated rounds, 962 then 1,369 then 1,787 records

STEP 3

Targets tab with sector, cost and direct download columns

STEP 4

27 USAID farmer reports, every link curl verified 200

OUTCOME

4,118 producer records organised into one sheet, one tab per website, all pulled without a single login

Meet the platform

A producer matching platform built around a simple idea: when the US government stopped its farmer aid programs, years of vetted African producer data was left sitting on government and archive websites, organised by nobody. The platform matches those producers with buyers. Its working prototype ran on demo records. Our job was the data pull: find the real producers, verify them, organise them, load them.

The challenge

There is no single producer registry for African coffee. The data lives in fragments: an organic certification database here, a factory listing there, archive evaluations somewhere else, and several official sources that are simply dead. Some countries publish nothing at all. A matching platform built on scraped guesses would match buyers with ghosts, so every record had to come from a real, named, public source, and every gap had to be admitted rather than filled.

The solution

Three rounds, one sheet, one tab per website

All data went into a single sheet, one tab per source website, so any record can be traced back to where it came from. Round one, on November 15, pulled 962 records: certification lots, winning auction lots, washing station lists, exporter directories and certified company rows. Round two, on November 16, added 1,369 records in 13 new tabs, the biggest being 761 records from the USDA organic integrity database, an official full database export. Round three, on November 17, added 1,787 records in 6 tabs, including 983 Kenya factory listings, the single biggest tab in the build. The arithmetic reconciles exactly: 962 plus 1,369 plus 1,787 is 4,118.

A targets tab that says what everything costs

The targets list grew from the original 43 sources to 80 mapped sources, and gained sector, cost and direct download columns for every row: government, private or mixed; free, free account, paid or request only. Anyone continuing this work can see at a glance what is pullable today and what is gated, instead of rediscovering it.

The farmer reports, verified link by link

The same sheet holds all 27 verified coffee farmer reports from the USAID DEC collection. The original host for those reports is dead, so working copies were found in archive collections, and every single link was curl verified returning 200 before it was added. One report was found and deliberately not added: both its archive page and its PDF return 404, and a dead link in a verified list is worse than a gap.

The gaps, stated plainly

Ethiopia has no public government producer registry, licensed exporter list or washing station database: the official sites are dead or down, and only private directories and union level records could be pulled. Kenya licensing moved to a revived Coffee Board under a 2026 act with no register published yet, and its biggest listing source is a non official compilation that must be verified before use. South Sudan has almost no public coverage at all: 9 named farmer organisations from one USAID report is everything that exists publicly. Several sources stay blocked behind logins, paid API tokens and request only lists, and they are logged as blocked, not silently skipped.

The results

The return is the asset a matching platform actually runs on: real, sourced, buyer ready producer data that cost nothing to access because it was public all along, just scattered. The expensive part was never the data. It was the organising, and that part is done.

FAQ

Where did the producer records come from?

Public sources only: government databases, certification bodies, auction and factory listings, exporter directories and archive collections. Every tab in the sheet is one website, so every record traces back to its source.

Why one tab per website instead of one big list?

Provenance. A merged dump loses where each record came from, and with it any way to verify, refresh or defend the data. One tab per source keeps the audit trail intact.

What could not be pulled?

Ethiopia publishes no public producer registry at all, several sources sit behind logins or paid tokens, and one farmer report exists only as a dead link. Those are logged as gaps in the sheet rather than filled with guesses.

Are the Kenya listings official?

No, and the sheet says so. The largest Kenya source is a non official compilation, flagged for verification before buyer use. Flagging a source honestly is part of the deliverable.

By the numbers

producer records in the finished database4,118
records in the biggest tab, the Kenya factory listings983
records from the USDA organic integrity database761
sources mapped in the targets tab80
countries covered after Kenya was added7
verified coffee farmer reports held in the same sheet27

Bars are scaled so very small and very large numbers fit on one chart. The values printed are exact.

THE ROI
$0

spent on logins, subscriptions or paid data to pull all 4,118 records, every source was public

4,118 producer records and 27 verified farmer reports, organised in three days of rounds, at zero data access cost.

What was built

The concrete pieces this engagement shipped, in one list.

Your mail is being sent unauthenticated. Here is the full fix.

Lower stack cost. Back in the inbox. Built to send at any scale.

We rebuild it properly: secondary domains, inboxes, SPF, DKIM and DMARC set to enforcement, warmup and safe sending limits, blacklist monitoring on top. Send-ready in about 17 days. No campaigns, no copy, no lead lists. Infrastructure only.

Almost a decade building cold outreach infrastructure, including his own sending and verification stack built from scratch. 20+ B2B clients at companies worth $10M and above, all in tier one countries.

Free · Written plan + fixed price · No sales call required

More case studies

Lead dataA US M&A advisory firm (name withheld)
46,000

prospects matched on LinkedIn, 93% of the final list

151,218 rows in. 49,373 decision-makers out.

READ CASE STUDY →

ROIValid decision-maker leads at $0.067 each in the pilot, then all 49,373 scored for $1.54 total.

InfrastructureA US advisory firm's cold email program (name withheld)
100%

sender health at the end of the wave, with 1 hard bounce in the final campaign

30 inboxes. 1,596 sends. Zero burned.

READ CASE STUDY →

ROIZero inboxes burned: 1,596 sends delivered and the pool ended at 100% health, ready for the next wave.

OutreachPartner outreach for a US advisory firm (name withheld)
Step 2

the follow-up, not the first touch, produced the first interested partner reply

The first yes did not come from the first email

READ CASE STUDY →

ROI958 sends across the wave produced an interested partner and a $1,000 logged opportunity.

Copied
Free tools Get an inbox plan