Opportunity
Lists opportunity records, including stages, statuses, and associated accounts.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM OpportunityAnalysis.Opportunity;
Columns
| Name | Type | References | SupportedOperators | Description |
| opportunityID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the opportunity record within Eloqua. | |
| createdDate | Datetime | Date and time when the opportunity record was first created. | ||
| crmCampaignID | String | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the opportunity to its originating campaign in the connected CRM system. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the opportunity record. | ||
| opportunityClosedDateHour | Datetime | Date and time, rounded to the hour, when the opportunity was closed (won or lost). | ||
| opportunityName | String | The display name or descriptive label for the opportunity. | ||
| primaryContactID | Int |
Contact.contactId | Identifier of the primary contact associated with the opportunity. | |
| stage | String | Current stage of the opportunity within the sales process, such as Qualification, Proposal, or Closed. | ||
| stageStatus | String | Status of the opportunity stage, indicating whether it is Active, Won, or Lost. | ||
| territory | String | Sales or marketing territory responsible for the opportunity. | ||
| totalOpportunityAmount | Decimal | Total monetary value associated with the opportunity. |