Share via

Data entities mapping table

  • Article

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