Read the Deals reports
See the forecast of open deals by month, where the open deals stand, and what was won and lost in a period, and export the list.
Open Deals, then Reports. With more than one pipeline, choose a pipeline or All pipelines under the title. Every report covers the pipeline you choose.
Forecast
The open deals by the month they are expected to close: this month and the five after it, with a line for dates that have passed and one for deals with no date. Each line gives the number of deals, their total and their weighted value.
The weighted value of a deal is its value times its stage's chance of winning. A deal worth 10,000 in a stage with a 50% chance weighs 5,000.
Open deals by stage
A bar for each stage shows its share of the open deals by number, over a table with each stage's chance of winning, number of deals, total and weighted value.
Won and lost
Choose the period at the top of Won and lost, then select Show.
The deals closed in the period, by the day each was marked won or lost:
- how many were won and lost, and their value;
- the win rate, which is deals won divided by deals won plus deals lost;
- the average value of a won deal;
- the average number of days from when a deal was added to when it was won.
The same figures follow by owner and by source, and lost deals by reason.
A period is in your own time zone. Between two dates shows two dates to fill in.
Amounts and empty figures
Amounts are added up per currency and never mixed or converted. Your team's own currency comes first.
A figure with nothing to count shows a dash. A win rate with no deals won or lost in the period is a dash, not 0%.
Export the list
Open List, narrow it to the deals you want, select More and then Export CSV. The file holds every deal the list matches, with its status, lost reason, source and dates. Times in the file are UTC.
From Board, Export CSV gives the open deals of the board's pipeline.
If a figure does not match what you see in the list, Contact support.
Ask Magpie support
Send Magpie staff a question about anything this article does not answer.