AccountCampaignScore
Displays campaign scoring metrics at the account level.
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.AccountCampaignScore;
Columns
| Name | Type | References | SupportedOperators | Description |
| accountCampaignScoreId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the account campaign score record within Eloqua. | |
| accountId | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the account associated with the campaign score. |
| eloquaCampaignId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the campaign score record to the related Eloqua campaign. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the account campaign score record. | ||
| score | Double | =,<>,>,<,>=,<=,IN,NOT IN | Numerical score representing the account's level of engagement or performance within the campaign. | |
| account_accountId | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the campaign score record back to the corresponding account record in Eloqua. |