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