Opportunity Analysis
All API endpoints in the Opportunity Analysis schema are read-only, so these endpoints are all exposed in the component as views.
Views
The Views section, which lists all views, contains samples of what you might have access to in your Oracle Eloqua Reporting account.
The views exposed under this schema are:
| View | Description |
| Account | Provides account-level data tied to opportunity analysis. |
| AccountCampaignScore | Displays campaign scoring metrics at the account level. |
| AccountEngagement | Summarizes account engagement with Eloqua campaigns and activities. |
| Contact | Contains contact information related to opportunity engagement and outcomes. |
| Opportunity | Lists opportunity records, including stages, statuses, and associated accounts. |
| OpportunityRevenue | Reports on revenue metrics associated with opportunities, including attributed and influenced revenue. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations.