+
Stream your marketing data from GA4 to Snowflake
About GA4
About SnowFlake
Connect GA4 to Snowflake in 2023
It is very simple to connect GA4 to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select GA4 as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3.Enter all the credentials required and click Save
4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.
GA4 metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Account ID | TEXT | The Account ID |
| Account Name | TEXT | The Account Name |
| Achievement ID | TEXT | The achievement ID in a game for an event. Populated by the event parameter 'achievement_id'. |
| 1-day active users | NUMERIC | The number of distinct active users on your site or app within a 1 day period. The 1 day period includes the last day in the report's date range. Note: this is the same as Active Users. |
| 28-day active users | NUMERIC | The number of distinct active users on your site or app within a 28 day period. The 28 day period includes the last day in the report's date range. |
| 7-day active users | NUMERIC | The number of distinct active users on your site or app within a 7 day period. The 7 day period includes the last day in the report's date range. |
| Active users | NUMERIC | The number of distinct users who visited your site or app. |
| Ad format | TEXT | Describes the way ads looked and where they were located. Typical formats include 'Interstitial', 'Banner', 'Rewarded', and 'Native advanced'. |
| Ad source | TEXT | The source network that served the ad. Typical sources include 'AdMob Network', 'Liftoff', 'Facebook Audience Network', and 'Mediated house ads'. |
| Ad unit exposure | NUMERIC | The time that an ad unit was exposed to a user, in milliseconds. |
| Ad unit | TEXT | The name you chose to describe this Ad unit. Ad units are containers you place in your apps to show ads to users. |
| Add to carts | NUMERIC | The number of times users added items to their shopping carts. |
| Ads clicks | NUMERIC | Total number of times users have clicked on an ad to reach the property. Includes clicks from linked integrations like linked Search Ads 360 advertisers. Also includes uploaded clicks from data import. |
| Ads cost | NUMERIC | The total amount you paid for your ads. Includes costs from linked integrations like linked Google Ads accounts. Also includes uploaded cost from data import; to learn more, see [Import cost data](https://support.google.com/analytics/answer/10071305). |
| Ads cost per click | NUMERIC | Ads cost per click is ad cost divided by ad clicks and is often abbreviated CPC. |
| Ads impressions | NUMERIC | The total number of impressions. Includes impressions from linked integrations like linked Display & Video 360 advertisers. Also includes uploaded impressions from data import. |
| Age | TEXT | User age brackets. |
| App version | TEXT | The app's versionName (Android) or short bundle version (iOS). |
| Audience id | TEXT | The numeric identifier of an Audience. Users are reported in the audiences to which they belonged during the report's date range. Current user behavior does not affect historical audience membership in reports. |
| Audience name | TEXT | The given name of an Audience. Users are reported in the audiences to which they belonged during the report's date range. Current user behavior does not affect historical audience membership in reports. |
| Average purchase revenue | NUMERIC | The average purchase revenue in the transaction group of events. |
| ARPPU | NUMERIC | Average revenue per paying user (ARPPU) is the total purchase revenue per active user that logged a purchase event. The summary metric is for the time period selected. |
| Average purchase revenue per user | NUMERIC | The average purchase revenue per active user is the total purchase revenue per active user that logged any event. The summary metric is for the time period selected. |
| ARPU | NUMERIC | Average revenue per active user (ARPU). The summary metric is for the time period selected. ARPU uses Total Revenue and includes AdMob estimated earnings. |
| Average session duration | NUMERIC | The average duration (in seconds) of users' sessions. |
| Bounce rate | NUMERIC | The percentage of sessions that were not engaged ((Sessions Minus Engaged sessions) divided by Sessions). This metric is returned as a fraction; for example, 0.2761 means 27.61% of sessions were bounces. |
| Interests | TEXT | Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories. For example, 'Shoppers', 'Lifestyles & Hobbies/Pet Lovers', or 'Travel/Travel Buffs/Beachbound Travelers'. |
| Browser | TEXT | The browsers used to view your website. |
| Campaign (alias for Campaign name) | TEXT | The name of the marketing campaign. Present only for conversion events. |
| Campaign ID | TEXT | The identifier of the marketing campaign. Present only for conversion events. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
| Campaign name | TEXT | The name of the marketing campaign. Present only for conversion events. |
| Cart-to-view rate | NUMERIC | The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s). This metric is returned as a fraction; for example, 0.1132 means 11.32% of users who viewed a product also added the same product to their cart. |
| Character | TEXT | The player character in a game for an event. Populated by the event parameter 'character'. |
| Checkouts | NUMERIC | The number of times users started the checkout process. This metric counts the occurrence of the 'begin_checkout' event. |
| City | TEXT | The city from which the user activity originated. |
| City ID | TEXT | The geographic ID of the city from which the user activity originated, derived from their IP address. |
| Cohort | TEXT | The cohort's name in the request. A cohort is a set of users who started using your website or app in any consecutive group of days. If a cohort name is not specified in the request, cohorts are named by their zero based index: cohort_0, cohort_1, etc. |
| Cohort active users | NUMERIC | The number of users in the cohort who are active in the time window corresponding to the cohort nth day/week/month. For example for the row where cohortNthWeek = 0001, this metric is the number of users (in the cohort) who are active in week 1. |
| Daily cohort | TEXT | Day offset relative to the firstSessionDate for the users in the cohort. For example, if a cohort is selected with the start and end date of 2020-03-01, then for the date 2020-03-02, cohortNthDay will be 0001. |
| Monthly cohort | TEXT | Month offset relative to the firstSessionDate for the users in the cohort. Month boundaries align with calendar month boundaries. For example, if a cohort is selected with the start and end date in March 2020, then for any date in April 2020, cohortNthMonth will be 0001. |
| Weekly cohort | TEXT | Week offset relative to the firstSessionDate for the users in the cohort. Weeks start on Sunday and end on Saturday. For example, if a cohort is selected with the start and end date in the range 2020-11-08 to 2020-11-14, then for the dates in the range 2020-11-15 to 2020-11-21, cohortNthWeek will be 0001. |
| Cohort total users | NUMERIC | The total number of users in the cohort. This metric is the same value in every row of the report for each cohort. Because cohorts are defined by a shared acquisition date, cohortTotalUsers is the same as cohortActiveUsers for the cohort's selection date range. For report rows later than the ochort's selection range, it is typical for cohortActiveUsers to be smaller than cohortTotalUsers. This difference represents users from the cohort that were not active for the later date. cohortTotalUsers is commonly used in the metric expression cohortActiveUsers/cohortTotalUsers to compute a user retention fraction for the cohort. The relationship between activeUsers and totalUsers is not equivalent to the relationship between cohortActiveUsers and cohortTotalUsers. |
| Content group | TEXT | A category that applies to items of published content. Populated by the event parameter 'content_group'. |
| Content ID | TEXT | The identifier of the selected content. Populated by the event parameter 'content_id'. |
| Content type | TEXT | The category of the selected content. Populated by the event parameter 'content_type'. |
| Continent | TEXT | The continent from which the user activity originated. For example, 'Americas' or 'Asia'. |
| Continent ID | TEXT | The geographic ID of the continent from which the user activity originated, derived from their IP address. |
| Conversions | NUMERIC | The count of conversion events. Events are marked as conversions at collection time; changes to an event's conversion marking apply going forward. You can mark any event as a conversion in Google Analytics, and some events (i.e. first_open, purchase) are marked as conversions by default. To learn more, see |
| Cost per conversion | NUMERIC | Cost per conversion is ad cost divided by conversions. |
| Country | COUNTRY | The country from which the user activity originated. |
| Country ID | TEXT | The geographic ID of the country from which the user activity originated, derived from their IP address. Formatted according to ISO 3166-1 alpha-2 standard. |
| Crash-affected users | NUMERIC | The number of users that logged a crash in this row of the report. For example if the report is time series by date, this metrics reports total users with at least one crash on this date. Crashes are events with the name "app_exception". |
| Crash-free users rate | NUMERIC | The number of users without crash events (in this row of the report) divided by the total number of users. This metric is returned as a fraction; for example, 0.9243 means 92.43% of users were crash-free. |
| Date | DATE | The date of the event, formatted as YYYYMMDD. |
| Date + hour (YYYYMMDDHH) | TEXT | The combined values of date and hour formatted as YYYYMMDDHH. |
| Date hour and minute | TEXT | The combined values of date, hour, and minute formatted as YYYYMMDDHHMM. |
| DAU / MAU | NUMERIC | The rolling percent of 30-day active users who are also 1-day active users. This metric is returned as a fraction; for example, 0.113 means 11.3% of 30-day active users were also 1-day active users. |
| DAU / WAU | NUMERIC | The rolling percent of 7-day active users who are also 1-day active users. This metric is returned as a fraction; for example, 0.082 means 8.2% of 7-day active users were also 1-day active users. |
| Day | TEXT | The day of the month, a two-digit number from 01 to 31. |
| Day of week | TEXT | The day of the week. It returns values in the range [0,6] with Sunday as the first day of the week. |
| Default channel group | TEXT | The conversion's default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
| Device | TEXT | The branded device name (examples are Galaxy S10 or P30 Pro). |
| Device model | TEXT | The mobile device model (example: iPhone 10,6). |
| Device category | TEXT | The type of device - Desktop, Tablet, or Mobile. |
| Ecommerce purchases | NUMERIC | The number of times users completed a purchase. This metric counts 'purchase' events; this metric does not count 'in_app_purchase' and subscription events. |
| Engaged sessions | NUMERIC | The number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views. |
| Engagement rate | PERCENT | The percentage of engaged sessions (Engaged sessions divided by Sessions). This metric is returned as a fraction; for example, 0.7239 means 72.39% of sessions were engaged sessions. |
| Event count | NUMERIC | The count of events. |
| Event count per user | NUMERIC | The average number of events per user (Event count divided by Active users). |
| Event name | TEXT | The name of the event. |
| Event value | NUMERIC | The sum of the event parameter named 'value'. |
| Events per session | NUMERIC | The average number of events per session (Event count divided by Sessions). |
| File extension | TEXT | The extension of the downloaded file (for example, 'pdf' or 'txt'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'file_extension'. |
| File name | TEXT | The page path of the downloaded file (for example, '/menus/dinner-menu.pdf'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'file_name'. |
| First session date | TEXT | The date the user's first session occurred, formatted as YYYYMMDD. |
| First-time purchaser conversion | NUMERIC | The percentage of active users who made their first purchase. This metric is returned as a fraction; for example, 0.092 means 9.2% of active users were first time purchasers. |
| First time purchasers | NUMERIC | The number of users that completed their first purchase event. |
| First-time purchasers per new user | NUMERIC | The average number of first time purchasers per new user. |
| First user campaign ID | TEXT | Identifier of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
| First user campaign | TEXT | Name of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
| First user default channel group | TEXT | The default channel group that first acquired the user. Default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
| First user Google Ads account name | TEXT | The Account name from Google Ads that first acquired the user. |
| First user Google Ads ad group ID | TEXT | The Ad Group Id in Google Ads that first acquired the user. |
| First user Google Ads ad group name | TEXT | The Ad Group Name in Google Ads that first acquired the user. |
| First user Google Ads ad network type | TEXT | The advertising network that first acquired the user. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
| First user Google Ads campaign ID | TEXT | Identifier of the Google Ads marketing campaign that first acquired the user. |
| First user Google Ads campaign | TEXT | Name of the Google Ads marketing campaign that first acquired the user. |
| First user Google Ads campaign type | TEXT | The campaign type of the Google Ads campaign that first acquired the user. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see |
| First user Google Ads creative ID | TEXT | The ID of the Google Ads creative that first acquired the user. Creative IDs identify individual ads. |
| First user Google Ads customer ID | TEXT | The Customer ID from Google Ads that first acquired the user. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
| First user Google Ads keyword text | TEXT | The matched keyword that first acquired the user. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see |
| First user Google Ads query | TEXT | The search query that first acquired the user. |
| First user manual ad content | TEXT | The ad content that first acquired the user. Populated by the utm_content parameter. |
| First user manual term | TEXT | The term that first acquired the user. Populated by the utm_term parameter. |
| First user medium | TEXT | The medium that first acquired the user to your website or app. |
| First user source | TEXT | The source that first acquired the user to your website or app. |
| First user source / medium | TEXT | The combined values of the dimensions 'firstUserSource' and 'firstUserMedium'. |
| First user source platform | TEXT | The source platform that first acquired the user. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
| Full page URL | TEXT | The hostname, page path, and query string for web pages visited; for example, the fullPageUrl portion of https://www.example.com/store/contact-us?query_string=true is www.example.com/store/contact-us?query_string=true. |
| Gender | TEXT | User gender. |
| Google Ads account name | TEXT | The Account name from Google Ads for the campaign that led to the conversion event. Corresponds to customer.descriptive_name in the Google Ads API. |
| Google Ads ad group ID | TEXT | The ad group id attributed to the conversion event. |
| Google Ads ad group name | TEXT | The ad group name attributed to the conversion event. |
| Google Ads ad network type | TEXT | The advertising network type of the conversion. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
| Google Ads campaign ID | TEXT | The campaign ID for the Google Ads campaign attributed to the conversion event. |
| Google Ads campaign | TEXT | The campaign name for the Google Ads campaign attributed to the conversion event. |
| Google Ads campaign type | TEXT | The campaign type for the Google Ads campaign attributed to the conversion event. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see |
| Google Ads creative ID | TEXT | The ID of the Google Ads creative attributed to the conversion event. Creative IDs identify individual ads. |
| Google Ads customer ID | TEXT | The Customer ID from Google Ads for the campaign that led to conversion event. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
| Google Ads keyword text | TEXT | The matched keyword that led to the conversion event. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see |
| Google Ads query | TEXT | The search query that led to the conversion event. |
| Group ID | TEXT | The player group ID in a game for an event. Populated by the event parameter 'group_id'. |
| Hostname | TEXT | Includes the subdomain and domain names of a URL; for example, the Host Name of www.example.com/contact.html is www.example.com. |
| Hour | TEXT | The two-digit hour of the day that the event was logged. This dimension ranges from 0-23 and is reported in your property's timezone. |
| Is conversion event | TEXT | The string 'true' if the event is a conversion. Events are marked as conversions at collection time; changes to an event's conversion marking apply going forward. You can mark any event as a conversion in Google Analytics, and some events (i.e. first_open, purchase) are marked as conversions by default. To learn more, see |
| Item affiliation | TEXT | The name or code of the affiliate (partner/vendor; if any) associated with an individual item. Populated by the 'affiliation' item parameter. |
| Item brand | TEXT | Brand name of the item. |
| Item category | TEXT | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category. |
| Item category 2 | TEXT | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category 2. |
| Item category 3 | TEXT | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Summer is the item category 3. |
| Item category 4 | TEXT | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Shirts is the item category 4. |
| Item category 5 | TEXT | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category 5. |
| Item ID | TEXT | The ID of the item. |
| Item-list click events | NUMERIC | The number of times users clicked an item when it appeared in a list. This metric counts the occurrence of the 'select_item' event. |
| Item list click through rate | NUMERIC | The number of users who selected a list(s) divided by the number of users who viewed the same list(s). This metric is returned as a fraction; for example, 0.2145 means 21.45% of users who viewed a list also selected the same list. |
| Item list ID | TEXT | The ID of the item list. |
| Item list name | TEXT | The name of the item list. |
| Item-list view events | NUMERIC | The number of times the item list was viewed. This metric counts the occurrence of the 'view_item_list' event. |
| Item name | TEXT | The name of the item. |
| Item promotion click through rate | NUMERIC | The number of users who selected a promotion(s) divided by the number of users who viewed the same promotion(s). This metric is returned as a fraction; for example, 0.1382 means 13.82% of users who viewed a promotion also selected the promotion. |
| Item promotion creative name | TEXT | The name of the item-promotion creative. |
| Item promotion ID | TEXT | The ID of the item promotion. |
| Item promotion name | TEXT | The name of the promotion for the item. |
| Item revenue | NUMERIC | The total revenue from items only. Item revenue is the product of its price and quantity. Item revenue excludes tax and shipping values; tax & shipping values are specified at the event and not item level. |
| Item variant | TEXT | The specific variation of a product. e.g., XS, S, M, L for size; or Red, Blue, Green, Black for color. Populated by the 'item_variant' parameter. |
| Item view events | NUMERIC | The number of times the item details were viewed. The metric counts the occurrence of the 'view_item' event. |
| Items added to cart | NUMERIC | The number of units added to cart for a single item. This metric counts the quantity of items in 'add_to_cart' events. |
| Items checked out | NUMERIC | The number of units checked out for a single item. This metric counts the quantity of items in 'begin_checkout' events. |
| Items clicked in list | NUMERIC | The number of units clicked in list for a single item. This metric counts the quantity of items in 'select_item' events. |
| Items clicked in promotion | NUMERIC | The number of units clicked in promotion for a single item. This metric counts the quantity of items in 'select_promotion' events. |
| Items purchased | NUMERIC | The number of units for a single item included in purchase events. This metric counts the quantity of items in purchase events. |
| Items viewed | NUMERIC | The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events. |
| Items viewed in list | NUMERIC | The number of units viewed in list for a single item. This metric counts the quantity of items in 'view_item_list' events. |
| Items viewed in promotion | NUMERIC | The number of units viewed in promotion for a single item. This metric counts the quantity of items in 'view_promotion' events. |
| Landing page + query string | TEXT | The page path + query string associated with the first pageview in a session. |
| Language | TEXT | The language setting of the user's browser or device. e.g. English |
| Language code | TEXT | The language setting (ISO 639) of the user's browser or device. e.g. 'en-us' |
| Level | TEXT | The player's level in a game. Populated by the event parameter 'level'. |
| Link classes | TEXT | The HTML class attribute for an outbound link. For example if a user clicks a link '', this dimension will return 'center'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_classes'. |
| Link domain | TEXT | The destination domain of the outbound link. For example if a user clicks a link '', this dimension will return 'youtube.com'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_domain'. |
| Link ID | TEXT | The HTML id attribute for an outbound link or file download. For example if a user clicks a link '', this dimension will return 'socialLinks'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_id'. |
| Link text | TEXT | The link text of the file download. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_text'. |
| Link URL | TEXT | The full url for an outbound link or file download. For example if a user clicks a link '', this dimension will return 'https://www.youtube.com/results?search_query=analytics'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_url'. |
| Manual ad content | TEXT | The ad content attributed to the conversion event. Populated by the utm_content parameter. |
| Manual term | TEXT | The term attributed to the conversion event. Populated by the utm_term parameter. |
| Medium | TEXT | The medium attributed to the conversion event. |
| Method | TEXT | The method by which an event was triggered. Populated by the event parameter 'method'. |
| Minute | TEXT | The two-digit minute of the hour that the event was logged. This dimension ranges from 0-59 and is reported in your property's timezone. |
| Device brand | TEXT | Manufacturer or branded name (examples: Samsung, HTC, Verizon, T-Mobile). |
| Mobile model | TEXT | The mobile device model name (examples: iPhone X or SM-G950F). |
| Month | TEXT | The month of the event, a two digit integer from 01 to 12. |
| New / returning | TEXT | New users have 0 previous sessions, and returning users have 1 or more previous sessions. This dimension returns two values: 'new' or 'returning'. |
| New users | NUMERIC | The web page titles used on your site. |
| Nth day | TEXT | The number of days since the start of the date range. |
| Nth hour | TEXT | The number of hours since the start of the date range. The starting hour is 0000. |
| Nth minute | TEXT | The number of minutes since the start of the date range. The starting minute is 0000. |
| Nth month | TEXT | The number of months since the start of a date range. The starting month is 0000. |
| Nth week | TEXT | A number representing the number of weeks since the start of a date range. |
| Nth year | TEXT | The number of years since the start of the date range. The starting year is 0000. |
| Operating system | TEXT | The operating systems used by visitors to your app or website. Includes desktop and mobile operating systems such as Windows and Android. |
| OS version | TEXT | The operating system versions used by visitors to your website or app. For example, Android 10's version is 10, and iOS 13.5.1's version is 13.5.1. |
| Operating system with version | TEXT | The operating system and version. For example, Android 10 or Windows 7. |
| Order coupon | TEXT | Code for the order-level coupon. |
| Organic google search average position | NUMERIC | The average ranking of your website URLs for the query reported from Search Console. For example, if your site's URL appears at position 3 for one query and position 7 for another query, the average position would be 5 (3+7/2). This metric requires an active Search Console link. |
| Organic google search click through rate | NUMERIC | The organic Google Search click through rate reported from Search Console. Click through rate is clicks per impression. This metric is returned as a fraction; for example, 0.0588 means about 5.88% of impressions resulted in a click. This metric requires an active Search Console link. |
| Organic google search clicks | NUMERIC | The number of organic Google Search clicks reported from Search Console. This metric requires an active Search Console link. |
| Organic google search impressions | NUMERIC | The number of organic Google Search impressions reported from Search Console. This metric requires an active Search Console link. |
| Outbound | TEXT | Returns 'true' if the link lead to a site is not a part of the property’s domain. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'outbound'. |
| Page location | TEXT | The protocol, hostname, page path, and query string for web pages visited; for example, the pageLocation portion of https://www.example.com/store/contact-us?query_string=true is https://www.example.com/store/contact-us?query_string=true. Populated by the event parameter 'page_location'. |
| Page path | TEXT | The portion of the URL between the hostname and query string for web pages visited; for example, the pagePath portion of https://www.example.com/store/contact-us?query_string=true is /store/contact-us. |
| Page path + query string | TEXT | The portion of the URL following the hostname for web pages visited; for example, the pagePathPlusQueryString portion of https://www.example.com/store/contact-us?query_string=true is /store/contact-us?query_string=true. |
| Page referrer | TEXT | The full referring URL including the hostname and path. This referring URL is the user's previous URL and can be this website's domain or other domains. Populated by the event parameter 'page_referrer'. |
| Page title | TEXT | The web page titles used on your site. |
| Percent scrolled | TEXT | The percentage down the page that the user has scrolled (for example, '90'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'percent_scrolled'. |
| Platform | TEXT | The platform on which your app or website ran; for example, web, iOS, or Android. To determine a stream's type in a report, use both platform and streamId. |
| Platform / device category | TEXT | The platform and type of device on which your website or mobile app ran. (example: Android / mobile) |
| Promotion clicks | NUMERIC | The number of times an item promotion was clicked. This metric counts the occurrence of the 'select_promotion' event. |
| Promotion views | NUMERIC | The number of times an item promotion was viewed. This metric counts the occurrence of the 'view_promotion' event. |
| Publisher ad clicks | NUMERIC | The number of ad_click events. |
| Publisher ad impressions | NUMERIC | The number of ad_impression events. |
| Purchase revenue | NUMERIC | The sum of revenue from purchases made in your app or site. Purchase revenue sums the revenue for these events: 'purchase', 'ecommerce_purchase', 'in_app_purchase', 'app_store_subscription_convert', and 'app_store_subscription_renew'. Purchase revenue is specified by the 'value' parameter in tagging. |
| Purchase-to-view rate | NUMERIC | The number of users who purchased a product(s) divided by the number of users who viewed the same product(s). This metric is returned as a fraction; for example, 0.128 means 12.8% of users that viewed a product(s) also purchased the same product(s). |
| Purchaser conversion | NUMERIC | The percentage of active users who made 1 or more purchase transactions. This metric is returned as a fraction; for example, 0.412 means 41.2% of users were purchasers. |
| Region | REGION | The geographic region from which the user activity originated, derived from their IP address. |
| Return on ad spend | NUMERIC | Return On Ad Spend (ROAS) is total revenue divided by advertiser ad cost. |
| Views | NUMERIC | The number of app screens or web pages your users viewed. Repeated views of a single page or screen are counted. (screen_view + page_view events). |
| Views per session | NUMERIC | The number of app screens or web pages your users viewed per session. Repeated views of a single page or screen are counted. (screen_view + page_view events) / sessions. |
| Views per user | NUMERIC | The number of app screens or web pages your users viewed per active user. Repeated views of a single page or screen are counted. (screen_view + page_view events) / active users. |
| Screen resolution | TEXT | The screen resolution of the user's monitor. For example, 1920x1080. |
| Scrolled users | NUMERIC | The number of unique users who scrolled down at least 90% of the page. |
| Search term | TEXT | The term searched by the user. For example if the user visits '/some-page.html?q=some-term', this dimension returns 'some-term'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'search_term'. |
| Session campaign ID | TEXT | The marketing campaign id for a session. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
| Session conversion rate | NUMERIC | The percentage of sessions in which any conversion event was triggered. |
| Session default channel group | TEXT | The session's default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
| Session Google Ads account name | TEXT | The Account name from Google Ads that led to the session. Corresponds to customer.descriptive_name in the Google Ads API. |
| Session Google Ads ad group ID | TEXT | The Ad Group Id in Google Ads for a session. |
| Session Google Ads ad group name | TEXT | The Ad Group Name in Google Ads for a session. |
| Session Google Ads ad network type | TEXT | The advertising network that led to the session. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
| Session Google Ads campaign ID | TEXT | The Campaign ID for the Google Ads Campaign that led to this session. |
| Session Google Ads campaign | TEXT | The Campaign name for the Google Ads Campaign that led to this session. |
| Session Google Ads campaign type | TEXT | The campaign type for the Google Ads campaign that led to this session. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see |
| Session Google Ads creative ID | TEXT | The ID of the Google Ads creative that lead to a session on your website or app. Creative IDs identify individual ads. |
| Session Google Ads customer ID | TEXT | The Customer ID from Google Ads that led to the session. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
| Session Google Ads keyword text | TEXT | The matched keyword that led to the session. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see |
| Session Google Ads query | TEXT | The search query that led to the session. |
| Session manual ad content | TEXT | The ad content that led to a session. Populated by the utm_content parameter. |
| Session manual term | TEXT | The term that led to a session. Populated by the utm_term parameter. |
| Session SA360 ad group name | TEXT | The Ad Group name from Search Ads 360 that led to this session. |
| Session SA360 campaign ID | TEXT | The Campaign ID from Search Ads 360 that led to this session. |
| Session SA360 campaign | TEXT | The Campaign name from Search Ads 360 that led to this session. |
| Session SA360 creative format | TEXT | The type of creative in Search Ads 360 that led to this session. For example, 'Responsive search ad' or 'Expanded text ad'. To learn more, see [GA4 Traffic Source Dimensions](https://support.google.com/analytics/answer/9143382#traffic-source). |
| Session SA360 engine account ID | TEXT | The ID of the engine account in SA360 that led to this session. |
| Session SA360 engine account name | TEXT | The name of the engine account in SA360 that led to this session. |
| Session SA360 engine account type | TEXT | The type of the engine account in Search Ads 360 that led to this session. For example, 'google ads', 'bing', or 'baidu'. |
| Session SA360 keyword text | TEXT | The search engine keyword from Search Ads 360 that led to this session. |
| Session SA360 medium | TEXT | The search engine keyword from Search Ads 360 that led to this session. For example, 'cpc'. |
| Session SA360 query | TEXT | The search query from Search Ads 360 that led to this session. |
| Session SA360 source | TEXT | The source of the traffic from Search Ads 360 that led to this session. For example, 'example.com' or 'google'. |
| Session source / medium | TEXT | The combined values of the dimensions 'sessionSource' and 'sessionMedium'. |
| Session source platform | TEXT | The source platform of the session's campaign. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
| Sessions | NUMERIC | The number of sessions that began on your site or app (event triggered: session_start). |
| Sessions per user | NUMERIC | The average number of sessions per user (Sessions divided by Active Users). |
| Shipping amount | NUMERIC | Shipping amount associated with a transaction. Populated by the 'shipping' event parameter. |
| Shipping tier | TEXT | The shipping tier (e.g. Ground, Air, Next-day) selected for delivery of the purchased item. Populated by the 'shipping_tier' event parameter. |
| Signed in with user ID | TEXT | The string 'yes' if the user signed in with the User-ID feature. To learn more about User-ID, see |
| Source | TEXT | The source attributed to the conversion event. |
| Source / medium | TEXT | The combined values of the dimensions 'source' and 'medium'. |
| Source platform | TEXT | The source platform of the conversion event's campaign. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
| Stream ID | TEXT | The numeric data stream identifier for your app or website. |
| Stream name | TEXT | The data stream name for your app or website. |
| Tax amount | NUMERIC | Tax amount associated with a transaction. Populated by the 'tax' event parameter. |
| Test data filter ID | TEXT | The numeric identifier of a data filter in testing state. You use data filters to include or exclude event data from your reports based on event-parameter values. To learn more, see |
| Test data filter name | TEXT | The name of data filters in testing state. You use data filters to include or exclude event data from your reports based on event-parameter values. To learn more, see |
| Total ad revenue | NUMERIC | The total advertising revenue from both Admob and third-party sources. |
| Total purchasers | NUMERIC | The number of users that logged purchase events for the time period selected. |
| Total revenue | NUMERIC | The sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue). |
| Total users | NUMERIC | The number of distinct users who have logged at least one event, regardless of whether the site or app was in use when that event was logged. |
| Transaction ID | TEXT | The ID of the ecommerce transaction. |
| Transaction revenue (alias for Total revenue) | NUMERIC | The sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue). |
| Transactions | NUMERIC | The count of transaction events with purchase revenue. Transaction events are in_app_purchase, ecommerce_purchase, purchase, app_store_subscription_renew, app_store_subscription_convert, and refund. |
| Transactions per purchaser | NUMERIC | The average numer of transactions per purchaser. |
| Page path and screen class | TEXT | The page path (web) or screen class (app) on which the event was logged. |
| Page path + query string and screen class | TEXT | The page path and query string (web) or screen class (app) on which the event was logged. |
| Page title and screen class | TEXT | The page title (web) or screen class (app) on which the event was logged. |
| Page title and screen name | TEXT | The page title (web) or screen name (app) on which the event was logged. |
| User conversion rate | NUMERIC | The percentage of users who triggered any conversion event. |
| User engagement | NUMERIC | The total amount of time (in seconds) your website or app was in the foreground of users' devices. |
| Video provider | TEXT | The source of the video (for example, 'youtube'). Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_provider'. |
| Video title | TEXT | The title of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_title'. |
| Video URL | TEXT | The url of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_url'. |
| Virtual currency name | TEXT | The name of a virtual currency with which the user is interacting. i.e. spending or purchasing gems in a game. Populated by the 'virtual_currency_name' event parameter. |
| Visible | TEXT | Returns 'true' if the content is visible. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'visible'. |
| WAU / MAU | NUMERIC | The rolling percent of 30-day active users who are also 7-day active users. This metric is returned as a fraction; for example, 0.234 means 23.4% of 30-day active users were also 7-day active users. |
| Week | TEXT | The week of the event, a two-digit number from 01 to 53. Each week starts on Sunday. January 1st is always in week 01. The first and last week of the year have fewer than 7 days in most years. Weeks other than the first and the last week of the year always have 7 days. For years where January 1st is a Sunday, the first week of that year and the last week of the prior year have 7 days. |
| Year | TEXT | The four-digit year of the event e.g. 2020. |
Easily connect Google Analytics 4 to Snowflake
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.