Data entities mapping table
A list of the minimal required data entities for each recommendations scenario is given as follows. Use this list to determine the data entities required to provide meaningful recommendations.
| Recommendations API scenario | Required data entities | Modeling tier requirement |
|---|---|---|
| Picks for you | Reco_ItemsAndVariants, Reco_Interactions | Standard |
| Similar – People Also (default) | Reco_ItemsAndVariants, Reco_Interactions | Standard |
| Similar – Visual | Reco_ItemsAndVariants, Reco_ItemAndVariantImages | Premium |
| Similar – Visual (for image ID) | Reco_ItemsAndVariants, Reco_ItemAndVariantImages | Premium |
| Similar – Textual | Reco_ItemsAndVariants | Premium |
| Cart | Reco_ItemsAndVariants, Reco_Interactions | Standard |
| Trending lists - New | Reco_ItemsAndVariants | Standard |
| Trending lists - BestSelling and Trending | Reco_ItemsAndVariants, Reco_Interactions | Standard |
| External Lists - editorial/human authored lists | Reco_ExternalRecommendationsLists, Reco_ExternalRecommendationsItems | Standard |
Note
If there are scenarios that aren't necessary for your business, you have the option of disabling them to reduce cooking time and cost. To learn more about which scenarios can be enabled or disabled for your description, go to Reco configuration data entity. As specified in the Reco_ItemsAndVariants data entity, you can replace that data entity with the Reco_Interactions data entity. For more information, go to Reco_ItemsAndVariants. You can learn more about the different flavors of each API Scenario by reviewing the AlgoTypes Table.
Mapping your Data to a data contract
Most intelligent Recommendations scenarios can be configured using only two data entities (Reco_ItemsAndVariants, Reco_Interactions). For a quick look at which specific data points (fields) in the data contract are required for all recommendations scenarios, you can use the table given as follows.
Note
Certain fields (ItemId, ItemVariantId) are used more than once, meaning even less data is needed from you in order to see results!
Catalog data entity fields
| CATALOG Data Entity |
CATALOG Data Entity Fields |
|---|---|
| Reco_ItemsAndVariants | ItemId ItemVariantId (optional) Title Description ReleaseDate |
| Reco_ItemCategories | ItemId Category |
| Reco_ItemAndVariantFilters | ItemId ItemVariantId (optional) FilterName FilterValue |
| Reco_ItemAndVariantImages | ItemId ItemVariantId (optional) ImageFullUrl IsPrimaryImage |
Interactions data entity fields
| INTERACTIONS Data Entity |
INTERACTIONS Data Entity Fields |
|---|---|
| Reco_Interactions | InteractionGroupingId ItemId ItemVariantId UserId (optional) InteractionType=Purchase Timestamp |
See also
Intelligent Recommendations API
Data contract overview
Interactions data entities
Catalog data entities
Reco configuration data entities
External lists data entities
Opted-out users data entities
Recommendations enrichment data entities
Image to item mapping data entities