DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_WEB_ACTIONS

Web Metrics - Actions

Details

Module: Customer Insights

Type: Dimension

Key Columns

ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ID NUMBER 38 0 True Record Identifier
SOURCE_RECORD_ID VARCHAR2 38 Source Record Id
HAS_DONE_TIP_ACTION VARCHAR2 20 Tips - has done
HAS_EXPORTED_DATA VARCHAR2 20 Exports - num data exports
HAS_FINISHED_AUDIT VARCHAR2 20 Web Audit - completed
HAS_SEEN_WAYSTOSAVE VARCHAR2 20 Tips - visited
HAS_STARTED_AUDIT VARCHAR2 20 Web Audit - started
HAS_STARTED_NOT_COMPLETED_AUDIT VARCHAR2 20 Web Audit - started not completed
HAS_VISITED_AUDIT VARCHAR2 20 Web Audit - visited
HAS_VISITED_NOT_STARTED_AUDIT VARCHAR2 20 Web Audit - not started
LAST_TIP_ACTION_BUCKET VARCHAR2 20 Tips - last action
LAST_TIP_ACTION_SORT NUMBER 38 0
NUM_DATA_EXPORTS_BUCKET VARCHAR2 20 Exports - num data exports bucket
TOTAL_TIPS_CLICKED_BUCKET VARCHAR2 20 Tips - num clicked
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6