A Greenwolf Tech Labs site · Our Data Studio agency team, India and USAgreenwolftechlabs.com ↗

Industry guide

Multifamily marketing dashboard: from ad spend to signed leases

A multifamily marketing dashboard shows a property management company, or the agency that markets its communities, which channels produce tours and signed leases, and what each lease costs. This guide is for marketing directors running a portfolio of apartment communities and for agencies with multifamily clients whose reports stop at leads. It covers the KPIs and formulas, the data sources, how housing ad rules affect reporting, a property and portfolio layout, a worked cost-per-lease example and when to buy a packaged tool instead.

Multifamily marketing dashboard in Data Studio showing cost per lease by channel and community
Industry guide6 min readUpdated November 18, 2026 · by Harsh Khubchandani

Quick answer

What should a multifamily marketing dashboard include?

A multifamily marketing dashboard should show leads, tours and signed leases by source, lead-to-tour and tour-to-lease rates, cost per lead, cost per lease, occupancy and exposure by property, and ad spend by channel and community. Lead data comes from ad platforms, listing sites and the leasing CRM; leases come from the property management system.

  • Judge every channel on cost per lease, because cost per lead rewards cheap, low-intent leads.
  • Signed leases live in the property management system, not in GA4 or the ad platforms.
  • Last-touch website credit hides which channel first found the renter, so keep the first source.
  • Build one property template and roll it up into a portfolio view with the same field names.
01

What is a multifamily marketing dashboard?

It is one live report that follows a prospective renter from an ad, a listing site or a search result to a tour and a signed lease, for every community in a portfolio. Ad platforms report clicks. Listing sites report leads. The leasing CRM reports contacts and tours. The property management system reports leases and occupancy. A multifamily marketing dashboard joins all four, so a regional manager can see that paid search filled twelve units at one community last month, not just that it produced three hundred clicks.

Page one for this phrase is mostly vendor products and short KPI lists. Platforms such as RentCafe Marketing IQ, PERQ and Social Kapture show dashboards inside their own software. Blogs from PERQ and Dyverse list the right KPIs (cost per lead, lead-to-tour, tour-to-lease, cost per lease) but stop before explaining how the systems connect or what the numbers look like in practice. This guide covers that part.

Teams feel the problem. In a June 26, 2026 Entrata article, Hannah-Marie Evans described multifamily marketers facing "almost decision fatigue because they have so much data coming at them". A good dashboard answers that by showing fewer, better numbers, each tied to a lease.

02

Which multifamily marketing KPIs matter most?

Group the KPIs by funnel stage: demand, leads, tours, leases and property health. Each stage has its own owner and its own fix. A fall from leads to tours is usually a response time or follow-up problem in the leasing office. A fall from tours to leases points to pricing, unit condition or the tour itself. Mixing them hides which team should act. PERQ defines the two cost metrics most teams use: cost per lead is marketing spend divided by leads generated, and cost per lease is marketing spend divided by leases signed.

StageKPIFormula or definitionUsual source
DemandSpend, impressions and clicks by channel and communityAs reportedGoogle Ads native connector, Meta via partner connector
LeadsUnique leads by first sourceNew guest cards, de-duplicatedLeasing CRM
LeadsCost per leadSpend / leadsCalculated
ToursLead-to-tour rateTours / leadsLeasing CRM
LeasesTour-to-lease rateLeases / toursCRM and property management system
LeasesCost per leaseSpend / leases signedCalculated
Property healthOccupancy, exposure and renewalsAs defined by the property management systemProperty management system export
03

Where does multifamily data come from, and how does it reach Data Studio?

A typical portfolio has six to eight data sources per community, and the two most valuable ones, tours and leases, rarely have a native Data Studio connector. Google Ads, GA4, Search Console and Google Sheets connect natively. Meta and other social platforms need a partner connector from vendors such as Supermetrics, Windsor.ai or Porter Metrics; vendor prices change, so check them directly. Listing site leads, leasing CRM activity and property management system data usually arrive as scheduled exports or through an API job.

