LandingPageActivities
Reports campaign landing page visits and engagement 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.LandingPageActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| landingPageActivitiesId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the aggregated landing page activity record. | |
| assetId | Int |
LandingPageAsset.landingPageID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the landing page asset associated with this activity record. |
| dateHour | Datetime | Date and time, rounded to the hour, when the landing page activity was recorded. | ||
| eloquaCampaignId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the landing page activity metrics to the related Eloqua campaign. | |
| landingPageTime | Double | Average amount of time, in seconds, that visitors spent on the landing page during the recorded period. | ||
| landingPageViews | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of times the landing page was viewed during the recorded period. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the landing page activity record. | ||
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the corresponding calendar date and hour. |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the related campaign record. |
| landingPageAsset_landingPageID | Int |
LandingPageAsset.landingPageID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the activity record to the related landing page asset record. |