Applied The Nick E. Playbook

Renewal Risk & Outreach Planner

Last reviewed

Intermediate

What you'll learn

~40 min
  • Ask an AI tool, in plan mode, for a renewal call list worked in lease-end windows, with the reasons for each place, and a note inviting each resident to talk
  • Read its plan for what goes into a ranking: your lease, payment and repair records only, with a missing record shown as missing
  • Show each resident's rent beside the market rent as a figure for your decision, while the offer itself stays with you and the owner
  • Use a place on the list only for who to call sooner, and move a resident up when you know something your files do not

The story, and what you will end up with

It is Monday 16 November 2026 at The Concord. Every Monday the office pulls the lease expiration report and works out whom to call about renewing. Today it has three exports from the office system: the leases, twelve months of rent payments, and the repair log. Ten residents are in them. Some leases end in two weeks, some in three months, and one resident’s lease ended in August and was never renewed.

The office works renewals in windows: leases ending within 30 days first, then within 60, then within 90. The first window is often already late for the renewal conversation: a lease ending in two weeks needs a call this week, whatever the resident’s record. Inside each window, you want the residents with something on record called first, with the reasons beside each name. You also want each resident’s current rent beside the market rent, because a resident paying well below market may be facing a large increase at renewal, and that is a reason to call early and to have the figures ready when you sit down with the owner.

By the end of this lesson you will have a small program on your own computer, the renewal planner, that reads the three files and makes that call list, and one short note per resident inviting them to talk about renewing. It never sends anything. You build it by asking your AI tool in plain English, and you check it by reading what it makes. In a working office this list is a call order that sits on top of your office’s own report of expiring leases, not a replacement for it.

🔍Words used in this lessonclick to expand
  • Lease renewal: when a lease is about to end, the property usually offers a new one. If the resident accepts, they renew; if not, they usually move out or stay on month to month.
  • Renewal offer: the document that sets out the new rent, the lease terms on offer and a date to reply by. It comes from you and the owner. The notes in this lesson are not offers; they invite a conversation about renewing.
  • Window: a group of leases by how soon they end. Here: within 30 days (0 to 30), 31 to 60, and 61 to 90.
  • Month-to-month: here, a resident whose lease has ended and who stays without a new one, paying each month.
  • Market rent: what the office would ask for the same apartment from a new resident today. The file has a figure for each unit.
  • Returned payment: a rent payment the bank sent back unpaid, such as a bounced check.
  • Call list: the order your office calls residents in. The windows set the order first; inside a window, the reasons put each resident in their place.

Before you start

First, if your AI tool is still open, leave it: type /exit and press Enter (if you use Antigravity, press Ctrl+D with nothing typed instead), and wait until you see the $ or % prompt. The next line goes there, in the terminal, not in the AI tool. It makes a new folder for this lesson inside property-ops, next to the earlier lessons’ folders, and goes into it:

Terminal window
mkdir -p ~/property-ops/03-renewal-outreach && cd ~/property-ops/03-renewal-outreach

Start your AI tool with the start line you kept from the setup lesson, the one with approval prompts off. Then ask it to set the folder up:

Set this folder up so we can undo any change you make, download https://learn.intellimetrics.net/starters/property-mgmt/03/renewal-data.zip and unpack it into a data folder, and save a checkpoint.

Look for it saying three things: the folder is set up with Git (the program that saves snapshots, from setup), three files are in the data folder (leases.csv, payments.csv and repair-requests.csv), and a first snapshot, your checkpoint, is saved. Later you can ask whether the files have changed since then. If it does not mention one of them, ask: “Did you save a checkpoint with the files in it?” If it says it kept the zip file somewhere outside this folder, ask it to delete that copy. If the download does not work, download renewal-data.zip in your browser, check where it went (the browser’s list of downloads shows the folder), and tell your AI tool, for example: “renewal-data.zip is in my Downloads folder. Unpack that one file into a data folder here, and save a checkpoint.” In Windows PowerShell or a desktop app, “my Downloads folder” works as is; only say “my Windows Downloads folder” if you use Ubuntu (WSL) on Windows, which keeps its own Downloads folder apart from Windows.

