Appearance
Person Purchase
| Field | Field Type | Description |
|---|---|---|
| ID | STRING | Person ID |
| BUYS_VIA_MAIL_ORDER | BOOLEAN | Purchases through mail order |
| BUYS_ONLINE | BOOLEAN | Purchases online |
| BUYS_VIA_CATALOG | BOOLEAN | Purchases from catalogs |
| IN_CONTINUITY_PROGRAM | BOOLEAN | Enrolled in a subscription or continuity program |
| IS_CLUB_MEMBER | BOOLEAN | Purchased a club membership in the last 24 months |
| BUYS_WOMENS_MERCHANDISE | BOOLEAN | Purchases women's merchandise |
| BUYS_MENS_MERCHANDISE | BOOLEAN | Purchases men's merchandise |
| IS_MAGAZINE_SUBSCRIBER | BOOLEAN | Subscribes to one or more magazines |
| BUYS_APPAREL_WOMENS | BOOLEAN | Purchases apparel womens |
| BUYS_APPAREL_MENS | BOOLEAN | Purchases apparel mens |
| BUYS_APPAREL_KIDS | BOOLEAN | Purchases apparel kids |
| BUYS_APPAREL_YOUNG | BOOLEAN | Purchases apparel young |
| BUYS_APPAREL_PETITE | BOOLEAN | Purchases apparel petite |
| BUYS_APPAREL_GENERAL | BOOLEAN | Purchases apparel general |
| BUYS_BOOKS | BOOLEAN | Purchases books |
| BUYS_COSMETICS | BOOLEAN | Purchased cosmetics via mail |
| BUYS_JEWELRY | BOOLEAN | Purchases jewelry |
| BUYS_LUGGAGE | BOOLEAN | Purchases luggage |
| BUYS_APPLIANCES | BOOLEAN | Purchases appliances |
| BUYS_CHILDRENS_PRODUCTS | BOOLEAN | Purchases childrens products |
| BUYS_AUTO_PARTS | BOOLEAN | A purchase of automotive, auto parts & accessories has occurred within the last 24 months |
| BUYS_GIFTS | BOOLEAN | Purchased gifts via mail |
| BUYS_HOME_FURNISHINGS | BOOLEAN | Purchased home furnishings via mail |
| BUYS_HOME_IMPROVEMENT | BOOLEAN | Home improvement purchase |
| BUYS_MUSICAL_INSTRUMENTS | BOOLEAN | Purchases musical instruments |
| BUYS_INVESTMENTS_PRODUCTS | BOOLEAN | Owns investments |
| SPEND_CATALOG_TOTAL | FLOAT | Total dollars spent on catalog purchases in the last 36 months |
| SPEND_CATALOG_AVG | FLOAT | Catalog purchases average dollar spent per order in the last 36 months |
| SPEND_CONTINUITY_TOTAL | FLOAT | Continuity purchases total dollars spent in the last 36 months |
| SPEND_CONTINUITY_AVG | FLOAT | Continuity purchases average dollars spent per order in the last 36 months |
| SPEND_APPAREL_TOTAL | FLOAT | Total dollars spent on apparel |
| SPEND_APPAREL_AVG | FLOAT | Apparel average dollars spent per order in the last 36 months |
| SPEND_DEVOTIONAL_TOTAL | FLOAT | Biblical devotional total dollars spent in the last 36 months |
| SPEND_DEVOTIONAL_AVG | FLOAT | Biblical devotional average dollars spent per order in the last 36 months |
| SPEND_FAMILY_TOTAL | FLOAT | Family related purchases - total dollars spent in the last 36 months |
| SPEND_FAMILY_AVG | FLOAT | Family related average dollars spent per order in the last 36 months |
| SPEND_HEALTH_TOTAL | FLOAT | Health total dollars in the last 36 months |
| SPEND_HEALTH_AVG | FLOAT | Average dollars spent per health related order in the last 36 months |
| SPEND_HOME_GOODS_TOTAL | FLOAT | Home Goods total dollars spent in the last 36 months |
| SPEND_HOME_GOODS_AVG | FLOAT | Home goods living average dollars spent per order in the last 36 months |
| SPEND_OUTDOORS_TOTAL | FLOAT | Outdoors total dollars spent in the last 36 months |
| SPEND_OUTDOORS_AVG | FLOAT | Outdoors average dollars spent per order in the last 36 months |
| SPEND_PUBLISHING_TOTAL | FLOAT | Total dollars spent on publishing |
| SPEND_WOMENS_FASHION_TOTAL | FLOAT | Women's fashion total dollars spent in the last 36 months |
| SPEND_WOMENS_FASHION_AVG | FLOAT | Women's fashion average dollars spent per order in the last 36 months |
| NUM_CATALOGS_CATALOG | INTEGER | Number of catalogs ordered from in the last 36 months |
| NUM_ORDERS_CATALOG | INTEGER | Catalog purchases total catalog orders in the last 36 months |
| NUM_ITEMS_CATALOG | INTEGER | Catalog purchases total items purchased in the last 36 months |
| NUM_MERCHANTS_CONTINUITY | INTEGER | Continuity purchases - number of unique companies ordered from in the last 36 months |
| NUM_ORDERS_CONTINUITY | INTEGER | Continuity purchases total continuity orders in the last 36 months |
| NUM_ORDERS_APPAREL | INTEGER | Apparel total orders in the last 36 months |
| NUM_ITEMS_APPAREL | INTEGER | Apparel total items purchased in the last 36 months |
| NUM_MERCHANTS_MENS_APPAREL | INTEGER | Unique companies ordered from for men's apparel |
| NUM_MERCHANTS_WOMENS_APPAREL | INTEGER | Unique companies ordered from for woman's apparel |
| NUM_MERCHANTS_CHILDRENS_APPAREL | INTEGER | Unique companies ordered from for children's apparel |
| NUM_ORDERS_DEVOTIONAL | INTEGER | Biblical devotional total orders in the last 36 months |
| NUM_ITEMS_DEVOTIONAL | INTEGER | Biblical devotional total item purchased in the last 36 months |
| NUM_ORDERS_FAMILY | INTEGER | Family related total orders in the last 36 months |
| NUM_ITEMS_FAMILY | INTEGER | Family related total items purchased in the last 36 months |
| NUM_PUBLISHERS_FAMILY_PUBLISHING | INTEGER | Unique publishers for family related publishing purchases in the last 36 months |
| NUM_MERCHANTS_FAMILY_CATALOG | INTEGER | Unique companies for family related catalog purchases in the last 36 months |
| NUM_ORDERS_HEALTH | INTEGER | Health total orders in the last 36 months |
| NUM_ITEMS_HEALTH | INTEGER | Health total items purchased in the last 36 months |
| NUM_MERCHANTS_HEALTH | INTEGER | Number of unique companies ordered from for health related purchases |
| NUM_MERCHANTS_FITNESS | INTEGER | Number of unique companies ordered from for fitness related purchases |
| NUM_ORDERS_HOME_GOODS | INTEGER | Home goods living total orders in the last 36 months |
| NUM_ITEMS_HOME_GOODS | INTEGER | Home goods living total items purchased in the last 36 months |
| NUM_MERCHANTS_HOME_DECORATING | INTEGER | Number of unique companies ordered from for home decorating in the last 36 months |
| NUM_CATALOGS_HOME_DECORATING | INTEGER | Number of unique catalogs purchase from for home decorating in the last 36 months |
| NUM_PUBLISHERS_HOME_DECORATING | INTEGER | Number of unique publishers purchased from for home decorating in the last 36 months |
| NUM_CATALOGS_HOME_LIVING | INTEGER | Number of unique catalogs purchased from for home living in the last 36 months |
| NUM_PUBLISHERS_HOME_LIVING | INTEGER | Number of unique publishers purchased from for home living in the last 36 months |
| NUM_CATALOGS_COOKING | INTEGER | Number of unique catalogs purchased from for cooking in the last 36 months |
| NUM_PUBLISHERS_COOKING | INTEGER | Number of unique publishers purchased from for cooking in the last 36 months |
| NUM_CATALOGS_GARDENING | INTEGER | Number of unique catalogs purchased from for gardening in the last 36 months |
| NUM_PUBLISHERS_GARDENING | INTEGER | Number of unique publishers purchased from for gardening in the last 36 months |
| NUM_CATALOGS_HOUSEWARES | INTEGER | Number of unique catalogs purchased from for housewares in the last 36 months |
| NUM_PUBLISHERS_HOUSEWARES | INTEGER | Number of unique publishers purchased from for housewares in the last 36 months |
| NUM_ORDERS_OUTDOORS | INTEGER | Outdoors total orders in the last 36 months |
| NUM_ITEMS_OUTDOORS | INTEGER | Outdoors total items purchased in the last 36 months |
| NUM_MERCHANTS_OUTDOORS | INTEGER | Number of unique companies ordered from for outdoor goods in the last 36 months |
| NUM_CATALOGS_OUTDOORS | INTEGER | Number of unique catalogs ordered from for outdoor goods in the last 36 months |
| NUM_PUBLISHERS_OUTDOORS | INTEGER | Number of unique publishing companies ordered from for outdoor goods in the last 36 months |
| NUM_MERCHANTS_BOATING_SAILING | INTEGER | Number of unique companies ordered from for boating and sailing in the last 36 months |
| NUM_MERCHANTS_CAMPING_HIKING | INTEGER | Number of unique companies ordered from for camping and hiking in the last 36 months |
| NUM_MERCHANTS_FISHING | INTEGER | Number of unique companies ordered from for fishing in the last 36 months |
| NUM_MERCHANTS_HUNTING | INTEGER | Number of unique companies ordered from for hunting in the last 36 months |
| NUM_PUBLISHERS_ALL | INTEGER | Number of unique publishing companies ordered from |
| NUM_MAGAZINE_SUBSCRIPTIONS | INTEGER | Number of distinct magazine titles ordered |
| NUM_ACTIVE_MAGAZINE_SUBSCRIPTIONS | INTEGER | Number of active magazine titles |
| NUM_MAGAZINE_EXPIRATIONS | INTEGER | Publishing number of expired mag titles in the last 36 months |
| NUM_MAGAZINE_AUTO_RENEWALS | INTEGER | Number of magazine titles on auto renew |
| NUM_TITLES_PUBLISHING | INTEGER | Publishing total publishing titles ordered in the last 36 months |
| NUM_ORDERS_WOMENS_FASHION | INTEGER | Women's fashion total orders in the last 36 months |
| NUM_MERCHANTS_WOMENS_FASHION | INTEGER | Number of unique companies ordered from for women's fashion in the last 36 months |
| NUM_MERCHANTS_MENS_FASHION | INTEGER | Number of unique companies ordered from men's fashion in the last 36 months |
| NUM_MERCHANTS_AUDIO_EQUIPMENT | INTEGER | Number of unique companies ordered from audio equipment in the last 36 months |
| NUM_MERCHANTS_BEAUTY_PRODUCT | INTEGER | Number of unique companies ordered from beauty product in the last 36 months |
| NUM_MERCHANTS_AUTOMOTIVE | INTEGER | Number of unique companies ordered from automotive in the last 36 months |
| NUM_MERCHANTS_AVIATION | INTEGER | Number of unique companies ordered from aviation in the last 36 months |
| NUM_MERCHANTS_BARGAIN_SEEKER | INTEGER | Number of unique companies ordered from bargain seekers in the last 36 months |
| NUM_MERCHANTS_BUSINESS | INTEGER | Number of unique companies ordered from business in the last 36 months |
| NUM_MERCHANTS_COLLECTIBLES | INTEGER | Number of unique companies ordered from collectibles in the last 36 months |
| NUM_MERCHANTS_COMPUTER | INTEGER | Number of unique companies ordered from for computer related equipment in the last 36 months |
| NUM_MERCHANTS_CRAFT | INTEGER | Number of unique companies ordered from crafts in the last 36 months |
| NUM_MERCHANTS_CULTURE_ARTS | INTEGER | Number of unique companies ordered from culture arts in the last 36 months |
| NUM_MERCHANTS_DIY | INTEGER | Number of unique companies ordered from do it yourself in the last 36 months |
| NUM_MERCHANTS_EQUESTRIAN | INTEGER | Number of unique companies ordered from equestrian in the last 36 months |
| NUM_MERCHANTS_ELECTRONICS | INTEGER | Number of unique companies ordered from electronics in the last 36 months |
| NUM_MERCHANTS_FICTION | INTEGER | Number of unique companies ordered from fiction in the last 36 months |
| NUM_MERCHANTS_GAMES | INTEGER | Number of unique companies ordered from games in the last 36 months |
| NUM_MERCHANTS_GENERAL_MERCHANDISE | INTEGER | Number of unique companies ordered from general merchandise in the last 36 months |
| NUM_MERCHANTS_GIFT | INTEGER | Number of unique companies ordered from gifts in the last 36 months |
| NUM_MERCHANTS_GOURMET | INTEGER | Number of unique companies ordered from gourmet in the last 36 months |
| NUM_MERCHANTS_HISTORY | INTEGER | Number of unique companies ordered from history in the last 36 months |
| NUM_MERCHANTS_HOLIDAY | INTEGER | Number of unique companies ordered from holiday in the last 36 months |
| NUM_MERCHANTS_HUMOR | INTEGER | Number of unique companies ordered from humor in the last 36 months |
| NUM_MERCHANTS_INSPIRATION | INTEGER | Number of unique companies ordered from inspiration in the last 36 months |
| NUM_MERCHANTS_MONEY_MAKING | INTEGER | Number of unique companies ordered from money making in the last 36 months |
| NUM_MERCHANTS_MOTORCYCLE | INTEGER | Number of unique companies ordered from motorcycles in the last 36 months |
| NUM_MERCHANTS_MUSIC | INTEGER | Number of unique companies ordered from music in the last 36 months |
| NUM_MERCHANTS_PETS | INTEGER | Number of unique companies ordered from pets in the last 36 months |
| NUM_MERCHANTS_PERSONAL_FINANCE | INTEGER | Number of unique companies ordered from personal finance in the last 36 months |
| NUM_MERCHANTS_PHOTOGRAPHY | INTEGER | Number of unique companies ordered from photography in the last 36 months |
| NUM_MERCHANTS_RURAL | INTEGER | Number of unique companies ordered from rural in the last 36 months |
| NUM_MERCHANTS_SCIENCE | INTEGER | Number of unique companies ordered from science in the last 36 months |
| NUM_MERCHANTS_SPORTS | INTEGER | Number of unique companies ordered from sports in the last 36 months |
| NUM_MERCHANTS_TRAVEL | INTEGER | Number of unique companies ordered from travel in the last 36 months |
| NUM_MERCHANTS_TV_MOVIES | INTEGER | Number of unique companies ordered from television movies in the last 36 months |
| NUM_MERCHANTS_WILDLIFE_ENVIRONMENT | INTEGER | Number of unique companies ordered from wildlife environment in the last 36 months |
| NUM_MERCHANTS_WOMENS | INTEGER | Number of unique companies ordered from women in the last 36 months |