DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_EMAIL_ENGAGEMENT

Email Engagement

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
EBILL_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 eBill - adjusted click to open rate
EBILL_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
EBILL_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 eBill - adjusted open rate
EBILL_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
EBILL_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 eBill - click rate
EBILL_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
EBILL_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 eBill - click to open rate
EBILL_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
EBILL_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 eBill - open rate
EBILL_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 Overall adjusted click to open rate
EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 Overall adjusted open rate
EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 Overall click rate
EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 Overall click to open rate
EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 Overall open rate
EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
HAS_RECEIVED_EMAIL VARCHAR2 20 Received Opower email
HAS_RECEIVED_EMAIL_EBILL VARCHAR2 20 eBill - received
HAS_RECEIVED_EMAIL_HIGH_BILL_ALERT_AMI VARCHAR2 20 High Bill Alert (AMI) - received
HAS_RECEIVED_EMAIL_HIGH_BILL_ALERT_NON_AMI VARCHAR2 20 High Bill Alert (non-AMI) - received
HAS_RECEIVED_EMAIL_HOME_ENERGY VARCHAR2 20 eHER - received
HAS_RECEIVED_EMAIL_LOAD_SHAPING VARCHAR2 20 Behavioral Load Shaping - received
HAS_RECEIVED_EMAIL_WEEKLY_AMI VARCHAR2 20 WAMI - received
HIGH_BILL_ALERT_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (AMI) - adjusted click to open rate
HIGH_BILL_ALERT_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_AMI_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (AMI) - adjusted open rate
HIGH_BILL_ALERT_AMI_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_AMI_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 High Bill Alert (AMI) - click rate
HIGH_BILL_ALERT_AMI_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_AMI_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (AMI) - click to open rate
HIGH_BILL_ALERT_AMI_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_AMI_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (AMI) - open rate
HIGH_BILL_ALERT_AMI_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_NON_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (non-AMI) - adjusted click to open rate
HIGH_BILL_ALERT_NON_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_NON_AMI_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (non-AMI) - adjusted open rate
HIGH_BILL_ALERT_NON_AMI_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_NON_AMI_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 High Bill Alert (non-AMI) - click rate
HIGH_BILL_ALERT_NON_AMI_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_NON_AMI_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (non-AMI) - click to open rate
HIGH_BILL_ALERT_NON_AMI_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HIGH_BILL_ALERT_NON_AMI_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 High Bill Alert (non-AMI) - open rate
HIGH_BILL_ALERT_NON_AMI_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
HOME_ENERGY_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 eHER - adjusted click to open rate
HOME_ENERGY_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HOME_ENERGY_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 eHER - adjusted open rate
HOME_ENERGY_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
HOME_ENERGY_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 eHER - click rate
HOME_ENERGY_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
HOME_ENERGY_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 eHER - click to open rate
HOME_ENERGY_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
HOME_ENERGY_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 eHER - open rate
HOME_ENERGY_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
LOAD_SHAPING_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 Behavioral Load Shaping - adjusted click to open rate
LOAD_SHAPING_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
LOAD_SHAPING_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 Behavioral Load Shaping - adjusted open rate
LOAD_SHAPING_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
LOAD_SHAPING_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 Behavioral Load Shaping - click rate
LOAD_SHAPING_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
LOAD_SHAPING_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 Behavioral Load Shaping - click to open rate
LOAD_SHAPING_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
LOAD_SHAPING_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 Behavioral Load Shaping - open rate
LOAD_SHAPING_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
WEEKLY_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 WAMI - adjusted click to open rate
WEEKLY_AMI_EMAIL_ADJUSTED_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
WEEKLY_AMI_EMAIL_ADJUSTED_OPEN_RATE_BUCKET VARCHAR2 20 WAMI - adjusted open rate
WEEKLY_AMI_EMAIL_ADJUSTED_OPEN_RATE_RANGE_MIN NUMBER 38 0
WEEKLY_AMI_EMAIL_CLICK_RATE_BUCKET VARCHAR2 20 WAMI - click rate
WEEKLY_AMI_EMAIL_CLICK_RATE_RANGE_MIN NUMBER 38 0
WEEKLY_AMI_EMAIL_CLICK_TO_OPEN_RATE_BUCKET VARCHAR2 20 WAMI - click to open rate
WEEKLY_AMI_EMAIL_CLICK_TO_OPEN_RATE_RANGE_MIN NUMBER 38 0
WEEKLY_AMI_EMAIL_OPEN_RATE_BUCKET VARCHAR2 20 WAMI - open rate
WEEKLY_AMI_EMAIL_OPEN_RATE_RANGE_MIN NUMBER 38 0
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6