| Name | Description | Specification | Sample | ||||||||||||||||||||||||||||||
| Category Data | Which category does each product belong to. A product can belong to zero, one or several categories. The maximum number of categories is 32767. Used to filter predictions. Example: If a user is browsing products in category A, you can choose to only recommend product within category A. | Column 1 - ProductId Column 2 - CategoryId |
|
||||||||||||||||||||||||||||||
| Category Names | Assigns names to category identifiers. Used for a more friendly administration of categories in the Control Panel. | Column 1 - CategoryId Column 2 - Category Name |
|
||||||||||||||||||||||||||||||
| Valid Products | Data on which products are currently "on the shelves". Used as a master filter to set which products are recommendable. | Column 1 - ProductId |
|
||||||||||||||||||||||||||||||
| Product Data | Product attribute data. The purpose of the product data is to create rules. The different product data types are described below. Inform Avail about the names and data types of the columns you are going to upload. | Column 1 - ProductId Column 2 - Product Data ... Column N - Product Data |
|
||||||||||||||||||||||||||||||
| Transaction History | Order data. The transaction history is used to derive the predictions. Each row is an order row, i.e. a purchase made by a customer. Only upload real products and users. Do not upload for example test users, proxy users such as call centers, give-aways, shipment-and-handling, vat and so forth. As only distinct rows are taken into consideration you can save bandwidth by making sure that only distinct rows are uploaded. If the third optional column cart id is used, cart predictions will be available. | Distinct Rows Column 1 - UserId Column 2 - ProductId Optional:Column 3 - OrderId |
|
||||||||||||||||||||||||||||||
| Name | Description |
| CategoryId | A unique identifier for a category |
| OrderId | A unique identifier for an order placed |
| ProductId | A unique identifier for a product |
| UserId | A unique identifier for a user |
| Name | Format | Min | Max | Example |
| Date | yyyy-MM-dd | 1915-01-01 | 2036-12-31 | 2008-12-05 |
| Float | A decimal number. Dot as a delimiter. See IEEE 754-1985 for formal definition. | Easy definition but slightly incorrect: -16,777,216 with 6 decimals accuracy. Formally: -3.4028235 × 10^38 | Easy definition but slightly incorrect: 16,777,216 with 6 decimals accuracy. Formally: 3.4028235 × 10^38 | 10.95 |
| Int | A natural number. I.e. whole numbers including zero and negative numbers. | -2,147,483,647 | 2,147,483,647 | 110 |
| String | A string of arbitrary length consisting of UTF8 characters. | Empty String | 20,000 characters | image.jpg, Star Wars. |