Connect GA4 to Snowflake: Build an Integration in 2023

google analytics
+
snowflake

Stream marketing data from GA4 to 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:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. 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.

GA4 google bigquery integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

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

Connect your data

 

nametypedescription
Account IDTEXTThe Account ID
Account NameTEXTThe Account Name
Achievement IDTEXTThe achievement ID in a game for an event. Populated by the event parameter 'achievement_id'.
1-day active usersNUMERICThe 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 usersNUMERICThe 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 usersNUMERICThe 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 UsersNUMERICPrimary user metric in GA4: The number of distinct users who visited your site or app.
Ad formatTEXTDescribes the way ads looked and where they were located. Typical formats include 'Interstitial', 'Banner', 'Rewarded', and 'Native advanced'.
Ad sourceTEXTThe source network that served the ad. Typical sources include 'AdMob Network', 'Liftoff', 'Facebook Audience Network', and 'Mediated house ads'.
Ad unit exposureNUMERICThe time that an ad unit was exposed to a user, in milliseconds.
Ad unitTEXTThe name you chose to describe this Ad unit. Ad units are containers you place in your apps to show ads to users.
Add to cartsNUMERICThe number of times users added items to their shopping carts.
Ads clicksNUMERICTotal 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 costNUMERICThe 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 clickNUMERICAds cost per click is ad cost divided by ad clicks and is often abbreviated CPC.
Ads impressionsNUMERICThe total number of impressions. Includes impressions from linked integrations like linked Display & Video 360 advertisers. Also includes uploaded impressions from data import.
AgeTEXTUser age brackets.
App versionTEXTThe app's versionName (Android) or short bundle version (iOS).
Audience idTEXTThe 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 nameTEXTThe 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.
Audience resource nameTEXTThe resource name of this audience. Resource names contain both collection & resource identifiers to uniquely identify a resource; to learn more, see https://google.aip.dev/122.
Average purchase revenueNUMERICThe average purchase revenue in the transaction group of events.
ARPPUNUMERICAverage 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 userNUMERICThe 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.
ARPUNUMERICAverage 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 durationNUMERICThe average duration (in seconds) of users' sessions.
Bounce rateNUMERICThe 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.
InterestsTEXTInterests 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'.
BrowserTEXTThe browsers used to view your website.
Campaign (alias for Campaign name)TEXTThe name of the marketing campaign. Present only for conversion events.
Campaign IDTEXTThe identifier of the marketing campaign. Present only for conversion events. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns.
Campaign nameTEXTThe name of the marketing campaign. Present only for conversion events.
Cart-to-view rateNUMERICThe 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.
CharacterTEXTThe player character in a game for an event. Populated by the event parameter 'character'.
CheckoutsNUMERICThe number of times users started the checkout process. This metric counts the occurrence of the 'begin_checkout' event.
CityCITYThe city from which the user activity originated.
City IDTEXTThe geographic ID of the city from which the user activity originated, derived from their IP address.
CohortTEXTThe 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 usersNUMERICThe 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 cohortTEXTDay 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 cohortTEXTMonth 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 cohortTEXTWeek 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 usersNUMERICThe 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 groupTEXTA category that applies to items of published content. Populated by the event parameter 'content_group'.
Content IDTEXTThe identifier of the selected content. Populated by the event parameter 'content_id'.
Content typeTEXTThe category of the selected content. Populated by the event parameter 'content_type'.
ContinentTEXTThe continent from which the user activity originated. For example, 'Americas' or 'Asia'.
Continent IDTEXTThe geographic ID of the continent from which the user activity originated, derived from their IP address.
ConversionsNUMERICThe 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 conversionNUMERICCost per conversion is ad cost divided by conversions.
CountryCOUNTRYThe country from which the user activity originated.
Country IDCOUNTRYThe 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 usersNUMERICThe 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 rateNUMERICThe 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.
Currency codeTEXTThe local currency code (based on ISO 4217 standard) of the eCommerce event. For example, 'USD' or 'GBP'. Currency is specified in tagging by the 'currency' parameter. Businesses that transact in more than one currency can specify a local currency code when sending eCommerce events to Analytics, and this dimension shows those currencies. To Learn more, See [Currency reference](https://support.google.com/analytics/answer/9796179).
DateDATEThe date of the event, formatted as YYYYMMDD.
Date + hour (YYYYMMDDHH)TIMESTAMPThe combined values of date and hour formatted as YYYYMMDDHH.
Date hour and minuteTIMESTAMPThe combined values of date, hour, and minute formatted as YYYYMMDDHHMM.
DAU / MAUNUMERICThe 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 / WAUNUMERICThe 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.
DayTEXTThe day of the month, a two-digit number from 01 to 31.
Day of weekTEXTThe integer day of the week. It returns values in the range [0,6] with Sunday as the first day of the week.
Day of week nameTEXTThe day of the week in English. This dimension has values of Sunday, Monday, etc.
Default channel groupTEXTThe 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'.
DeviceTEXTThe branded device name (examples are Galaxy S10 or P30 Pro).
Device modelTEXTThe mobile device model (example: iPhone 10,6).
Device categoryTEXTThe type of device - Desktop, Tablet, or Mobile.
Ecommerce purchasesNUMERICThe number of times users completed a purchase. This metric counts 'purchase' events; this metric does not count 'in_app_purchase' and subscription events.
Engaged sessionsNUMERICThe number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views.
Engagement ratePERCENTThe 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.
Campaign (Conversion event scope)TEXTThe name of the marketing campaign. Present only for conversion events. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns.
Event countNUMERICThe count of events.
Event count per userNUMERICThe average number of events per user (Event count divided by Active users).
Event nameTEXTThe name of the event.
Event valueNUMERICThe sum of the event parameter named 'value'.
Events per sessionNUMERICThe average number of events per session (Event count divided by Sessions).
File extensionTEXTThe 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 nameTEXTThe 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 dateDATEThe date the user's first session occurred, formatted as YYYYMMDD.
First-time purchaser conversionNUMERICThe 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 purchasersNUMERICThe number of users that completed their first purchase event.
First-time purchasers per new userNUMERICThe average number of first time purchasers per new user.
First user campaign IDTEXTIdentifier of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns.
First user campaignTEXTName of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns.
First user default channel groupTEXTThe 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 nameTEXTThe Account name from Google Ads that first acquired the user.
First user Google Ads ad group IDTEXTThe Ad Group Id in Google Ads that first acquired the user.
First user Google Ads ad group nameTEXTThe Ad Group Name in Google Ads that first acquired the user.
First user Google Ads ad network typeTEXTThe 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 IDTEXTIdentifier of the Google Ads marketing campaign that first acquired the user.
First user Google Ads campaignTEXTName of the Google Ads marketing campaign that first acquired the user.
First user Google Ads campaign typeTEXTThe 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, Demand Gen, App, Smart, Hotel, Local, and Performance Max. To learn more, see .
First user Google Ads creative IDTEXTThe ID of the Google Ads creative that first acquired the user. Creative IDs identify individual ads.
First user Google Ads customer IDTEXTThe 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 textTEXTThe 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 queryTEXTThe search query that first acquired the user.
First user manual ad contentTEXTThe ad content that first acquired the user. Populated by the utm_content parameter.
First user manual termTEXTThe term that first acquired the user. Populated by the utm_term parameter.
First user mediumTEXTThe medium that first acquired the user to your website or app.
First user sourceTEXTThe source that first acquired the user to your website or app.
First user source / mediumTEXTThe combined values of the dimensions 'firstUserSource' and 'firstUserMedium'.
First user source platformTEXTThe 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 URLTEXTThe 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.
GenderTEXTUser gender.
Google Ads account nameTEXTThe 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 IDTEXTThe ad group id attributed to the conversion event.
Google Ads ad group nameTEXTThe ad group name attributed to the conversion event.
Google Ads ad network typeTEXTThe 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 IDTEXTThe campaign ID for the Google Ads campaign attributed to the conversion event.
Google Ads campaignTEXTThe campaign name for the Google Ads campaign attributed to the conversion event.
Google Ads campaign typeTEXTThe 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, Demand Gen, App, Smart, Hotel, Local, and Performance Max. To learn more, see .
Google Ads creative IDTEXTThe ID of the Google Ads creative attributed to the conversion event. Creative IDs identify individual ads.
Google Ads customer IDTEXTThe 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 textTEXTThe 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 queryTEXTThe search query that led to the conversion event.
Gross item revenueNUMERICThe total revenue from items only. Gross 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. Gross item revenue does not include refunds.
Gross purchase revenueNUMERICThe sum of revenue from purchases made in your app or site. Gross 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.
Group IDTEXTThe player group ID in a game for an event. Populated by the event parameter 'group_id'.
HostnameTEXTIncludes the subdomain and domain names of a URL; for example, the Host Name of www.example.com/contact.html is www.example.com.
HourTEXTThe 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 eventTEXTThe 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 .
ISO week of the yearTEXTISO week number, where each week starts on Monday. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 01, 02, & 53.
ISO yearTEXTThe ISO year of the event. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 2022 & 2023.
ISO week of ISO yearTEXTThe combined values of isoWeek and isoYear. Example values include 201652 & 201701.
Item affiliationTEXTThe name or code of the affiliate (partner/vendor; if any) associated with an individual item. Populated by the 'affiliation' item parameter.
Item brandTEXTBrand name of the item.
Item categoryTEXTThe hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category.
Item category 2TEXTThe 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 3TEXTThe 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 4TEXTThe 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 5TEXTThe 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 discount amountNUMERICThe monetary value of item discounts in eCommerce events. This metric is populated in tagging by the 'discount' item parameter.
Item IDTEXTThe ID of the item.
Item-list click eventsNUMERICThe 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 rateNUMERICThe 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 IDTEXTThe ID of the item list.
Item list nameTEXTThe name of the item list.
Item list positionTEXTThe position of an item (e.g., a product you sell) in a list. This dimension is populated in tagging by the 'index' parameter in the items array.
Item-list view eventsNUMERICThe number of times the item list was viewed. This metric counts the occurrence of the 'view_item_list' event.
Item location IDTEXTThe physical location associated with the item (e.g. the physical store location). It's recommended to use the [Google Place ID](https://developers.google.com/maps/documentation/places/web-service/place-id) that corresponds to the associated item. A custom location ID can also be used. This field is populated in tagging by the 'location_id' parameter in the items array.
Item nameTEXTThe name of the item.
Item promotion click through rateNUMERICThe 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 nameTEXTThe name of the item-promotion creative.
Item promotion creative slotTEXTThe name of the promotional creative slot associated with the item. This dimension can be specified in tagging by the 'creative_slot' parameter at the event or item level. If the parameter is specified at both the event & item level, the item-level parameter is used.
Item promotion IDTEXTThe ID of the item promotion.
Item promotion nameTEXTThe name of the promotion for the item.
Item refund amountNUMERICItem refund amount is the total refunded transaction revenue from items only. Item refund amount is the product of price and quantity for the 'refund' event.
Item revenueNUMERICThe total revenue from purchases minus refunded transaction 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 variantTEXTThe 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 eventsNUMERICThe number of times the item details were viewed. The metric counts the occurrence of the 'view_item' event.
Items added to cartNUMERICThe number of units added to cart for a single item. This metric counts the quantity of items in 'add_to_cart' events.
Items checked outNUMERICThe number of units checked out for a single item. This metric counts the quantity of items in 'begin_checkout' events.
Items clicked in listNUMERICThe number of units clicked in list for a single item. This metric counts the quantity of items in 'select_item' events.
Items clicked in promotionNUMERICThe number of units clicked in promotion for a single item. This metric counts the quantity of items in 'select_promotion' events.
Items purchasedNUMERICThe number of units for a single item included in purchase events. This metric counts the quantity of items in purchase events.
Items viewedNUMERICThe number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.
Items viewed in listNUMERICThe 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 promotionNUMERICThe number of units viewed in promotion for a single item. This metric counts the quantity of items in 'view_promotion' events.
Landing pageTEXTThe page path associated with the first pageview in a session.
Landing page + query stringTEXTThe page path + query string associated with the first pageview in a session.
LanguageTEXTThe language setting of the user's browser or device. e.g. English
Language codeTEXTThe language setting (ISO 639) of the user's browser or device. e.g. 'en-us'
LevelTEXTThe player's level in a game. Populated by the event parameter 'level'.
TEXTThe 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'.
TEXTThe 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'.
TEXTThe 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'.
TEXTThe link text of the file download. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_text'.
TEXTThe 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 contentTEXTThe ad content attributed to the conversion event. Populated by the utm_content parameter.
Manual termTEXTThe term attributed to the conversion event. Populated by the utm_term parameter.
MediumTEXTThe medium attributed to the conversion event.
MethodTEXTThe method by which an event was triggered. Populated by the event parameter 'method'.
MinuteTEXTThe 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 brandTEXTManufacturer or branded name (examples: Samsung, HTC, Verizon, T-Mobile).
Mobile modelTEXTThe mobile device model name (examples: iPhone X or SM-G950F).
MonthTEXTThe month of the event, a two digit integer from 01 to 12.
New / returningTEXTNew users have 0 previous sessions, and returning users have 1 or more previous sessions. This dimension returns two values: 'new' or 'returning'.
New usersNUMERICThe web page titles used on your site.
Nth dayTEXTThe number of days since the start of the date range.
Nth hourTEXTThe number of hours since the start of the date range. The starting hour is 0000.
Nth minuteTEXTThe number of minutes since the start of the date range. The starting minute is 0000.
Nth monthTEXTThe number of months since the start of a date range. The starting month is 0000.
Nth weekTEXTA number representing the number of weeks since the start of a date range.
Nth yearTEXTThe number of years since the start of the date range. The starting year is 0000.
Operating systemTEXTThe operating systems used by visitors to your app or website. Includes desktop and mobile operating systems such as Windows and Android.
OS versionTEXTThe 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 versionTEXTThe operating system and version. For example, Android 10 or Windows 7.
Order couponTEXTCode for the order-level coupon.
NUMERICThe 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.
NUMERICThe 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.
NUMERICThe number of organic Google Search clicks reported from Search Console. This metric requires an active Search Console link.
NUMERICThe number of organic Google Search impressions reported from Search Console. This metric requires an active Search Console link.
OutboundTEXTReturns '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 locationTEXTThe 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 pathTEXTThe 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 stringTEXTThe 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 referrerTEXTThe 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 titleTEXTThe web page titles used on your site.
Percent scrolledTEXTThe 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'.
PlatformTEXTThe 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 categoryTEXTThe platform and type of device on which your website or mobile app ran. (example: Android / mobile)
Promotion clicksNUMERICThe number of times an item promotion was clicked. This metric counts the occurrence of the 'select_promotion' event.
Promotion viewsNUMERICThe number of times an item promotion was viewed. This metric counts the occurrence of the 'view_promotion' event.
Publisher ad clicksNUMERICThe number of ad_click events.
Publisher ad impressionsNUMERICThe number of ad_impression events.
Purchase revenueNUMERICThe sum of revenue from purchases minus refunded transaction revenue 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 rateNUMERICThe 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 conversionNUMERICThe 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.
Total refund amountNUMERICThe total refunded transaction revenues. Refund amount sums refunded revenue for the 'refund' and 'app_store_refund' events.
RegionREGIONThe geographic region from which the user activity originated, derived from their IP address.
Return on ad spendNUMERICReturn On Ad Spend (ROAS) is total revenue divided by advertiser ad cost.
ViewsNUMERICThe 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 sessionNUMERICThe 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 userNUMERICThe 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 resolutionTEXTThe screen resolution of the user's monitor. For example, 1920x1080.
Scrolled usersNUMERICThe number of unique users who scrolled down at least 90% of the page.
TEXTThe 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 IDTEXTThe marketing campaign id for a session. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns.
Session conversion rateNUMERICThe percentage of sessions in which any conversion event was triggered.
Session default channel groupTEXTThe 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 nameTEXTThe 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 IDTEXTThe Ad Group Id in Google Ads for a session.
Session Google Ads ad group nameTEXTThe Ad Group Name in Google Ads for a session.
Session Google Ads ad network typeTEXTThe 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 IDTEXTThe Campaign ID for the Google Ads Campaign that led to this session.
Session Google Ads campaignTEXTThe Campaign name for the Google Ads Campaign that led to this session.
Session Google Ads campaign typeTEXTThe 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, Demand Gen, App, Smart, Hotel, Local, and Performance Max. To learn more, see .
Session Google Ads creative IDTEXTThe 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 IDTEXTThe Customer ID from Google Ads that led to the session. Customer IDs in Google Ads uniquely identify Google Ads accounts.
Session Google Ads keyword textTEXTThe 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 queryTEXTThe search query that led to the session.
Session manual ad contentTEXTThe ad content that led to a session. Populated by the utm_content parameter.
Session manual termTEXTThe term that led to a session. Populated by the utm_term parameter.
Session SA360 ad group nameTEXTThe Ad Group name from Search Ads 360 that led to this session.
Session SA360 campaign IDTEXTThe Campaign ID from Search Ads 360 that led to this session.
Session SA360 campaignTEXTThe Campaign name from Search Ads 360 that led to this session.
Session SA360 creative formatTEXTThe 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 IDTEXTThe ID of the engine account in SA360 that led to this session.
Session SA360 engine account nameTEXTThe name of the engine account in SA360 that led to this session.
Session SA360 engine account typeTEXTThe type of the engine account in Search Ads 360 that led to this session. For example, 'google ads', 'bing', or 'baidu'.
Session SA360 keyword textTEXTThe search engine keyword from Search Ads 360 that led to this session.
Session SA360 mediumTEXTThe search engine keyword from Search Ads 360 that led to this session. For example, 'cpc'.
Session SA360 queryTEXTThe search query from Search Ads 360 that led to this session.
Session SA360 sourceTEXTThe source of the traffic from Search Ads 360 that led to this session. For example, 'example.com' or 'google'.
Session source / mediumTEXTThe combined values of the dimensions 'sessionSource' and 'sessionMedium'.
Session source platformTEXTThe 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.
SessionsNUMERICThe number of sessions that began on your site or app (event triggered: session_start).
Sessions per userNUMERICThe average number of sessions per user (Sessions divided by Active Users).
Shipping amountNUMERICShipping amount associated with a transaction. Populated by the 'shipping' event parameter.
Shipping tierTEXTThe 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 IDTEXTThe string 'yes' if the user signed in with the User-ID feature. To learn more about User-ID, see .
SourceTEXTThe source attributed to the conversion event.
Source / mediumTEXTThe combined values of the dimensions 'source' and 'medium'.
Source platformTEXTThe 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 IDTEXTThe numeric data stream identifier for your app or website.
Stream nameTEXTThe data stream name for your app or website.
Tax amountNUMERICTax amount associated with a transaction. Populated by the 'tax' event parameter.
Test data filter IDTEXTThe 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 nameTEXTThe 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 revenueNUMERICThe total advertising revenue from both Admob and third-party sources.
Total purchasersNUMERICThe number of users that logged purchase events for the time period selected.
Total revenueNUMERICThe sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue).
Total usersNUMERICThe 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 IDTEXTThe ID of the ecommerce transaction.
Transaction revenue (alias for Total revenue)NUMERICThe sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue).
TransactionsNUMERICThe 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 purchaserNUMERICThe average numer of transactions per purchaser.
Page path and screen classTEXTThe page path (web) or screen class (app) on which the event was logged.
Page path + query string and screen classTEXTThe page path and query string (web) or screen class (app) on which the event was logged.
Page title and screen classTEXTThe page title (web) or screen class (app) on which the event was logged.
Page title and screen nameTEXTThe page title (web) or screen name (app) on which the event was logged.
User conversion rateNUMERICThe percentage of users who triggered any conversion event.
User engagementNUMERICThe total amount of time (in seconds) your website or app was in the foreground of users' devices.
UsersNUMERICAlias for active_users.
Video providerTEXTThe 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 titleTEXTThe title of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_title'.
Video URLTEXTThe url of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_url'.
Virtual currency nameTEXTThe 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.
VisibleTEXTReturns 'true' if the content is visible. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'visible'.
WAU / MAUNUMERICThe 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.
WeekTEXTThe 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.
YearTEXTThe four-digit year of the event e.g. 2020.
Year monthTEXTThe combined values of year and month. Example values include 202212 or 202301.
Year weekTEXTThe combined values of year and week. Example values include 202253 or 202301.
TodayDATEToday's date

Easily connect Google Analytics 4 to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your GA4 and Snowflake Integrations