AccountEngagement
Tracks engagement metrics across accounts, summarizing campaign interactions and activity scores.
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 AccountActivity.AccountEngagement;
Columns
| Name | Type | References | SupportedOperators | Description |
| accountId [KEY] | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the account within Eloqua, used to link reporting data back to the correct account record. |
| accountContacts | Int | Total number of contacts associated with this account, reflecting the size of the account's contact base. | ||
| engagedContacts | Int | Number of contacts within the account who have recently engaged with campaigns, emails, or other tracked activities. | ||
| engagementScore | Double | Calculated engagement score that measures overall activity and responsiveness of the account's contacts. | ||
| engagementScorePrev | Double | Engagement score from the previous reporting period, used to track changes in account engagement over time. | ||
| lastModifiedDate | Datetime | Timestamp of the last update made to the account record or its engagement metrics. | ||
| reachableContacts | Int | Number of contacts within the account who are considered reachable via active and deliverable communication channels. | ||
| account_accountId | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key reference linking the record to the related account entity in Eloqua. |