Page tree
Skip to end of metadata
Go to start of metadata

To see the statistics on opportunities in your person reports, you can add opportunity columns.


Marketo is now standardizing language across all subscriptions, so you may see lead/leads in your subscription and person/people in These terms mean the same thing; it does not affect article instructions. There are some other changes, too. Learn more.

1. Go to  the Marketing Activities area.

2. Select your report from the navigation tree and click the Setup tab.
3. Double-click Opportunity Columns.
4. Select Shown from the drop-down menu.
5. Click the Report tab to see your report with opportunity metrics.



Scroll right to see more columns. 


6. To add or remove columns from the report, click any column heading and select Columns.
The available opportunity columns are:



Each opportunity is counted only once, based on the primary contact assigned to it. 

No OpportunityNumber of people who are not a primary opportunity contact.
Days No OpportunityAverage age, in days, of people who are not a primary contact.
Has OpportunityNumber of people who are a primary opportunity contact.
Has Opportunity %Percentage of people who are a primary opportunity contact.
Days Until OpportunityAverage number of days for conversion from person to primary opportunity contact.
Total Opportunity AmountSum of all opportunity amounts.
Avg Opportunity AmountSum of opportunity amounts, divided by the number of opportunities.
Total OpportunityNumber of all opportunities.
ClosedNumber of opportunities that have been closed, won or lost.
WonNumber of opportunities that have been won.
% WonPercentage of opportunities that have been won.
Total Won AmountSum of won opportunity amounts.
Days to CloseAverage number of days to close opportunities.
Days in SalesAverage length of the sales cycle (Days Until Opportunity + Days to Close).

Learn how to manage the size of your report.

Deep Dive

See what else you can do with reports in the Basic Reporting deep dive.