Skip to content

Where are rooms about to open, and which sources fill them?

Join the rent roll, the CRM, ad spend and referral fees. See which communities have rooms open or opening, what each source costs per move-in, and where spend went.

Open Querri

What you'll need

Querri (Free trial) to set rooms opening beside spend and sources

Yardi, Welcome Home, Google Ads, Meta Ads and Sage Intacct: Step 1 says what each adds

Your source and cost rules: so cost per move-in means the same for every source

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

Next month's marketing budget usually follows last month's. Moving it means knowing where rooms are about to open and what each source really costs per move-in, and those sit in the rent roll, the CRM, two ad accounts and the referral invoices. Nobody has time to piece that together before the budget is due.

This playbook counts rooms open or opening by community, works out cost per move-in for every source, and sets last quarter's digital spend beside both.

How it works:

  • • Connect the ad accounts; upload Yardi, Welcome Home and Sage Intacct
  • • Count vacant units and notices by community
  • • Work out cost per move-in by source
  • • Compare where spend went with where rooms are opening
  • • Build next month's spend view

Follow the steps

Open Querri →
1 Step 1:

Connect the ad accounts; upload Yardi, Welcome Home and Sage Intacct

Five sources, one project:

  • •

    Yardi rent roll (or your resident system): vacant units and move-out notices.

  • •

    Welcome Home (or your CRM): inquiries and move-ins by lead source.

  • •

    Google Ads: search spend by campaign.

  • •

    Meta Ads: social spend by campaign.

  • •

    Sage Intacct (or your ledger): referral fees, events and website costs.

Google Ads and Meta Ads connect directly; the others come in as exports.

Tip: Bring twelve months of leads and costs, so cost per move-in rests on more than a handful of move-ins.

  • Yardi rent roll
  • Welcome Home leads
  • Google Ads
  • Meta Ads
  • Sage Intacct bills
Querri One project
2 Step 2:

Count vacant units and notices by community

Start with where rooms are open or about to open:

Prompt

"From the rent roll, how many units are vacant or on notice at each community today?"

Forty rooms are open or opening across the four communities, and Harrowby House has 19 of them.

Count vacant units and notices by community
CommunityVacantOn notice
Harrowby House154
Ashby Commons62
Kestrel Grove53
Linden Hill41

Rent roll at September 30, 2026. Units out of service are not counted.

3 Step 3:

Work out cost per move-in by source

Then price every source the same way:

Prompt

"For the last 12 months, work out inquiries, move-ins and cost per move-in for each lead source, using Welcome Home, the ad accounts, and the referral and event bills in Sage Intacct."

The online referral service brought a third of inquiries at $5,001 per move-in. Professional referrals cost $759 per move-in, the lowest among paid sources.

Work out cost per move-in by source
SourceMove-insCost per move-in
Professional referral38$759
Website25$998
Resident or family referral30$1,500
Online referral service15$5,001
Paid search6$12,684

Twelve months to September 30, 2026. Cost leaves out sales commissions. Walk-ins (10 move-ins) have no recorded cost.

4 Step 4:

Compare where spend went with where rooms are opening

Last, set spend beside the rooms:

Prompt

"Compare last quarter's Google and Meta spend by community with where rooms are open or opening."

Community-tagged digital spend was split evenly, 25% to each community, while Harrowby House holds 47.5% of the rooms open or opening.

Compare where spend went with where rooms are opening
CommunityRooms shareDigital spend share
Harrowby House47.5%25.0%
Ashby Commons20.0%25.0%
Kestrel Grove20.0%25.0%
Linden Hill12.5%25.0%

Q3 2026 community-tagged paid digital spend (Google Ads and Meta Ads; the brand campaign names no community and is left out), against rooms at September 30.

5 Step 5:

Build next month's spend view

Four numbers for the budget conversation, and where to look first.

The narrative Querri writes:

Harrowby House holds nearly half of the rooms open or opening and a quarter of digital spend, and professional referrals fill rooms for the least.

What you can create or export:

Build next month's spend view
CommunityRooms open or openingDigital spend share
Harrowby House1925.0%
Ashby Commons825.0%
Kestrel Grove825.0%
Linden Hill525.0%

October planning view.

Put next month's budget where rooms are about to open, on the sources that fill them.

Try it on your own data
Querri for senior living sales and marketing See how Querri helps sales and marketing see why census moved, put spend where rooms are opening, and know which incentives pay. See Querri for sales and marketing

See Querri for the whole operator

Tips for a spend view people trust

Count notices, not only vacancies

A unit on notice is a room you can start filling now. Vacancies alone show where you are already behind.

Keep one cost rule for every source

Referral fees, events and ads all count the same way, with commissions left out. Otherwise the cheapest source is whichever one was priced last.

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

What a room open or opening is, which costs belong to each source, how move-ins are counted, how campaigns map to communities: 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

"Cost per move-in is a source's referral fees, events, website and ad spend divided by its move-ins, leaving out commissions. Save that as a rule for the Welcome Home leads table."

Or bring the document that already says it

Upload your marketing budget guidelines 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:

  • Rooms open or opening: vacant units plus units on notice
  • Units out of service are not counted
  • Move-ins by source: the lead's recorded source
  • Cost per move-in leaves out sales commissions
  • A campaign belongs to the community named in it
  • The brand campaign belongs to no community
Prompt

"Read our marketing budget guidelines and propose the rules they state about source costs. 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 sales and marketing 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 budget conversation

Spend moves to where rooms are opening, with a cost per move-in behind every source. Changing a cost rule is a sentence.

Frequently asked questions

What counts as a room open or opening?
A vacant unit or a unit with a move-out notice on the rent roll. Units out of service are left out. There are 40 across the four communities.
What does cost per move-in include?
Each source's referral fees, events, website and ad spend over twelve months, divided by its move-ins in the same months. Sales commissions, $52,400 here, are left out.
Is move-ins per inquiry a conversion rate?
Not here. Both are counted over the same twelve months, so some move-ins came from earlier inquiries. A true conversion rate follows one group of inquiries to the end.
Why is the online referral service so expensive?
It brought 415 inquiries, a third of the total, and 15 move-ins. Its placement fees are paid per move-in, which makes $5,001 each.
What about walk-ins?
Ten move-ins came from walk-ins with no recorded cost, so they are left out of the lowest cost comparison.
Why leave out the brand campaign?
It names no community, so it can't be split by community. It cost $1,095 in Q3 and is shown on its own.
Do I need connectors for all five?
Google Ads and Meta Ads connect directly. The rent roll, the CRM and the ledger come in as exports.
How often should this run?
Monthly before the budget is set, and weekly for rooms on notice while a community is filling.