This table requires activation of Marketing Campaign Activity Detail Analytics functional area. This table stores Landing Page Visit Details
Module:
LANDING_PAGE_VIEW_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| LANDING_PAGE_VIEW_ID | NUMBER | 38 | 0 | True | landing page view ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. source record ID | ||||
| LANDING_PAGE_VIEW_DATE_HOUR | TIMESTAMP | landing page view date hour | |||||
| CAMPAIGN_ID | NUMBER | campaign ID | DW_ELQ_CAMPAIGN_D | ELOQUA_CAMPAIGN_ID | |||
| LANDING_PAGE_ID | NUMBER | 38 | 0 | landing page ID | DW_ELQ_LANDING_PAGE_ASSET_D | LANDING_PAGE_ID | |
| REFERRER_ID | NUMBER | 38 | 0 | referrer ID | DW_ELQ_REFERRER_D | REFERRER_ID | |
| LANDING_PAGE_TIME | NUMBER | 38 | 0 | landing page time | |||
| CONTACT_ID | NUMBER | 38 | 0 | contact ID | DW_ELQ_CONTACT_D | CONTACT_ID | |
| ACCOUNT_ID | NUMBER | 38 | 0 | account ID | DW_ELQ_ACCOUNT_D | ACCOUNT_ID | |
| ELOQUA_LINKED_ACCOUNT_ID | NUMBER | 38 | 0 | eloqua linked account ID | DW_ELQ_ELOQUA_LINKED_ACCOUNT_D | ELOQUA_LINKED_ACCOUNT_ID | |
| ACTIVITY_NAME | VARCHAR2 | 32 | activity name | ||||
| ACTIVITY_TYPE | VARCHAR2 | 32 | type of activity | ||||
| ACTIVITY_CATEGORY | VARCHAR2 | 32 | activity category | ||||
| CONTACT_LINKAGE_LAST_SFDC_CAMPAIGN_ID | VARCHAR2 | 4000 | SFDC campaign ID | ||||
| CONTACT_LINKAGE_LAST_SFDC_CAMPAIGN_NAME | VARCHAR2 | 4000 | SFDC Campaign Name | ||||
| CONTACT_LINKAGE_LAST_SFDC_CAMPAIGN_STATUS | VARCHAR2 | 4000 | SFDC Campaign status | ||||
| CONTACT_LINKAGE_SFDC_CONTACT_ID | VARCHAR2 | 4000 | SFDC contact id | ||||
| CONTACT_LINKAGE_SFDC_ACCOUNT_ID | VARCHAR2 | 4000 | SFDC account id | ||||
| CONTACT_LINKAGE_SFDC_EMAIL_OPT_OUT | VARCHAR2 | 4000 | SFDC email optout | ||||
| CONTACT_LINKAGE_SFDC_LEAD_ID | VARCHAR2 | 4000 | SFDC lead id | ||||
| CONTACT_LINKAGE_SFDC_LEAD_RATING | VARCHAR2 | 4000 | SFDC lead rating | ||||
| CONTACT_LINKAGE_OSC_ACCOUNT_ID | VARCHAR2 | 4000 | Oracle Sales cloud account id | ||||
| CONTACT_LINKAGE_OSC_CONTACT_ID | VARCHAR2 | 4000 | Oracle Sales cloud contact id | ||||
| CONTACT_LINKAGE_OSC_LEAD_ID | VARCHAR2 | 4000 | Oracle Sales cloud lead id |
Copyright © 2019, 2026, Oracle and/or its affiliates.