- Created by Sylvain Paillard, last modified on Jan 02, 2023
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 4 Current »
We are listing here all the key opportunities we see we could seize with BigQuery ML for e-shops based on Google Analytics 4, Google Ads, the E-shop and Boxalino tracking / requests data.
Factor analysis of parameters affecting the performance of the PDP
Identify automatically what are the factors of a good performance or a bad performance of a PDP (product detail page) (especially for the case of visitors landing on the PDP from Google Shopping).
Example: it might be that products with 3 stars or more (in their ratings) are a major factor to increase the engagement and the conversion rate.
These parameters can be related to the product data, or the session data (device, …) or the combination of both (e.g.: if the users are on the mobile, a long textual description is not a good thing)
Data Available:
Product properties
the item brand and categories are indicated in GA4 view_item events, but Boxalino has a lot more product attribute from the e-shop, including (the properties would be provided as an associate array with property names and values: ARRAY<STRUCT<name, ARRAY<string> values>>):brand
category (several levels)
price (before or after discount)
number of stars
state of discount (in discount and how much)
pictures (number of pictures, urls, …)
description (to see if the length or other aspects could play a role)
delivery state (in stock, …)
…
in example after: product_properties : have string properties for the recommended products
GA4 data
view_item indicating that it is a PDP
traffic source
device
geo
…
in the data : all the ga4 view_item event are therepage_views (to see what page view happens before / after, because it is maybe very different if it is a landing page)
in the data: array_length of prior_pages
fyi- the sample data after are computed (except for the product_properties) fully on the basis of GA4 data.
Performance metrics:
Bounce rate
in the data: next_pages would be emptyNumber of page views
in the data: array_length of next_pagessession conversion rate
in the data: count(distinct session_id) / count(distinct next_purchases.ecommerce.transaction_Id)in scope conversion rate (not only there is a conversion, but there is a conversion with this product)
in the data: compare the main item with the items of the next purchase itemssession $ value (average value per session)
in the data: next_purchases.ecommerce.purchase_revenue and session_idAOV (averge order value)
in the data: next_purchases.ecommerce.purchase_revenue / next_purchases.ecommerce.transaction_id
Sample data
{
"items": [
{
"item_id": "57839",
"item_name": "Gartenlounge Luka 4-teilig",
"item_brand": "",
"item_variant": "",
"item_category": "Haushalt & Garten",
"item_category2": "Gartenmöbel",
"item_category3": "Gartenlounges",
"item_category4": "(not set)",
"item_category5": "(not set)",
"price_in_usd": "1392.040619",
"price": "1299.0",
"quantity": null,
"item_revenue_in_usd": null,
"item_revenue": null,
"item_refund_in_usd": null,
"item_refund": null,
"coupon": "(not set)",
"affiliation": "(not set)",
"location_id": "(not set)",
"item_list_id": "(not set)",
"item_list_name": "(not set)",
"item_list_index": "(not set)",
"promotion_id": "(not set)",
"promotion_name": "(not set)",
"creative_name": "(not set)",
"creative_slot": "(not set)"
}
],
"event_timestamp": "1647299427141410",
"user_id": null,
"user_pseudo_id": "571948535.1643665154",
"device": {
"category": "mobile",
"mobile_brand_name": "Samsung",
"mobile_model_name": "SM-G715FN",
"mobile_marketing_name": "Galaxy XCover Pro",
"mobile_os_hardware_model": null,
"operating_system": "Android",
"operating_system_version": "Android 11",
"vendor_id": null,
"advertising_id": null,
"language": "de-de",
"is_limited_ad_tracking": "No",
"time_zone_offset_seconds": null,
"browser": null,
"browser_version": null,
"web_info": {
"browser": "Chrome",
"browser_version": "99.0.4844.58",
"hostname": "www.lehner-versand.ch"
}
},
"geo": {
"continent": "Europe",
"country": "Switzerland",
"region": "Basel City",
"city": "Basel",
"sub_continent": "Western Europe",
"metro": "(not set)"
},
"traffic_source": {
"name": null,
"medium": "cpc",
"source": "google"
},
"session_id": "1647299334",
"session_number": "7",
"source_medium_session": "google / cpc",
"campaign_session": "(organic)",
"full_referrer": "https://www.google.com/",
"default_channel_grouping_session": "Paid Search",
"source_medium_user": "google / cpc",
"campaign_user": null,
"default_channel_grouping_user": "Paid Search",
"gclid": "Cj0KCQjwz7uRBhDRARIsAFqjulmsuHZmU6b6pQxdgVD2YZQG58_6z2BCnOuAd5eSJeI3rQkC1VFAxmIaAtSAEALw_wcB",
"date": "2022-03-14",
"page_location": "https://www.lehner-versand.ch/p-57839-gartenlounge-luka-4-teilig/",
"next_page_view": {
"event_timestamp": null,
"page_location": "NONE (exit)"
},
"next_next_page_view": {
"event_timestamp": null,
"page_location": "NONE (exit)"
},
"prior_page_view": {
"event_timestamp": "1647299419390739",
"page_location": "https://www.lehner-versand.ch/k-haushalt-garten/gartenmoebel/?gclid=Cj0KCQjwz7uRBhDRARIsAFqjulmsuHZmU6b6pQxdgVD2YZQG58_6z2BCnOuAd5eSJeI3rQkC1VFAxmIaAtSAEALw_wcB"
},
"prior_prior_page_view": {
"event_timestamp": "1647299396717140",
"page_location": "https://www.lehner-versand.ch/k-haushalt-garten/kueche/?limit=204"
},
"next_view_item": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"items": [
]
},
"next_next_view_item": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"items": [
]
},
"prior_view_item": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"items": [
]
},
"prior_prior_view_item": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"items": [
]
},
"next_add_to_cart": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"ecommerce": null,
"items": [
]
},
"next_next_add_to_cart": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"ecommerce": null,
"items": [
]
},
"prior_add_to_cart": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"ecommerce": null,
"items": [
]
},
"prior_prior_add_to_cart": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"ecommerce": null,
"items": [
]
},
"next_purchase": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"ecommerce": null,
"items": [
]
},
"next_next_purchase": {
"event_timestamp": null,
"page_location": "NONE (exit)",
"ecommerce": null,
"items": [
]
},
"prior_purchase": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"ecommerce": null,
"items": [
]
},
"prior_prior_purchase": {
"event_timestamp": null,
"page_location": "NONE (landing)",
"ecommerce": null,
"items": [
]
},
"next_session_purchase": {
"event_timestamp": null,
"ecommerce": null,
"items": [
]
},
"next_next_session_purchase": {
"event_timestamp": null,
"ecommerce": null,
"items": [
]
},
"prior_session_purchase": {
"event_timestamp": null,
"ecommerce": null,
"items": [
]
},
"prior_prior_session_purchase": {
"event_timestamp": null,
"ecommerce": null,
"items": [
]
},
"path": "p-57839-gartenlounge-luka-4-teilig/",
"url": "https://www.lehner-versand.ch/p-57839-gartenlounge-luka-4-teilig/",
"prior_page_url_full": "https://www.lehner-versand.ch/k-haushalt-garten/gartenmoebel/?gclid=Cj0KCQjwz7uRBhDRARIsAFqjulmsuHZmU6b6pQxdgVD2YZQG58_6z2BCnOuAd5eSJeI3rQkC1VFAxmIaAtSAEALw_wcB",
"prior_prior_page_url_full": "https://www.lehner-versand.ch/k-haushalt-garten/kueche/?limit=204",
"next_page_url_full": "NONE (exit)",
"next_next_page_url_full": "NONE (exit)",
"prior_page_is_view_item": "0",
"prior_prior_page_is_view_item": "0",
"next_page_is_view_item": "0",
"next_next_page_is_view_item": "0",
"prior_page_is_add_to_cart": "0",
"prior_prior_page_is_add_to_cart": "0",
"next_page_is_add_to_cart": "0",
"next_next_page_is_add_to_cart": "0",
"prior_page_is_purchase": "0",
"prior_prior_page_is_purchase": "0",
"next_page_is_purchase": "0",
"next_next_page_is_purchase": "0",
"product_properties": [
{
"property_id": null,
"property_name": "categories_fr_4",
"property_label": "category (fr) 4th",
"property_values": [
"13838011/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin",
"13833071/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin"
],
"property_value_labels": [
"13838011/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin",
"13833071/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin"
]
},
{
"property_id": "1",
"property_name": "bq_product_high_low_end",
"property_label": "bq product high low end",
"property_values": [
"high-end"
],
"property_value_labels": [
"high-end"
]
},
{
"property_id": null,
"property_name": "brand_de",
"property_label": "brand",
"property_values": [
"not-set"
],
"property_value_labels": [
"not-set"
]
},
{
"property_id": null,
"property_name": "category_leaf_de",
"property_label": "category leaf (de)",
"property_values": [
"13833079/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel/Gartenlounges",
"50590007/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten/Garten + Gartenmöbel"
],
"property_value_labels": [
"13833079/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel/Gartenlounges",
"50590007/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten/Garten + Gartenmöbel"
]
},
{
"property_id": null,
"property_name": "categories_fr_3",
"property_label": "category (fr) 3rd",
"property_values": [
"13837955/Root Catalog/lehner-versand.ch/Promotions",
"13481553/Root Catalog/lehner-versand.ch/Ménage & jardin"
],
"property_value_labels": [
"13837955/Root Catalog/lehner-versand.ch/Promotions",
"13481553/Root Catalog/lehner-versand.ch/Ménage & jardin"
]
},
{
"property_id": "27",
"property_name": "parent_sku",
"property_label": "Parent SKU",
"property_values": [
"57839"
],
"property_value_labels": [
"57839"
]
},
{
"property_id": null,
"property_name": "categories_de_5",
"property_label": "category (de) 5th",
"property_values": [
"50590007/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten/Garten + Gartenmöbel",
"13833079/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel/Gartenlounges"
],
"property_value_labels": [
"50590007/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten/Garten + Gartenmöbel",
"13833079/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel/Gartenlounges"
]
},
{
"property_id": null,
"property_name": "categories_fr_5",
"property_label": "category (fr) 5th",
"property_values": [
"13833079/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin/Salons de jardin",
"50590007/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin/Jardin + meubles de jardin"
],
"property_value_labels": [
"13833079/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin/Salons de jardin",
"50590007/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin/Jardin + meubles de jardin"
]
},
{
"property_id": null,
"property_name": "categories_de_4",
"property_label": "category (de) 4th",
"property_values": [
"13833071/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel",
"13838011/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten"
],
"property_value_labels": [
"13833071/Root Catalog/lehner-versand.ch/Haushalt & Garten/Gartenmöbel",
"13838011/Root Catalog/lehner-versand.ch/Schnäppchen/Haushalt & Garten"
]
},
{
"property_id": "14",
"property_name": "bq_main_topic_3",
"property_label": "Semantic Topic 3",
"property_values": [
"Schnäppchen"
],
"property_value_labels": [
"Schnäppchen"
]
},
{
"property_id": null,
"property_name": "flag",
"property_label": "flag",
"property_values": [
"discount"
],
"property_value_labels": [
"discount"
]
},
{
"property_id": null,
"property_name": "discount_percentage",
"property_label": "discount %",
"property_values": [
"0.4"
],
"property_value_labels": [
"0.4"
]
},
{
"property_id": null,
"property_name": "categories_de_3",
"property_label": "category (de) 3rd",
"property_values": [
"13481553/Root Catalog/lehner-versand.ch/Haushalt & Garten",
"13837955/Root Catalog/lehner-versand.ch/Schnäppchen"
],
"property_value_labels": [
"13481553/Root Catalog/lehner-versand.ch/Haushalt & Garten",
"13837955/Root Catalog/lehner-versand.ch/Schnäppchen"
]
},
{
"property_id": "13",
"property_name": "bq_main_topic_2",
"property_label": "Semantic Topic 2",
"property_values": [
"Gartenmöbel"
],
"property_value_labels": [
"Gartenmöbel"
]
},
{
"property_id": null,
"property_name": "category_leaf_id",
"property_label": "category leaf id",
"property_values": [
"13833079",
"50590007"
],
"property_value_labels": [
"13833079",
"50590007"
]
},
{
"property_id": null,
"property_name": "category_leaf_fr",
"property_label": "category leaf (fr)",
"property_values": [
"13833079/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin/Salons de jardin",
"50590007/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin/Jardin + meubles de jardin"
],
"property_value_labels": [
"13833079/Root Catalog/lehner-versand.ch/Ménage & jardin/Meubles de jardin/Salons de jardin",
"50590007/Root Catalog/lehner-versand.ch/Promotions/Ménage & jardin/Jardin + meubles de jardin"
]
}
],
"prior_page_url": "https://www.lehner-versand.ch/k-haushalt-garten/gartenmoebel/",
"prior_prior_page_url": "https://www.lehner-versand.ch/k-haushalt-garten/kueche/",
"next_page_url": "NONE (exit)",
"next_next_page_url": "NONE (exit)",
"prior_page_type": "page_view",
"prior_prior_page_type": "page_view",
"next_page_type": "NONE (exit)",
"next_next_page_type": "NONE (exit)"
}
First attempts
As the first attempt, we did a logistic regression based on the basic item properties of GA4 (brand, category, and price):
CREATE OR REPLACE TABLE `@reports.Data_PDPPrediction_logistic_reg_v1_11M` as SELECT count(distinct vi.session_id) as sessions , sum(case when p.session_id is null then 0 else 1 end) as purchases , vi.items[safe_offset(0)].item_brand , vi.items[safe_offset(0)].item_category , vi.items[safe_offset(0)].item_category2 , vi.items[safe_offset(0)].item_category3 , vi.items[safe_offset(0)].item_category4 , vi.items[safe_offset(0)].item_category5 , vi.items[safe_offset(0)].price FROM `@core.ga_events_enriched` as vi left join `@core.ga_events_enriched`as p on vi.session_id = p.session_id and p.date >= date_sub(current_date(), interval 6 month) and p.event_name = 'purchase' WHERE vi.date >= date_sub(current_date(), interval 6 month) and vi.event_name = 'view_item' group by item_brand, item_category, item_category2, item_category3, item_category4, item_category5, price ; CREATE OR REPLACE MODEL `@reports.Model_PDPPrediction_logistic_reg_v1_11M` OPTIONS( model_type='logistic_reg' , CATEGORY_ENCODING_METHOD = 'DUMMY_ENCODING' , CALCULATE_P_VALUES = TRUE, ENABLE_GLOBAL_EXPLAIN = TRUE ) AS SELECT (IF(purchases >= it,1,0)) AS label , item_brand , item_category , item_category2 , item_category3 , item_category4 , item_category5 , price FROM `@reports.Data_PDPPrediction_logistic_reg_v1_11M` join unnest(GENERATE_ARRAY(1,sessions)) as it ;
The results showed a quite limited predictive power (which was to be expected with such a basic set of parameters):
The Interpretability tab shows some information about the attribution to each parameter, showing that the brand and the category have much higher attribution than the price (but this could be partially because the price is a numeric field):
Factor analysis of parameters affecting the performance of product recommendations on the PDP
Identify automatically what are the factors of a good performance or a bad performance of a product recommendation
Example: recommending products which have bad ratings might be a bad idea
Example: recommending products of the same brand than the one of the currently viewed product might be a good idea for some brands and a bad idea for other brands
These parameters can be related to the product data of either the PDP or of the recommended products, as well as the session data (device, …) or the combination of them (e.g.: on products of the brand X recommending products of the brand Y doesn’t work)
Data Available:
Product properties (for both the PDP and the recommended products)
the item brand and categories are indicated in GA4 view_item events, but Boxalino has a lot more product attribute from the e-shop, including (the properties would be provided as an associate array with property names and values: ARRAY<STRUCT<name, ARRAY<string> values>>):number of stars
state of discount (in discount and how much)
pictures (number of pictures, urls, …)
description (to see if the length or other aspects could play a role)
delivery state (in stock, …)
…
in example data :
string_properties : have string properties for the recommended products
numeric_properties : have numeric properties for the recommended products
source_string_properties : have string properties for the current PDP
source_numeric_properties : have numeric properties for the current PDP
Other data
test variant (it is often the case that there are several algorithms tested as different test variant, we could use the test variant as a factor to see if it makes a different (positive or negative) for specific products)
in example data : variant_id
Performance metrics:
Click-Through-Rate (the number of times the recommended product is clicked compared to the number of times it is shown)
in example data : KPI_defined.click / KPI_defined.mainImpressionAdd-To-Basket-RAte (the number of times the recommended product is clicked and then added to the basket compared to the number of times it is shown)
in example data : KPI_defined.click_n_atb/ KPI_defined.mainImpression
Buy-Through-Rate (the number of times the recommended product is clicked and then added to the basket and then bought compared to the number of times it is shown)
in example data : KPI_defined.click_n_buy / KPI_defined.mainImpression
Display $ Value (the average value bought by the Buy-Throughs compared to the number of times the product is shown, so the average value of showing the product as a recommendation)
in example data : KPI_defined.click_n_revenue / KPI_defined.mainImpression
Example data
{
"product_id": "2457",
"groupby_field": "products_group_id",
"title_de": "khadi Pflanzenfarbe HENNA, AMLA, JATROPHA - ROT - Teinture aux Plantes Henné, Amla \u0026 Jatropha Rouge",
"title_fr": "Khadi Plant Colour HENNA, AMLA, JATROPHA - RED - Teinture aux Plantes Henné, Amla \u0026amp; Jatropha Rouge",
"exact_margin": "0.38815789473684204",
"exact_price": "15.2",
"ean": "4260378040114",
"sku": null,
"source_product_id": "3486",
"source_groupby_field": "products_group_id",
"source_title_de": "khadi Shampoo AUFTRAGEFLASCHE",
"source_title_fr": "Bouteille de shampoing khadi",
"source_exact_margin": "0.39743589743589736",
"source_exact_price": "3.9",
"source_ean": null,
"source_sku": null,
"source_subtype": "mainProduct",
"variant_id": "control",
"variants": "1",
"requests": "51",
"landing_requests": "0",
"exit_requests": "0",
"avg_nth_page": "14.943981481481481",
"avg_page_size": "8.0",
"landing_sessions": "0",
"exit_sessions": "0",
"sessions": "6",
"visitor_personas": "6",
"user_personas": "5",
"returnings": "0",
"channel": "",
"country": "",
"device_category": "",
"orders": "5",
"order_products": "23",
"order_qty": "35",
"total_crncy_amt": "641.5",
"total_margin_crncy_amt": "215.9981429897864",
"KPI_defined": {
"clicks": "0.0",
"mainImpressions": "4.0",
"percentageImpressions": "4.0",
"click_n_atbs": "0.0",
"click_n_buys": "0.0",
"click_n_revenue": null,
"click_n_margin": null,
"click": "0.0",
"mainImpression": "4.0",
"click_n_atb": "0.0",
"click_n_buy": "0.0"
},
"language_cd": "",
"string_properties": [{
"property_id": null,
"property_name": "flag",
"property_label": "flag",
"property_values": ["parameter_change_7_14"],
"property_value_labels": ["parameter change - 7 to 14 days"]
}, {
"property_id": "5",
"property_name": "products_optionID_13_de",
"property_label": "Haartyp",
"property_values": ["normales Haar", "feines \u0026 dünnes Haar", "dickes \u0026 kräftiges Haar", "krauses \u0026 gelocktes Haar", "trockenes, strapaziertes Haar", "empfindlich | irritierter | trockener Kopfhaut"],
"property_value_labels": ["normales Haar", "feines \u0026 dünnes Haar", "dickes \u0026 kräftiges Haar", "krauses \u0026 gelocktes Haar", "trockenes, strapaziertes Haar", "empfindlich | irritierter | trockener Kopfhaut"]
}, {
"property_id": null,
"property_name": "categories_de_3",
"property_label": "category (de) 3rd",
"property_values": ["370/Root/Puresense/HAARE"],
"property_value_labels": ["370/Root/Puresense/HAARE"]
}, {
"property_id": null,
"property_name": "categories_de_5",
"property_label": "category (fr) 5th",
"property_values": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"],
"property_value_labels": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"]
}, {
"property_id": null,
"property_name": "categories_fr_4",
"property_label": "category (de) 4th",
"property_values": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"],
"property_value_labels": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"]
}, {
"property_id": null,
"property_name": "category_leaf_id",
"property_label": "category leaf id",
"property_values": ["874", "875", "1518"],
"property_value_labels": ["874", "875", "1518"]
}, {
"property_id": "1",
"property_name": "products_optionID_6_de",
"property_label": "products_optionID_6_de",
"property_values": ["Haarpflege | Kopfhautpflege | Haarfarben"],
"property_value_labels": ["Haarpflege | Kopfhautpflege | Haarfarben"]
}, {
"property_id": null,
"property_name": "category_leaf_de",
"property_label": "category leaf (de)",
"property_values": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"],
"property_value_labels": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"]
}, {
"property_id": "2",
"property_name": "products_optionID_10_de",
"property_label": "products_optionID_10_de",
"property_values": ["BDIH", "Vegan"],
"property_value_labels": ["BDIH", "Vegan"]
}, {
"property_id": null,
"property_name": "products_brand",
"property_label": "brand",
"property_values": ["khadi Pflanzenfarben \u0026 more"],
"property_value_labels": ["khadi Pflanzenfarben \u0026 more"]
}, {
"property_id": null,
"property_name": "category_leaf_fr",
"property_label": "category leaf (fr)",
"property_values": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"],
"property_value_labels": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"]
}, {
"property_id": "10",
"property_name": "bq_product_high_low_end",
"property_label": "bq product high low end",
"property_values": ["low-end"],
"property_value_labels": ["low-end"]
}, {
"property_id": "8",
"property_name": "products_immediate_delivery",
"property_label": "products_immediate_delivery",
"property_values": ["1"],
"property_value_labels": ["1"]
}, {
"property_id": null,
"property_name": "categories_fr_3",
"property_label": "category (de) 3rd",
"property_values": ["370/Root/Puresense/HAARE"],
"property_value_labels": ["370/Root/Puresense/HAARE"]
}, {
"property_id": null,
"property_name": "categories_fr_5",
"property_label": "category (fr) 5th",
"property_values": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"],
"property_value_labels": ["874/Root/Puresense/FRAU/Haarpflege/Haarfarbe", "875/Root/Puresense/HAARE/Haarpflege/Haarfarbe", "1518/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Pflanzenhaarfarben"]
}, {
"property_id": null,
"property_name": "categories_de_4",
"property_label": "category (de) 4th",
"property_values": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"],
"property_value_labels": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"]
}, {
"property_id": "100",
"property_name": "bq_main_topic_listing",
"property_label": "BQ main topic listing",
"property_values": ["Nagellacke"],
"property_value_labels": ["Nagellacke"]
}, {
"property_id": "100",
"property_name": "bq_product_high_low_end",
"property_label": "BQ product high low end",
"property_values": ["low-end"],
"property_value_labels": ["low-end"]
}, {
"property_id": "100",
"property_name": "bq_custom_bq_create_date_less_30",
"property_label": "BQ custom BQ create date less 30",
"property_values": ["0"],
"property_value_labels": ["0"]
}],
"numeric_properties": [{
"name": "bq_widget_basket_Clicks_all_time",
"label": "BQ widget basket Clicks all time",
"values": ["0"]
}, {
"name": "bq_std_price_min_products_group_id",
"label": "BQ standard price min group id",
"values": ["15.2"]
}, {
"name": "bq_product_baskets_products_group_id_season_year",
"label": "BQ product baskets group id season year",
"values": ["0"]
}, {
"name": "bq_order_count_products_group_id_season_year",
"label": "BQ order count group id season year",
"values": ["7"]
}, {
"name": "bq_order_last_count_medium_time_all_time",
"label": "BQ order last count medium time all time",
"values": ["201"]
}, {
"name": "bq_order_profit_daily",
"label": "BQ order profit daily",
"values": ["0.642268005"]
}, {
"name": "bq_order_qty_products_group_id_long_term",
"label": "BQ order qty group id long term",
"values": ["274"]
}, {
"name": "bq_order_count_products_group_id_mid_term",
"label": "BQ order count group id mid term",
"values": ["28"]
}, {
"name": "bq_order_count_products_group_id_daily",
"label": "BQ order count group id daily",
"values": ["0.123471171"]
}, {
"name": "bq_product_views_products_group_id_mid_term",
"label": "BQ product views group id mid term",
"values": ["0"]
}, {
"name": "bq_std_price_max_products_group_id",
"label": "BQ standard price max group id",
"values": ["15.2"]
}, {
"name": "bq_widget_basket_Click-UPs_all_time",
"label": "BQ widget basket Click UPs all time",
"values": ["0"]
}, {
"name": "bq_std_margin_percent_products_group_id",
"label": "BQ standard margin percent group id",
"values": ["0"]
}, {
"name": "bq_product_baskets_products_group_id_all_time",
"label": "BQ product baskets group id all time",
"values": ["0"]
}, {
"name": "bq_std_list_price_min_products_group_id",
"label": "BQ standard list price min group id",
"values": ["15.2"]
}, {
"name": "bq_order_revenue_products_group_id_all_time",
"label": "BQ order revenue group id all time",
"values": ["3034.37"]
}, {
"name": "bq_product_baskets_products_group_id_long_term",
"label": "BQ product baskets group id long term",
"values": ["0"]
}, {
"name": "bq_order_revenue_products_group_id_short_term",
"label": "BQ order revenue group id short term",
"values": ["136.8"]
}, {
"name": "bq_order_revenue_products_group_id_long_term",
"label": "BQ order revenue group id long term",
"values": ["2472.27"]
}, {
"name": "bq_order_revenue_products_group_id_season_year",
"label": "BQ order revenue group id season year",
"values": ["104.3"]
}, {
"name": "bq_order_profit_long_term",
"label": "BQ order profit long term",
"values": ["851.174164016"]
}, {
"name": "bq_order_qty_products_group_id_season_year",
"label": "BQ order qty group id season year",
"values": ["12"]
}, {
"name": "bq_top_category_rank_score_products_group_id",
"label": "BQ top category rank score group id",
"values": ["0"]
}, {
"name": "bq_order_count_yearly_week",
"label": "BQ order count yearly week",
"values": ["0.361742656"]
}, {
"name": "bq_widget_basket_U-Click-UPs_all_time",
"label": "BQ widget basket U Click UPs all time",
"values": ["0"]
}, {
"name": "bq_order_count_products_group_id_week_day",
"label": "BQ order count group id week day",
"values": ["27"]
}, {
"name": "bq_order_last_count_short_time_all_time",
"label": "BQ order last count short time all time",
"values": ["209"]
}, {
"name": "bq_product_view_session_order_products_products_group_id_all_time",
"label": "BQ product view session order group id all time",
"values": ["0"]
}, {
"name": "bq_product_baskets_products_group_id_mid_term",
"label": "BQ product baskets group id mid term",
"values": ["0"]
}, {
"name": "bq_widget_basket_U-Displays_all_time",
"label": "BQ widget basket U Displays all time",
"values": ["0"]
}, {
"name": "bq_product_views_products_group_id_all_time",
"label": "BQ product views group id all time",
"values": ["0"]
}, {
"name": "bq_product_baskets_products_group_id_short_term",
"label": "BQ product baskets group id short term",
"values": ["0"]
}, {
"name": "bq_order_profit_short_term",
"label": "BQ order profit short term",
"values": ["53.1"]
}, {
"name": "bq_std_description_length",
"label": "BQ standard description length",
"values": ["0"]
}, {
"name": "bq_order_profit_season_year",
"label": "BQ order profit season year",
"values": ["50.4"]
}, {
"name": "bq_order_qty_products_group_id_week_day",
"label": "BQ order qty group id week day",
"values": ["43"]
}, {
"name": "bq_order_profit_week_day",
"label": "BQ order profit week day",
"values": ["140.739130439"]
}, {
"name": "bq_product_view_session_order_revenue_products_group_id_all_time",
"label": "BQ product view session order revenue group id all time",
"values": ["0"]
}, {
"name": "bq_order_bought_with_profit_all_time",
"label": "BQ order bought with profit all time",
"values": ["1102.774164016"]
}, {
"name": "bq_order_repeated_count_all_time",
"label": "BQ order repeated count all time",
"values": ["218"]
}, {
"name": "bq_std_margin_amount_products_group_id",
"label": "BQ standard margin amount group id",
"values": ["0"]
}, {
"name": "bq_product_view_overall_order_qty_products_group_id_all_time",
"label": "BQ product view overall order qty group id all time",
"values": ["0"]
}, {
"name": "bq_widget_basket_ctr_level_all_time",
"label": "BQ widget basket ctr level all time",
"values": ["0"]
}, {
"name": "bq_widget_basket_Displays_all_time",
"label": "BQ widget basket Displays all time",
"values": ["0"]
}, {
"name": "bq_product_baskets_products_group_id_week_day",
"label": "BQ product baskets group id week day",
"values": ["0"]
}, {
"name": "bq_product_view_session_order_qty_products_group_id_all_time",
"label": "BQ product view session order qty group id all time",
"values": ["0"]
}, {
"name": "bq_std_discount_percent_products_group_id",
"label": "BQ standard discount percent group id",
"values": ["0"]
}, {
"name": "bq_product_views_products_group_id_long_term",
"label": "BQ product views group id long term",
"values": ["0"]
}, {
"name": "bq_order_revenue_products_group_id_mid_term",
"label": "BQ order revenue group id mid term",
"values": ["425.3"]
}, {
"name": "bq_order_qty_products_group_id_all_time",
"label": "BQ order qty group id all time",
"values": ["332"]
}, {
"name": "bq_order_new_1_month_count_all_time",
"label": "BQ order new 1 month count all time",
"values": ["3"]
}, {
"name": "bq_product_views_products_group_id_season_year",
"label": "BQ product views group id season year",
"values": ["0"]
}, {
"name": "bq_product_view_overall_order_revenue_products_group_id_all_time",
"label": "BQ product view overall order revenue group id all time",
"values": ["0"]
}, {
"name": "bq_product_view_overall_order_profit_products_group_id_all_time",
"label": "BQ product view overall order profit group id all time",
"values": ["0"]
}, {
"name": "bq_std_repurchase_category_count",
"label": "BQ standard repurchase category count",
"values": ["0"]
}, {
"name": "bq_order_count_products_group_id_short_term",
"label": "BQ order count group id short term",
"values": ["9"]
}, {
"name": "bq_order_qty_products_group_id_daily",
"label": "BQ order qty group id daily",
"values": ["0.193360513"]
}, {
"name": "bq_order_count_products_group_id_all_time",
"label": "BQ order count group id all time",
"values": ["212"]
}, {
"name": "bq_order_count_products_group_id_long_term",
"label": "BQ order count group id long term",
"values": ["175"]
}, {
"name": "bq_widget_basket_btr_level_all_time",
"label": "BQ widget basket btr level all time",
"values": ["0"]
}, {
"name": "bq_product_view_overall_order_count_products_group_id_all_time",
"label": "BQ product view overall order count group id all time",
"values": ["0"]
}, {
"name": "bq_widget_basket_U-Clicks_all_time",
"label": "BQ widget basket U Clicks all time",
"values": ["0"]
}, {
"name": "bq_order_profit_all_time",
"label": "BQ order profit all time",
"values": ["1102.774164016"]
}, {
"name": "bq_product_view_session_order_profit_products_group_id_all_time",
"label": "BQ product view session order profit group id all time",
"values": ["0"]
}, {
"name": "bq_order_qty_products_group_id_short_term",
"label": "BQ order qty group id short term",
"values": ["11"]
}, {
"name": "bq_order_qty_products_group_id_mid_term",
"label": "BQ order qty group id mid term",
"values": ["47"]
}, {
"name": "bq_order_first_count_all_time",
"label": "BQ order first count all time",
"values": ["218"]
}, {
"name": "bq_std_discount_amount_products_group_id",
"label": "BQ standard discount amount group id",
"values": ["0"]
}, {
"name": "bq_order_profit_mid_term",
"label": "BQ order profit mid term",
"values": ["198.5"]
}, {
"name": "bq_product_views_products_group_id_week_day",
"label": "BQ product views group id week day",
"values": ["0"]
}, {
"name": "bq_std_discount_percent",
"label": "BQ standard discount percent",
"values": ["0"]
}, {
"name": "bq_order_revenue_products_group_id_week_day",
"label": "BQ order revenue group id week day",
"values": ["385.7"]
}, {
"name": "bq_order_bought_with_revenue_products_group_id_all_time",
"label": "BQ order bought with revenue group id all time",
"values": ["3034.37"]
}, {
"name": "bq_product_views_products_group_id_short_term",
"label": "BQ product views group id short term",
"values": ["0"]
}, {
"name": "bq_product_view_session_order_count_products_group_id_all_time",
"label": "BQ product view session order count group id all time",
"values": ["0"]
}, {
"name": "bq_order_last_count_long_time_all_time",
"label": "BQ order last count long time all time",
"values": ["175"]
}, {
"name": "bq_order_revenue_products_group_id_daily",
"label": "BQ order revenue group id daily",
"values": ["1.767251019"]
}, {
"name": "bq_std_repurchase_count",
"label": "BQ standard repurchase count",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_search_ctr_mid_term_position_score",
"label": "BQ correlation last bought item search ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_navigation_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item navigation disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_navigation_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item navigation disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_accessories_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item accessories disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_complementary_disp_views_mid_term_position_score",
"label": "BQ correlation context item complementary disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_similar_disp_orders_mid_term_position_score",
"label": "BQ correlation context item similar disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_accessories_ctr_mid_term_position_score",
"label": "BQ correlation context item accessories ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_related_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item related disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-tfidf-products-description-de_position_score",
"label": "BQ correlation textual similarity tfidf products description de position score",
"values": ["0"]
}, {
"name": "bq_correlation_bought_after_position_score",
"label": "BQ correlation bought after position score",
"values": ["0"]
}, {
"name": "bq_correlation_bought_first_second_purchase_position_score",
"label": "BQ correlation bought first second purchase position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-bought-together_position_score",
"label": "BQ correlation collaborative filtering bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-search-product-views_position_score",
"label": "BQ correlation collaborative filtering search product views position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_search_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item search disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_related_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item related disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_complementary_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item complementary disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_accessories_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item accessories disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_accessories_disp_orders_mid_term_position_score",
"label": "BQ correlation context item accessories disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_accessories_btr_mid_term_position_score",
"label": "BQ correlation context item accessories btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_affinities-discover-customer_position_score",
"label": "BQ correlation affinities discover customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_complementary_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item complementary disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_accessories_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item accessories disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_accessories_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item accessories disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_accessories_btr_mid_term_position_score",
"label": "BQ correlation last viewed item accessories btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_navigation_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item navigation disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-wordembeddings-body_position_score",
"label": "BQ correlation textual similarity wordembeddings body position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-tfidfvectorizer-bought-together_position_score",
"label": "BQ correlation textual similarity unigram tfidfvectorizer bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-countvectorizer-body_position_score",
"label": "BQ correlation textual similarity unigram countvectorizer body position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-icf-bought-together_position_score",
"label": "BQ correlation textual similarity icf bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-viewed-same-session_position_score",
"label": "BQ correlation collaborative filtering viewed same session position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_navigation_ctr_mid_term_position_score",
"label": "BQ correlation last bought item navigation ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_similar_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item similar disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_navigation_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item navigation disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_search_ctr_mid_term_position_score",
"label": "BQ correlation last viewed item search ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_search_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item search disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-bq-tfidf-title_position_score",
"label": "BQ correlation textual similarity BQ tfidf title position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-tfidf-body-de-inhaltsstoffe_position_score",
"label": "BQ correlation textual similarity tfidf body de inhaltsstoffe position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-tfidf-body-de_position_score",
"label": "BQ correlation textual similarity tfidf body de position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-countvectorizer-title_position_score",
"label": "BQ correlation textual similarity unigram countvectorizer title position score",
"values": ["0"]
}, {
"name": "bq_correlation_basketed_in_same_session_position_score",
"label": "BQ correlation basketed in same session position score",
"values": ["0"]
}, {
"name": "bq_correlation_bought_same_customer_position_score",
"label": "BQ correlation bought same customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_bought_together_position_score",
"label": "BQ correlation bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-basket-same-session_position_score",
"label": "BQ correlation collaborative filtering basket same session position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-first-second-purchase_position_score",
"label": "BQ correlation collaborative filtering first second purchase position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_navigation_btr_mid_term_position_score",
"label": "BQ correlation last bought item navigation btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_accessories_ctr_mid_term_position_score",
"label": "BQ correlation last bought item accessories ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_similar_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item similar disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last-search-tag-customer_position_score",
"label": "BQ correlation last search tag customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_related_disp_orders_mid_term_position_score",
"label": "BQ correlation context item related disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_complementary_disp_orders_mid_term_position_score",
"label": "BQ correlation context item complementary disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_top_category_rank_position_score",
"label": "BQ correlation top category rank position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-last-views-customer_position_score",
"label": "BQ correlation collaborative filtering last views customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_related_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item related disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_search_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item search disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_search_btr_mid_term_position_score",
"label": "BQ correlation last viewed item search btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-bought-together_position_score",
"label": "BQ correlation textual similarity bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-tfidf-body_position_score",
"label": "BQ correlation textual similarity unigram tfidf body position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-first-second-purchase-customer_position_score",
"label": "BQ correlation collaborative filtering first second purchase customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_viewed_in_same_session_position_score",
"label": "BQ correlation viewed in same session position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-search-product-orders_position_score",
"label": "BQ correlation collaborative filtering search product orders position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_search_btr_mid_term_position_score",
"label": "BQ correlation last bought item search btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_search_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item search disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_similar_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item similar disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_complementary_disp_orders_mid_term_position_score",
"label": "BQ correlation last bought item complementary disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_bought_item_related_disp_views_mid_term_position_score",
"label": "BQ correlation last bought item related disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_related_disp_views_mid_term_position_score",
"label": "BQ correlation context item related disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_affinities-rebuy-customer_position_score",
"label": "BQ correlation affinities rebuy customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_similar_disp_views_mid_term_position_score",
"label": "BQ correlation last viewed item similar disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_complementary_disp_orders_mid_term_position_score",
"label": "BQ correlation last viewed item complementary disp orders mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_navigation_btr_mid_term_position_score",
"label": "BQ correlation last viewed item navigation btr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-bq-python-tfidf-title_position_score",
"label": "BQ correlation textual similarity BQ python tfidf title position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-countvectorizer-bought-together_position_score",
"label": "BQ correlation textual similarity unigram countvectorizer bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-bq-tfidf-body_position_score",
"label": "BQ correlation textual similarity BQ tfidf body position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-unigram-tfidf-title_position_score",
"label": "BQ correlation textual similarity unigram tfidf title position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-tfidf-title_position_score",
"label": "BQ correlation textual similarity tfidf title position score",
"values": ["0"]
}, {
"name": "bq_correlation_bought_together_lift_position_score",
"label": "BQ correlation bought together lift position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-bought-same-customer_position_score",
"label": "BQ correlation collaborative filtering bought same customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_widget_basket_context_item_product_ctr_learnings_position_score",
"label": "BQ correlation widget basket context item product ctr learnings position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_similar_disp_views_mid_term_position_score",
"label": "BQ correlation context item similar disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_context_item_accessories_disp_views_mid_term_position_score",
"label": "BQ correlation context item accessories disp views mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_accessories_ctr_mid_term_position_score",
"label": "BQ correlation last viewed item accessories ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_last_viewed_item_navigation_ctr_mid_term_position_score",
"label": "BQ correlation last viewed item navigation ctr mid term position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-wordembeddings-bought-together_position_score",
"label": "BQ correlation textual similarity wordembeddings bought together position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-tfidf-title-backup_position_score",
"label": "BQ correlation textual similarity tfidf title backup position score",
"values": ["0"]
}, {
"name": "bq_correlation_textual-similarity-wordembeddings-title_position_score",
"label": "BQ correlation textual similarity wordembeddings title position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-customer-purchases-customer_position_score",
"label": "BQ correlation collaborative filtering customer purchases customer position score",
"values": ["0"]
}, {
"name": "bq_correlation_collaborative-filtering-bought-after_position_score",
"label": "BQ correlation collaborative filtering bought after position score",
"values": ["0"]
}],
"source_string_properties": [{
"source_property_id": null,
"source_property_name": "categories_fr_4",
"source_property_label": "category (de) 4th",
"source_property_values": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "242/Root/Puresense/FRAU/Zubehör | Schwämme", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"],
"source_property_value_labels": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "242/Root/Puresense/FRAU/Zubehör | Schwämme", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"]
}, {
"source_property_id": null,
"source_property_name": "category_leaf_de",
"source_property_label": "category leaf (de)",
"source_property_values": ["242/Root/Puresense/FRAU/Zubehör | Schwämme", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"],
"source_property_value_labels": ["242/Root/Puresense/FRAU/Zubehör | Schwämme", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"]
}, {
"source_property_id": null,
"source_property_name": "categories_de_5",
"source_property_label": "category (fr) 5th",
"source_property_values": ["1208/Root/Puresense/FRAU/Haarpflege/Zubehör", "1519/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Zubehör", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"],
"source_property_value_labels": ["1208/Root/Puresense/FRAU/Haarpflege/Zubehör", "1519/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Zubehör", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"]
}, {
"source_property_id": null,
"source_property_name": "categories_fr_3",
"source_property_label": "category (de) 3rd",
"source_property_values": ["370/Root/Puresense/HAARE"],
"source_property_value_labels": ["370/Root/Puresense/HAARE"]
}, {
"source_property_id": "1",
"source_property_name": "products_optionID_6_de",
"source_property_label": "products_optionID_6_de",
"source_property_values": ["Accessoires", "Haarpflege | Kopfhautpflege | Haarfarben"],
"source_property_value_labels": ["Accessoires", "Haarpflege | Kopfhautpflege | Haarfarben"]
}, {
"source_property_id": null,
"source_property_name": "flag",
"source_property_label": "flag",
"source_property_values": ["parameter_change_7_14"],
"source_property_value_labels": ["parameter change - 7 to 14 days"]
}, {
"source_property_id": null,
"source_property_name": "categories_de_4",
"source_property_label": "category (de) 4th",
"source_property_values": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "242/Root/Puresense/FRAU/Zubehör | Schwämme", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"],
"source_property_value_labels": ["49/Root/Puresense/FRAU/Haarpflege", "575/Root/Puresense/HAARE/Haarpflege", "242/Root/Puresense/FRAU/Zubehör | Schwämme", "872/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more"]
}, {
"source_property_id": null,
"source_property_name": "categories_fr_5",
"source_property_label": "category (fr) 5th",
"source_property_values": ["1208/Root/Puresense/FRAU/Haarpflege/Zubehör", "1206/Root/Puresense/HAARE/Haarpflege/Zubehör", "1519/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Zubehör", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"],
"source_property_value_labels": ["1208/Root/Puresense/FRAU/Haarpflege/Zubehör", "1206/Root/Puresense/HAARE/Haarpflege/Zubehör", "1519/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Zubehör", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"]
}, {
"source_property_id": null,
"source_property_name": "category_leaf_fr",
"source_property_label": "category leaf (fr)",
"source_property_values": ["242/Root/Puresense/FRAU/Zubehör | Schwämme", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"],
"source_property_value_labels": ["242/Root/Puresense/FRAU/Zubehör | Schwämme", "1520/Root/Puresense/MARKEN/khadi Pflanzenfarben \u0026 more/Shampoo | Waschpulver | Conditioner | Maske | Öle"]
}, {
"source_property_id": null,
"source_property_name": "category_leaf_id",
"source_property_label": "category leaf id",
"source_property_values": ["242", "1520"],
"source_property_value_labels": ["242", "1520"]
}, {
"source_property_id": "8",
"source_property_name": "products_immediate_delivery",
"source_property_label": "products_immediate_delivery",
"source_property_values": ["1"],
"source_property_value_labels": ["1"]
}, {
"source_property_id": null,
"source_property_name": "products_brand",
"source_property_label": "brand",
"source_property_values": ["khadi Pflanzenfarben \u0026 more"],
"source_property_value_labels": ["khadi Pflanzenfarben \u0026 more"]
}, {
"source_property_id": null,
"source_property_name": "categories_de_3",
"source_property_label": "category (de) 3rd",
"source_property_values": ["370/Root/Puresense/HAARE"],
"source_property_value_labels": ["370/Root/Puresense/HAARE"]
}, {
"source_property_id": "10",
"source_property_name": "bq_product_high_low_end",
"source_property_label": "bq product high low end",
"source_property_values": ["low-end"],
"source_property_value_labels": ["low-end"]
}, {
"source_property_id": "100",
"source_property_name": "bq_custom_bq_create_date_less_30",
"source_property_label": "BQ custom BQ create date less 30",
"source_property_values": ["0"],
"source_property_value_labels": ["0"]
}, {
"source_property_id": "100",
"source_property_name": "bq_product_high_low_end",
"source_property_label": "BQ product high low end",
"source_property_values": ["low-end"],
"source_property_value_labels": ["low-end"]
}, {
"source_property_id": "100",
"source_property_name": "bq_main_topic_listing",
"source_property_label": "BQ main topic listing",
"source_property_values": ["green", "pukka", "vegan", "MATCHA", "ginseng", "EBENHOLZ", "Ebenholz", "Grüntee", "cellulite"],
"source_property_value_labels": ["green", "pukka", "vegan", "MATCHA", "ginseng", "EBENHOLZ", "Ebenholz", "Grüntee", "cellulite"]
}],
"source_numeric_properties": [{
"source_name": "bq_product_view_overall_order_qty_products_group_id_all_time",
"source_label": "BQ product view overall order qty group id all time",
"values": ["0"]
}, {
"source_name": "bq_product_baskets_products_group_id_week_day",
"source_label": "BQ product baskets group id week day",
"values": ["0"]
}, {
"source_name": "bq_order_revenue_products_group_id_short_term",
"source_label": "BQ order revenue group id short term",
"values": ["31.2"]
}, {
"source_name": "bq_product_baskets_products_group_id_mid_term",
"source_label": "BQ product baskets group id mid term",
"values": ["0"]
}, {
"source_name": "bq_order_qty_products_group_id_long_term",
"source_label": "BQ order qty group id long term",
"values": ["107"]
}, {
"source_name": "bq_order_profit_daily",
"source_label": "BQ order profit daily",
"values": ["0.123659341"]
}, {
"source_name": "bq_widget_basket_Clicks_all_time",
"source_label": "BQ widget basket Clicks all time",
"values": ["0"]
}, {
"source_name": "bq_product_view_session_order_profit_products_group_id_all_time",
"source_label": "BQ product view session order profit group id all time",
"values": ["0"]
}, {
"source_name": "bq_std_description_length",
"source_label": "BQ standard description length",
"values": ["0"]
}, {
"source_name": "bq_order_revenue_products_group_id_long_term",
"source_label": "BQ order revenue group id long term",
"values": ["335.01"]
}, {
"source_name": "bq_product_baskets_products_group_id_all_time",
"source_label": "BQ product baskets group id all time",
"values": ["0"]
}, {
"source_name": "bq_order_last_count_long_time_all_time",
"source_label": "BQ order last count long time all time",
"values": ["86"]
}, {
"source_name": "bq_product_views_products_group_id_all_time",
"source_label": "BQ product views group id all time",
"values": ["0"]
}, {
"source_name": "bq_order_bought_with_revenue_products_group_id_all_time",
"source_label": "BQ order bought with revenue group id all time",
"values": ["405.21"]
}, {
"source_name": "bq_order_profit_week_day",
"source_label": "BQ order profit week day",
"values": ["18.6"]
}, {
"source_name": "bq_order_count_products_group_id_all_time",
"source_label": "BQ order count group id all time",
"values": ["104"]
}, {
"source_name": "bq_std_discount_percent_products_group_id",
"source_label": "BQ standard discount percent group id",
"values": ["0"]
}, {
"source_name": "bq_std_price_min_products_group_id",
"source_label": "BQ standard price min group id",
"values": ["3.9"]
}, {
"source_name": "bq_widget_basket_Displays_all_time",
"source_label": "BQ widget basket Displays all time",
"values": ["0"]
}, {
"source_name": "bq_order_count_yearly_week",
"source_label": "BQ order count yearly week",
"values": ["1"]
}, {
"source_name": "bq_order_last_count_short_time_all_time",
"source_label": "BQ order last count short time all time",
"values": ["101"]
}, {
"source_name": "bq_order_profit_season_year",
"source_label": "BQ order profit season year",
"values": ["10.85"]
}, {
"source_name": "bq_order_qty_products_group_id_season_year",
"source_label": "BQ order qty group id season year",
"values": ["4"]
}, {
"source_name": "bq_order_qty_products_group_id_mid_term",
"source_label": "BQ order qty group id mid term",
"values": ["10"]
}, {
"source_name": "bq_order_count_products_group_id_season_year",
"source_label": "BQ order count group id season year",
"values": ["3"]
}, {
"source_name": "bq_order_profit_long_term",
"source_label": "BQ order profit long term",
"values": ["133.145"]
}, {
"source_name": "bq_product_baskets_products_group_id_long_term",
"source_label": "BQ product baskets group id long term",
"values": ["0"]
}, {
"source_name": "bq_order_revenue_products_group_id_daily",
"source_label": "BQ order revenue group id daily",
"values": ["0.296857143"]
}, {
"source_name": "bq_top_category_rank_score_products_group_id",
"source_label": "BQ top category rank score group id",
"values": ["0"]
}, {
"source_name": "bq_order_bought_with_profit_all_time",
"source_label": "BQ order bought with profit all time",
"values": ["168.795"]
}, {
"source_name": "bq_order_qty_products_group_id_all_time",
"source_label": "BQ order qty group id all time",
"values": ["127"]
}, {
"source_name": "bq_std_price_max_products_group_id",
"source_label": "BQ standard price max group id",
"values": ["3.9"]
}, {
"source_name": "bq_order_count_products_group_id_short_term",
"source_label": "BQ order count group id short term",
"values": ["8"]
}, {
"source_name": "bq_order_repeated_count_all_time",
"source_label": "BQ order repeated count all time",
"values": ["109"]
}, {
"source_name": "bq_order_profit_short_term",
"source_label": "BQ order profit short term",
"values": ["12.4"]
}, {
"source_name": "bq_std_discount_percent",
"source_label": "BQ standard discount percent",
"values": ["0"]
}, {
"source_name": "bq_product_view_overall_order_revenue_products_group_id_all_time",
"source_label": "BQ product view overall order revenue group id all time",
"values": ["0"]
}, {
"source_name": "bq_product_view_session_order_revenue_products_group_id_all_time",
"source_label": "BQ product view session order revenue group id all time",
"values": ["0"]
}, {
"source_name": "bq_order_count_products_group_id_week_day",
"source_label": "BQ order count group id week day",
"values": ["12"]
}, {
"source_name": "bq_order_profit_all_time",
"source_label": "BQ order profit all time",
"values": ["168.795"]
}, {
"source_name": "bq_product_view_session_order_count_products_group_id_all_time",
"source_label": "BQ product view session order count group id all time",
"values": ["0"]
}, {
"source_name": "bq_widget_basket_Click-UPs_all_time",
"source_label": "BQ widget basket Click UPs all time",
"values": ["0"]
}, {
"source_name": "bq_std_repurchase_count",
"source_label": "BQ standard repurchase count",
"values": ["0"]
}, {
"source_name": "bq_order_first_count_all_time",
"source_label": "BQ order first count all time",
"values": ["109"]
}, {
"source_name": "bq_std_list_price_min_products_group_id",
"source_label": "BQ standard list price min group id",
"values": ["3.9"]
}, {
"source_name": "bq_order_last_count_medium_time_all_time",
"source_label": "BQ order last count medium time all time",
"values": ["98"]
}, {
"source_name": "bq_product_baskets_products_group_id_season_year",
"source_label": "BQ product baskets group id season year",
"values": ["0"]
}, {
"source_name": "bq_std_margin_percent_products_group_id",
"source_label": "BQ standard margin percent group id",
"values": ["0"]
}, {
"source_name": "bq_widget_basket_U-Click-UPs_all_time",
"source_label": "BQ widget basket U Click UPs all time",
"values": ["0"]
}, {
"source_name": "bq_order_qty_products_group_id_week_day",
"source_label": "BQ order qty group id week day",
"values": ["13"]
}, {
"source_name": "bq_widget_basket_btr_level_all_time",
"source_label": "BQ widget basket btr level all time",
"values": ["0"]
}, {
"source_name": "bq_product_views_products_group_id_long_term",
"source_label": "BQ product views group id long term",
"values": ["0"]
}, {
"source_name": "bq_product_views_products_group_id_week_day",
"source_label": "BQ product views group id week day",
"values": ["0"]
}, {
"source_name": "bq_product_view_overall_order_count_products_group_id_all_time",
"source_label": "BQ product view overall order count group id all time",
"values": ["0"]
}, {
"source_name": "bq_std_discount_amount_products_group_id",
"source_label": "BQ standard discount amount group id",
"values": ["0"]
}, {
"source_name": "bq_order_revenue_products_group_id_mid_term",
"source_label": "BQ order revenue group id mid term",
"values": ["39"]
}, {
"source_name": "bq_product_view_session_order_products_products_group_id_all_time",
"source_label": "BQ product view session order group id all time",
"values": ["0"]
}, {
"source_name": "bq_product_view_overall_order_profit_products_group_id_all_time",
"source_label": "BQ product view overall order profit group id all time",
"values": ["0"]
}, {
"source_name": "bq_order_qty_products_group_id_daily",
"source_label": "BQ order qty group id daily",
"values": ["0.093040293"]
}, {
"source_name": "bq_widget_basket_U-Clicks_all_time",
"source_label": "BQ widget basket U Clicks all time",
"values": ["0"]
}, {
"source_name": "bq_order_qty_products_group_id_short_term",
"source_label": "BQ order qty group id short term",
"values": ["10"]
}, {
"source_name": "bq_order_revenue_products_group_id_all_time",
"source_label": "BQ order revenue group id all time",
"values": ["405.21"]
}, {
"source_name": "bq_std_repurchase_category_count",
"source_label": "BQ standard repurchase category count",
"values": ["0"]
}, {
"source_name": "bq_product_views_products_group_id_mid_term",
"source_label": "BQ product views group id mid term",
"values": ["0"]
}, {
"source_name": "bq_product_view_session_order_qty_products_group_id_all_time",
"source_label": "BQ product view session order qty group id all time",
"values": ["0"]
}, {
"source_name": "bq_order_profit_mid_term",
"source_label": "BQ order profit mid term",
"values": ["23.25"]
}, {
"source_name": "bq_widget_basket_U-Displays_all_time",
"source_label": "BQ widget basket U Displays all time",
"values": ["0"]
}, {
"source_name": "bq_product_views_products_group_id_short_term",
"source_label": "BQ product views group id short term",
"values": ["0"]
}, {
"source_name": "bq_order_count_products_group_id_mid_term",
"source_label": "BQ order count group id mid term",
"values": ["10"]
}, {
"source_name": "bq_std_margin_amount_products_group_id",
"source_label": "BQ standard margin amount group id",
"values": ["0"]
}, {
"source_name": "bq_order_count_products_group_id_daily",
"source_label": "BQ order count group id daily",
"values": ["0.076190476"]
}, {
"source_name": "bq_product_baskets_products_group_id_short_term",
"source_label": "BQ product baskets group id short term",
"values": ["0"]
}, {
"source_name": "bq_order_new_1_month_count_all_time",
"source_label": "BQ order new 1 month count all time",
"values": ["4"]
}, {
"source_name": "bq_order_revenue_products_group_id_week_day",
"source_label": "BQ order revenue group id week day",
"values": ["46.8"]
}, {
"source_name": "bq_product_views_products_group_id_season_year",
"source_label": "BQ product views group id season year",
"values": ["0"]
}, {
"source_name": "bq_widget_basket_ctr_level_all_time",
"source_label": "BQ widget basket ctr level all time",
"values": ["0"]
}, {
"source_name": "bq_order_revenue_products_group_id_season_year",
"source_label": "BQ order revenue group id season year",
"values": ["11.7"]
}, {
"source_name": "bq_order_count_products_group_id_long_term",
"source_label": "BQ order count group id long term",
"values": ["86"]
}]
}
First attempts
We did the first attempt for the case of accessories recommendations (cross-selling on the PDP) as follows:
CREATE OR REPLACE TABLE `@reports.Data_AccessoriesPrediction_logistic_reg_v1_11M` as SELECT sum(KPI_defined.mainImpressions) as mainImpressions , sum(KPI_defined.clicks) as clicks , sum(KPI_defined.clicks) / sum(KPI_defined.mainImpressions) as ctr , case when source_exact_price > 0 and abs(exact_price / source_exact_price) between 0.8 and 1.2 then 1 else 0 end as same_price_20 , case when source_exact_price > 0 and abs(exact_price / source_exact_price) between 0.9 and 1.1 then 1 else 0 end as same_price_10 , case when source_exact_price > 0 and abs(exact_price / source_exact_price) between 0.7 and 1.3 then 1 else 0 end as same_price_30 , case when ifnull((select property_values[safe_offset(0)] from unnest(product_properties) where property_name = 'category_leaf_de' limit 1),'-') in unnest((select ifnull(source_property_values, []) from unnest(source_product_properties) where source_property_name = 'category_leaf_de' limit 1)) then 1 else 0 end as same_leaf_category , case when ifnull((select property_values[safe_offset(0)] from unnest(product_properties) where property_name = 'products_brand' limit 1),'-') in unnest((select ifnull(source_property_values, []) from unnest(source_product_properties) where source_property_name = 'products_brand' limit 1)) then 1 else 0 end as same_brand , case when ifnull((select property_values[safe_offset(0)] from unnest(product_properties) where property_label = 'Produktlinie' limit 1),'-') in unnest((select ifnull(source_property_values, []) from unnest(source_product_properties) where source_property_label = 'Produktlinie' limit 1)) then 1 else 0 end as same_product_line FROM `@reports.widget_context_item_product_analytics` WHERE date(day) >= date_sub(current_date(), interval 6 month) and widget = 'accessories' group by same_brand, same_leaf_category, same_price_10, same_price_20, same_price_30, same_product_line ; CREATE OR REPLACE MODEL `@reports.Model_AccessoriesPrediction_logistic_reg_v1_11M` OPTIONS( model_type='logistic_reg' , CATEGORY_ENCODING_METHOD = 'DUMMY_ENCODING' , CALCULATE_P_VALUES = TRUE, ENABLE_GLOBAL_EXPLAIN = TRUE ) AS SELECT (IF(clicks >= it,1,0)) AS label , same_price_10 , same_price_20 , same_price_30 , same_leaf_category , same_brand , same_product_line FROM `@reports.Data_AccessoriesPrediction_logistic_reg_v1_11M` join unnest(GENERATE_ARRAY(1,mainImpressions)) as it ;
As a result, the predictive power only based on these few similar parameters is quite low (as it was expected), but could grow with more parameters.
Also, the Explainable AI tab shows possible usage of the model as factor analysis, showing here that the attribution is highest on the same product line and brand and only after the category and price.
- No labels
Add Comment