LandingPageActivity
Tracks visitor interactions on Eloqua landing pages, including visits and engagement events.
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 LandingPageAnalysis.LandingPageActivity;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the landing page activity metrics to the related Eloqua campaign. | |
| landingPageID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier of the landing page asset associated with the activity. | |
| webClickDateHour [KEY] | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Date and time, rounded to the hour, when the landing page activity was recorded. |
| averageLandingPageTime | Double | Average amount of time, in seconds, that visitors spent on the landing page. | ||
| landingPageTime | Double | Total amount of time, in seconds, spent on the landing page by all visitors during the recorded period. | ||
| landingPageViews | Int | Total number of landing page views recorded during the period. | ||
| totalVisitors | Int | Total number of unique visitors to the landing page. | ||
| totalVisits | Int | Total number of visits to the landing page, including repeat visits by the same visitor. | ||
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the landing page activity record to the corresponding calendar date and hour. |