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