Opportunity Export

Use the Opportunity Export report to download opportunity data to a Microsoft Excel spreadsheet file or other file format.

Contents

Column	Description
Opportunity Name	This column displays the name of the opportunity.
Number	This column displays the opportunity identifier.
Organization	If your enterprise uses organizations, this column displays the identifier for the organization that is responsible for pursuing the opportunity.
Organization Name	If you use organizations, this column displays the name of the organization that is responsible for pursuing the opportunity.
Primary Customer	This column displays the name of the primary client associated with the opportunity.
Primary Contact Name	This column displays the name of the primary contact associated with the opportunity.
Project Number	If you created a project record from the opportunity record, this column displays the project number.
Project Name	If you created a project record from the opportunity record, this column displays the project name.
Promotional Project Number	If you created a promotional project to track and bill charges for proposal generation, this column displays the promotional project number.
Promotional Project Name	If you created a promotional project to track and bill charges for proposal generation, this column displays the promotional project number.
Organization Status	This column displays the status of the organization: Active, Inactive, or Dormant.
Project Manager Name	This column displays the name of the employee serving as project manager for the opportunity.
Principal Name	This column displays the name of the principal responsible for the opportunity.
Supervisor Name	This column displays the name of the employee serving as supervisor for the opportunity.
Est. Revenue	This column displays the estimated revenue you expect to earn from the opportunity.
Probability	This column displays the probability that the opportunity will become a project. For example, if that probability is 80%, this column contains 80.
Weighted Revenue	This column displays the weighted revenue for the opportunity: Estimated revenue x probability / 100.
Date Opened	This column displays the date on which you identified the opportunity and began pursuing the job.
Date Closed	This column displays the date on which you closed the opportunity (for example, the date you stopped pursuing the opportunity or the date you were awarded the job).
Days Open	This column displays the number of days the opportunity has been open. For a closed opportunity, this column displays the number of days from the date it was opened to the date it was closed.
Stage	This column displays the current stage of the opportunity (for example, Pending, Proposal Submitted, or Awarded).
Type	This column displays the type of the opportunity (for example, Educational, Municipal, or Medical).
Source	This column displays the source of the opportunity (for example, Client Referral, Consultant Job, or Marketing Campaign).
Status	This column displays the current status of the opportunity: Active or Inactive.
Est. Start Date	This column displays the date you expect to begin work if you are awarded the contract.
Est. Compl. Date	This column displays the date you expect to complete the work if you are awarded the contract.
Address 1 - 3	This column displays the opportunity mailing address information (street name and number, suite number, post office box number).
City	This column displays the city from the opportunity address.
State	This column displays the two-character abbreviation for the state from the opportunity address.
Zip	This column displays the zip code from the opportunity address.
Country	This column displays the country from the opportunity address.
Create User	This column displays the user ID of the person who created the opportunity record.
Create Date	This column displays the date on which the opportunity record was created.
Modify User	This column displays the user ID of the person who most recently modified the opportunity record.
Modify Date	This column displays the date on which the opportunity record was most recently modified.
Description	This column displays the description of the opportunity.
Closed Reason	This column displays the reason the opportunity closed.
Closed Notes	This column displays any description that relates to the closing of the opportunity.
Period of Performance	This column displays the calendar years that you expect to work on the contract associated with the opportunity.
Total Contract Value	This column displays the amount of the total contract value that you expect your company to earn, if you are awarded the contract associated with the opportunity.