# Auditing a data vendor before you sign the contract
A vendor's sales deck shows a beautiful heat mapmapUsing software to automate repetitive marketing tasks and campaigns, enabling personalisation at scale across channels like email, web, and social.View full definition → of "real-time" cap rates across 50 US metros. You ask one question: "When was this last updated?" The answer is "last quarter." That single gap between the word "real-time" and the reality of a 90-day lag is the entire subject of this lesson.
Real estate data vendors sell confidence. Your job before signing a six-figure annual license is to test whether that confidence is earned. This lesson walks through a live-style audit framework you can run on any vendor: CoStar, Green Street, Reonomy, Yardi Matrix, or a scrappy proptech startup pitching "alternative data."
Real estate is structurally opaque. Unlike public equities, there is no centralized tape of every transaction. Data comes from a patchwork of county recorders, brokers, surveys, and scraped listings. That fragmentation means two vendors covering "the same" market can show cap rates 50 to 100 basis points apart, simply because of different sample construction.
Contrast this with public markets, where a Bloomberg terminal and a Reuters terminal will show you the same closing price. In real estate, the vendor's methodology *is* the product. If you don't audit it, you're licensing someone else's blind spots.
Ask for the actual timestamp logic, not marketing language.
Audit test: pull the same metric (say, Manhattan office vacancy) from two vendors dated the same week. If they diverge by more than 200 to 300 basis points, ask both for their as-of date and sample size. The divergence is usually a cadence or sample problem, not a market mystery.
This is the audit step most buyers skip, and the one that causes the most expensive mistakes.
Ask three questions:
1. What's the universe? A vendor covering "US multifamily" might only track properties over 50 units, missing the small-balance stock that dominates many secondary markets.
2. How is the sample sourced? Broker-submitted data over-represents institutional-grade, professionally marketed assets. Publicly recorded deed data over-represents smaller, less complex transactions (because large portfolio deals are often structured to avoid a single recordable event).
3. Is there survivorship bias? Repeat-sales indices (like the Case-Shiller Home Price Index, a well-established methodology) only include properties that sold at least twice. That excludes new construction and long-hold assets, which can bias the index toward more liquid, more traded submarkets.
Worked example of sample bias distorting a benchmark:
Suppose a vendor reports average US industrial cap rates at 5.8% (illustrative, not a real current figure) based on 200 tracked deals. If 150 of those 200 deals are Class A logistics assets near major ports (because those are the deals brokers push hardest to data vendors), the "national average" is really a large-asset, coastal-market average. A Class B infill industrial building in a secondary market could realistically trade 100 to 150 basis points higher, and the vendor's number would mislead you about it.
The fix isn't to reject the vendor. It's to ask for a sample breakdown by asset class, geography, and deal size before you apply their benchmark to your specific deal.
A vendor confident in its data will publish (or at minimum, share on request under NDA):
Red flag: "proprietary methodology, cannot disclose" with zero white paper, zero methodology PDF, and zero named data scientist or economist backing the number. Reputable vendors like NCREIF (National Council of Real Estate Investment Fiduciaries, which runs the widely cited NPI, the NCREIF Property Index) publish detailed methodology documents precisely because institutional buyers demand it.
| Dimension | Question to ask | Green flag | Red flag |
|---|---|---|---|
| Cadence | "What's the median lag between event and data availability?" | Specific number, by data type | "Real-time" with no specifics |
| Bias | "What percentage of your sample is broker-submitted vs. public record?" | Clear percentage breakdown | "We aggregate everything" |
| Methodology | "Can I see the index construction white paper?" | PDF exists, peer-reviewed or industry-audited | Verbal explanation only |
| Coverage | "What's excluded from this universe?" | Named exclusions (e.g., sub-$5M deals) | "We cover the whole market" |
Score each 0 to 2. Anything below 5 out of 8 is a license fee you're paying for a marketing narrative, not a defensible dataset.
If you have APIAPIApplication Programming Interface: a standardised interface that lets applications communicate and exchange data without knowing each other's internal workings.View full definition → or CSV access to a trial dataset, a basic reconciliation script forces the bias question fast:
import pandas as pd
vendor_a = pd.read_csv("vendor_a_capstacks.csv")
vendor_b = pd.read_csv("vendor_b_capstacks.csv")
merged = vendor_a.merge(vendor_b, on="property_id", suffixes=("_a", "_b"))
merged["cap_rate_diff_bps"] = (merged["cap_rate_a"] - merged["cap_rate_b"]) * 10000
print(merged["cap_rate_diff_bps"].describe())
# If the standard deviation exceeds ~50-75 bps, dig into sample construction before trusting either feed.This won't tell you who's "right." It tells you where to point the methodology questions.
🎬 [VIDEO: "How Real Estate Data Actually Gets Collected" - https://www.youtube.com/results?search_query=how+real+estate+data+gets+collected - search for recent explainer content from CRE data providers or NCREIF walking through transaction data pipelines, useful for visualizing the lag between deal close and data availability]
Knowledge check
1. Why does a real estate data vendor's methodology matter so much more than in public equities?
2. A vendor's marketing deck describes its cap rate data as 'real-time.' What is the most important follow-up question to test this claim?
3. Two vendors report cap rates for the 'same' market that differ by 50-100 basis points. What is the most likely explanation given the lesson's framework?
4. Select ALL correct answers about why real estate data is structurally different from public equities data.
Select all the correct answers.
5. Select ALL correct answers about update cadence differences within a single real estate data vendor's offerings.
Select all the correct answers.
Once you've scored the vendor, use it in the negotiation, not just the decision:
Also check regulatory exposure on data sourcing. In the EU, vendors aggregating property or ownership data may touch GDPR (General Data Protection Regulation) if any personal data (individual owner names, for instance) is embedded in "commercial" datasets. In the US, county recorder data is public record, but scraped listing data can raise contractual issues with the source platform (MLS, Multiple Listing Service, terms of use). Ask your vendor how they're licensed to resell scraped data, not just how they collect it.