View: Product Detail Page (OLD VERSION)

This article will help you learn about the fields available in the Product Detail Page view, the field types, descriptions and how the fields are calculated

 

THIS EXPLORE IS NO LONGER BEING USED AS OF 3/27/23 - Please see View: Product Page for the NEW Explore.

 

Key Topics

Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

  • View Definition
  • Explores
  • Extractor

View Definition

This view is linked to the [ga.base_pdp_performance] table which generated as part of our Google Analytics integration and has the following fields available/visible for use.

 

Field Name Field Type Description Source / Calculation
Visit Date Dimension Group Date of Visit from Google Analytics created_on
Product Adds to Cart Dimension Number of Times Product was Added to Cart product_adds_to_cart
Product Checkout Dimension Number of Times Product was in Checkout product_checkouts
Product Detail Views Dimension Number of Times Product Detail Page (PDP) was viewed product_detail_views
Product Name Dimension Name of the Product sent to Google Analytics product_name
Product Sales Dimension Sales attributed to Product from Google Analytics product_sales
Product SKU Dimension Name of the SKU sent to Google Analytics product_sku
View ID Dimension View ID in Google Analytics that is used to extract the data view_id
Average Sales per Page ($) Measure Product Sales ($) / Product Detail (PDP) Views COALESCE(SUM(product_sales), 0) * 1.0 / NULLIF(COALESCE(SUM(product_detail_views), 0), 0)
Page Add Rate Measure Product Adds to Cart / Product Detail (PDP) Views COALESCE(SUM(product_add_to_cart), 0) * 1.0 / NULLIF(COALESCE(SUM(product_detail_views), 0), 0)
Page Conversion Measure Product Checkouts / Product Detail (PDP) Views COALESCE(SUM(product_checkouts), 0) * 1.0 / NULLIF(COALESCE(SUM(product_detail_views), 0), 0)
Total Adds to Cart Measure Total number of times the products were added to the cart COALESCE(SUM(product_add_to_cart), 0)
Total Conversions Measure Total number of products that were purchased COALESCE(SUM(product_checkouts), 0)
Total Product Detail Views (PDP) Measure Total number of times the Product Detail Page (PDP) was viewed COALESCE(SUM(product_detail_views), 0)
Total Product Sales Measure Total Product Sales COALESCE(SUM(product_sales), 0)

Explores

This view is part of the following explores:

  • GA PDP Performance

Extractor

This view is a table generated by the following Daasity Integration:

  • Google Analytics