How to Track Real Estate Deal Profitability, Cost Per Lead, and Campaign ROI in Salesforce

Real estate companies track leads and deals in Salesforce. Their marketing spend — on direct mail, dialers, PPC, TV, and referral programs — lives in spreadsheets. At the end of the month, someone manually calculates which campaigns made money and which didn't.

This is the gap that costs the most: when you don't know your true cost-per-closed-deal by campaign, you can't allocate your marketing budget with any precision. You invest based on volume — which campaigns generate the most leads — instead of profitability — which campaigns generate leads that actually close at a profit.

Building this analysis directly inside Salesforce, connected to your actual deal data, solves that problem permanently.

The Four Financial Metrics That Matter

Before building anything, define exactly what you're measuring. For real estate acquisition companies, the four metrics that drive budget decisions are:

The Salesforce Object Model

To calculate these metrics inside Salesforce, you need financial data to live in the right places. The key principle: marketing spend belongs on the Campaign object, and deal financials belong on the Transaction or Opportunity object. The Campaign field on each Lead, Opportunity, and Transaction is the thread that connects them.

Campaign Object — Marketing Spend Fields

Add these custom fields to the Campaign object to capture your marketing investment:

• Monthly Spend — currency field for total spend this month on this campaign
• Spend to Date — cumulative spend since campaign launch
• Cost Per Mail Piece (for direct mail) — unit cost for calculations
• Total Pieces Sent — for calculating actual spend from unit cost

Transaction / Opportunity Object — Deal Financial Fields

Deal financials should live here, not in a spreadsheet:

• Contract Purchase Price — what you agreed to pay the seller
• Acquisition Closing Costs — title fees, legal, transfer taxes
• Renovation Budget / Actual Cost — for flips and wholetails
• Holding Costs — insurance, taxes, utilities during hold period
• Sale Price — what you sold the property for
• Selling Closing Costs — agent commission, title, other costs at sale
• Net Profit — formula field (see below)

The Net Profit Formula

A Salesforce formula field on the Transaction object calculates net profit automatically the moment fields are updated:

This formula runs in real time. The moment your transaction coordinator updates the sale price or enters final renovation costs, the net profit figure updates everywhere — in the record, in reports, and in dashboards.

Cost Per Lead by Campaign — The Report Structure

To calculate cost per lead by campaign, you need a report that joins Campaign spend data with Lead counts. In Salesforce, this is a Cross-Object Summary Report:

• Report type: Campaigns with Leads
• Grouping: Campaign Name
• Columns: Campaign Spend to Date, Lead Count (record count), and a formula column: Spend_to_Date__c / LEAD_COUNT
• Filter: Campaign Status = Active, Lead Created Date = this quarter

The result: a single table showing every active campaign, how many leads it generated, what it cost, and the cost per lead — updated every time the report is run.

Campaign ROI — Connecting Spend to Closed Deals

The most valuable report connects marketing spend all the way through to closed revenue and net profit. This requires Leads, Opportunities, and Transactions to all have the Campaign field correctly populated — which is exactly why lead source and campaign management automation is worth investing in early.

With that in place, a Cross-Object Summary Report across Campaigns → Leads → Opportunities → Transactions gives you a complete attribution chain: this campaign generated X leads at $Y CPL, produced Z opportunities at $A CPO, closed B deals at $C net profit each, and delivered a total ROI of D% on marketing spend.

The Dashboard View

With the reports built, the dashboard that leadership actually uses shows four components side by side:

• Cost Per Lead by Campaign — bar chart sorted high to low, showing which campaigns are expensive to generate leads from
• Cost Per Closed Deal by Campaign — the number that matters for budget allocation
• Net Profit by Lead Source — which sources generate the most profitable deals, not just the most deals
• Campaign Spend vs Revenue This Month — rolling 30-day view of marketing investment versus closed revenue

This dashboard answers the question leadership asks every month: "Where should we put next month's marketing budget?" Instead of answering from gut feel or volume metrics, you answer with data: the campaign that generates the highest net profit per dollar of marketing spend gets the budget increase.

What to Build First

If your Salesforce doesn't have any of this today, the priority order is:

• Step 1 — Add Campaign field to Transactions and build automation to populate it from the linked Lead/Opportunity
• Step 2 — Add financial fields to the Transaction object (purchase price, costs, sale price)
• Step 3 — Build the Net Profit formula field
• Step 4 — Add marketing spend fields to Campaigns and start populating them monthly
• Step 5 — Build the reports and dashboard once you have 30-60 days of data

The whole system can be live in 2-4 weeks. After that, every closed deal automatically feeds the financial analytics — no spreadsheets, no manual data pulls, no end-of-month scramble.