WebActivities
Captures campaign-related web interactions including visits, form completions, and clicks.
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.WebActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| webActivitiesId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the aggregated web activity record within Eloqua. | |
| dateHour | Datetime | Date and time, rounded to the hour, when the web activity metrics were recorded. | ||
| eloquaCampaignId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the web activity metrics to the related Eloqua campaign. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the web activity record. | ||
| totalPageViews | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of tracked page views during the recorded time period. | |
| totalVisitors | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of unique visitors recorded during the time period. | |
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the web activity record to the corresponding calendar date and hour. |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the web activity record to the related campaign record. |