ExternalActivityTotals
Summarizes totals of external activities tracked alongside Eloqua campaign activity.
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.ExternalActivityTotals;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignId [KEY] | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the external activity totals to the related Eloqua campaign. |
| externalAssetId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the external asset associated with the activity totals. | |
| dateHour | Datetime | Date and time, rounded to the hour, for the recorded external activities. | ||
| externalAssetType | Int | =,<>,>,<,>=,<=,IN,NOT IN | Numeric code representing the type of external asset, such as webinar, ad, or social media activity. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the external activity totals record. | ||
| totalExternalActivities | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of external activity events captured for the campaign and asset. | |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the external activity totals record to the parent campaign record in Eloqua. |