Where can I find the lead Deal Size attribute for my BI analysis?

You can find the lead Deal Size attribute in multiple subject areas. For example, in the Sales - CRM Pipeline subject area, it's available in the Facts > Lead Facts folder. In this subject area, and in many others, Deal Size is renamed Potential Revenue.

Here's how to find all the subject areas that include Deal Size:

1. Download the spreadsheet for your release from the customer connect post R13.x CX OTBI Subject Area to Database Lineage Mapping Spreadsheet.
2. Filter column G, DATABASE_OBJECT, on MKL_LM_LEADS.
3. Filter column H, DATABASE_COLUMN, on DEAL_SIZE.

Column A, SUBJECT_AREA, lists the subject areas where the attribute is available. Column B, PRESENTATION_TABLE lists the folders that contain the Deal Size attribute.

Attention: In most of the subject areas, Deal Size is called Potential Revenue.

Here's a list of the subject areas, the folders, and attribute names for lead Deal Size in the 23C spreadsheet.

Subject Area	Folder	Attribute Name
Marketing - CRM Lead to Order	Lead Facts	Potential Revenue
Marketing - CRM Campaigns and Leads Real Time	Lead Facts	Potential Revenue
Marketing - CRM Campaign Performance	Lead Facts	Potential Revenue
Marketing - CRM Leads	Lead Facts	Potential Revenue
Marketing - CRM Leads Real Time	Lead Facts	Potential Revenue
Partners - CRM Leads and Opportunities Real Time	Lead Facts	Potential Revenue
Marketing Segmentation Leads	Lead	Deal Size
Marketing Segmentation Leads	Lead Facts	Potential Revenue
Partners - CRM Partner Overview	Partner Registered Lead Facts	Deal Size
Partners - CRM Registered Leads Real Time	Partner Registered Lead Facts	Deal Size
Sales - CRM Customer Overview	Lead Facts	Potential Revenue
Sales - CRM Pipeline	Lead Facts	Potential Revenue
Territory Management - CRM Leads	Lead Facts	Potential Revenue