AccountEngagement
Summarizes account engagement with Eloqua campaigns and activities.
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.AccountEngagement;
Columns
| Name | Type | References | SupportedOperators | Description |
| accountId [KEY] | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the account within Eloqua. |
| accountContacts | Int | Total number of contacts associated with the account. | ||
| engagedContacts | Int | Number of contacts within the account who have actively engaged with campaigns, emails, or other tracked activities. | ||
| engagementScore | Double | Calculated score that represents the overall engagement level of the account's contacts. | ||
| engagementScorePrev | Double | Engagement score from the previous reporting period, used to measure changes in engagement over time. | ||
| lastModifiedDate | Datetime | Timestamp of the most recent update to the account engagement record. | ||
| reachableContacts | Int | Number of contacts within the account that are reachable via active and deliverable communication channels. | ||
| account_accountId | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the engagement record back to the associated account record. |