Skip to content

Are new residents settling in during their first 90 days?

Join each move-in date with program attendance and the 30-day check-in. See how new residents at each community are joining in, and who has had no attendance in the last two weeks.

Open Querri

What you'll need

Querri (Free trial) to follow new residents through their first 90 days

Yardi, LifeLoop and SurveySparrow: Step 1 says what each adds

Your measure of settling in: so every community is compared the same way

Free resources

Start your free trial here →

Sample data sets

Synthetic data for Tallowmere Senior Living, a made-up operator with four communities. Residents appear as codes only. Not real resident, family, staff or financial data.

Need help?

If you have any questions, you can request a demo or email our team.

Before we begin

The first weeks after a move-in shape how a resident feels about the community. Following them means matching the move-in list from the resident system with attendance from the engagement app, if anyone has time. Move-ins, attendance and the check-in survey each live somewhere different.

This playbook lists every resident in their first 90 days with their attendance, compares communities, and looks back at what last year's first two weeks went with.

How it works:

  • • Connect SurveySparrow; upload Yardi and LifeLoop
  • • List new residents with their attendance
  • • Compare communities and the first survey
  • • Look back at last year's first two weeks
  • • Build the new resident review

Follow the steps

Open Querri →
1 Step 1:

Connect SurveySparrow; upload Yardi and LifeLoop

Three sources, one project:

  • •

    Yardi (or your resident system): who moved in and when.

  • •

    LifeLoop (or your engagement app): every program each resident attended.

  • •

    SurveySparrow: the 30-day check-in answers.

SurveySparrow connects directly; Yardi and LifeLoop come in as exports.

Tip: Bring fifteen months of attendance, so last year's move-ins can be followed for their full 90 days.

  • Yardi move-ins
  • LifeLoop attendance
  • SurveySparrow check-in
Querri One project
2 Step 2:

List new residents with their attendance

Start with everyone in their first 90 days:

Prompt

"List every resident in their first 90 days with how many programs they have come to since move-in."

Thirty-two residents are in their first 90 days. Twenty-four have been in house two weeks or more and are scored; six of them come to fewer than one program a week.

List new residents with their attendance
Programs a weekResidents
Under 16
1 to under 23
2 to under 311
3 or more4

Scored new residents at September 30, 2026, by programs a week since move-in.

3 Step 3:

Compare communities and the first survey

Then compare communities on Tallowmere's example measure:

Prompt

"By community, how many new residents are at two or more programs a week, and what did they say in their 30-day check-in?"

Fifteen of 24 scored new residents come to two or more programs a week. At Kestrel Grove it is 1 of 4.

Compare communities and the first survey
CommunityScoredAt two or more a week
Ashby Commons76
Linden Hill64
Harrowby House74
Kestrel Grove41

Scored new residents at September 30, 2026. Two or more programs a week is Tallowmere's example measure.

4 Step 4:

Look back at last year's first two weeks

History shows what the first two weeks went with:

Prompt

"Look back at last year's move-ins. Of residents who came to nothing in their first two weeks, how many were at two programs a week by day 90, compared with residents who came to at least one?"

Among last year's move-ins, 6 of 19 who came to nothing in their first two weeks were at two programs a week in days 61 to 90, against 92 of 105 who came to at least one.

Look back at last year's first two weeks
First two weeksResidentsTwo a week, days 61 to 90
Came to nothing1931.6%
Came to at least one program10587.6%

Move-ins July 2025 to June 2026 who stayed at least 90 days. An association in past data, not a cause.

5 Step 5:

Build the new resident review

Four numbers for the weekly huddle, and who to introduce first.

The narrative Querri writes:

Most new residents come to two or more programs a week, Kestrel Grove's new residents are behind, and two residents haven't come to a program in the last two weeks.

What you can create or export:

Build the new resident review
ResidentCommunityDays since move-in
HAR-1171Harrowby House39
KES-1110Kestrel Grove67

Residents who haven't come to a program since September 17, 2026.

Make the introduction in the first two weeks, while it still shapes how a resident settles in.

Try it on your own data
Querri for senior living resident experience See how Querri helps resident experience teams see which communities and residents need them first, with surveys, programs and staffing side by side. See Querri for resident experience

See Querri for the whole operator

Tips for a new resident review people trust

Don't score the first two weeks

A resident in house for five days can't be at two programs a week yet. Wait two weeks before scoring, and list the newest on their own.

Treat the measure as a prompt

Two programs a week is one example of joining in. Some residents settle in other ways; the list says who to check on, not who is unhappy.

Teach Querri your rules once. Every answer after that follows them.

Who counts as a new resident, how attendance is counted, what settling in means, when a resident is scored: say each rule once and Querri applies it to every question on that data.

Show me how

Say it in chat

Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.

Prompt

"A new resident is scored only after 14 days in house, and settling in means two or more programs a week since move-in. Save that as a rule for the LifeLoop attendance table."

Or bring the document that already says it

Upload your new resident onboarding plan like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:

  • New resident: moved in within the last 90 days
  • Scored after 14 days in house
  • Programs a week: attendance since move-in, divided by weeks in house
  • Settling in: two or more programs a week (example measure)
  • No recent attendance: nothing in the last 14 days
  • Residents appear by code, never by name
Prompt

"Read our new resident onboarding plan and propose the rules it states about the first 90 days. I'll review them in the Inbox."

Where the rules reach

A rule is attached to the data, not to one person's chat, so it follows the data everywhere:

  • • Every question asked in chat, by anyone on the resident experience team
  • • Every view the Librarian builds on that data
  • • Every step of a project, including the code it writes
  • • Dashboards and scheduled runs, each time they refresh
  • • Claude and ChatGPT, when they ask Querri

You stay in control

Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.

The payoff in the huddle

Life enrichment staff start the week knowing which new residents to introduce. Changing the measure is a sentence.

Frequently asked questions

Does two programs a week mean someone has settled in?
No. It is Tallowmere's example measure, one sign of joining in. Some residents settle in through dining, friends or family visits; use the list to decide who to check on.
Does early attendance cause residents to settle in?
The data doesn't show that. Among last year's move-ins, 31.6% (6 of 19) of those who came to nothing in their first two weeks were at two programs a week in days 61 to 90, against 87.6% (92 of 105) of those who came to at least one. It is an association.
Why wait two weeks before scoring?
A resident in house for a few days hasn't had time to reach two programs a week. Eight of the 32 new residents were too new to score.
Why is Kestrel Grove behind?
One of its four scored new residents is at two or more programs a week. The data shows the gap, not the reason; four residents is a small group, so the counts sit beside the share.
Who has had no attendance in the last two weeks?
Two residents in house more than two weeks have come to nothing since September 17: one at Harrowby House and one at Kestrel Grove.
What does the 30-day check-in add?
How the resident says the first month is going. Sixteen of the 24 scored residents answered, with an average of 4.13.
Do I need connectors for all three?
SurveySparrow connects directly. Move-ins and attendance come in as exports.
How often should this run?
Weekly, so a new resident's first two weeks don't pass before anyone looks.