Every resident, unit, lease and rent in the files is made up for this course. No real resident’s details are in them, and none should go into this folder.

The box below says what is in the practice files; later steps refer to them.

ℹWhat is in renewal-data.zipclick to expand

Three spreadsheet files (each opens in Excel):

  • leases.csv: one row per resident: unit, name, move-in date, the current lease’s start and end, rent and market rent. Rents are written the way an export writes them, such as $2,728.00.
  • payments.csv: one row per resident per month from November 2025 to October 2026, marked on_time, late (with the days late) or returned. A resident who moved in later has rows from their first month.
  • repair-requests.csv: 18 repair requests from May to October 2026, with the date, the kind of repair, how many days it took, and the note the office wrote.

The practice files were exported on Monday 16 November 2026, so the practice run counts days to lease end from that date. That way every lease lands in the same window for everyone, whatever day you do this lesson. On your own files you count from the day you run it.

WindowUnitResidentLease endsDays to lease endPayments on recordRepairs on record
Month-to-month0304Paul Anders31 August 2026ended 77 days ago2 returned, 1 late1
Within 30 days0609Grace Holloway30 November 202614all 11 on time2
Within 30 days1310Samuel Park12 December 2026262 late1
31 to 60 days0208Laura Bennett22 December 202636all 12 on time1
31 to 60 days0802Kevin Walsh31 December 2026454 late (5, 12, 18 and 22 days), 1 returned6
31 to 60 days1103Nadia Haddad10 January 202755no rows at all1
61 to 90 days0910Emily Carter25 January 2027701 late3
61 to 90 days1108Priya Natarajan31 January 2027761 late2
61 to 90 days1202Joan Whitaker10 February 202786all 12 on timenone
Over 90 days1106Tobias Moreno30 April 2027165all 12 on time1
UnitRentMarket rentDifference
0304$2,310$2,400$90
0609$2,450$2,450none
1310$2,980$3,050$70
0208$2,352$2,450$98
0802$2,425$2,500$75
1103$3,640$3,700$60
0910$2,400$2,450$50
1108$2,728$3,100$372
1202$3,150$3,150none
1106$2,600$2,650$50

Four of these matter later:

  • 0304: his lease ended in August, he stays month to month, and two of his payments came back. The real question for him is whether to offer a renewal at all. That is your decision, with the owner; the list flags him and decides nothing. His note is set aside and not sent until you and the owner have decided whether to offer him a renewal at all.
  • 0802: a first lease (he moved in on 1 January 2026). Three of his six requests are the same kitchen sink leak; one took 9 days, and its note says he was frustrated. His payments are getting later, and one came back, so whether to renew him is also your decision, and the list marks him for it.
  • 1108: both her requests are the air conditioning, taking 8 and 5 days, and both notes say she was frustrated. Her rent, $2,728, is $372 below the market rent of $3,100 for her unit, which is 12% of the market rent.
  • 1103: the payment file has no rows for her, though she has lived here since January 2024. The files do not say why. That is a gap in the export, not a record of on-time payment.

Each lesson’s practice files are their own made-up week and do not continue from one lesson to the next, so an apartment can be occupied in one lesson’s files and empty in another’s.

Switch to plan mode

Your AI tool is already open. Switch to plan mode now: Shift+Tab until it says plan, or /plan (the keys for each tool). In plan mode it usually reads your files, asks its questions and shows you a plan before it builds anything; the order can vary.

The conversation

Each message below is an example. Say it your own way.

Say what you want

Say what you do, which files to use, the date to count from, and what you want from them:

I manage an apartment building. From the files in data, as of 16 November 2026, build a renewal call list: who to call first, rent against market, and a note inviting each to talk. Ask me what you need first.

