EmailActivities
Tracks aggregated email interactions across campaigns, including opens, clicks, and responses.
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.EmailActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailSentAggKey [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the aggregated email activity record. | |
| clickthroughRate | Double | Percentage of delivered emails that generated at least one clickthrough event. | ||
| clickToOpenRate | Double | Percentage of opened emails that resulted in at least one clickthrough event. | ||
| dateHour | Datetime | Date and time, rounded to the hour, for the aggregated email activity metrics. | ||
| eloquaCampaignId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the email activity metrics to the related Eloqua campaign. | |
| emailId | Int |
EmailAsset.emailID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset associated with the activity metrics. |
| existingVisitorClickthroughs | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of clickthroughs generated by existing contacts or visitors. | |
| isClickThroughed | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator showing whether any clickthrough activity occurred for the email during this period. | |
| isOpened | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator showing whether any open events occurred for the email during this period. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the aggregated email activity record. | ||
| newVisitorClickthroughs | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of clickthroughs generated by new visitors or leads. | |
| openRate | Double | Percentage of delivered emails that were opened by recipients. | ||
| segmentId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the aggregated email activity metrics. | |
| totalBouncebacks | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of bounced emails, including both soft and hard bouncebacks. | |
| totalClickthroughs | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of clickthrough events recorded for the email. | |
| totalDelivered | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of emails successfully delivered to recipients. | |
| totalHardBouncebacks | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of hard bouncebacks, indicating permanent delivery failures. | |
| totalOpens | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of recorded opens for the email. | |
| totalPossibleForwarders | Int | =,<>,>,<,>=,<=,IN,NOT IN | Estimated number of recipients likely to forward the email, based on system logic. | |
| totalSends | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of emails sent to recipients. | |
| totalSoftBouncebacks | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of soft bouncebacks, indicating temporary delivery failures. | |
| totalSpamUnsubscribersByEmail | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of contacts who unsubscribed by reporting the email as spam. | |
| totalUnsubscribesbyEmail | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of contacts who unsubscribed directly from the email. | |
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the corresponding calendar date and hour. |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the related campaign record. |
| emailAsset_emailID | Int |
EmailAsset.emailID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the related email asset record. |
| segment_segmentId | Int |
Segment.segmentId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the related segment record. |