← Back to app

Reports on deals, leads, contacts and email

See closings, GCI, your pipeline, leads and speed to lead, your database and your email, for you, your team, or your whole team or brokerage.

Workspace settingA brand administrator can manage this in Settings → Features. It is not a separate paid add-on.

Open Reports → Deal reports for Production, Pipeline, Leads, Contacts and Appointments. Open Reports → Email reports for email. Goals are in Work → Goals. You see these reports when your workspace has the CRM turned on and you have permission to view deals.

Choose the period and the people

  • Period: a month, a quarter, a year, the last 12 months, or your own dates.
  • Show: your own numbers, your team, the whole team or brokerage, another team or one agent.
  • An agent sees their own numbers. A team leader sees their team. Admins, and people with the See all records permission, see the whole team or brokerage. A team that works under partner brokerages sees Whole team. A brokerage sees Whole brokerage.
  • Your team is you, the people you are Manager of, and the people they manage. To set a person's manager, open Settings → Users and select Details next to the person.

Each number is compared with the same dates a year earlier. Real estate is seasonal, so this October is compared with last October.

Every number opens its deals or contacts

Select a number to see the deals or contacts behind it. Select a deal or contact to open it.

How the numbers count

  • Closings and GCI count on the deal's closing date. With no closing date, they count on the day the deal was marked Won.
  • GCI is the GCI on the deal. With none, Berchtold uses your side's commission from the deal's rates and fees.
  • Contracts written count on the contract date. A contract that fell through still counts.
  • Pending is open deals under contract today.
  • Time in stage counts from the day a deal moved to its stage, or from the day it was made.

Deals at risk

Pipeline shows At risk: open deals with warning signs. Each night, Berchtold checks each deal in the Active and Under contract stages for these signs:

  • A Key Date passed and is still open.
  • A Key Date is due in the next 3 days and is still open.
  • No one touched the deal for too long: 21 days when Active, 7 days when Under contract.
  • A signature request was declined, or it was sent more than 3 days ago and is not signed.
  • The expected close passed on a deal under contract.
  • A deal under contract has no title company, or no lender when the buyer uses a loan.

Each sign adds points. At 35 points, a deal is At risk. At 60 points, it is High risk. The list shows the total GCI at stake. For each deal, it shows the risk level and its worst signs. Select Open the deal to work on it.

The points adjust to your own workspace. Once 10 closed deals had a sign, its points follow how many of those deals were lost. A sign that often came before a lost deal counts up to twice as much. A sign that rarely did counts as little as half. The Today plan and the Monday email use the same check.

Leads and speed to lead

  • A lead is a deal made in the period. Deals you imported are not leads.
  • The source is the original source of the lead's main contact, for example a web form, iHomefinder or Calendly.
  • Lead to closing follows the leads made in the period up to today. It counts how many reached an appointment, a contract and a closing. Here, an appointment is a lead that reached the Active stage.
  • First response is the time to the first call, text or email a person sent. Automations and AI do not count.
  • From your website shows the leads that came from a web page or website chat, by page and campaign. Website visits are in Audience.
  • Facebook & Instagram cost per lead shows when the report covers the whole team or brokerage. It uses the ad accounts you chose. It divides each campaign's ad spend by the contacts that campaign's lead ads brought into Berchtold. When Meta counts a different number, the row says so. See Facebook and Instagram ad results.

Appointments

  • Appointments booked count on the day they were booked. Appointments met count on the appointment's date.
  • Kept rate is the appointments met, divided by all appointments met, missed (no-shows) and canceled in the period. An appointment that still waits for an answer is left out.
  • The member who meets the client gets the credit. The report lists the appointments that wait for an answer. See Book and track appointments.
  • The Leads report still counts a lead that reached the Active stage as an appointment.

Contacts and email

  • Going cold is a contact with no call, text, email, note or task from a person in 90 days.
  • Email shows campaign email and one-to-one email. Email that a team program sends in a member's name counts for that member.
  • Open and click rates are out of the email delivered. Some email apps open email on their own, so open rates can look high.

All workspaces

If your organization has two or more workspaces, and you may see everyone's numbers in them, Show has All workspaces. The report adds them up, and a table shows each workspace.

Export

Select Export:

  • Download CSV saves the numbers on screen as a spreadsheet file.
  • Download PDF makes a branded report with the same period and people. Only you can open it.

Claude, ChatGPT and Muse can read the same reports through Berchtold.