To track Skool members, leads and programs in Airtable, build three linked tables, one for people, one for programs and one for enrollments, so a single person can be a lead, a free member and a paying client in two programs without duplicate rows. Airtable is worth it over a spreadsheet when you sell more than one thing and need to see who is in what. Why linked tables matter A flat member list breaks as soon as you have a second program. Do you add a column per program? A row per enrollment? Both get messy fast. Airtable's linked records solve this: each person exists once, each program exists once, and enrollments connect them. Step 1: The People table One row per human, whether they've joined Skool yet or not: • Name • Email • Skool profile link • Source: lead magnet, referral, YouTube, ad • Stage: lead, free member, paid member, client, alumni • Goal, from their membership answer • Notes Step 2: The Programs table One row per thing you sell or run: • Program name, for example "Paid community," "8-week cohort," "1:1 coaching" • Type: membership, cohort, coaching • Start and end dates, for cohorts • Price Step 3: The Enrollments table This is the link between the two: • Person (linked to People) • Program (linked to Programs) • Status: invited, active, finished, dropped • Start date • Course progress or completion, if you track it Now one person can have three enrollments over a year and you'll see the whole path on their record. Step 4: Views that answer real questions • Leads who joined the free community this month • Free members with a goal that matches your paid offer • Active cohort members who haven't finished week 2 • Alumni from last year's cohort, for a reunion or upsell Each view should answer one question you'd otherwise answer by scrolling. Step 5: Getting data in Skool has no public API. Your options: • Leads from forms or a landing page go straight into People through the form tool's Airtable connection • Skool member events can come in through an automation platform like n8n or Make, fed by a Skool-native tool that sends webhooks