Stream marketing data from Google Analytics to Snowflake
About Google Analytics
About SnowFlake
Connect Google Analytics to Snowflake in 2023
It is very simple to connect Google Analytics 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 Google Analytics 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 from Google Analytics to Snowflake. In case there is an error you will be notified.
Google Analytics metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| 14 Day Active Users | NUMERIC | Total number of 14-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 14-day period ending on the given date. |
| 1 Day Active Users | NUMERIC | Total number of 1-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 1-day period ending on the given date. |
| 28 Day Active Users | NUMERIC | Total number of 28-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 28-day period ending on the given date. |
| 30 Day Active Users | NUMERIC | Total number of 30-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 30-day period ending on the given date. |
| 7 Day Active Users | NUMERIC | Total number of 7-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 7-day period ending on the given date. |
| Account ID | TEXT | Google Analytics view ID |
| Account Name | TEXT | Google Analytics view name |
| Ad Clicks | NUMERIC | Total number of times users have clicked on an ad to reach the property. |
| Ad Content | TEXT | For manual campaign tracking, it is the value of the utm_content campaign tracking parameter. For AdWords autotagging, it is the first line of the text for the online Ad campaign. If you use mad libs for the AdWords content, it contains the keywords you provided for the mad libs keyword match. If you use none of the above, its value is (not set). |
| Ad Cost | NUMERIC | Derived cost for the advertising campaign. Its currency is the one you set in the AdWords account. |
| Destination URL | TEXT | The URL to which the AdWords ads referred traffic. |
| Display URL | TEXT | The URL the AdWords ads displayed. |
| Ad Distribution Network | TEXT | The network (Content, Search, Search partners, etc.) used to deliver the ads. |
| Ad Format | TEXT | The AdWords ad format (Text, Image, Flash, Video, etc.). |
| Google Ads: Ad Group | TEXT | The name of the AdWords ad group. |
| Keyword Match Type | TEXT | The match type (Phrase, Exact, or Broad) applied to the keywords. For details, see https://support.google.com/adwords/answer/2472708. |
| Ad Matched Query | TEXT | The search query that triggered impressions. |
| Query Match Type | TEXT | The match type (Phrase, Exact, Broad, etc.) applied for users' search term. Ads on the content network are identified as "Content network". For details, see https://support.google.com/adwords/answer/2472708?hl=en. |
| Placement Domain | TEXT | The domain where the ads on the content network were placed. |
| Placement URL | TEXT | The URL where the ads were placed on the content network. |
| Query Word Count | TEXT | The number of words in the search query. |
| Google Ads: Ad Slot | TEXT | The location (Top, RHS, or not set) of the advertisement on the hosting page. |
| Placement Type | TEXT | It is Automatic placements or Managed placements, indicating how the ads were managed on the content network. |
| Targeting Type | TEXT | This (keyword, placement, or vertical targeting) indicates how the AdWords ads were targeted. |
| Google Ads Ad Group ID | TEXT | AdWords API AdGroup.id. |
| Google Ads Campaign ID | TEXT | AdWords API Campaign.id. |
| Google Ads Creative ID | TEXT | AdWords API Ad.id. |
| Google Ads Criteria ID | TEXT | AdWords API Criterion.id. The geographical targeting Criteria IDs are listed at https://developers.google.com/analytics/devguides/collection/protocol/v1/geoid. |
| Google Ads Customer ID | TEXT | Customer's AdWords ID, corresponding to AdWords API AccountInfo.customerId. |
| AdX Clicks | NUMERIC | The number of times AdX ads were clicked on the site. |
| AdX Coverage | PERCENT | Coverage is the percentage of ad requests that returned at least one ad. Generally, coverage can help identify sites where the Ad Exchange account isn't able to provide targeted ads. (Ad Impressions / Total Ad Requests) * 100 |
| AdX CTR | PERCENT | The percentage of pageviews that resulted in a click on an Ad Exchange ad. |
| AdX eCPM | NUMERIC | The effective cost per thousand pageviews. It is the Ad Exchange revenue per 1,000 pageviews. |
| AdX Impressions | NUMERIC | An Ad Exchange ad impression is reported whenever an individual ad is displayed on the website. For example, if a page with two ad units is viewed once, we'll display two impressions. |
| AdX Impressions / Session | NUMERIC | The ratio of Ad Exchange ad impressions to Analytics sessions (Ad Impressions / Analytics Sessions). |
| AdX Monetized Pageviews | NUMERIC | This measures the total number of pageviews on the property that were shown with an ad from the linked Ad Exchange account. Note that a single page can have multiple ad units. |
| AdX Revenue | NUMERIC | The total estimated revenue from Ad Exchange ads. |
| AdX Revenue / 1000 Sessions | NUMERIC | The total estimated revenue from Ad Exchange ads per 1,000 Analytics sessions. Note that this metric is based on sessions to the site, not on ad impressions. |
| AdX Viewable Impressions % | PERCENT | The percentage of viewable ad impressions. An impression is considered a viewable impression when it has appeared within users' browsers and has the opportunity to be seen. |
| Affiliation | TEXT | A product affiliation to designate a supplying company or brick and mortar location. |
| Avg. Domain Lookup Time (sec) | NUMERIC | The average time (in seconds) spent in DNS lookup for this page. |
| Avg. Document Content Loaded Time (sec) | NUMERIC | The average time (in seconds) the browser takes to parse the document. |
| Avg. Document Interactive Time (sec) | NUMERIC | The average time (in seconds), including the network time from users' locations to the site's server, the browser takes to parse the document and execute deferred and parser-inserted scripts. |
| Avg. Value | NUMERIC | The average value of an event. |
| Avg. Page Download Time (sec) | NUMERIC | The average time (in seconds) to download this page. |
| Avg. Page Load Time (sec) | NUMERIC | The average time (in seconds) pages from the sample set take to load, from initiation of the pageview (e.g., a click on a page link) to load completion in the browser. |
| Avg. Redirection Time (sec) | NUMERIC | The average time (in seconds) spent in redirects before fetching this page. If there are no redirects, this is 0. |
| Avg. Search Depth | NUMERIC | The average number of pages people viewed after performing a search. |
| Adverage Time after Search | NUMERIC | The average time (in seconds) users, after searching, spent on the property. |
| Results Pageviews / Search | NUMERIC | The average number of times people viewed a page as a result of a search. |
| Avg. Server Connection Time (sec) | NUMERIC | The average time (in seconds) spent in establishing a TCP connection to this page. |
| Avg. Server Response Time (sec) | NUMERIC | The average time (in seconds) the site's server takes to respond to users' requests; this includes the network time from users' locations to the server. |
| Avg. Session Duration | NUMERIC | The average duration (in seconds) of users' sessions. |
| Avg. Time on Page | NUMERIC | The average time users spent viewing this page or a set of pages. |
| Bounce Rate | PERCENT | The percentage of single-page session (i.e., session in which the person left the property from the first page). |
| Bounces | NUMERIC | The total number of single page (or single interaction hit) sessions for the property. |
| Browser | TEXT | The name of users' browsers, for example, Internet Explorer or Firefox. |
| Browser Size | TEXT | The viewport size of users' browsers. A session-scoped dimension, browser size captures the initial dimensions of the viewport in pixels and is formatted as width x height, for example, 1920x960. |
| Browser Version | TEXT | The version of users' browsers, for example, 2.0.0.14. |
| Buy-to-Detail Rate | PERCENT | Unique purchases divided by views of product detail pages (Enhanced Ecommerce). |
| Campaign | TEXT | For manual campaign tracking, it is the value of the utm_campaign campaign tracking parameter. For AdWords autotagging, it is the name(s) of the online ad campaign(s) you use for the property. If you use neither, its value is (not set). |
| Campaign Code | TEXT | For manual campaign tracking, it is the value of the utm_id campaign tracking parameter. |
| Cart-to-Detail Rate | PERCENT | Product adds divided by views of product details (Enhanced Ecommerce). |
| Default Channel Grouping (duplicate) | TEXT | The Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings). |
| Default Channel Grouping | TEXT | The Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings). |
| Checkout Options | TEXT | User options specified during the checkout process, e.g., FedEx, DHL, UPS for delivery options; Visa, MasterCard, AmEx for payment options. This dimension should be used with ga:shoppingStage (Enhanced Ecommerce). |
| City | CITY | Users' city, derived from their IP addresses or Geographical IDs. |
| City ID | TEXT | Users' city ID, derived from their IP addresses or Geographical IDs. The city IDs are the same as the Criteria IDs found at https://developers.google.com/analytics/devguides/collection/protocol/v1/geoid. |
| clientid from google analytics | TEXT | clientid from google analytics. |
| Continent | TEXT | Users' continent, derived from users' IP addresses or Geographical IDs. |
| Continent ID | TEXT | Users' continent ID, derived from users' IP addresses or Geographical IDs. |
| Cost per Conversion | NUMERIC | The cost per conversion (including ecommerce and goal conversions) for the property. |
| Cost per Goal Conversion | NUMERIC | The cost per goal conversion for the property. |
| Cost per Transaction | NUMERIC | The cost per transaction for the property. |
| Country | COUNTRY | Users' country, derived from their IP addresses or Geographical IDs. |
| Country ISO Code | COUNTRY | Users' country's ISO code (in ISO-3166-1 alpha-2 format), derived from their IP addresses or Geographical IDs. For example, BR for Brazil, CA for Canada. |
| CPC | NUMERIC | Cost to advertiser per click. |
| CPM | NUMERIC | Cost per thousand impressions. |
| CTR | PERCENT | Click-through-rate for the ad. This is equal to the number of clicks divided by the number of impressions for the ad (e.g., how many times users clicked on one of the ads where that ad appeared). |
| Currency Code (googleanalytics) | TEXT | The local currency code (based on ISO 4217 standard) of the transaction. |
| Data driven conversions (All goals) | NUMERIC | The total data driven conversions for all goals. |
| Data driven revenue | NUMERIC | The total data driven revenue. |
| Data Source | TEXT | The data source of a hit. By default, hits sent from analytics.js are reported as "web" and hits sent from the mobile SDKs are reported as "app". These values can be overridden in the Measurement Protocol. |
| Date | DATE | The date of the session formatted as YYYYMMDD. |
| Hour of Day | TIMESTAMP | Combined values of ga:date and ga:hour formated as YYYYMMDDHH. |
| Date Hour and Minute | TIMESTAMP | Combined values of ga:date, ga:hour and ga:minute formated as YYYYMMDDHHMM. |
| Day of the month | TEXT | The day of the month, a two-digit number from 01 to 31. |
| Day of month | TEXT | Day of the month |
| Day of Week | TEXT | Day of the week, a one-digit number from 0 (Sunday) to 6 (Saturday). |
| Day of Week Name | TEXT | Name (in English) of the day of the week. |
| Days Since Last Session | TEXT | The number of days elapsed since users last visited the property, used to calculate user loyalty. |
| Days to Transaction | TEXT | The number of days between users' purchases and the most recent campaign source prior to the purchase. |
| Device Category | TEXT | The type of device: desktop, tablet, or mobile. |
| Domain Lookup Time (ms) | NUMERIC | The total time (in milliseconds) all samples spent in DNS lookup for this page. |
| Document Content Loaded Time (ms) | NUMERIC | The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document and execute deferred and parser-inserted scripts (DOMContentLoaded). When parsing of the document is finished, the Document Object Model (DOM) is ready, but the referenced style sheets, images, and subframes may not be finished loading. This is often the starting point of Javascript framework execution, e.g., JQuery's onready() callback. |
| Document Interactive Time (ms) | NUMERIC | The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document (DOMInteractive). At this time, users can interact with the Document Object Model even though it is not fully loaded. |
| DOM Latency Metrics Sample | NUMERIC | Sample set (or count) of pageviews used to calculate the averages for site speed DOM metrics. This metric is used to calculate ga:avgDomContentLoadedTime and ga:avgDomInteractiveTime. |
| Entrances / Pageviews | PERCENT | The percentage of pageviews in which this page was the entrance. |
| Entrances | NUMERIC | The number of entrances to the property measured as the first pageview in a session, typically used with landingPagePath. |
| Event Action | TEXT | Event action. |
| Event Category | TEXT | The event category. |
| Event Label | TEXT | Event label. |
| Events / Session with Event | NUMERIC | The average number of events per session with event. |
| Events / Session with Event (deprecated) | NUMERIC | The average number of events per session with event. |
| Event Value | NUMERIC | Total value of events for the profile. |
| Exit Page | TEXT | The last page or exit page in users' sessions. |
| % Exit | PERCENT | The percentage of exits from the property that occurred out of the total pageviews. |
| Exits | NUMERIC | The number of exits from the property. |
| First touch conversions (All goals) | NUMERIC | The total first touch conversions for all goals. |
| First touch revenue | NUMERIC | The total first touch revenue. |
| Flash Version | TEXT | The version of Flash, including minor versions, supported by users' browsers. |
| Full Referrer | TEXT | The full referring URL including the hostname and path. |
| Gender | TEXT | Gender of users. |
| Goal 10 Data driven Completions | TEXT | The total number of Data driven completions for Goal 10. |
| Goal 10 Data driven value | TEXT | The total Data driven value for Goal 10 |
| Goal 10 First touch Completions | TEXT | The total number of First touch completions for Goal 10. |
| Goal 10 First touch value | TEXT | The total First touch value for Goal 10 |
| Goal 10 Last touch Completions | TEXT | The total number of Last touch completions for Goal 10. |
| Goal 10 Last touch value | TEXT | The total Last touch value for Goal 10 |
| Goal 10 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 10. |
| Goal 10 Linear touch value | TEXT | The total Linear touch value for Goal 10 |
| Goal 10 Completions | NUMERIC | The total number of completions for Goal 10. |
| Goal 10 Value | NUMERIC | The total numeric value for Goal 10. |
| Goal 11 Data driven Completions | TEXT | The total number of Data driven completions for Goal 11. |
| Goal 11 Data driven value | TEXT | The total Data driven value for Goal 11 |
| Goal 11 First touch Completions | TEXT | The total number of First touch completions for Goal 11. |
| Goal 11 First touch value | TEXT | The total First touch value for Goal 11 |
| Goal 11 Last touch Completions | TEXT | The total number of Last touch completions for Goal 11. |
| Goal 11 Last touch value | TEXT | The total Last touch value for Goal 11 |
| Goal 11 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 11. |
| Goal 11 Linear touch value | TEXT | The total Linear touch value for Goal 11 |
| Goal 11 Completions | NUMERIC | The total number of completions for Goal 11. |
| Goal 11 Value | NUMERIC | The total numeric value for Goal 11. |
| Goal 12 Data driven Completions | TEXT | The total number of Data driven completions for Goal 12. |
| Goal 12 Data driven value | TEXT | The total Data driven value for Goal 12 |
| Goal 12 First touch Completions | TEXT | The total number of First touch completions for Goal 12. |
| Goal 12 First touch value | TEXT | The total First touch value for Goal 12 |
| Goal 12 Last touch Completions | TEXT | The total number of Last touch completions for Goal 12. |
| Goal 12 Last touch value | TEXT | The total Last touch value for Goal 12 |
| Goal 12 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 12. |
| Goal 12 Linear touch value | TEXT | The total Linear touch value for Goal 12 |
| Goal 12 Completions | NUMERIC | The total number of completions for Goal 12. |
| Goal 12 Value | NUMERIC | The total numeric value for Goal 12. |
| Goal 13 Data driven Completions | TEXT | The total number of Data driven completions for Goal 13. |
| Goal 13 Data driven value | TEXT | The total Data driven value for Goal 13 |
| Goal 13 First touch Completions | TEXT | The total number of First touch completions for Goal 13. |
| Goal 13 First touch value | TEXT | The total First touch value for Goal 13 |
| Goal 13 Last touch Completions | TEXT | The total number of Last touch completions for Goal 13. |
| Goal 13 Last touch value | TEXT | The total Last touch value for Goal 13 |
| Goal 13 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 13. |
| Goal 13 Linear touch value | TEXT | The total Linear touch value for Goal 13 |
| Goal 13 Completions | NUMERIC | The total number of completions for Goal 13. |
| Goal 13 Value | NUMERIC | The total numeric value for Goal 13. |
| Goal 14 Data driven Completions | TEXT | The total number of Data driven completions for Goal 14. |
| Goal 14 Data driven value | TEXT | The total Data driven value for Goal 14 |
| Goal 14 First touch Completions | TEXT | The total number of First touch completions for Goal 14. |
| Goal 14 First touch value | TEXT | The total First touch value for Goal 14 |
| Goal 14 Last touch Completions | TEXT | The total number of Last touch completions for Goal 14. |
| Goal 14 Last touch value | TEXT | The total Last touch value for Goal 14 |
| Goal 14 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 14. |
| Goal 14 Linear touch value | TEXT | The total Linear touch value for Goal 14 |
| Goal 14 Completions | NUMERIC | The total number of completions for Goal 14. |
| Goal 14 Value | NUMERIC | The total numeric value for Goal 14. |
| Goal 15 Data driven Completions | TEXT | The total number of Data driven completions for Goal 15. |
| Goal 15 Data driven value | TEXT | The total Data driven value for Goal 15 |
| Goal 15 First touch Completions | TEXT | The total number of First touch completions for Goal 15. |
| Goal 15 First touch value | TEXT | The total First touch value for Goal 15 |
| Goal 15 Last touch Completions | TEXT | The total number of Last touch completions for Goal 15. |
| Goal 15 Last touch value | TEXT | The total Last touch value for Goal 15 |
| Goal 15 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 15. |
| Goal 15 Linear touch value | TEXT | The total Linear touch value for Goal 15 |
| Goal 15 Completions | NUMERIC | The total number of completions for Goal 15. |
| Goal 15 Value | NUMERIC | The total numeric value for Goal 15. |
| Goal 16 Data driven Completions | TEXT | The total number of Data driven completions for Goal 16. |
| Goal 16 Data driven value | TEXT | The total Data driven value for Goal 16 |
| Goal 16 First touch Completions | TEXT | The total number of First touch completions for Goal 16. |
| Goal 16 First touch value | TEXT | The total First touch value for Goal 16 |
| Goal 16 Last touch Completions | TEXT | The total number of Last touch completions for Goal 16. |
| Goal 16 Last touch value | TEXT | The total Last touch value for Goal 16 |
| Goal 16 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 16. |
| Goal 16 Linear touch value | TEXT | The total Linear touch value for Goal 16 |
| Goal 16 Completions | NUMERIC | The total number of completions for Goal 16. |
| Goal 16 Value | NUMERIC | The total numeric value for Goal 16. |
| Goal 17 Data driven Completions | TEXT | The total number of Data driven completions for Goal 17. |
| Goal 17 Data driven value | TEXT | The total Data driven value for Goal 17 |
| Goal 17 First touch Completions | TEXT | The total number of First touch completions for Goal 17. |
| Goal 17 First touch value | TEXT | The total First touch value for Goal 17 |
| Goal 17 Last touch Completions | TEXT | The total number of Last touch completions for Goal 17. |
| Goal 17 Last touch value | TEXT | The total Last touch value for Goal 17 |
| Goal 17 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 17. |
| Goal 17 Linear touch value | TEXT | The total Linear touch value for Goal 17 |
| Goal 17 Completions | NUMERIC | The total number of completions for Goal 17. |
| Goal 17 Value | NUMERIC | The total numeric value for Goal 17. |
| Goal 18 Data driven Completions | TEXT | The total number of Data driven completions for Goal 18. |
| Goal 18 Data driven value | TEXT | The total Data driven value for Goal 18 |
| Goal 18 First touch Completions | TEXT | The total number of First touch completions for Goal 18. |
| Goal 18 First touch value | TEXT | The total First touch value for Goal 18 |
| Goal 18 Last touch Completions | TEXT | The total number of Last touch completions for Goal 18. |
| Goal 18 Last touch value | TEXT | The total Last touch value for Goal 18 |
| Goal 18 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 18. |
| Goal 18 Linear touch value | TEXT | The total Linear touch value for Goal 18 |
| Goal 18 Completions | NUMERIC | The total number of completions for Goal 18. |
| Goal 18 Value | NUMERIC | The total numeric value for Goal 18. |
| Goal 19 Data driven Completions | TEXT | The total number of Data driven completions for Goal 19. |
| Goal 19 Data driven value | TEXT | The total Data driven value for Goal 19 |
| Goal 19 First touch Completions | TEXT | The total number of First touch completions for Goal 19. |
| Goal 19 First touch value | TEXT | The total First touch value for Goal 19 |
| Goal 19 Last touch Completions | TEXT | The total number of Last touch completions for Goal 19. |
| Goal 19 Last touch value | TEXT | The total Last touch value for Goal 19 |
| Goal 19 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 19. |
| Goal 19 Linear touch value | TEXT | The total Linear touch value for Goal 19 |
| Goal 19 Completions | NUMERIC | The total number of completions for Goal 19. |
| Goal 19 Value | NUMERIC | The total numeric value for Goal 19. |
| Goal 1 Data driven Completions | TEXT | The total number of Data driven completions for Goal 1. |
| Goal 1 Data driven value | TEXT | The total Data driven value for Goal 1 |
| Goal 1 First touch Completions | TEXT | The total number of First touch completions for Goal 1. |
| Goal 1 First touch value | TEXT | The total First touch value for Goal 1 |
| Goal 1 Last touch Completions | TEXT | The total number of Last touch completions for Goal 1. |
| Goal 1 Last touch value | TEXT | The total Last touch value for Goal 1 |
| Goal 1 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 1. |
| Goal 1 Linear touch value | TEXT | The total Linear touch value for Goal 1 |
| Goal 1 Completions | NUMERIC | The total number of completions for Goal 1. |
| Goal 1 Value | NUMERIC | The total numeric value for Goal 1. |
| Goal 20 Data driven Completions | TEXT | The total number of Data driven completions for Goal 20. |
| Goal 20 Data driven value | TEXT | The total Data driven value for Goal 20 |
| Goal 20 First touch Completions | TEXT | The total number of First touch completions for Goal 20. |
| Goal 20 First touch value | TEXT | The total First touch value for Goal 20 |
| Goal 20 Last touch Completions | TEXT | The total number of Last touch completions for Goal 20. |
| Goal 20 Last touch value | TEXT | The total Last touch value for Goal 20 |
| Goal 20 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 20. |
| Goal 20 Linear touch value | TEXT | The total Linear touch value for Goal 20 |
| Goal 20 Completions | NUMERIC | The total number of completions for Goal 20. |
| Goal 20 Value | NUMERIC | The total numeric value for Goal 20. |
| Goal 2 Data driven Completions | TEXT | The total number of Data driven completions for Goal 2. |
| Goal 2 Data driven value | TEXT | The total Data driven value for Goal 2 |
| Goal 2 First touch Completions | TEXT | The total number of First touch completions for Goal 2. |
| Goal 2 First touch value | TEXT | The total First touch value for Goal 2 |
| Goal 2 Last touch Completions | TEXT | The total number of Last touch completions for Goal 2. |
| Goal 2 Last touch value | TEXT | The total Last touch value for Goal 2 |
| Goal 2 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 2. |
| Goal 2 Linear touch value | TEXT | The total Linear touch value for Goal 2 |
| Goal 2 Completions | NUMERIC | The total number of completions for Goal 2. |
| Goal 2 Value | NUMERIC | The total numeric value for Goal 2. |
| Goal 3 Data driven Completions | TEXT | The total number of Data driven completions for Goal 3. |
| Goal 3 Data driven value | TEXT | The total Data driven value for Goal 3 |
| Goal 3 First touch Completions | TEXT | The total number of First touch completions for Goal 3. |
| Goal 3 First touch value | TEXT | The total First touch value for Goal 3 |
| Goal 3 Last touch Completions | TEXT | The total number of Last touch completions for Goal 3. |
| Goal 3 Last touch value | TEXT | The total Last touch value for Goal 3 |
| Goal 3 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 3. |
| Goal 3 Linear touch value | TEXT | The total Linear touch value for Goal 3 |
| Goal 3 Completions | NUMERIC | The total number of completions for Goal 3. |
| Goal 3 Value | NUMERIC | The total numeric value for Goal 3. |
| Goal 4 Data driven Completions | TEXT | The total number of Data driven completions for Goal 4. |
| Goal 4 Data driven value | TEXT | The total Data driven value for Goal 4 |
| Goal 4 First touch Completions | TEXT | The total number of First touch completions for Goal 4. |
| Goal 4 First touch value | TEXT | The total First touch value for Goal 4 |
| Goal 4 Last touch Completions | TEXT | The total number of Last touch completions for Goal 4. |
| Goal 4 Last touch value | TEXT | The total Last touch value for Goal 4 |
| Goal 4 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 4. |
| Goal 4 Linear touch value | TEXT | The total Linear touch value for Goal 4 |
| Goal 4 Completions | NUMERIC | The total number of completions for Goal 4. |
| Goal 4 Value | NUMERIC | The total numeric value for Goal 4. |
| Goal 5 Data driven Completions | TEXT | The total number of Data driven completions for Goal 5. |
| Goal 5 Data driven value | TEXT | The total Data driven value for Goal 5 |
| Goal 5 First touch Completions | TEXT | The total number of First touch completions for Goal 5. |
| Goal 5 First touch value | TEXT | The total First touch value for Goal 5 |
| Goal 5 Last touch Completions | TEXT | The total number of Last touch completions for Goal 5. |
| Goal 5 Last touch value | TEXT | The total Last touch value for Goal 5 |
| Goal 5 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 5. |
| Goal 5 Linear touch value | TEXT | The total Linear touch value for Goal 5 |
| Goal 5 Completions | NUMERIC | The total number of completions for Goal 5. |
| Goal 5 Value | NUMERIC | The total numeric value for Goal 5. |
| Goal 6 Data driven Completions | TEXT | The total number of Data driven completions for Goal 6. |
| Goal 6 Data driven value | TEXT | The total Data driven value for Goal 6 |
| Goal 6 First touch Completions | TEXT | The total number of First touch completions for Goal 6. |
| Goal 6 First touch value | TEXT | The total First touch value for Goal 6 |
| Goal 6 Last touch Completions | TEXT | The total number of Last touch completions for Goal 6. |
| Goal 6 Last touch value | TEXT | The total Last touch value for Goal 6 |
| Goal 6 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 6. |
| Goal 6 Linear touch value | TEXT | The total Linear touch value for Goal 6 |
| Goal 6 Completions | NUMERIC | The total number of completions for Goal 6. |
| Goal 6 Value | NUMERIC | The total numeric value for Goal 6. |
| Goal 7 Data driven Completions | TEXT | The total number of Data driven completions for Goal 7. |
| Goal 7 Data driven value | TEXT | The total Data driven value for Goal 7 |
| Goal 7 First touch Completions | TEXT | The total number of First touch completions for Goal 7. |
| Goal 7 First touch value | TEXT | The total First touch value for Goal 7 |
| Goal 7 Last touch Completions | TEXT | The total number of Last touch completions for Goal 7. |
| Goal 7 Last touch value | TEXT | The total Last touch value for Goal 7 |
| Goal 7 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 7. |
| Goal 7 Linear touch value | TEXT | The total Linear touch value for Goal 7 |
| Goal 7 Completions | NUMERIC | The total number of completions for Goal 7. |
| Goal 7 Value | NUMERIC | The total numeric value for Goal 7. |
| Goal 8 Data driven Completions | TEXT | The total number of Data driven completions for Goal 8. |
| Goal 8 Data driven value | TEXT | The total Data driven value for Goal 8 |
| Goal 8 First touch Completions | TEXT | The total number of First touch completions for Goal 8. |
| Goal 8 First touch value | TEXT | The total First touch value for Goal 8 |
| Goal 8 Last touch Completions | TEXT | The total number of Last touch completions for Goal 8. |
| Goal 8 Last touch value | TEXT | The total Last touch value for Goal 8 |
| Goal 8 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 8. |
| Goal 8 Linear touch value | TEXT | The total Linear touch value for Goal 8 |
| Goal 8 Completions | NUMERIC | The total number of completions for Goal 8. |
| Goal 8 Value | NUMERIC | The total numeric value for Goal 8. |
| Goal 9 Data driven Completions | TEXT | The total number of Data driven completions for Goal 9. |
| Goal 9 Data driven value | TEXT | The total Data driven value for Goal 9 |
| Goal 9 First touch Completions | TEXT | The total number of First touch completions for Goal 9. |
| Goal 9 First touch value | TEXT | The total First touch value for Goal 9 |
| Goal 9 Last touch Completions | TEXT | The total number of Last touch completions for Goal 9. |
| Goal 9 Last touch value | TEXT | The total Last touch value for Goal 9 |
| Goal 9 Linear touch Completions | TEXT | The total number of Linear touch completions for Goal 9. |
| Goal 9 Linear touch value | TEXT | The total Linear touch value for Goal 9 |
| Goal 9 Completions | NUMERIC | The total number of completions for Goal 9. |
| Goal 9 Value | NUMERIC | The total numeric value for Goal 9. |
| Total Abandonment Rate | PERCENT | Goal abandonment rate. |
| Abandoned Funnels | NUMERIC | The overall number of times users started goals without actually completing them. |
| Goal Completion Location | TEXT | The page path or screen name that matched any destination type goal completion. |
| Goal Completions | NUMERIC | Total number of completions for all goals defined in the profile. |
| Goal Conversion Rate | PERCENT | The percentage of sessions which resulted in a conversion to at least one of the goals. |
| Goal Previous Step - 1 | TEXT | The page path or screen name that matched any destination type goal, one step prior to the goal completion location. |
| Goal Previous Step - 2 | TEXT | The page path or screen name that matched any destination type goal, two steps prior to the goal completion location. |
| Goal Previous Step - 3 | TEXT | The page path or screen name that matched any destination type goal, three steps prior to the goal completion location. |
| Goal Starts | NUMERIC | Total number of starts for all goals defined in the profile. |
| Goal Value | NUMERIC | Total numeric value for all goals defined in the profile. |
| Per Search Goal Value | NUMERIC | The average goal value of a search. |
| Per Session Goal Value | NUMERIC | The average goal value of a session. |
| Per Session Goal Value (deprecated) | NUMERIC | The average goal value of a session. |
| Social Source Referral | TEXT | A boolean, either Yes or No, indicates whether sessions to the property are from a social source. |
| Hits | NUMERIC | Total number of hits for the view (profile). This metric sums all hit types, including pageview, custom event, ecommerce, and other types. Because this metric is based on the view (profile), not on the property, it is not the same as the property's hit volume. |
| Hostname | TEXT | The hostname from which the tracking request was made. |
| Hour | TEXT | A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. If the timezone follows daylight savings time, there will be an apparent bump in the number of sessions during the changeover hour (e.g., between 1:00 and 2:00) for the day per year when that hour repeats. A corresponding hour with zero sessions will occur at the opposite changeover. (Google Analytics does not track user time more precisely than hours.) |
| Impressions | NUMERIC | Total number of campaign impressions. |
| Affinity Category (reach) | TEXT | Indicates that users are more likely to be interested in learning about the specified category. |
| In-Market Segment | TEXT | Indicates that users are more likely to be ready to purchase products or services in the specified category. |
| Other Category | TEXT | Indicates that users are more likely to be interested in learning about the specified category, and more likely to be ready to purchase. |
| Internal Promotion Clicks | NUMERIC | The number of clicks on an internal promotion (Enhanced Ecommerce). |
| Internal Promotion Creative | TEXT | The creative content designed for a promotion (Enhanced Ecommerce). |
| Internal Promotion CTR | PERCENT | The rate at which users clicked through to view the internal promotion (ga:internalPromotionClicks / ga:internalPromotionViews) - (Enhanced Ecommerce). |
| Internal Promotion ID | TEXT | The ID of the promotion (Enhanced Ecommerce). |
| Internal Promotion Name | TEXT | The name of the promotion (Enhanced Ecommerce). |
| Internal Promotion Position | TEXT | The position of the promotion on the web page or application screen (Enhanced Ecommerce). |
| Internal Promotion Views | NUMERIC | The number of views of an internal promotion (Enhanced Ecommerce). |
| ISO Week of the Year | TEXT | ISO week number, where each week starts on Monday. For details, see http://en.wikipedia.org/wiki/ISO_week_date. ga:isoWeek should only be used with ga:isoYear because ga:year represents Gregorian calendar. |
| ISO Year | TEXT | The ISO year of the session. For details, see http://en.wikipedia.org/wiki/ISO_week_date. ga:isoYear should only be used with ga:isoWeek because ga:week represents Gregorian calendar. |
| ISO Week of ISO Year | TEXT | Combined values of ga:isoYear and ga:isoWeek. |
| TrueView Video Ad | TEXT | A boolean, Yes or No, indicating whether the ad is an AdWords TrueView video ad. |
| Quantity | NUMERIC | Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7. |
| Product Revenue | NUMERIC | The total revenue from purchased product items. |
| Avg. QTY | NUMERIC | The average quantity of this item (or group of items) sold per purchase. |
| Java Support | TEXT | A boolean, either Yes or No, indicating whether Java is enabled in users' browsers. |
| Keyword | TEXT | For manual campaign tracking, it is the value of the utm_term campaign tracking parameter. For AdWords traffic, it contains the best matching targeting criteria. For the display network, where multiple targeting criteria could have caused the ad to show up, it returns the best matching targeting criteria as selected by Ads. This could be display_keyword, site placement, boomuserlist, user_interest, age, or gender. Otherwise its value is (not set). |
| Landing Page Path | TEXT | The first page in users' sessions, or the landing page. |
| Language | TEXT | The language, in ISO-639 code format (e.g., en-gb for British English), provided by the HTTP Request for the browser. |
| Last touch conversions (All goals) | NUMERIC | The total last touch conversions for all goals. |
| Last touch revenue | NUMERIC | The total last touch revenue. |
| Latitude | TEXT | The approximate latitude of users' city, derived from their IP addresses or Geographical IDs. Locations north of the equator have positive latitudes and locations south of the equator have negative latitudes. |
| Linear touch conversions (All goals) | NUMERIC | The total linear touch conversions for all goals. |
| Linear touch revenue | NUMERIC | The total linear touch revenue. |
| Local Product Revenue | NUMERIC | Product revenue in local currency. |
| Local Product Refund Amount | NUMERIC | Refund amount in local currency for a given product (Enhanced Ecommerce). |
| Local Refund Amount | NUMERIC | Total refund amount in local currency for the transaction (Enhanced Ecommerce). |
| Local Revenue | NUMERIC | Transaction revenue in local currency. |
| Local Shipping | NUMERIC | Transaction shipping cost in local currency. |
| Local Tax | NUMERIC | Transaction tax in local currency. |
| Longitude | TEXT | The approximate longitude of users' city, derived from their IP addresses or Geographical IDs. Locations east of the prime meridian have positive longitudes and locations west of the prime meridian have negative longitudes. |
| Medium | TEXT | The type of referrals. For manual campaign tracking, it is the value of the utm_medium campaign tracking parameter. For AdWords autotagging, it is cpc. If users came from a search engine detected by Google Analytics, it is organic. If the referrer is not a search engine, it is referral. If users came directly to the property and document.referrer is empty, its value is (none). |
| Metro | TEXT | The Designated Market Area (DMA) from where traffic arrived. |
| Metro Id | TEXT | The three digit Designated Market Area (DMA) code from where traffic arrived, derived from users' IP addresses or Geographical IDs. |
| Minute | TEXT | Returns the minutes, between 00 and 59, in the hour. |
| Mobile Device Branding | TEXT | Mobile manufacturer or branded name. |
| Mobile Device Info | TEXT | The branding, model, and marketing name used to identify the mobile device. |
| Mobile Device Marketing Name | TEXT | The marketing name used for the mobile device. |
| Mobile Device Model | TEXT | Mobile device model. |
| Mobile Input Selector | TEXT | Selector (e.g., touchscreen, joystick, clickwheel, stylus) used on the mobile device. |
| Month of the year | TEXT | Month of the session, a two digit integer from 01 to 12. |
| Network Domain | TEXT | The domain name of users' ISP, derived from the domain name registered to the ISP's IP address. |
| Service Provider | TEXT | The names of the service providers used to reach the property. For example, if most users of the website come via the major cable internet service providers, its value will be these service providers' names. |
| New Users | NUMERIC | The number of sessions marked as a user's first sessions. |
| New Users (deprecated) | NUMERIC | The number of sessions marked as a user's first sessions. |
| Day Index | TEXT | The index for each day in the specified date range. The index for the first day (i.e., start-date) in the date range is 0, for the second day 1, and so on. |
| Hour Index | TEXT | The index for each hour in the specified date range. The index for the first hour of the first day (i.e., start-date) in the date range is 0, for the next hour 1, and so on. |
| Minute Index | TEXT | The index for each minute in the specified date range. The index for the first minute of the first day (i.e., start-date) in the date range is 0, for the next minute 1, and so on. |
| Month Index | TEXT | The index for a month in the specified date range. In the date range, the index for the first month is 0, for the second month 1, and so on. |
| Week Index | TEXT | The index for each week in the specified date range. The index for the first week in the date range is 0, for the second week 1, and so on. The index corresponds to week entries. |
| Operating System | TEXT | Users' operating system, for example, Windows, Linux, Macintosh, or iOS. |
| Operating System Version | TEXT | The version of users' operating system, i.e., XP for Windows, PPC for Macintosh. |
| Order Coupon Code | TEXT | Code for the order-level coupon (Enhanced Ecommerce). |
| Organic Searches | NUMERIC | The number of organic searches happened in a session. This metric is search engine agnostic. |
| Page Depth | TEXT | The number of pages visited by users during a session. The value is a histogram that counts pageviews across a range of possible values. In this calculation, all sessions will have at least one pageview, and some percentage of sessions will have more. |
| Page Download Time (ms) | NUMERIC | The total time (in milliseconds) to download this page among all samples. |
| Page Load Sample | NUMERIC | The sample set (or count) of pageviews used to calculate the average page load time. |
| Page Load Time (ms) | NUMERIC | Total time (in milliseconds), from pageview initiation (e.g., a click on a page link) to page load completion in the browser, the pages in the sample set take to load. |
| Page Path | TEXT | A page on the website specified by path and/or query parameters. Use this with hostname to get the page's full URL. |
| Page path level 1 | TEXT | This dimension rolls up all the page paths in the first hierarchical level in pagePath. |
| Page path level 2 | TEXT | This dimension rolls up all the page paths in the second hierarchical level in pagePath. |
| Page path level 3 | TEXT | This dimension rolls up all the page paths in the third hierarchical level in pagePath. |
| Page path level 4 | TEXT | This dimension rolls up all the page paths into hierarchical levels. Up to 4 pagePath levels maybe specified. All additional levels in the pagePath hierarchy are also rolled up in this dimension. |
| Page Title | TEXT | The page's title. Multiple pages might have the same page title. |
| Page Value | NUMERIC | The average value of this page or set of pages, which is equal to (ga:transactionRevenue + ga:goalValueAll) / ga:uniquePageviews. |
| Pageviews | NUMERIC | The total number of pageviews for the property. |
| Pages / Session | NUMERIC | The average number of pages viewed during a session, including repeated views of a single page. |
| Pages / Session (deprecated) | NUMERIC | The average number of pages viewed during a session, including repeated views of a single page. |
| % New Sessions | PERCENT | The percentage of sessions by users who had never visited the property before. |
| % New Sessions (deprecated) | PERCENT | The percentage of sessions by users who had never visited the property before. |
| % Search Refinements | PERCENT | The percentage of the number of times a refinement (i.e., transition) occurs between internal keywords search within a session. |
| % Sessions with Search | PERCENT | The percentage of sessions with search. |
| % Sessions with Search (deprecated) | PERCENT | The percentage of sessions with search. |
| Previous Page Path | TEXT | A page visited before another page on the same property, typically used with the pagePath dimension. |
| Product Adds To Cart | NUMERIC | Number of times the product was added to the shopping cart (Enhanced Ecommerce). |
| Product Category | TEXT | Any product variation (size, color) supplied by the ecommerce application for purchased items, not compatible with Enhanced Ecommerce. |
| Product Checkouts | NUMERIC | Number of times the product was included in the check-out process (Enhanced Ecommerce). |
| Product Detail Views | NUMERIC | Number of times users viewed the product-detail page (Enhanced Ecommerce). |
| Product List Clicks | NUMERIC | Number of times users clicked the product when it appeared in the product list (Enhanced Ecommerce). |
| Product List CTR | PERCENT | The rate at which users clicked through on the product in a product list (ga:productListClicks / ga:productListViews) - (Enhanced Ecommerce). |
| Product List Views | NUMERIC | Number of times the product appeared in a product list (Enhanced Ecommerce). |
| Product | TEXT | The product name, supplied by the ecommerce tracking application, for purchased items. |
| Product Refund Amount | NUMERIC | Total refund amount associated with the product (Enhanced Ecommerce). |
| Product Refunds | NUMERIC | Number of times a refund was issued for the product (Enhanced Ecommerce). |
| Product Removes From Cart | NUMERIC | Number of times the product was removed from the shopping cart (Enhanced Ecommerce). |
| Product Revenue per Purchase | NUMERIC | Average product revenue per purchase (commonly used with Product Coupon Code) (ga:itemRevenue / ga:uniquePurchases) - (Enhanced Ecommerce). |
| Product SKU | TEXT | The product SKU, defined in the ecommerce tracking application, for purchased items. |
| Google Analytics view (profile) ID (alias) | TEXT | Alias for Google Analytics view (profile) ID |
| Google Analytics view (profile) name (alias) | TEXT | Alias for Google Analytics view (profile) name |
| Quantity Added To Cart | NUMERIC | Number of product units added to the shopping cart (Enhanced Ecommerce). |
| Quantity Checked Out | NUMERIC | Number of product units included in check out (Enhanced Ecommerce). |
| Quantity Refunded | NUMERIC | Number of product units refunded (Enhanced Ecommerce). |
| Quantity Removed From Cart | NUMERIC | Number of product units removed from a shopping cart (Enhanced Ecommerce). |
| Redirection Time (ms) | NUMERIC | The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0. |
| Referral Path | TEXT | The path of the referring URL (e.g., document.referrer). If someone places on their webpage a link to the property, this is the path of the page containing the referring link. |
| Refund Amount | NUMERIC | Currency amount refunded for a transaction (Enhanced Ecommerce). |
| Region | REGION | Users' region, derived from their IP addresses or Geographical IDs. In U.S., a region is a state, New York, for example. |
| Region ID | TEXT | Users' region ID, derived from their IP addresses or Geographical IDs. In U.S., a region is a state, New York, for example. The region IDs are the same as the Criteria IDs listed at https://developers.google.com/analytics/devguides/collection/protocol/v1/geoid. |
| Region ISO Code | REGION | Users' region ISO code in ISO-3166-2 format, derived from their IP addresses or Geographical IDs. |
| Avg. Price | NUMERIC | The average revenue per item. |
| Avg. Order Value | NUMERIC | The average revenue of an ecommerce transaction. |
| Revenue per User | NUMERIC | The total sale revenue (excluding shipping and tax) of the transaction divided by the total number of users. |
| ROAS | PERCENT | Return On Ad Spend (ROAS) is the total transaction revenue and goal value divided by derived advertising cost. |
| RPC | NUMERIC | RPC or revenue-per-click, the average revenue (from ecommerce sales and/or goal value) you received for each click on one of the search ads. |
| Screen Colors | TEXT | The color depth of users' monitors, retrieved from the DOM of users' browsers. For example, 4-bit, 8-bit, 24-bit, or undefined-bit. |
| Screen Resolution | TEXT | Resolution of users' screens, for example, 1024x738. |
| Search Depth | NUMERIC | The total number of subsequent page views made after a use of the site's internal search feature. |
| Destination Page | TEXT | The page users immediately visited after performing an internal search on the site. This is usually the search results page. |
| Time after Search | NUMERIC | The session duration when the site's internal search feature is used. |
| % Search Exits | PERCENT | The percentage of searches that resulted in an immediate exit from the property. |
| Search Exits | NUMERIC | The number of exits on the site that occurred following a search result from the site's internal search feature. |
| Site Search Goal Conversion Rate | PERCENT | The percentage of search sessions (i.e., sessions that included at least one search) which resulted in a conversion to at least one of the goals. |
| Search Refinements | NUMERIC | The total number of times a refinement (transition) occurs between internal keywords search within a session. For example, if the sequence of keywords is "shoes", "shoes", "pants", "pants", this metric will be one because the transition between "shoes" and "pants" is different. |
| Results Pageviews | NUMERIC | The number of times a search result page was viewed. |
| Sessions with Search | NUMERIC | The total number of sessions that included an internal search. |
| Total Unique Searches | NUMERIC | Total number of unique keywords from internal searches within a session. For example, if "shoes" was searched for 3 times in a session, it would be counted only once. |
| Site Search Status | TEXT | A boolean, either Visits With Site Search or Visits Without Site Search, to distinguish whether internal search was used in a session. |
| Sessions with Search (deprecated) | NUMERIC | The total number of sessions that included an internal search. |
| Second Page | TEXT | The second page in users' sessions. |
| Server Connection Time (ms) | NUMERIC | Total time (in milliseconds) all samples spent in establishing a TCP connection to this page. |
| Server Response Time (ms) | NUMERIC | The total time (in milliseconds) the site's server takes to respond to users' requests among all samples; this includes the network time from users' locations to the server. |
| Count of Sessions | TEXT | The session index for a user. Each session from a unique user will get its own incremental index starting from 1 for the first session. Subsequent sessions do not change previous session indices. For example, if a user has 4 sessions to the website, sessionCount for that user will have 4 distinct values of '1' through '4'. |
| Session Duration | NUMERIC | Total duration (in seconds) of users' sessions. |
| The Length of Session | TEXT | The length (returned as a string) of a session measured in seconds and reported in second increments. |
| Sessions | NUMERIC | The total number of sessions. |
| Number of Sessions per User | NUMERIC | The total number of sessions divided by the total number of users. |
| Sessions to Transaction | TEXT | The number of sessions between users' purchases and the related campaigns that lead to the purchases. |
| Sessions with Event | NUMERIC | The total number of sessions with events. |
| Shopping Stage | TEXT | Various stages of the shopping experience that users completed in a session, e.g., PRODUCT_VIEW, ADD_TO_CART, CHECKOUT, etc. (Enhanced Ecommerce). |
| Social Network | TEXT | The social network name. This is related to the referring social network for traffic sources; e.g., Google+, Blogger. |
| Source | TEXT | The source of referrals. For manual campaign tracking, it is the value of the utm_source campaign tracking parameter. For AdWords autotagging, it is google. If you use neither, it is the domain of the source (e.g., document.referrer) referring the users. It may also contain a port address. If users arrived without a referrer, its value is (direct). |
| Source / Medium | TEXT | Combined values of ga:source and ga:medium. |
| Speed Metrics Sample | NUMERIC | The sample set (or count) of pageviews used to calculate the averages of site speed metrics. This metric is used in all site speed average calculations, including avgDomainLookupTime, avgPageDownloadTime, avgRedirectionTime, avgServerConnectionTime, and avgServerResponseTime. |
| Sub Continent | TEXT | Users' sub-continent, derived from their IP addresses or Geographical IDs. For example, Polynesia or Northern Europe. |
| Sub Continent Code | TEXT | Users' sub-continent code in UN M.49 format, derived from their IP addresses or Geographical IDs. For example, 061 for Polynesia, 154 for Northern Europe. |
| Time on Page | NUMERIC | Time (in seconds) users spent on a particular page, calculated by subtracting the initial view time for a particular page from the initial view time for a subsequent page. This metric does not apply to exit pages of the property. |
| Today | DATE | Today's date |
| Total Events | NUMERIC | The total number of events for the profile, across all categories. |
| Publisher Clicks | NUMERIC | The number of times ads from a linked publisher account (AdSense, AdX, DFP) were clicked on the site. |
| Publisher Coverage | PERCENT | Coverage is the percentage of ad requests that returned at least one ad. Generally, coverage can help you identify sites where the publisher account (AdSense, AdX, DFP) isn't able to provide targeted ads. (Ad Impressions / Total Ad Requests) * 100 |
| Publisher CTR | PERCENT | The percentage of pageviews that resulted in a click on a linked publisher account (AdSense, AdX, DFP) ad. |
| Publisher eCPM | NUMERIC | The effective cost per thousand pageviews. It is the total estimated revenue from all linked publisher accounts (AdSense, AdX, DFP) per 1,000 pageviews. |
| Publisher Impressions | NUMERIC | An ad impression is reported whenever an individual ad is displayed on the website. For example, if a page with two ad units is viewed once, we'll display two impressions. |
| Publisher Impressions / Session | NUMERIC | The ratio of linked publisher account (AdSense, AdX, DFP) ad impressions to Analytics sessions (Ad Impressions / Analytics Sessions). |
| Publisher Monetized Pageviews | NUMERIC | This measures the total number of pageviews on the property that were shown with an ad from one of the linked publisher accounts (AdSense, AdX, DFP). Note that a single page can have multiple ad units. |
| Publisher Revenue | NUMERIC | The total estimated revenue from all linked publisher account (AdSense, AdX, DFP) ads. |
| Publisher Revenue / 1000 Sessions | NUMERIC | The total estimated revenue from all linked publisher accounts (AdSense, AdX, DFP) per 1,000 Analytics sessions. |
| Publisher Viewable Impressions % | PERCENT | The percentage of viewable ad impressions. An impression is considered a viewable impression when it has appeared within users' browsers and has the opportunity to be seen. |
| Refunds | NUMERIC | Number of refunds that have been issued (Enhanced Ecommerce). |
| Total Value | NUMERIC | Total value for the property (including total revenue and total goal value). |
| Transaction ID | TEXT | The transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart. |
| Transaction Revenue | NUMERIC | The total sale revenue (excluding shipping and tax) of the transaction. |
| Per Session Value | NUMERIC | Average transaction revenue for a session. |
| Per Session Value (deprecated) | NUMERIC | Average transaction revenue for a session. |
| Transactions | NUMERIC | The total number of transactions. |
| Shipping | NUMERIC | The total cost of shipping. |
| Ecommerce Conversion Rate | PERCENT | The average number of transactions in a session. |
| Transactions per User | NUMERIC | Total number of transactions divided by total number of users. |
| Ecommerce Conversion Rate (deprecated) | PERCENT | The average number of transactions in a session. |
| Tax | NUMERIC | Total tax for the transaction. |
| Unique Dimension Combinations | NUMERIC | Unique Dimension Combinations counts the number of unique dimension-value combinations for each dimension in a report. This lets you build combined (concatenated) dimensions post-processing, which allows for more flexible reporting without having to update your tracking implementation or use additional custom-dimension slots. For more information, see https://support.google.com/analytics/answer/7084499. |
| Unique Events | NUMERIC | The number of unique events. Events in different sessions are counted as separate events. |
| Unique Pageviews | NUMERIC | Unique Pageviews is the number of sessions during which the specified page was viewed at least once. A unique pageview is counted for each page URL + page title combination. |
| Unique Purchases | NUMERIC | The number of product sets purchased. For example, if users purchase 2 frisbees and 5 tennis balls from the site, this will be 2. |
| Age bracket | TEXT | Age bracket of users. |
| User Bucket | TEXT | Randomly assigned users tag to allow A/B testing and splitting of remarketing lists. Ranges from 1-100. |
| User Defined Value | TEXT | The value provided when defining custom user segments for the property. |
| Users | NUMERIC | The total number of users for the requested time period. |
| User Type | TEXT | A boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning. |
| Google Analytics view (profile) ID | TEXT | Google Analytics view (profile) ID |
| Google Analytics view (profile) name | TEXT | Google Analytics view (profile) name |
| Bounce Rate (deprecated) | PERCENT | The percentage of single-page session (i.e., session in which the person left the property from the first page). |
| Count of Sessions (deprecated) | TEXT | The session index for a user. Each session from a unique user will get its own incremental index starting from 1 for the first session. Subsequent sessions do not change previous session indices. For example, if a user has 4 sessions to the website, sessionCount for that user will have 4 distinct values of '1' through '4'. |
| Session Duration (deprecated) | TEXT | The length (returned as a string) of a session measured in seconds and reported in second increments. |
| Age (deprecated) | TEXT | Age bracket of users. |
| Gender (deprecated) | TEXT | Gender of users. |
| Users (deprecated) | NUMERIC | The total number of users for the requested time period. |
| User Type (deprecated) | TEXT | A boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning. |
| Sessions (deprecated) | NUMERIC | The total number of sessions. |
| Sessions with Event (deprecated) | NUMERIC | The total number of sessions with events. |
| Week of the Year | TEXT | The week of the session, a two-digit number from 01 to 53. Each week starts on Sunday. |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | The year of the session, a four-digit year from 2005 to the current year. |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
| Month of Year | TEXT | Combined values of ga:year and ga:month. |
| Week of Year | TEXT | Combined values of ga:year and ga:week. |
Easily connect Google Analytics to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ 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.