Operate > WebSphere Commerce Accelerator > Marketing > Customer segments
Customer segment attributes
The following table lists the attributes you can use to define customer segments in WebSphere Commerce Accelerator. The right columns indicate where the data is stored in the WebSphere Commerce database.
Address attributes
Attribute Description Stored in this table Stored in this column City Target or exclude customers based upon the city in which they reside. ADDRESS CITY State or Province Target or exclude customers based upon the state or province in which they reside. ADDRESS STATE Country or Region Target or exclude customers based upon the country or region in which they reside. ADDRESS COUNTRY ZIP Code or Postal Code Target or exclude customers based upon their ZIP or Postal code. This supports string comparison, so you can target partial codes. ADDRESS ZIPCODE Phone Number Target or exclude customers based upon their telephone number. This supports string comparison, so you can target area codes, or specific exchanges. ADDRESS PHONE1, PHONE2 Target or exclude customers based upon their e-mail address. This supports string comparison, so you can target domain names. ADDRESS EMAIL1, EMAIL2
Demographics attributes
Attribute Description Stored in this table Stored in this column Gender Target or exclude customers based upon their gender, or specifically target those customers who have not specified. USERDEMO GENDER Age Target or exclude customers whose age falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary. USERDEMO AGE Annual Income Target or exclude customers whose income falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary. USERDEMO INCOME Marital Status Target or exclude customers based upon their marital status, or specifically target those customers who have not specified. USERDEMO MARITALSTATUS Children Target or exclude customers who have a number of children that falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary. USERDEMO CHILDREN Household Target or exclude customers whose household size falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary USERDEMO HOUSEHOLD
Purchase Details attributes
Attribute Description Stored in this table Stored in this column Amount Spent Since Registration Target or exclude customers whose total amount spent at the store falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary. Note that this total only captures the amount spent on orders in the database, and may not reflect an amount spent prior to database pruning. ORDERS n/a Orders Target or exclude customers whose number of orders at the store falls within a specified range. Multiple ranges can be targeted by promotions or activities, and the ranges can be customized as necessary. Note that this total only captures the amount spent on orders in the database, and may not reflect an amount spent prior to database pruning. ORDERS n/a Last Purchase Date Target or exclude customers that made a purchase from the site on, before, or since a specified date, or number of days. For example, you can target customers who have made purchases in the last 30 days to follow-up with a coupon. USERS LASTORDER Last Visit Date Target or exclude customers that have visited the site on, before, or since a specified date, or number of days. This works similarly to the Last purchase date attribute. These two attributes can be used in combination too, such as targeting customers that have not made a purchase in the last 60 days, but who have visited the site in the last week. Those customers might be looking to make a purchase, and might be good candidates for an e-mail. USERS LASTSESSION
Registration attributes
Attribute Description Stored in this table Stored in this column Registration Status Target or exclude customers based upon their registration status (registered or guest). USERS REGISTERTYPE Registration Date Target or exclude customers who registered at the site on, before, or since a specified date, or number of days. USERS REGISTRATION Last Registration Update Target or exclude customers who last updated their registration information on, before, or since a specified date, or number of days. USERS REGISTRATIONUPDATE Interests Target or exclude customers based on their specified interests. USERDEMO HOBBIES Company Target or exclude customers based on their specified employer. USERDEMO COMPANYNAME Language Target or exclude customers based on their specified preferred language. USERS LANGUAGE_ID Job Function Target or exclude customers based on their specified job function, such as senior management, or professional. These job functions can be customized as necessary. MBRATTR Member attribute - "JobFunction" Preferred Method of Communication Target or exclude customers based on their specified preferred method of communication. USERPROF PREFERREDCOMM
The following table lists Account attributes. These attributes are applicable to B2B store models only. This data is stored as member attributes in the MBRATTR table (with the exception of the Account Sales attribute, which is stored in the ORDERS table). Your store must populate these member attributes if using them in B2B customer segments.
Account attributes
Attribute Description Stored in this table Name of member attribute Account Size Target customers who belong to accounts with a particular size, as specified during account creation. MBRATTR OrgEntitySize Account Geographical Location Target customers who belong to accounts that are based in a particular location, as specified during account creation. MBRATTR OrgEntityGeographicLocation Account Countries or Regions of Operation Target customers who belong to accounts that operate in a particular location, as specified during account creation. This is distinct from the geographical location in that an American account may operate in the US, Canada, and the UK. MBRATTR CountriesOfOperation Account Industry Target customers who belong to accounts that are within a particular industry, as specified during account creation. MBRATTR OrgEntityIndustryType Account Business Target customers who belong to accounts that are within a particular business, as specified during account creation. Includes options like manufacturing, wholesale, and retail. MBRATTR OrgEntityBusinessType Account Sales Target customers who belong to accounts with an amount spent that falls within a specified range. This is the total of all orders made under the contract ORDERS n/a
Related concepts
Related tasks
View a customer segment summary or list