ExternalActivities
Reports external campaign activities logged into Eloqua from third-party platforms.
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 CampaignExternalActivity.ExternalActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| externalActivitiesId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the external activity record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the external activity to the associated account. | |
| campaignId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the Eloqua campaign related to the external activity. | |
| contactId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who generated or was linked to the external activity. | |
| createdDate | Datetime | Date and time when the external activity record was created in Eloqua. | ||
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the external activity record to a related Eloqua linked account record. | |
| externalActivity | String | =,<>,>,<,>=,<=,IN,NOT IN | Description or label of the external activity, such as Webinar Attendance or Event Check-In. | |
| externalActivityDate | Datetime | Date and time when the external activity occurred. | ||
| externalAssetId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the external asset associated with the activity, such as a specific event or third-party integration. |