Web Audit Customer Data Extract Specification

The Web Audit Customer Answers and Questions data extract contains data provided by utility customers who have completed the Home Energy Analysis survey. The table below defines the columns in the extract. The extract is available in Inside Opower.

For a list of the default Home Energy Analysis survey questions and their possible responses, see Valid Questions and Answers.

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.
premise_id	An identifier for a site occupied by an individual customer. Note: This premise ID should be the same premise ID that is sent in the billed usage data files, as described in the Customer Fields of the Oracle Utilities Opower Legacy Billing Data Transfer Standards. Field Size: 40. Can Be Empty?: No.
question_go_live_date	Date and time that this version of the question was deployed in YYYY-MM-DD HH:mm:ss.SSS format. Example: 2016-01-01 12:00:00.000 Field Size: 23. Can Be Empty?: No.
questionnaire_version	Version number of the survey that the customer responded to. Field Size: 4. Can Be Empty?: No.
question_name	Short representation of the survey question (for example, homeType). Field Size: 200. Can Be Empty?: No.
user_input_answer	Free-form customer response to the survey question. For questions that allow multiple responses, there would be multiple rows for the same utility_customer_id, question_name, and timestamp combination. Field Size: 65535. Can Be Empty?: Yes.
selected_answer_option	Selected customer (i.e., from a dropdown or list of checkboxes) response to the survey question. For questions that allow multiple responses, there would be multiple rows for the same utility_customer_id, question_name, and timestamp combination. Field Size: 65535. Can Be Empty?: Yes.
entered_at	Date and time that the customer responded to the question in YYYY-MM-DD HH:mm:ss.SSS format. Note: These timestamps are in US Eastern Time, and the weekly reports will include data from Friday 21:00:00PM PST (Saturday 00:00:00AM EST) until Friday 20:59:59:PM PST (Friday 23:59:59PM EST). Example: 2016-01-01 12:00:00.000 Field Size: 23. Can Be Empty?: No.