--- title: "View: GA Shopping Stage" description: 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 --- [Back to home](https://support.daasity.com/migrated/knowledge) - [ Welcome to Daasity ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources) - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central) - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app) - [ Daasity Platform | Business User Analytics ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd) - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards) - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports) - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores) - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views) - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences) - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations) - [ ELT+ | Technical User Documentation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform) - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation) - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations) - [ User Manual and Support ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices) - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics) - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics) - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics) - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics) - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates) # 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](https://support.daasity.com/knowledge/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