|
Analytics > Designing an Analysis > Getting Started with Analytics > Selecting Subject Areas > Advanced Custom Objects Historical Analytics Subject Area
Advanced Custom Objects Historical Analytics Subject Area
Availability
This subject area is available in all editions of Oracle CRM On Demand.
Business Purpose
This subject area provides the ability to analyze advanced custom objects.
The Advanced Custom Objects Historical Analytics subject area is a specialized subject area that allows the reporting of the one-to-many and many-to-one relationship between Custom Objects 01, 02, and 03 and certain prebuilt objects. Because the Advanced Custom Objects Historical Analytics subject area unites the reporting of a number of objects under a single subject area, it is necessary to include a determining metric for the analysis to help it choose a relationship path among the objects included in the analysis. Whenever two or more dimensions are in an analysis, Oracle CRM On Demand analytics requires a metric to relate the dimensions. If the report does not include a metric, Oracle CRM On Demand analytics chooses one randomly.
The many-to-many relationship is implemented for Custom Objects 01, 02, and 03 and account, contact, service request, and opportunity in Analytics. Therefore, it is possible to report on the one-to-many relationship between Custom Objects 01, 02, and 03 and these objects.
Relationship Type
Federated
Dimensions
This subject area has the following dimensions:
- Account
- Campaign
- Contact
- Custom Object 01
- Custom Object 02
- Custom Object 03
- Opportunity
- Owned By User
- Service Request
Metrics
The complete list of metrics for these subject areas is as follows:
- Account Metrics
- Account Custom Metrics
- Account Optimized Custom Metrics
- Number (#) of Accounts
- Number (#) of Accounts with Opportunities
- Average (Avg) Closed Revenue
- Average (Avg) Revenue
- Average (Avg) Days to Close Opportunity (Definition: The number of days to close an opportunity divided by the number of wins.)
- Campaign Metrics
- Campaign Optimized Custom Metrics
- Number (#) of Accounts for Campaign
- Number (#) of Campaigns
- Number (#) of Campaigns Active
- Number (#) of Campaigns Completed
- Number (#) of Campaigns Planned
- Number (#) of Contacts for Campaign
- Number (#) of Leads
- Number (#) of Opportunities
- Number (#) of Wins
- Percentage (%) of Budget (Definition: The cost multiplied by 100, then divided by the budgeted cost.)
- Percentage (%) of Lead Target Achieved (Definition: The number of leads multiplied by 100, then divided by the lead target.)
- Percentage (%) of Revenue Target Achieved (Definition: The closed revenue multiplied by 100, then divided by the revenue target.)
- Average (Avg) Cost Per Closed Sale (Definition: The average cost divided by the number of wins.)
- Average (Avg) Cost Per Lead (Definition: The average cost divided by the number of leads.)
- Average (Avg) Days to Convert Lead (Definition: The number of days between the lead-created date and lead-converted date divided by the number of leads converted to opportunities.)
- Cost per Closed Sale (Definition: The cost divided by the number of wins.)
- Cost per Lead (Definition: The cost divided by the number of leads.)
- Lead Conversion Rate (Definition: The leads who became customers, expressed as a percentage.)
- Opportunity Win Rate (Definition: The total number of win opportunities, divided by the total number of won and lost opportunities.)
- Return on investment (ROI)
- Contact Metrics
- Contact Custom Metrics
- Contact Optimized Custom Metrics
- Home Value
- Average (Avg) Home Value
- Average (Avg) Home Value (000)
- Home Value
- Home Value (000)
- Total Assets
- Average (Avg) Total Assets
- Average (Avg) Total Assets (000)
- Total Assets
- Total Assets (000)
- Total Expenses
- Average (Avg) Total Expenses
- Average (Avg) Total Expenses (000)
- Total Expenses
- Total Expenses (000)
- Total Income
- Average (Avg) Total Income
- Average (Avg) Total Income (000)
- Total Income
- Total Income (000)
- Total Liabilities
- Average (Avg) Total Liabilities
- Average (Avg) Total Liabilities (000)
- Total Liabilities
- Total Liabilities (000)
- Total Net Worth
- Average (Avg) Total Net Worth
- Average (Avg) Total Net Worth (000)
- Total Net Worth
- Total Net Worth (000)
- Year To Date (YTD) Sales
- Average Year To Date (Avg YTD) Sales
- Average Year To Date (Avg YTD) Sales (000)
- Year To Date (YTD) Sales
- Year To Date (YTD) Sales (000)
- Number (#) of Clients
- Number (#) of Contacts
- Number (#) of Prospects
- Custom Object 01-03 Metrics
- Custom Object 01-03 Custom Metrics
- Custom Object 01-03 Optimized Custom Metrics
- Number (#) of Custom Objects 01-03
- Opportunity Metrics
- Opportunity Custom Metrics
- Opportunity Metrics by Open Date
- Number (#) of Contacts with Opportunities (Optys)
- Number (#) of Open Opportunities
- Number (#) of Opportunities
- Number (#) of Wins
- Average Number (Avg #) of Days in Stage
- Average (Avg) Deal Size (Definition: The average size of each sale for each customer, expressed as the number of units or revenue amount.)
- Average (Avg) Sales Cycle
- Closed Revenue
- Expected Revenue
- Opportunity Loss Rate
- Opportunity Win Rate
- Revenue
- Opportunity Optimized Custom Metrics
- Number (#) of Contacts with Opportunities (Optys)
- Number (#) of Open Opportunities
- Number (#) of Opportunities
- Number (#) of Wins
- Average Number (Avg #) of Days in Stage
- Average (Avg) Deal Size
- Average (Avg) Sales Cycle
- Closed Revenue
- Closed Revenue (000)
- Expected Revenue
- Expected Revenue (000)
- Opportunity Loss Rate
- Opportunity Win Rate
- Quarter Ago Closed Revenue
- Quarter Ago Closed Revenue (000)
- Quarter Ago Opportunity Revenue
- Quarter Ago Opportunity Revenue (000)
- Revenue
- Revenue (000)
- Service Request Metrics
- Service Request Custom Metrics
- Service Request Metrics by Close Date
- Number (#) of Cancelled Service Requests (SRs) (Close Date)
- Number (#) of Closed Service Requests (SRs) (Close Date)
- Average (Avg) Days to Close Service Requests (SRs) (Close Date)
- Average (Avg) Minutes to Close Service Requests (SRs) (Close Date)
- Service Request Optimized Custom Metrics
- Number (#) of Cancelled Service Requests (SRs)
- Number (#) of Closed Service Requests (SRs)
- Number (#) of Open Service Requests (SRs)
- Number (#) of Pending Service Requests (SRs)
- Number (#) of Service Requests (SRs)
- Average (Avg) Days to Close Service Request (SR)
- Average (Avg) Minutes to Close Service Requests (SRs)
- Average (Avg) Open Service Request (SR) Age
- Average (Avg) Open Service Request (SR) Age (Minutes)
Usage Notes
Analyses with no results can occur due to several reasons. One reason is the lack of a metric in the analysis. Your analysis must contain at least one metric.
You can also get an analysis with no results if you are using two custom objects that are not directly linked to each other. To analyze the association between a custom object and another object including another custom object, the objects must be directly associated. For example, if an Account object is directly associated to Custom Object 01 and Custom Object 03, then you can report on the association between Account and Custom Object 01 as well as the association between Account and Custom Object 03. However, you cannot report on the combined association among Account, Custom Object 01 and Custom Object 03 unless a direct association between Custom Object 01 and Custom Object 03 is defined in the application.
Taking this example further, if an Account object is directly associated to Custom Object 01, and Custom Object 01 is directly associated to Custom Object 03, then you can report on the association between Account and Custom Object 01 as well as the association between Custom Object 01 and Custom Object 03. However, the combined association between Account, Custom Object 01, and Custom Object 03 cannot be reported on unless there is a direct association between Account and Custom Object 03 as defined in the application.
The Account, Contact, and Service Request dimensions include a Book hierarchy, which enables you to analyze metrics and related attributes at any level.
Associated Object Custom Fields
An associated object's custom fields are not available for use in reports in the Advanced Custom Objects Historical Analytics subject area. For example, if you create a field for a custom object as a related field of another custom object, then the new field is not available under the main object folder in the Advanced Custom Objects Historical Analytics subject area. However, the new field remains available in the related object's folder.
|
