ccdw_aggr_product_recommendation_recommender

This table aggregates product recommendation performance broken down by individual recommender.

Column AliasData TypeKeyDescriptionIndex?
recommendation_dateDATEDate of the recommendation event.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
recommender_nameVARCHARName of the specific recommender.No
num_recommender_viewsINTEGERTotal number of times this recommender was viewed.No
num_product_viewsINTEGERTotal number of product views from this recommender.No
num_clicksINTEGERTotal number of clicks on recommended products from this recommender.No
num_cart_addsINTEGERTotal number of products added to cart from this recommender.No
num_products_purchasedINTEGERTotal number of products purchased from this recommender.No
num_ordersINTEGERTotal number of orders resulting from this recommender.No
std_attributed_revenueNUMERICTotal attributed revenue in standard currency from this recommender.No