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