This table stores data about how often items from category pairs are purchased together. It is used for the Affinity Selling feature of ATG Commerce.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
CATEGORY_1_ID | int | No | Primary key component. Foreign key to ARF_CATEGORY.ID column. | |
CATEGORY_2_ID | int | No | Primary key component. Foreign key to ARF_CATEGORY.ID column. | |
DAY_ID | varchar | 40 | No | Primary key component. Foreign key to ARF_TIME_DAY.ID column. |
SEGMENT_ID | tinyint | No | Primary key component. Foreign key to ARF_SEGMENT.ID column. | |
PURCHASE_PURCHASE_OCCURRENCES | int | Yes | The number of times products from these two categories have been purchased by the same customer, on the day the second product was purchased. | |
PURCHASE_PURCHASE_AFFINITY | double | Yes | The number of times products from these two categories have been purchased by the same customer, on the day the second product was purchased, weighted by the number of days between the first and second product purchases. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
INFLATION | double | Yes | A value used to ensure that recent purchase pairs are recommended more strongly than pairs purchased farther in the past. | |
PURCHASE_PURCHASE_INFLATED | double | Yes | The INFLATION value times the PURCHASE_PURCHASE_AFFINITY value. | |
PURCHASE_PURCHASE_TOTAL_SPREAD | int | Yes | Spread is defined as the number of days between purchases for each product in a product pair. For example, if Product 1 is purchased on April 1, and Product 2 is purchased on April 5, the spread is 4. The Purchase to Purchase Total Spread represents the sum of the spreads for all product pairs. |