Opportunity Analysis
All API endpoints in the Opportunity Analysis schema are read-only, so these endpoints are all exposed in the add-in 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.