The date matters: without it, your AI tool may count from the day you do this lesson, and every lease would land somewhere else. Your AI tool reads the files and usually comes back with questions. It may also point out what it noticed, such as 0304’s lease having ended, 1103 having no payments, or 1108 paying well below market.

Answer its questions

Answer each in a sentence. These are questions the tools often ask, with one way to answer each. Yours may ask them in a different order or show a list of choices:

If it asksYou might say
A page in the browser, a spreadsheet, or Word documents?A spreadsheet for the call list, and each note as a text file.
All ten residents, or only leases ending within a set window?Only leases ending within 90 days, plus anyone month-to-month.
Should lease deadlines come first, or the strongest concerns?Work it in windows: ending within 30 days, then 60, then 90. Concerns first inside each.
0304’s lease ended in August. Month-to-month, renewed, or moved out?0304 is month-to-month. Put him at the top, marked as needing my decision.
1103 has no payment records. Missing data, or a real gap?I don’t know why. Mark her payments as missing, and I’ll check the ledger.
Is the market rent column current?It’s what our system shows. Label it market rent as recorded, and show the difference, for my decision only.
0802’s late payments are getting worse. List him as normal, or flag him for you?Flag him as needing my decision, like 0304, with his reasons.
What should each note offer: what rent, what term, any concessions?No rent or offer. I set renewal offers with the owner.
A formal offer, or an invitation to talk about renewing?An invitation to talk about renewing.
Should a note mention repairs or payments?Keep the notes neutral; don’t mention repairs or payments.
How much notice do your lease or local rules require?I’ll check notice rules myself.
Whose name, title and phone number go on the notes?Dana Reyes, Community Manager, The Concord, (703) 555-0142.

The name and phone number are made up for practice; for your own building, sign with your own.

If it asks several questions at once, answer any about how something is counted or who decides from your owner’s agreement or your own judgment, and accept its suggestions only about how the page looks. If it asks something not listed here, answer it the same way, in a sentence.

Read the plan

Next it usually shows you a plan: what it will build and how it will check it. Read it for six things:

  1. The list is worked in windows: anyone month-to-month at the top, then leases ending within 30 days, then 31 to 60, then 61 to 90, each with the date the lease ends. 0304 and 0802 are marked as needing your decision.
  2. Inside each window, every place comes with its reasons, taken from your lease, payment and repair files and nothing else.
  3. Each resident’s rent, market rent and the difference are shown, as figures for your decision.
  4. The program sets no rent and makes no offer. Each note invites the resident to talk about renewing, and no note mentions repairs or payments.
  5. A resident with no payment records is shown as missing, not counted as paying on time.
  6. It saves a program in this folder that you can run again on next month’s files. Nothing is sent, and your three files are read and left as they are.

What a place on the list is for. This list is for one thing: who gets called first. It is never used to decide who gets a worse offer, a shorter term, or no renewal. A resident who complained or asked for repairs is never treated worse for it; they are called sooner, never offered less. A repair request can also be a request for a disability accommodation, so read the request itself, not only how many there were.

Anything else you want to do with a list like this goes to your fair-housing contact and your counsel first.

A first plan often leaves out one of the six things above. If it does, say so in a sentence, in your own words, for example:

Group the list by lease end first: within 30 days, then 60, then 90, concerns ranked inside each. Mark 0304 and 0802 as needing my decision.

When the plan has all six, approve it: if your AI tool offers a choice to go ahead, pick it; otherwise say “Yes, go ahead and build it.” In Codex, press Shift+Tab first to leave plan mode. In Copilot, saying it brings up a choice to go ahead; pick that. Let it build. It may run what it built and tell you how to run it yourself; either way, the next step asks it to. When it has finished, ask it: “Did you install anything, and where?” Nothing, or something inside this lesson’s folder, is fine for these lessons. If it names anywhere else on your computer, ask it what that is for, and to remove it if you do not want it there.

Look at what it built

Ask it to run what it built:

Run it and show me the call list and one note.

