Amr MagdySalesforce CRM Consultant
Recipes · by Amr Magdy · October 2026

20 Salesforce reports for a wholesaling team.

The Salesforce reports that matter most to wholesalers show where leads come from, how fast they’re called, which offers become contracts, and what each source costs per closed deal. Here are 20 report recipes written as report type, filter, grouping and measure, the limits to know, and which five belong on the Monday dashboard. To turn the stage counts into leads per deal, see funnel math from your own CRM.

Short version
  • These are 20 reports a wholesaling team can build in Salesforce, written as report type → filter → group by → measure, so you or your admin can build them in an afternoon.
  • Three features make them possible: custom report types (Property, Offer, Buyer), cross filters (“leads without activities”) and reporting snapshots (trends over time). source · snapshots
  • Most need fields that exist and are filled in: lead source as a picklist, call outcome, MAO, contract and assignment price, dead reason. Start with the CRM field kit.

20 reports for a wholesaling team

ReportReport typeFilterGroup byMeasureAnswers
Leads by source this monthLeadsCreated date = this monthLead sourceCountMonday 5
Speed to first contactLeads with activitiesCreated last 30 daysOwnerAverage minutes from created to first call (formula field)Speed to lead
Leads with no activity in 7 daysLeads with or without activities (cross filter: without activities in 7 days)Status not deadOwnerCountFollow-up
Missed inbound calls and callback timeTasks / call logsDirection inbound, outcome missed, last 7 daysDay, campaignCount; avg callback minutesMissed calls
Call outcomes by callerTasksType = call, last 7 daysCaller, outcomeCountCoaching
Contact rate by listLeads with activitiesSource = listList nameContacted ÷ dialed (summary formula)Lists
Appointments by campaignOpportunities or eventsCreated this monthCampaignCount; cost per appointmentMonday 5
Offers made vs contracts signedOffers with deals (custom report type)Offer date this monthRepOffers; contracts; ratioOffer discipline
Offers above MAOOffersOffer amount > MAO (formula flag)RepCountOffer discipline
Pipeline by stageOpportunitiesOpenStageCount; expected feePipeline
Days in stageOpportunities with field historyOpenStageAverage days (from stage history)Bottlenecks
Contract to first TC callOpportunities with activitiesUnder contract this monthTCAverage hoursClosing
Cost per closed deal by sourceCampaigns with opportunitiesClosed this quarter, fall-outs excludedLead sourceSpend ÷ closed dealsCost per deal
Booked vs realized feesOpportunitiesClosed this quarterMonthExpected fee; actual fee; differenceRevenue
Fall-outs by reasonOpportunitiesStage = cancelledDead reason, sourceCountHonest ROI
Dead leads with re-contact date this weekLeadsStatus = not now, re-contact date = this weekOwnerCountLong follow-up
Days from contract to assignmentOpportunitiesAssigned this quarterDispo repAverage daysDispo
Buyers who closed in 12 monthsBuyers with deals (custom report type)Closed in last 12 monthsBuyerDeals; total paidBuyer list
Who changed lead sourceLead historyField = lead sourceUserCountData trust
Weekly pipeline trendReporting snapshot objectLast 12 weeksWeekPipeline valueTrend

What Salesforce report limits should you know?

ItemLimit
Rows shown in a report2,000 in the interface; export for more
Custom report typesProfessional 50, Enterprise 300, Unlimited 2,000
Objects in one custom report typeUp to 60 object references, 1,000 fields
Joined reportsEnterprise and up, up to 5 blocks
Cross filtersUp to 3 per report
Dashboard componentsUp to 25 per dashboard
Reporting snapshotsProfessional and up; 200 in Professional
Field history20 fields per object, 18 months in the interface

Sources: limits · report types · joined reports · snapshots · field history

Which reports belong on the Monday dashboard?

Five, not twenty: leads by source, speed to first contact, offers vs contracts, cost per closed deal by source, and pipeline by stage. Everything else is for drilling in when a number moves. The reasoning and formulas are in the Monday 5; layout ideas in the pipeline dashboard guide.

Why do CRM reports get ignored?

Usually because nobody trusts the data. In Validity’s 2025 survey of 602 CRM users, 76% said less than half of their CRM data is accurate and complete. source The fix is upstream: picklists instead of free text, validation rules at each stage, lead source locked after creation, and a “who changed it” report so problems are visible.

Questions

What reports should a wholesaler run in Salesforce?

Start with leads by source, speed to first contact, leads with no activity in 7 days, offers vs contracts by rep, cost per closed deal by source and pipeline by stage.

How do I report on leads with no activity in Salesforce?

Use a cross filter: leads without activities, with a date condition such as the last 7 days. Salesforce allows up to 3 cross filters per report.

Can Salesforce show trends over time?

Yes. Reporting snapshots save a report’s results to a custom object on a schedule, so you can chart weekly pipeline or lead counts.

Why can I only see 2,000 rows in a Salesforce report?

The report interface shows up to 2,000 rows. Export the report to see all rows, or summarize with groupings.

Sources

  1. Salesforce Help: reports and dashboards limits
  2. Salesforce Help: custom report type guidelines
  3. Salesforce Help: joined reports
  4. Salesforce Help: reporting snapshots
  5. Salesforce Help: field history tracking
  6. Validity: The State of CRM Data Management in 2025

Last updated October 2026. Product names, editions and limits change; check the linked source before you rely on one. Not legal advice.

Want these reports built on clean data?

I build Salesforce for real estate investors and wholesalers, set up around how your team actually works. Start with a free 30-minute call or the fixed-price CRM Revenue Audit (USD 1,500).

Book a free 30-minute callSee the Revenue Audit

Already on Salesforce? See a sample audit report. On Podio, REsimpli or GoHighLevel? See how a move to Salesforce works.

Or just ask one question about your setup: email · WhatsApp · LinkedIn

Amr Magdy

About the author: Amr Magdy

Amr Magdy is a Salesforce CRM Consultant for US real estate investors and wholesalers. He runs the Salesforce for a two-market home-buying company in Ohio, where he built campaign ROI by market, missed-call alerts, shared lead queues and underwriting on the deal record, and he builds the same system for other investor teams. LinkedIn · Free tools · CRM Revenue Audit

Book a free callThe audit