LandingPageVisit
Logs visits to Eloqua-managed landing pages with associated visitor metadata.
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 ActivityDetails.LandingPageVisit;
Columns
| Name | Type | References | SupportedOperators | Description |
| landingPageViewID [KEY] | Long | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the landing page view event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the landing page visit to the associated account. | |
| baseURLID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the base URL of the landing page being visited. | |
| campaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the campaign associated with the landing page visit. | |
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who visited the landing page, if known. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the landing page visit to a related Eloqua linked account record. | |
| landingPageID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier of the landing page that was viewed. | |
| landingPageTime | Int | =,<>,>,<,>=,<=,IN,NOT IN | Duration of time, in seconds, that the visitor spent on the landing page. | |
| landingPageViewDateHour | Datetime | Date and time, rounded to the hour, when the landing page was viewed. | ||
| referrerID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the referring source that directed the visitor to the landing page. | |
| sessionID | Long | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the visitor's web session in which the landing page view occurred. | |
| visitorID | Long | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the visitor who viewed the landing page. |