EmailAsset
Displays campaign email assets, including content, subject, and configuration details.
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 CampaignAnalysis.EmailAsset;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email asset within Eloqua. | |
| emailCreatedByUserID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who created the email asset. |
| emailGroup | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the email group the asset belongs to, used for categorization and management. | |
| emailGroupDescription | String | Text description providing context about the purpose or scope of the email group. | ||
| emailGroupID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email group associated with the asset. | |
| emailGroupIsDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the associated email group has been deleted. | |
| emailName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the email asset as defined in Eloqua. | |
| isArchived | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag showing whether the email asset has been archived and is no longer active. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the email asset has been deleted from Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the email asset record. | ||
| subjectLine | String | Subject line text of the email, displayed to recipients in their inbox. | ||
| user_userID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the email asset to the user record responsible for its creation or management. |