ERW9 – AgentPULSE Reports
(Executive Reports Warehouse #9)
What’s my closing schedule look like? How am I doing so far this year?
AgentPULSE are a set of reports that managers can use with agents to help them keep tabs on their day to day business as well as review past performance, sources of business, and monitor future production.

Of key interest for each agent is the pending business that is in the pipeline. A number of reports are available to help monitor this potential. Sales only pendings are reported using erw9-2 above. Included are:
Other pending reports will print all sale types pending, and sales to close within a specified close date range.

Closed transactions can be reported with erw9-5 and –6. Key production figures for the agent are included for a specified close date range.

Another format for the agent’s closed sale commission reporting are the "commission determination" reports. They are typically used to report over the current agent’s commission plan period and will report the detailed earnings as well as the accumulated figure that the agent’s plan may be based on.
Included in the report for each closed transaction are:
Erw9-9 above shows cumulative company dollar in the rightmost column. If your scales are based on another figure these reports are also available:
Report name cumulates figure
Erw9-10 agent gross commission
Erw9-11 agent NAGCI
Erw9-12 agent AGCI
Erw9-13 agent volume

To help agents with follow-up and details, the drill-down shown above is available within the commission reports for each individual transaction. Seller and buyer demographics such as phone numbers, source, addresses, spouse, and company are included.

A number of listing reports are included to assist the agent. The above report is used for help maintain a pulse on the active listings. It is ordered by the street name and also includes:

To obtain seller details, use the drill-down report as shown above. Seller phone numbers and mailing address are included to assist with follow-up.

Report erw9-15 is an active listing detail report showing listing and seller information. The report is ordered by street name.
Other active listing reports include:

Agent listings written are detailed with report erw9-20 as shown above. The listings taken are sorted by listing date.

Drill-downs are included for seller information, and if the listing is sold, buyer information as well.

Pending transactions for the agent with seller and buyer information is included in the erw9-21 report. Items:

Seller and buyer details can be viewed with built-in drill-down as shown above.

For pending sale details, use the ewr9-22 report as shown above. Key information is included for the agent plus seller and buyer details. Similar reports showing seller and buyer information for closed sales are available in reports ewr9-23 and erw9-24.
These reports are included in the erw9, AgentPULSE portion of the warehouse:
.rpt Name ewr9 AgentPULSE report name contents
erw9- 1 agent's pendings - all sales pendings
erw9- 2 agent's pendings - sales only pendings
erw9- 3 agent's pendings - all sales pendings to close in date range
erw9- 4 agent's pendings - sales only pendings to close in date range
erw9- 5 agent's closings - all sales closed in date range
erw9- 6 agent's pendings - sales only closed in date range
erw9- 7 agent's written - all sales pending date range
erw9- 8 agent's written - sales only pending date range
erw9- 9 agent commission determiniation closed in date range - cumulate company dollar
erw9- 10 agent commission determiniation closed in date range - cumulate agent gross
erw9- 11 agent commission determiniation closed in date range - cumulate NAGCI
erw9- 12 agent commission determiniation closed in date range - cumulate AGCI
erw9- 13 agent commission determiniation closed in date range - cumulate Volume
erw9- 14 active listings by street all active listings
erw9- 15 active listings Detail by street all active listings
erw9- 16 active listings by Price all active listings
erw9- 17 active listings Detail by Price all active listings
erw9- 18 active listings by Expiration active listings within expiration date range
erw9- 19 active listings Detail by Expiration active listings within expiration date range
erw9- 20 written listings by list date all listings
erw9- 21 pending sales information pending sales
erw9- 22 pending sales Detail information pending sales
erw9- 23 closed sales information closed sales
erw9- 24 closed sales Detail information closed sales