Engagement Metrics Extract (Incremental)

The Engagement Metrics extract contains details about customer engagement events (such as clicks and bounces) that occur for Oracle Utilities Opower outbound communications, such as Email Home Energy Reports with an event date within a specified date range. It is available 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.
communication_id	Unique ID for the communication. Can be used to join with the Outbound Communications extract. Field Size: 21. Can Be Empty?: No.
event_type	The engagement event type. Allowed Values: CLICK HARD_BOUNCE NOT_SENT OPEN OTHER OTHER_BOUNCE SENT SOFT_BOUNCE Field Size: 12. Can Be Empty?: No.
event_date	Date and time of event. Field Size: 19. Can Be Empty?: No.
url	Click Uniform Resource Locator (URL). This field is only populated for click events. Field Size: 255. Can Be Empty?: Yes.
reason	Bounce reason. Only populated for bounce events. Field Size: 255. Can Be Empty?: Yes.