Use these ready-to-copy prompts to help you generate reports and insights from Loft47 using MCP.

Each prompt includes recommended filters and formatting instructions to help you get more accurate results.

How to Use

• Select a prompt below.
• Copy and paste it into Claude AI.
• Replace the placeholders (date range, brokerage ID, office ID, agent name/ID, etc.) with your own values.
• Run the prompt and customize it further as needed.

📈 Production & Agent Performance

YOY Agent GCI Comparison
Compare agent Gross Commission Income year-over-year using closed transaction dates.
➡️ [MCP Prompt: Year Over Year Agent GCI Comparison]
"For brokerage [X] on Loft47 Production, compare each agent's Gross Commission Income — defined as total commission before deductions (totalCommissions) — year-over-year using closedAt as the date field: Jan 1 through today's date, vs. the same period last year. Group by agent, show total GCI for each period, the dollar change, and the % change. Exclude voided and collapsed deals. Sort by % change descending."

If user actually wants the net-of-split definition instead, they'd swap that clause to: "defined as net commission after brokerage split."

Monthly Production Review
Review monthly brokerage production, including sales volume, GCI, units closed, and top producing agents.
➡️ [MCP Prompt: Monthly Production Review]
"For brokerage [X] on Loft47 Production, review this month's production using closedAt as the date field — the 1st through today (or last day of month if reviewing a completed month). Include: total sales volume, total Gross Commission Income (GCI, defined as total commission before deductions), units closed, and the top 5 agents by GCI. Exclude voided and collapsed deals. Group agent totals by office if the brokerage has multiple offices."

Agent Activity Review
Identify agents with no closed deals within a selected timeframe.
➡️ [MCP Prompt: Agent Activity Review]
"For brokerage [X] on Loft47 Production, list all active agents who have zero closed deals between [start date] and [end date], using closedAt as the date field. Include agents with no deals in any status during that window, not just no closed ones — flag whether they have deals in conditional or firm status that just haven't closed yet, versus agents with no activity at all. Exclude terminated/inactive agent profiles from the list."

💵 My Earnings This Month & Year
Show an individual agent how much they've actually been paid out, month-to-date and year-to-date.
➡️ [MCP Prompt:  Agent Earnings by Month & Year]
"For brokerage [X] on Loft47 Production, show all commission payouts transacted to [agent name] for two periods: month-to-date (1st of this month through today) and year-to-date (Jan 1 through today), using transactedAt as the date field. For each period, show total gross commission, total deductions, and net amount paid out. Exclude voided and collapsed deals."

💰 Brokerage Revenue & Accounting

Brokerage Income Deduction Analysis
Review brokerage income deductions by agent and compare changes over time.
➡️ [MCP Prompt: Brokerage Income Deduction Analysis]
"For brokerage [X] on Loft47 Production, show income deductions — deductions where deductionType=income — grouped by agent and deduction template name, using closedAt as the date field for [start date] through [end date]. Compare totals to the same-length period immediately prior (or the same period last year, whichever comparison you want), showing dollar change and % change per agent and per deduction type. Exclude voided and collapsed deals."

🏠 Transaction Analysis

Closed Deals by Title Company
Analyze closed transaction activity by title company, agent, and sales volume.
➡️ [MCP Prompt: Closed Deals by Title Company]
"For brokerage [X] on Loft47 Production, list all closed deals between [start date] and [end date] using closedAt as the date field, grouped by title company, then by agent, showing count of deals and total sales volume for each grouping. Exclude voided and collapsed deals."

Closing Forecast
Review upcoming closings and estimated commission income.
➡️ [MCP Prompt: Closing Forecast]
"For brokerage [X] on Loft47 Production, show all deals with a closing date (closedAt) between [start date] and [end date] that haven't closed yet — status conditional or firm. Include property address, agent(s), sales price, and estimated Gross Commission Income (GCI, defined as total commission before deductions). Sort by closing date ascending. Exclude voided and collapsed deals."

More Prompts Coming Soon

Additional MCP prompt templates will be added as new reporting needs and use cases are identified.