If it says it ran a copy or saved one somewhere outside this folder, ask it to delete that copy. Your call list and notes will be worded and laid out in their own way, and inside each window your planner sets its own order from the reasons it found. Check them for these:

  • The folder holds the program that makes the list, not only the list. If it made only the list, ask: “Save what makes the list as a program in this folder, so I can run it again on next month’s files.”
  • 0304 is at the top, apart from the windows, shown as month-to-month and needing your decision.
  • 0802 is marked as needing your decision, either beside 0304 at the top or in his window.
  • The windows hold the right units: within 30 days, 0609 and 1310; 31 to 60 days, 0208, 0802 (unless he sits at the top with 0304) and 1103; 61 to 90 days, 0910, 1108 and 1202. 1106, whose lease ends on 30 April 2027, is not on the list.
  • Where it shows days to lease end, they match the box above: 0609 14, 1310 26, 0208 36, 0802 45, 1103 55, 0910 70, 1108 76, 1202 86.
  • 0802’s reasons name the repeated plumbing repair (the kitchen sink leak, three times) and the late and returned payments. 1108’s name the two air conditioning repairs with notes saying she was frustrated. 1202’s show no late or returned payments and no repair requests recorded.
  • Each resident’s rent and market rent match the box, with the difference beside them: $372 for 1108, none for 0609 and 1202, between $50 and $98 for the others.
  • 1103 is shown as having no payment records, or as not assessed for payments. She is not described as paying on time.
  • Every note invites the resident to talk about renewing, and no note gives a rent, an increase or a discount, or mentions repairs or payments.
  • When you ask “Have my data files changed since the checkpoint?”, it compares them with the checkpoint and says no.

Read the order inside each window as who to call sooner. 0802 and 1108 may sit high in theirs because of repairs and complaints: that is a reason to call them early and listen.

Set 0304’s note aside: it is not sent until you and the owner have decided whether to offer him a renewal at all. Hold 0802’s the same way until his is decided.

Your planner may show 1103 with no concerns, or give her a 0 if it counts concerns as a number, because her repairs and rent show little. That covers what is on record, and for her most of it is not. If the call list makes her look like a resident with no concerns, tell your AI tool, for example: “1103 has no payment records, so don’t show her as low risk. Show her payments as not assessed.”

The notes stay neutral. If you want a line in one of them, such as asking how a repair has held up, adding it by hand before you send it is your call.

If something else on the list is not true, tell your AI tool in a sentence what you see and what you expected, for example: “1106 is on the call list, but his lease ends in April. Leave him off.”

Notice what the files cannot tell you

Now something no file holds. On Friday 13 November, Joan Whitaker in 1202 picked up a package at the front desk and mentioned that she has been touring houses. The front desk passed it on this morning. First, ask your AI tool:

Where is 1202 on the list, and why?

It should say she is in the 61 to 90 day window, likely at or near its bottom, and why: every payment on time, no repairs, rent at market, here since February 2023. Before you read on: is she the resident least likely to leave?

Her files show no late or returned payments and no repair requests recorded, and that is all they show. Nothing in a lease, a rent ledger or a repair log records what a resident plans to do. The front desk heard something the planner never will. So move her yourself, and keep what the files say about her as it is:

The front desk says Joan Whitaker in 1202 mentioned touring houses. Put her first on the call list with that note, and keep her reasons as they are.

Look for her at the top of the list with the front desk’s note beside her, her reasons unchanged, and her note to her unchanged. The front desk’s note is your office’s knowledge, set beside the files, not mixed into them. Record what she says when you call in whatever system your office keeps resident records in.

A ranking you can explain is one your team can challenge when they know something the data does not capture.

One real run

Here is part of what one AI tool said when asked where 1202 was, with Claude Code on 11 November 2026, before the front desk’s note was added. Yours will word it differently; check your list against the list above, not against this.