Data Studio blends are limited to 5 sources and equality joins only, and a portfolio dashboard passes that limit quickly. We combine the sources first in BigQuery, or in Google Sheets for a small portfolio, and point Data Studio at one table keyed on week, community and channel. Partition the BigQuery tables by date so the query bill stays small as history grows.

  • Ad platforms: Google Ads natively, Meta, Microsoft Ads and others through partner connectors.
  • Website: GA4 sessions, key events (contact forms, tour bookings, phone clicks) and landing pages by community.
  • Listing sites (ILS) such as Apartments.com or Zillow: lead counts and spend, usually from exports or the leasing CRM.
  • Leasing CRM: guest cards, first source, tours booked and tours completed.
  • Property management system such as Yardi, RealPage or Entrata: signed leases, move-ins, occupancy and renewals.
  • Mapping table in Sheets: one row per community, tracking number, UTM campaign and source label, so every system uses the same names.
04

How do housing ad rules affect a multifamily dashboard?

Google's housing policy changes what you can segment, so the dashboard should not promise breakdowns the ads cannot use. In the United States and Canada, Google Ads does not allow housing ads to be targeted by gender, age, parental status, marital status or ZIP code. Location targeting is still possible by radius (at least 1 km), city or country, and in Canada by the first three characters of a postal code.

In practice, build geography into the dashboard by community and by the radius or city each campaign targets, not by ZIP code. Report results by community and campaign, and avoid audience breakdowns by age or gender for housing campaigns. That keeps the report aligned with what the media team is allowed to change, and it avoids a report that appears to invite targeting the policy forbids.

Fair housing obligations go well beyond ad targeting, and the property's own compliance team should own them. The dashboard's job is narrower: report on the targeting that is actually used, and keep prospect personal data out of shared views.

05

Why is cost per lease so hard to trust?

Cost per lease is only as good as the source attached to each lease. Hyly.AI argued in July 2026 that both cost per lead and cost per lease are often wrong because leases get credited to the property website, the last touch, rather than the listing site, ad or search that first brought the renter in. A prospect who found the community on a listing site, then booked a tour through the website, shows up as a website lease.

Three fixes make the number usable. First, record the first source on the guest card and lock it, so later touches do not overwrite it. Second, use a source mapping table so free-text values like 'apts.com', 'Apartments.com' and 'ILS - AC' roll into one channel. Third, show leases by first source and by last source side by side, so the team sees how much credit moves between them.

In Data Studio, the grouping is a CASE statement on the source field, and cost per lease is a calculated field such as SUM(spend) / SUM(leases) on a table where spend and leases already share the week, community and channel keys.

06

A worked example: cost per lead vs cost per lease

Take a hypothetical 300-unit community in one month. These are illustrative numbers, not benchmarks. It spends $4,000 on a listing site and $3,000 on Google search ads. The listing site produces 200 leads, 40 tours and 10 leases. Search produces 75 leads, 30 tours and 12 leases.

Cost per lead favors the listing site at $20 a lead against $40 for search. Cost per lease reverses that: $400 for the listing site ($4,000 divided by 10) and $250 for search ($3,000 divided by 12). The funnel explains why: search leads toured at 40% and leased at 40% of tours, while listing site leads toured at 20% and leased at 25% of tours.

Now check attribution. If four of the twelve search leases first came in through the listing site and later clicked a branded search ad, first-source cost per lease moves to about $286 for the listing site and $375 for search. The decision may change. A dashboard that shows both views lets the marketing director make that call with the evidence in front of them.

MetricListing siteGoogle search
Spend$4,000$3,000
Leads / tours / leases200 / 40 / 1075 / 30 / 12
Cost per lead$20$40
Lead-to-tour / tour-to-lease20% / 25%40% / 40%
Cost per lease (last source)$400$250
Cost per lease (first source, 4 leases moved)About $286$375
07

How should a multifamily marketing dashboard be laid out?

Build two levels from one data table: a portfolio view for the marketing director and asset managers, and a property view for each community manager. Put a date control, a region filter and a community filter on every page. The portfolio summary answers the Monday question: where are we under-leased, what did we spend, and what did each lease cost?

  • Portfolio summary: occupancy, exposure, leases, spend and cost per lease by community, against target.
  • Channels: spend, leads, tours, leases and cost per lease by channel, with first and last source views.
  • Leasing funnel: lead-to-tour and tour-to-lease by community, plus lead response time where the CRM records it.
  • Paid media: campaigns by community and target radius, with spend pacing.
  • Website: GA4 sessions, tour bookings and contact key events by landing page and community.
  • Renewals: renewal rate and move-outs by community, for teams that report retention alongside acquisition.
08

Should you build it in Data Studio or buy a multifamily analytics tool?

