Outbound Communications Extract (Incremental)

The Outbound Communications extract contains a record for all outbound print and electronic communications such as Home Energy Reports, Weekly Energy Updates, and High Bill Alerts AMI (formerly known as Unusual Usage Alerts) delivered within a specified date range. It is available in Inside Opower or as a standard recurring extract from your Delivery Team.

Column	Description
utility_customer_id	The customer identifier that is used on customer communications. This is usually the same value as the `customer_id` column sent by the utility in other data files, but not always. Additional identifiers may need to be added to the extract. Discuss this modification with your Delivery Team, if necessary. Example: 1234-1234-1234-1234 Field Size: 40. Can Be Empty?: No.
opower_communication_id	Unique ID for this communication. Can be used to join to the Engagement Metrics extract. Field Size: 21. Can Be Empty?: No.
delivery_date	For digital communications, this refers to the date on which the communication was dispatched for delivery. For paper communications, this refers to the date of generation. Field Size: 19. Can Be Empty?: No.
event_type	Communication type. Example Values: COMBINED_BILL_FORECAST_ALERT HOME_ENERGY WEEKLY_AMI Note: The values provided will vary by program. Contact your Delivery Team if you have any questions about the values and what they mean. Field Size: No restriction. Can Be Empty?: No.
notification_channel	Channel used to deliver the communication. Allowed Values: EMAIL IVR PRINT PUSH SMS Field Size: 5. Can Be Empty?: No.