How do I get a report that gives me the closing ratio for my reps?

In order to calculate the closing ration of your sales, you need to combine the output from two separate reports. Towards the end of the reporting period, run a pipeline report to get a snapshot of Opportunities’ revenue and status at that point. Once the reporting period closes, run the Won/Loss report to report on how many of those deals were closed successful. You can then combine the reports in Excel and create a formula to calculate the closing percentage.

Another option is to set a quota for your Reps in the User Management section of the Prophet Administrator page. Then you can run a report under Account Sales to calculate how the reps are performing to that quota.

Prophet CRM: Prophet OnDemand Closing Ratio Dialog Box