Lead List Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Most available columns show data from the Lead Info Center. In addition, you can use this tab to include columns that contain associated data. These are called "grid columns."

The list of columns in this topic includes all available grid columns. However, the grid columns that actually display on the Columns tab vary based on your selection in Grid Type on the General tab of the Options dialog box. The grid column labels begin with the grid type. For example, the each of the activities grid column labels begins with Activities - (Activities - Type, Activities - Start Date, and so on).

Contents

Field	Description
Lead Name	This column displays the lead’s full name.
Number (Title)	This column displays the lead's title (for example, CEO or Contracts Administrator).
Company	This column displays the name of the lead's current employer.
Status	This column displays the lead's status (for example, New or Qualified).
Source	This column displays the source of the lead (for example, the name of a specific conference or member list).
Rating	This column displays the rating of the lead's level of interest: Hot, Warm, or Cold.
Business Phone	This column displays the lead's business telephone number.
Leads Owner	This column displays the name of the employee at your firm who is associated with this lead as its "owner."
Description	This column displays additional text describing the lead.
Status Reason	This column displays the reason for the lead's status. For disqualified leads, this column could explain why the lead was disqualified.
Type	This column displays the type of lead (for example, Schools or Health Care).
Record Status	This column indicates if the lead is active or inactive: When a new lead is created, the record status is Active. When a lead is qualified, the record status changes to Inactive.
Address 1, 2, 3	This column displays the lead's street address (street name and number, suite number, post office box number).
City	This column displays the city from the lead's address.
State	This column displays the state from the lead's address.
Zip	This column displays the zip code from the lead's address.
Country	This column displays the country from the lead's address.
Business Fax	This column displays the lead's business fax number.
Mobile	This column displays the lead's cellular telephone number.
Home Phone	This column displays the lead's home telephone number.
Pager	This column displays the lead's pager telephone number.
Email Address	This column displays the lead's email address.
Web Site	This column displays the lead’s company Web site address.
Create User	This column displays the user ID of the person who created the lead record in the Lead Info Center.
Create Date	This column displays the date on which the lead record was created.
Modify User	This column displays the user ID of the person who most recently modified the lead record.
Modify Date	This column displays the date on which the lead record was most recently modified.
Custom Currency Code	If a currency code was specified in the Info Center, this column displays that code.
Activities - Completed	The activity can be Pending or Completed.
Activities - Type	This column displays the activity type (for example, Phone Call, Meeting, or Email).
Activities - Subject	This column displays a brief description of the activity (for example, Initial Consultation, Planning Meeting, Customer Lunch, or Follow-up Visit).
Activities - Start Date	This column displays the date and time that the activity is scheduled to begin.
Activities - Priority	This column displays the priority ranking that indicates the relative importance of individual activities: High, Medium, or Low.
Activities - Activity Owner	This column displays the name of the employee who is responsible for the activity.
Activities - Client Name	This column displays the name of the client associated with the activity.
Activities - Contact Name	This column displays the name of the contact associated with the activity.
Activities - Contact Bus. Phone	This column displays the work telephone number of the contact associated with the activity.
Activities - Opportunity	This column displays the name of the opportunity associated with the activity.
Activities - Project	This column displays the name of the project associated with the activity.
Activities - Marketing Campaign	This column displays the marketing campaign associated with the activity.
Activities - Location	This column displays the location where the activity occurred or will occur.
Activities - Notes	This column displays additional text that describes the activity.
Files - Description	This column displays a brief description of the file or Web address (URL).
Files - File Path	This column contains one of the following: The complete path for an external file. This path includes the file name and extension. If you preview the report, you can click the file path to open the file. The address (URL) for a Web site, intranet site, file transfer (FTP) site, and so on. If you preview the report, you can click the file path to go to that address.
Files - Graphic	This column contains a Y or N (yes or no) to indicate whether or not the file is a graphic file.
Marketing Campaigns - Number	This column displays the marketing campaign identifier.
Marketing Campaigns - Name	This column displays the name of the marketing campaign.
Marketing Campaigns - Status	This column displays the status of the marketing campaign: Active or Inactive.
Marketing Campaigns - Type	This column displays the type of marketing campaign (for example, Webcast, Direct Mail, or Seminar).
Marketing Campaigns - Launch Date	This column displays the marketing campaign's launch date.
Marketing Campaigns - End Date	This column displays the marketing campaign's ending date.
Row Count	This column displays the total number of detail lines for each group, based on the sorting and grouping selections on the Sorting/Grouping tab. If the report groups data at more than one level, this column displays row counts for all grouping levels.