If you've never worked with a Salesforce consultant, it's hard to picture what the engagement actually looks like. Is it one big project? A list of tickets? Strategy calls?
Here's the honest answer: it's a steady stream of very specific, very practical requests. Below is a categorized log of 50+ real requests I delivered for Pezon Properties, a Pennsylvania real estate acquisition company (identifying details like phone numbers and internal links removed). If you run acquisitions on Salesforce — or are thinking about it — this is the most realistic preview you'll find of what a consultant actually does.
25
Metrics in one campaign dashboard
1. Campaign Performance & ROI Reporting
The single biggest request: a dashboard that tracks the entire marketing funnel by campaign, filterable by week, month, and quarter. Twenty-five metrics, including:
- Volume: total cost, total mail sent, gross and net lead counts, gross and net response rates
- Conversion: opportunity count and conversion rate, appointment count and rate, signed agreement count and rate, closed deal count and rate
- Unit economics: cost per gross lead, net lead, opportunity, appointment, signed agreement, and closed deal
- Profitability: gross and net profit, profit per unit, and return multiple on marketing spend
Supporting requests: quarterly campaign automation (old campaigns deactivate when new ones start, with consistent naming like "2024 Q4 Municipal Liens"), and reports on time-to-respond for text messages and lead age per path stage.
This is the system behind the Pezon Properties results: +15% faster acquisitions and real-time net profit per deal. See the full case study →
2. Lead Source & Campaign Attribution
ROI reporting is only as good as attribution. Several requests existed purely to make sure every lead carries the right source and campaign:
- Call-tracking attribution — each marketing channel (web, PPC, Google Business Profile per city, direct mail) has a dedicated tracking phone number; the lead source and campaign are set automatically based on the number the seller called
- Cross-channel matching — when a web or PPC lead comes in from an address that already received a direct mail letter, the direct mail campaign is automatically associated, matched by street address
- Unique numbers per direct mail campaign — inbound calls on a campaign's tracking number auto-generate a homeowner lead record tied to that campaign
- Campaign mapping to activities — the campaign field flows from lead/opportunity to tasks and events, so activity reports segment by channel too
3. Lead Lifecycle Automation
Acquisition teams live and die by follow-up discipline. These requests automate it:
- Auto status updates — "New" flips to "Working" the moment an outbound call, text, or email is logged; "Working" flips to "Follow-up" after 30 days of no activity
- Stale-lead escalation — if a lead sits in "New" for more than 24 hours, the sales inbox and lead manager get an automated email
- Follow-up task automation — every new lead spawns an assigned follow-up task with an email notification; overdue tasks trigger reminder emails with leadership CC'd
- Disposition-driven branching — call outcomes ("answered", "follow up") route the lead to different statuses and create the right next task automatically
- Conversion gates — leads can't be converted to qualified without units, beds/baths, square footage, full name, complete address, and occupancy filled in, with an error message that links to the missing fields
- Clean conversion — on conversion, every detail (negotiation notes, campaign, lead source) migrates to the opportunity automatically
4. Data Governance & Compliance
- Process enforcement — manual opportunity creation removed for non-admins (the only path is lead conversion); lead-status edit access locked down
- Duplicate handling — rules for prospect-vs-homeowner collisions that preserve historical homeowner records and campaign attribution
- Do-not-contact compliance — a Do Not Mail campaign where every member is flagged across all four channels: do not mail, do not call, do not text, email opt-out
- Role-based access — per-user permission matrices (a transaction coordinator who can edit transactions but only read leads; a marketing coordinator with import and campaign rights)
5. Transaction Coordination App Rebuild
The largest single engagement: rebuilding the transaction coordination application so the checklist adapts to the deal instead of asking the same 60 questions every time.
- Cash vs. financed logic — cash purchases automatically hide loan request, lender appraisal, and inspection-financing fields
- Unit-count logic — single-family and small multi-family deals hide property-management presale steps; 5+ unit properties keep the full diligence set; seller deliverables default based on unit count
- A 40+ field property onboarding checklist stage — everything from utilities, insurance, and mortgage details to laundry rooms, mailbox keys, fire escapes, and lead-paint disclosure — inserted as a new stage between due diligence and contingency management
- Quality-control gates — a required QC checkbox (comps and rehab budget reviewed) that blocks stage progression until checked
- Field mapping — purchase price, rehab cost, and unit count flow from opportunity to transaction; the opportunity owner maps to acquisition rep and manager fields automatically
- Financial fields — carrying cost, closing cost, and selling cost fields with auto-calculated equity and return multiple
6. Call & Response Analytics
For a seller-facing team, answer speed is revenue. These requests measure it honestly:
- Speed-to-lead report — elapsed time between lead creation and the first genuine outbound activity (excluding incoming texts, which aren't a response)
- Missed-call-to-callback time — measuring only valid missed calls (spam excluded), per rep
- Live answer rate — missed calls tagged to the right owner by tracking number so the percentage is real
- Activity logging fixes — calls and SMS logged consistently across lead, opportunity, and person account records for the same human being
7. Integrations & Imports
- DocuSign — agreements of sale sent from the CRM with status tracked back on the deal
- Google Sheets + Zapier lead import — bulk lead uploads assigned to the correct campaign with no manual data entry
- Direct mail previews — letter previews routed to the marketing coordinator for approval before sending
- Call script tooling — a guided lead call form with inbound/outbound toggles, stacked (not overwritten) notes, and appointment assignment to any user
What This List Teaches You
First: almost nothing on it is exotic. It's flows, validation rules, formula fields, report types, and well-designed page layouts — applied relentlessly to one business model. The value isn't in rare technology; it's in knowing what an acquisition operation needs before they ask.
Second: the requests compound. Call-tracking attribution feeds the ROI dashboard; conversion gates feed clean transaction data; clean transaction data feeds net profit per deal. A consultant who only does tickets in isolation builds none of that compounding.
Third: this is what "ongoing CRM management" means in practice. Not a retainer for emergencies — a steady cadence of improvements, each small enough to ship in days, each making the next one more valuable.
Want a request log like this for your company?
I offer a free 30-minute audit — bring your current Salesforce frustrations and I'll show you what the first ten requests should be.
Book Free Audit →