Unit 1202, Joan Whitaker, is #9, last on the list. Her lease falls in
the latest window, and she's the only resident in that window with no
concerns.
- Window: her lease ends February 10, 2027, which is 86 days after
November 16. That puts her in the 61-90 day window, the last group
called.
- Within the window: concerns come first, so two residents in that
window go ahead of her:
- #7 Emily Carter (0910) had one late payment.
- #8 Priya Natarajan (1108) had one late payment, two AC repairs
and a frustrated note.
- No concerns:
- All 12 payments from November 2025 to October 2026 were on time.
- There are no repair requests on file for her unit.
- Her rent of $3,150 matches market exactly.

The building, the residents and the records in this answer are made up for this course.

In that list 0910, with one late payment, sits ahead of 1108, with a late payment and two air conditioning repairs whose notes say she was frustrated. The order inside a window is your planner’s own weighing of the reasons, and that order is exactly what you read and correct. If you would call 1108 first, say so:

Put 1108 ahead of 0910. She has more on record: two air conditioning repairs and a late payment.

How real properties differ

The units, residents, rents and records here are made up. The laws are real:

  • Federal law makes it unlawful “To discriminate against any person in the terms, conditions, or privileges of sale or rental of a dwelling, or in the provision of services or facilities in connection therewith, because of race, color, religion, sex, familial status, or national origin” (42 U.S.C. 3604(b)). Paragraph (f)(2) of the same section uses the same words, “in the terms, conditions, or privileges of sale or rental of a dwelling”, for discrimination “because of a handicap”.
  • The same section, paragraph (f)(3)(B), counts as discrimination “a refusal to make reasonable accommodations in rules, policies, practices, or services, when such accommodations may be necessary to afford such person equal opportunity to use and enjoy a dwelling” (42 U.S.C. 3604). Whether a particular repair request is also an accommodation request is a question for the person your company relies on for fair-housing questions.
  • Virginia’s Fair Housing Law makes it unlawful to “Discriminate against any person in the terms, conditions, or privileges of sale or rental of a dwelling”, and its list for that paragraph reads “race, color, religion, national origin, sex, elderliness, source of funds, familial status, sexual orientation, gender identity, or military status” (Va. Code 36-96.3, A.2). Other states and cities have their own lists, so check the one where your property sits.
  • Virginia’s landlord and tenant law has a section headed “Retaliatory conduct prohibited” (Va. Code 55.1-1258), and as of 11 November 2026 that page shows a version in force until 1 January 2027 and a new one from that date. Read it with your counsel.
  • The planner you built reads leases, payments and repairs, and nothing about who a resident is or who lives with them. Keep it that way when you add to it. Whether anything you add, or any way your office uses the list, raises a fair-housing question is a call for the person your company relies on for fair-housing questions, not for the program and not for this lesson. If part of a resident’s rent is paid by a housing program on its own schedule, ask that person how late marks for that rent should be read.
  • To decide an offer, you will often also want in front of you what this practice data does not have: whether an offer has already gone out and what happened to it, the date by which notice must be given, any balance owed, the last increase, and the owner’s pricing for renewals.
  • Your lease, your company and your state or city may set how much notice a renewal offer or a rent change needs. Check those before any offer goes out.
  • Your company may already have renewal letters and offer forms it approves, and a way it sets renewal terms. Use those; the notes your AI tool drafted are only a starting point.

Keep going

Small changes do not need plan mode. Say each in a sentence, then run it again:

  1. “Does the program name any unit or resident from these practice files? If it does, make it work those out from the files instead.” A planner built in a conversation may keep your answers about 0304 and 1103 written into the program, and on another month’s files it would get those residents wrong. Your AI tool may keep the note for 1202, since you asked for it; ask it to take that out too before you use real files: “Take the call-first note for 1202 out of the program.”
  2. “Make me a one-page list of this week’s calls that I can print.”
  3. “Save a checkpoint.” Your AI tool saves a snapshot you can return to.

