2.1Intermediate
0 of 7 lessons0%
Enrichment That Pays For Itself
Cut the credit cost of a 1,000 row list by an order of magnitude without losing coverage, and read every cell that came back without a value.
Someone burning credits faster than they expected, on lists that are not obviously better for it.
7 lessons43 min
What this course costs
Work the examples on 100 row samples and the course costs very little. The whole point is that you finish it spending less per list than you do today.
What you will be able to do
- Build a column that only runs on rows meeting a condition, so cost scales with quality rather than volume.
- Write a custom research step in plain English that returns a consistent, filterable value.
- Read an empty looking cell: tell Not Found from Skipped, and a filtered run from a cell worth flagging.
Before you start
- Course 1.2. You need a real list with real columns to work on.
- A table of at least 200 rows, ideally one you already think is too expensive to enrich.
The lessons
- 1Website Finder first, always, and why everything depends on it5 min readA flat charge for every row it processes, so run it only on the rows that are missing a website. The figure is on the tool card.
- 2Conditions: run a column only on rows that qualify7 min readscreenshotsFree to set. Conditions are the thing that makes everything else cheap.
- 3The enrichment waterfall, and what charged on success really means6 min readFree to read. The habits it teaches lower every later bill.
- 4Build your own research step in plain English9 min readscreenshotsCharged on run at the price on the tool card, so a row costs the same whether it finds an answer or not. Preview on five rows before creating the column.
- 5Finding a value versus checking one, and when to reach for QA Agent7 min readQA Agent is charged on run, so a fail costs the same as a pass. Lite is 1 credit and checks the row logically. Standard is 2 and adds web search plus evidence. Validate Email is a separate, email only check at a fraction of a credit.
- 6Not Found, Skipped, Error or blank: read the cell before you run it again5 min readscreenshotsFree. This lesson is about reading what a column already did.
- 7Column dependencies: how one column waits for the one it reads4 min readFree. Dependencies are set for you when the column is created.
The build that proves it
The same list, an order of magnitude cheaper
Take a 1,000 row list you would previously have enriched flat. Rebuild it with Website Finder first, two conditional columns, a free scoring pass and a threshold, then the expensive enrichment on survivors only. Record the credits spent at each step.
- You have done it when
- Your final spend is under a fifth of the flat cost, and the number of usable rows at the end is the same or higher.
- Credit budget
- Work on a 100 row sample and multiply. Read each tool card before you create the column.