View: GA Shopping Stage

This article will help you learn about the fields available in the GA Shopping Stage view, the field types, descriptions and how the fields are calculated

 

This View is NO LONGER IN USE AS OF 3/27/23. Please see View: Shopping Stage 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_shopping_stage] 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
Modified Last Click Channel Dimension Modified Last Click Google Analytics Channel Based on Your Custom Logic from the Channel Mapping BSD channel
Vendor Dimension Vendor as entered in Channel Mapping BSD vendor
Device Type Dimension Desktop, tablet or mobile from Google Analytics device_category
GA Last Click Channel Dimension Last Click Channel (Channel) directly from Google Analytics channel_grouping
Shopping Stage Dimension Filtered and Sorted Shopping Stage from GA to view the site funnel CASE WHEN shopping_stage = 'ALL_VISITS' THEN '1 - ALL_VISITS'
WHEN shopping_stage = 'PRODUCT_VIEW' THEN '2 - PRODUCT_VIEW'
WHEN shopping_stage = 'ADD_TO_CART' THEN '3 - ADD_TO_CART'
WHEN shopping_stage = 'CHECKOUT' THEN '4 - CHECKOUT'
WHEN shopping_stage = 'TRANSACTION' THEN '5 - TRANSACTION'
ELSE NULL END
Shopping Stage (RAW) Dimension The GA defined stage of the shopping stage that a user completed shopping_stage
User Type Dimension User Type (New or Returning) from Google Analytics user_type
UTM Campaign Dimension Campaign from Google Analytics campaign
UTM Medium Dimension Medium from Google Analytics medium
UTM Source Dimension Source from Google Analytics source
View ID Dimension View ID in Google Analytics that is used to extract the data view_id
Average Pageviews Measure Total Pageviews / Total Sessions COALESCE(SUM(pageviews), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
Average Time on Site (Seconds) Measure Total Session Time/Total Visits COALESCE(SUM(session_duration), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
Bounce Rate (%) Measure Total Bounces / Total Sessions COALESCE(SUM(bounces), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
GA Conversion Rate (%) Measure Total GA Orders / Total Sessions COALESCE(SUM(transactions), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
Mobile Sessions (%) Measure Mobile Sessions / Total Sessions COALESCE(SUM(CASE WHEN (device_category IN ('mobile', 'tablet')) THEN sessions ELSE NULL END), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
New User Sessions (%) Measure New User Sessions / Total Sessions COALESCE(SUM(CASE WHEN (user_type = 'New Visitor') THEN sessions ELSE NULL END), 0) * 1.0 / NULLIF(COALESCE(SUM(sessions), 0), 0)
Total Bounces Measure Total Bounces (ga:bounces) COALESCE(SUM(bounces), 0)
Total GA Orders Measure Total GA Orders as captured by pixel (will not match eCommerce actuals) COALESCE(SUM(transactions), 0)
Total Mobile Sessions Measure Sessions from Mobile or Tablet Devices COALESCE(SUM(CASE WHEN (device_category IN ('mobile', 'tablet')) THEN sessions ELSE NULL END), 0)
Total New User Sessions Measure Sessions from New Users COALESCE(SUM(CASE WHEN (user_type = 'New Visitor') THEN sessions ELSE NULL END), 0)
Total Pageviews Measure Total Pageviews (ga:pageviews) COALESCE(SUM(pageviews), 0)
Total Sessions Measure Total Sessions (ga:session) COALESCE(SUM(sessions), 0)
Total Time on Site Measure Total Time on Site (ga:sessionDuration) COALESCE(SUM(session_duration), 0)

Explores

This view is part of the following explores:

  • GA Shopping Stage

Extractor

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

  • Google Analytics