Full Customer Extract

The Full Customer Extract contains a complete listing of all utility customers in one or more program waves, or the entire utility population for Web For All customers. It is a more detailed version of the Basic Customer Extract and is available as a standard recurring extract from your Delivery Team.

Note: Either the Basic or Full Customer Extract is applicable to each utility. Your Delivery Team will work with you to identify which one is applicable to you.

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.
recipient_status	A flag to indicate whether the customer is a recipient or part of a control group. Allowed Values: CONTROL RECIPIENT Field Size: 9. Can Be Empty?: Yes.
elec_acct_inactive_date	Inactive date if a customer has deactivated an electric account. Field Size: 10. Can Be Empty?: Yes.
gas_acct_inactive_date	Inactive date if a customer has deactivated a gas account. Field Size: 10. Can Be Empty?: Yes.
has_web_account	Indicates whether the customer has logged into the Energy Efficiency web portal. Note: This column may not be applicable to your situation. Contact your Delivery Team if you have any questions. Allowed Values: N Y Field Size: 1. Can Be Empty?: No.
has_print	Indicates whether a customer has an active print Home Energy Report subscription. Allowed Values: N Y Field Size: 1. Can Be Empty?: No.
has_email	Indicates whether a customer has an active email subscription. Allowed Values: N Y Field Size: 1. Can Be Empty?: No.
first_print_report_date	Generation date for first print Home Energy Report. Field Size: 10. Can Be Empty?: Yes.
print_report_count	Total number of print Home Energy Reports generated. Field Size: 5. Can Be Empty?: Yes.
first_email_report_date	Generation date for first Email Home Energy Report. Field Size: 10. Can Be Empty?: Yes.
email_report_count	Total number of Email Home Energy Reports generated. Field Size: 5. Can Be Empty?: Yes.
opt_out_date	Date the customer opted out of the Home Energy Report program, if applicable. Field Size: 10. Can Be Empty?: Yes.
opt_out_reason	Reason for customer’s opt-out of the Home Energy Report program, if applicable. Allowed Values: DESIRES_NO_COMPARISONS DESIRES_NO_JUDGING INACCURATE_COMPARISONS MARKETING OTHER PRIVACY REDUCE_MAIL UNFAIR_COMPARISONS UNKNOWN Field Size: 40. Can Be Empty?: Yes.
include_in_test_analysis	A flag used to denote VIPs who receive reports but who arenot included in measurement and analysis. Note: This column is only used in select programs. Contact your Delivery Team if you have any questions. Allowed Values: N Y Field Size: 1. Can Be Empty?: No.
wave	Program wave name. Example: 201305_E Field Size: 40. Can Be Empty?: Yes.
groups	Comma-separated list of additional customer groups (customized per utility if applicable). Field Size: 512. Can Be Empty?: Yes.