Skip to end of banner
Go to start of banner

BigQuery ML Opportunities

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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 there

    • page_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 empty

  • Number of page views
    in the data: array_length of next_pages

  • session 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 items

  • session $ value (average value per session)
    in the data: next_purchases.ecommerce.purchase_revenue and session_id

  • AOV (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)"
}

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.mainImpression

  • Add-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"]
  }]
}
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.