A packaged multifamily tool suits a portfolio that already runs on that vendor's CRM or property management system and wants reports with little data work. The trade-off is that the reports cover what the vendor's system sees, and changing a definition depends on the vendor.

A custom Data Studio dashboard suits portfolios that use several systems across communities (common after acquisitions), agencies reporting on many multifamily clients, and teams that want one definition of cost per lease across every channel. It is free to view, sits in your own Google account, and can draw on BigQuery when the data grows.

It is not worth building if leasing staff do not record a source on guest cards. Fix source capture first; until then any dashboard, bought or built, will report guesses.

NeedPackaged multifamily toolCustom Data Studio build
Ready-made leasing reportsYesBuilt to your definitions
Several CRMs or property systems across the portfolioOften limited to its own stackYes, combined in BigQuery or Sheets
First-source and last-source views side by sideDepends on the toolYes
Ownership of reports and dataInside the vendor's softwareIn your Google account
Viewer licencesSet by the vendorFree; Pro only for creators who need it
09

What mistakes make multifamily marketing reports misleading?

Most misleading reports are not wrong; they stop too early or credit the wrong channel. These are the issues we check first when we review an existing report.

  • Ranking channels on cost per lead, which rewards high-volume, low-intent listing leads.
  • Crediting every lease to the website because it was the last touch before the tour booking.
  • Counting duplicate guest cards when the same prospect enquires through two channels.
  • Reporting one blended portfolio cost per lease, which hides the communities in lease-up.
  • Segmenting housing campaigns by age, gender or ZIP code, which Google's housing policy does not allow for targeting.
  • Leaving spend for listing sites out of the dashboard because it is paid by invoice, not through an ad platform.
10

How Greenwolf Tech Labs builds multifamily marketing dashboards

We start with a free review of your channels, listing site contracts, leasing CRM exports, property management system reports and the source values your leasing teams already use. Then we agree KPI definitions, build the mapping table and data layer in BigQuery or Sheets, design the portfolio and property pages in Data Studio, and reconcile leases and spend against the source systems before handover.

Our team has delivered 100+ projects for 200+ clients, and our marketing dashboards bring Google Ads, Meta, LinkedIn, GA4 and Search Console into one view. We quote a fixed price after the review, and every report and data source is transferred to accounts you own.

FAQ

Frequently asked questions

What KPIs should a multifamily marketing team track?

Track leads, tours and leases by source, lead-to-tour and tour-to-lease rates, cost per lead, cost per lease, and occupancy and exposure by community. Cost per lease is the number that ties spend to filled units. Add renewal rate if the team also owns retention.

How do you calculate cost per lease?

Divide marketing spend for a channel by the leases signed from that channel in the same period. Use the first source recorded on the guest card where possible, because last-touch credit often moves leases to the property website. Include listing site fees paid by invoice, not just ad platform spend.

Can Data Studio connect to Yardi, RealPage or Entrata?

Not through a native Data Studio connector. The usual route is a scheduled report export or an API job that writes weekly lease, move-in and occupancy counts by community to Google Sheets or BigQuery. Data Studio then reads that table alongside ad and website data.

Can housing ads be targeted by ZIP code in Google Ads?

No. In the United States and Canada, Google's housing policy does not allow targeting by ZIP code, gender, age, parental status or marital status. Radius targeting of at least 1 km, city and country targeting remain available, and in Canada the first three characters of a postal code.

Why do our CRM leases not match our marketing reports?

Ad platforms count conversions such as form fills and calls, many of which are duplicates or never tour. The property management system counts signed leases, often credited to a different source. A dashboard that joins both by week, community and source makes the gap visible.

Is there a free multifamily marketing dashboard template?

Connector vendors publish generic marketing templates for Data Studio covering ads, GA4 and search. They do not include tours, leases or occupancy from the property management system, which are the numbers that matter. Most teams start from a template and add those sources.

Do community managers need a paid licence to view the dashboard?

No. Data Studio is free for creators and viewers. Data Studio Pro costs $9 per user per project per month and applies only to creators, editors and managers in Pro workspaces, so managers who view reports never need one.

Reviewed by Team Greenwolf Tech Labs · 18 Nov 2026

Get started

Tell us what your reporting has to do

Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.

  • Free 30-minute reporting review
  • Fixed quote before any work starts
  • Everything built and owned in your Google account

Prefer email? info@greenwolftechlabs.com

Get a free proposal

Two lines is enough to start.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.

Ask us anything

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.