OpportunityRevenue
Reports on revenue metrics associated with opportunities, including attributed and influenced revenue.
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.OpportunityRevenue;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the revenue attribution record to the related Eloqua campaign. | |
| opportunityID [KEY] | Int |
Opportunity.opportunityID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the opportunity associated with the revenue attribution data. |
| attributedRevenue | Decimal | Amount of revenue directly attributed to the Eloqua campaign's influence on the opportunity. | ||
| influencedRevenue | Decimal | Amount of revenue influenced by the campaign, including indirect contributions across multiple touchpoints. | ||
| lastModifiedDate | Datetime | Timestamp of the most recent update to the opportunity revenue record. | ||
| opportunity_opportunityID | Int |
Opportunity.opportunityID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the revenue attribution record back to the associated opportunity record. |