When you want a call list for your real residents, use the finished planner. It runs on your real files by itself, with your AI tool closed, so your AI tool never sees them. Do these steps in order; the first three happen now, while your AI tool is open and this folder still holds only the practice files:

  1. Go through the data check, the questions in setup about what the data is, who decides how it is used, and which AI tool would see it. Resident names, leases and payments are your management company’s to decide on. Go on only if it allows this use.

  2. The planner expects files shaped like the practice ones. Your office system’s export will differ: it may come as one file or several, and its columns will have other names. Open your export in a spreadsheet and tell your AI tool the column names only, never a row of records, for example: “My lease export has the columns Unit, Tenant, Lease To, Current Rent and Market Rent. Change the planner to read files like that.” Do the same for your payment and repair exports.

  3. Decide on a folder of its own for your real files, outside this course folder, for example /home/dana/renewal-files. Nothing has to be in it yet. Ask your AI tool for the exact line, for example: “Give me the exact one line to run this myself on the files in /home/dana/renewal-files, saving everything there too, with the date to count from as its last part.” Use your own folder’s full path; if you do not know it, ask your AI tool how to find it. If it offers to copy your real files into this folder instead, say no.

  4. Copy the line it gives you into a note. It will look something like this one, though yours may differ:

    Terminal window
    python3 /home/dana/property-ops/03-renewal-outreach/tool/renewals.py --data /home/dana/renewal-files --out /home/dana/renewal-files/output --as-of 2026-11-23

    Read it left to right: python3 starts Python, which runs the program; next comes the planner, in this lesson’s folder; --data is the folder holding your files; --out is where the call list and notes go; --as-of is the date to count from, written year, month, day. Change that last part to the day you run it, each time: this example was written for Monday 23 November 2026. If you are unsure about any part, ask your AI tool now, while it is still open.

  5. Leave your AI tool the way you did at the start of this lesson.

  6. Put your real files in that folder. Paste the line from your note at the $ or % prompt and press Enter. The call list and notes appear in that folder, not in the course folder. To come back to the lesson folder later, type the line at the top of this page that begins with mkdir.

Try another case

Before the quiz, write two or three sentences for yourself. A colleague suggests adding a column to the leases file for how many people live in each apartment, “because families with kids move more often”, so the planner can rank them higher. What do you say, and what would you do instead if you think a household is thinking of leaving?

A good answer sees three things. The planner ranks residents on what is on record about the lease, the payments and the repairs; a household count is about who lives there, not about anything on record. Familial status is on both lists quoted under “How real properties differ”, so before anything like it goes near the planner, the question goes to whoever your company relies on for fair-housing questions. And what someone has said to the office goes in as a note beside the files, the way 1202’s did, not as a column that ranks a whole group.

Key takeaways

  • Ask briefly, and let your AI tool ask back. Say what you do, which files to use, the date to count from, and what you want; its questions fill in the rest.
  • Work the list in windows: month-to-month first, then leases ending within 30, 60 and 90 days, with concerns setting the order only inside a window.
  • Read the plan for what goes into the ranking: your lease, payment and repair records only, every place with its reasons, a missing record shown as missing.
  • A place on the list is for who to call sooner. A resident who complained is called sooner, never offered less.
  • The rent gap is an input, and a note is not an offer: the planner shows rent beside market rent and sets no rent; the offer is yours and the owner’s.
  • A place on the list shows what your files record, not what residents plan. Your team moves a resident when they know more, and the note stands beside the files.
  • Practice data stays practice data: real resident files go to the finished planner, with your AI tool closed, after the data check.
KNOWLEDGE CHECK

Your planner puts Joan Whitaker in 1202 at the bottom of her window: every payment on time, no repairs, rent at market. The front desk tells you she mentioned touring houses. What do you do?

What’s next

In the next lesson you build the Vendor & Make-Ready Orchestrator, which lays out a day-by-day make-ready schedule for the apartments residents have just left, around your vendors’ limits and days off.

intellimetrics · Arlington, VA
© 2026 intellimetrics.net
Search lessons