Connect Google Analytics to Azure with Windsor.ai

google analytics 1

+

azure logo 2

Stream all your analytics data from Google Analytics to Azure

About Google Analytics

Google Analytics is the worlds most used Web Analytics platform and offers its users detailed insights into website traffic, conversions, sales and other customisable dimensions and metrics. It is available in 40 languages and has a market share of 82%.

About Azure

Azure or Microsoft Azure is a cloud computing offering which allows management and hosting on Microsoft Managed data centers. It is used for business critical applications. In combination with Windsor.ai it allows joining marketing, analytics and CRM data to gain deeper insights.

Google Analytics metrics and dimensions available for streaming into Azure

NameTypeDescription
14 Day Active UsersNUMERICTotal 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 UsersNUMERICTotal 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 UsersNUMERICTotal 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 UsersNUMERICTotal 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 UsersNUMERICTotal 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.
ClicksNUMERICTotal number of times users have clicked on an ad to reach the property.
Ad ContentTEXTFor 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).
CostNUMERICDerived cost for the advertising campaign. Its currency is the one you set in the AdWords account.
Destination URLTEXTThe URL to which the AdWords ads referred traffic.
Display URLTEXTThe URL the AdWords ads displayed.
Ad Distribution NetworkTEXTThe network (Content, Search, Search partners, etc.) used to deliver the ads.
Ad FormatTEXTThe AdWords ad format (Text, Image, Flash, Video, etc.).
Google Ads: Ad GroupTEXTThe name of the AdWords ad group.
Keyword Match TypeTEXTThe match type (Phrase, Exact, or Broad) applied to the keywords. For details, see https://support.google.com/adwords/answer/2472708.
Search QueryTEXTThe search query that triggered impressions.
Query Match TypeTEXTThe 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 DomainTEXTThe domain where the ads on the content network were placed.
Placement URLTEXTThe URL where the ads were placed on the content network.
Query Word CountTEXTThe number of words in the search query.
Google Ads: Ad SlotTEXTThe location (Top, RHS, or not set) of the advertisement on the hosting page.
Placement TypeTEXTIt is Automatic placements or Managed placements, indicating how the ads were managed on the content network.
Targeting TypeTEXTThis (keyword, placement, or vertical targeting) indicates how the AdWords ads were targeted.
Google Ads Ad Group IDTEXTAdWords API AdGroup.id.
Google Ads Campaign IDTEXTAdWords API Campaign.id.
Google Ads Creative IDTEXTAdWords API Ad.id.
Google Ads Criteria IDTEXTAdWords API Criterion.id. The geographical targeting Criteria IDs are listed at https://developers.google.com/analytics/devguides/collection/protocol/v1/geoid.
Google Ads Customer IDTEXTCustomer's AdWords ID, corresponding to AdWords API AccountInfo.customerId.
AdX ClicksNUMERICThe number of times AdX ads were clicked on the site.
AdX CoverageNUMERICCoverage 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 CTRNUMERICThe percentage of pageviews that resulted in a click on an Ad Exchange ad.
AdX eCPMNUMERICThe effective cost per thousand pageviews. It is the Ad Exchange revenue per 1,000 pageviews.
AdX ImpressionsNUMERICAn 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 / SessionNUMERICThe ratio of Ad Exchange ad impressions to Analytics sessions (Ad Impressions / Analytics Sessions).
AdX Monetized PageviewsNUMERICThis 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 RevenueNUMERICThe total estimated revenue from Ad Exchange ads.
AdX Revenue / 1000 SessionsNUMERICThe 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 %NUMERICThe 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.
AffiliationTEXTA product affiliation to designate a supplying company or brick and mortar location.
Avg. Domain Lookup Time (sec)NUMERICThe average time (in seconds) spent in DNS lookup for this page.
Avg. Document Content Loaded Time (sec)NUMERICThe average time (in seconds) the browser takes to parse the document.
Avg. Document Interactive Time (sec)NUMERICThe 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. ValueNUMERICThe average value of an event.
Avg. Page Download Time (sec)NUMERICThe average time (in seconds) to download this page.
Avg. Page Load Time (sec)NUMERICThe 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)NUMERICThe average time (in seconds) spent in redirects before fetching this page. If there are no redirects, this is 0.
Avg. Search DepthNUMERICThe average number of pages people viewed after performing a search.
Time after SearchNUMERICThe average time (in seconds) users, after searching, spent on the property.
Results Pageviews / SearchNUMERICThe average number of times people viewed a page as a result of a search.
Avg. Server Connection Time (sec)NUMERICThe average time (in seconds) spent in establishing a TCP connection to this page.
Avg. Server Response Time (sec)NUMERICThe 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 DurationNUMERICThe average duration (in seconds) of users' sessions.
Avg. Time on PageNUMERICThe average time users spent viewing this page or a set of pages.
Bounce RateNUMERICThe percentage of single-page session (i.e., session in which the person left the property from the first page).
BouncesNUMERICThe total number of single page (or single interaction hit) sessions for the property.
BrowserTEXTThe name of users' browsers, for example, Internet Explorer or Firefox.
Browser SizeTEXTThe 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 VersionTEXTThe version of users' browsers, for example, 2.0.0.14.
Buy-to-Detail RateNUMERICUnique purchases divided by views of product detail pages (Enhanced Ecommerce).
CampaignTEXTFor 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 CodeTEXTFor manual campaign tracking, it is the value of the utm_id campaign tracking parameter.
Cart-to-Detail RateNUMERICProduct adds divided by views of product details (Enhanced Ecommerce).
Default Channel GroupingTEXTThe Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings).
Checkout OptionsTEXTUser 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).
CityTEXTUsers' city, derived from their IP addresses or Geographical IDs.
City IDTEXTUsers' 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 analyticsTEXTclientid from google analytics.
ContinentTEXTUsers' continent, derived from users' IP addresses or Geographical IDs.
Continent IDTEXTUsers' continent ID, derived from users' IP addresses or Geographical IDs.
Cost per ConversionNUMERICThe cost per conversion (including ecommerce and goal conversions) for the property.
Cost per Goal ConversionNUMERICThe cost per goal conversion for the property.
Cost per TransactionNUMERICThe cost per transaction for the property.
CountryTEXTUsers' country, derived from their IP addresses or Geographical IDs.
Country ISO CodeTEXTUsers' 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.
CPCNUMERICCost to advertiser per click.
CPMNUMERICCost per thousand impressions.
CTRNUMERICClick-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 CodeTEXTThe local currency code (based on ISO 4217 standard) of the transaction.
Data SourceTEXTThe 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.
DateDATEThe date of the session formatted as YYYYMMDD.
Hour of DayTIMESTAMPCombined values of ga:date and ga:hour formated as YYYYMMDDHH.
Date Hour and MinuteTIMESTAMPCombined values of ga:date, ga:hour and ga:minute formated as YYYYMMDDHHMM.
Day of the monthTEXTThe day of the month, a two-digit number from 01 to 31.
Day of WeekTEXTDay of the week, a one-digit number from 0 (Sunday) to 6 (Saturday).
Day of Week NameTEXTName (in English) of the day of the week.
Days Since Last SessionTEXTThe number of days elapsed since users last visited the property, used to calculate user loyalty.
Days to TransactionTEXTThe number of days between users' purchases and the most recent campaign source prior to the purchase.
Device CategoryTEXTThe type of device: desktop, tablet, or mobile.
Domain Lookup Time (ms)NUMERICThe total time (in milliseconds) all samples spent in DNS lookup for this page.
Document Content Loaded Time (ms)NUMERICThe 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)NUMERICThe 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 SampleNUMERICSample 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 / PageviewsNUMERICThe percentage of pageviews in which this page was the entrance.
EntrancesNUMERICThe number of entrances to the property measured as the first pageview in a session, typically used with landingPagePath.
Event ActionTEXTEvent action.
Event CategoryTEXTThe event category.
Event LabelTEXTEvent label.
Events / Session with EventNUMERICThe average number of events per session with event.
Events / Session with EventNUMERICThe average number of events per session with event.
Event ValueNUMERICTotal value of events for the profile.
Exit PageTEXTThe last page or exit page in users' sessions.
% ExitNUMERICThe percentage of exits from the property that occurred out of the total pageviews.
ExitsNUMERICThe number of exits from the property.
Flash VersionTEXTThe version of Flash, including minor versions, supported by users' browsers.
Full ReferrerTEXTThe full referring URL including the hostname and path.
Goal 10 CompletionsNUMERICThe total number of completions for Goal 10.
Goal 10 ValueNUMERICThe total numeric value for Goal 10.
Goal 11 CompletionsNUMERICThe total number of completions for Goal 11.
Goal 11 ValueNUMERICThe total numeric value for Goal 11.
Goal 12 CompletionsNUMERICThe total number of completions for Goal 12.
Goal 12 ValueNUMERICThe total numeric value for Goal 12.
Goal 13 CompletionsNUMERICThe total number of completions for Goal 13.
Goal 13 ValueNUMERICThe total numeric value for Goal 13.
Goal 14 CompletionsNUMERICThe total number of completions for Goal 14.
Goal 14 ValueNUMERICThe total numeric value for Goal 14.
Goal 15 CompletionsNUMERICThe total number of completions for Goal 15.
Goal 15 ValueNUMERICThe total numeric value for Goal 15.
Goal 16 CompletionsNUMERICThe total number of completions for Goal 16.
Goal 16 ValueNUMERICThe total numeric value for Goal 16.
Goal 17 CompletionsNUMERICThe total number of completions for Goal 17.
Goal 17 ValueNUMERICThe total numeric value for Goal 17.
Goal 18 CompletionsNUMERICThe total number of completions for Goal 18.
Goal 18 ValueNUMERICThe total numeric value for Goal 18.
Goal 19 CompletionsNUMERICThe total number of completions for Goal 19.
Goal 19 ValueNUMERICThe total numeric value for Goal 19.
Goal 1 CompletionsNUMERICThe total number of completions for Goal 1.
Goal 1 ValueNUMERICThe total numeric value for Goal 1.
Goal 20 CompletionsNUMERICThe total number of completions for Goal 20.
Goal 20 ValueNUMERICThe total numeric value for Goal 20.
Goal 2 CompletionsNUMERICThe total number of completions for Goal 2.
Goal 2 ValueNUMERICThe total numeric value for Goal 2.
Goal 3 CompletionsNUMERICThe total number of completions for Goal 3.
Goal 3 ValueNUMERICThe total numeric value for Goal 3.
Goal 4 CompletionsNUMERICThe total number of completions for Goal 4.
Goal 4 ValueNUMERICThe total numeric value for Goal 4.
Goal 5 CompletionsNUMERICThe total number of completions for Goal 5.
Goal 5 ValueNUMERICThe total numeric value for Goal 5.
Goal 6 CompletionsNUMERICThe total number of completions for Goal 6.
Goal 6 ValueNUMERICThe total numeric value for Goal 6.
Goal 7 CompletionsNUMERICThe total number of completions for Goal 7.
Goal 7 ValueNUMERICThe total numeric value for Goal 7.
Goal 8 CompletionsNUMERICThe total number of completions for Goal 8.
Goal 8 ValueNUMERICThe total numeric value for Goal 8.
Goal 9 CompletionsNUMERICThe total number of completions for Goal 9.
Goal 9 ValueNUMERICThe total numeric value for Goal 9.
Total Abandonment RateNUMERICGoal abandonment rate.
Abandoned FunnelsNUMERICThe overall number of times users started goals without actually completing them.
Goal Completion LocationTEXTThe page path or screen name that matched any destination type goal completion.
Goal CompletionsNUMERICTotal number of completions for all goals defined in the profile.
Goal Conversion RateNUMERICThe percentage of sessions which resulted in a conversion to at least one of the goals.
Goal Previous Step - 1TEXTThe page path or screen name that matched any destination type goal, one step prior to the goal completion location.
Goal Previous Step - 2TEXTThe page path or screen name that matched any destination type goal, two steps prior to the goal completion location.
Goal Previous Step - 3TEXTThe page path or screen name that matched any destination type goal, three steps prior to the goal completion location.
Goal StartsNUMERICTotal number of starts for all goals defined in the profile.
Goal ValueNUMERICTotal numeric value for all goals defined in the profile.
Per Search Goal ValueNUMERICThe average goal value of a search.
Per Session Goal ValueNUMERICThe average goal value of a session.
Per Session Goal ValueNUMERICThe average goal value of a session.
Social Source ReferralTEXTA boolean, either Yes or No, indicates whether sessions to the property are from a social source.
HitsNUMERICTotal 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.
HostnameTEXTThe hostname from which the tracking request was made.
HourTEXTA 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.)
ImpressionsNUMERICTotal number of campaign impressions.
Affinity Category (reach)TEXTIndicates that users are more likely to be interested in learning about the specified category.
In-Market SegmentTEXTIndicates that users are more likely to be ready to purchase products or services in the specified category.
Other CategoryTEXTIndicates that users are more likely to be interested in learning about the specified category, and more likely to be ready to purchase.
Internal Promotion ClicksNUMERICThe number of clicks on an internal promotion (Enhanced Ecommerce).
Internal Promotion CreativeTEXTThe creative content designed for a promotion (Enhanced Ecommerce).
Internal Promotion CTRNUMERICThe rate at which users clicked through to view the internal promotion (ga:internalPromotionClicks / ga:internalPromotionViews) - (Enhanced Ecommerce).
Internal Promotion IDTEXTThe ID of the promotion (Enhanced Ecommerce).
Internal Promotion NameTEXTThe name of the promotion (Enhanced Ecommerce).
Internal Promotion PositionTEXTThe position of the promotion on the web page or application screen (Enhanced Ecommerce).
Internal Promotion ViewsNUMERICThe number of views of an internal promotion (Enhanced Ecommerce).
ISO Week of the YearTEXTISO 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 YearTEXTThe 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 YearTEXTCombined values of ga:isoYear and ga:isoWeek.
TrueView Video AdTEXTA boolean, Yes or No, indicating whether the ad is an AdWords TrueView video ad.
QuantityNUMERICTotal number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.
Product RevenueNUMERICThe total revenue from purchased product items.
Avg. QTYNUMERICThe average quantity of this item (or group of items) sold per purchase.
Java SupportTEXTA boolean, either Yes or No, indicating whether Java is enabled in users' browsers.
KeywordTEXTFor 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 PageTEXTThe first page in users' sessions, or the landing page.
LanguageTEXTThe language, in ISO-639 code format (e.g., en-gb for British English), provided by the HTTP Request for the browser.
LatitudeTEXTThe 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.
Local Product RevenueNUMERICProduct revenue in local currency.
Local Product Refund AmountNUMERICRefund amount in local currency for a given product (Enhanced Ecommerce).
Local Refund AmountNUMERICTotal refund amount in local currency for the transaction (Enhanced Ecommerce).
Local RevenueNUMERICTransaction revenue in local currency.
Local ShippingNUMERICTransaction shipping cost in local currency.
Local TaxNUMERICTransaction tax in local currency.
LongitudeTEXTThe 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.
MarginNUMERICThis metric is deprecated and will be removed soon. Please use ga:ROAS instead.
MediumTEXTThe 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).
MetroTEXTThe Designated Market Area (DMA) from where traffic arrived.
Metro IdTEXTThe three digit Designated Market Area (DMA) code from where traffic arrived, derived from users' IP addresses or Geographical IDs.
MinuteTEXTReturns the minutes, between 00 and 59, in the hour.
Mobile Device BrandingTEXTMobile manufacturer or branded name.
Mobile Device InfoTEXTThe branding, model, and marketing name used to identify the mobile device.
Mobile Device Marketing NameTEXTThe marketing name used for the mobile device.
Mobile Device ModelTEXTMobile device model.
Mobile Input SelectorTEXTSelector (e.g., touchscreen, joystick, clickwheel, stylus) used on the mobile device.
Month of the yearTEXTMonth of the session, a two digit integer from 01 to 12.
Network DomainTEXTThe domain name of users' ISP, derived from the domain name registered to the ISP's IP address.
Service ProviderTEXTThe 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 UsersNUMERICThe number of sessions marked as a user's first sessions.
New UsersNUMERICThe number of sessions marked as a user's first sessions.
Day IndexTEXTThe 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 IndexTEXTThe 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 IndexTEXTThe 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 IndexTEXTThe 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 IndexTEXTThe 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 SystemTEXTUsers' operating system, for example, Windows, Linux, Macintosh, or iOS.
Operating System VersionTEXTThe version of users' operating system, i.e., XP for Windows, PPC for Macintosh.
Order Coupon CodeTEXTCode for the order-level coupon (Enhanced Ecommerce).
Organic SearchesNUMERICThe number of organic searches happened in a session. This metric is search engine agnostic.
Page DepthTEXTThe 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)NUMERICThe total time (in milliseconds) to download this page among all samples.
Page Load SampleNUMERICThe sample set (or count) of pageviews used to calculate the average page load time.
Page Load Time (ms)NUMERICTotal 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.
PageTEXTA 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 1TEXTThis dimension rolls up all the page paths in the first hierarchical level in pagePath.
Page path level 2TEXTThis dimension rolls up all the page paths in the second hierarchical level in pagePath.
Page path level 3TEXTThis dimension rolls up all the page paths in the third hierarchical level in pagePath.
Page path level 4TEXTThis 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 TitleTEXTThe page's title. Multiple pages might have the same page title.
Page ValueNUMERICThe average value of this page or set of pages, which is equal to (ga:transactionRevenue + ga:goalValueAll) / ga:uniquePageviews.
PageviewsNUMERICThe total number of pageviews for the property.
Pages / SessionNUMERICThe average number of pages viewed during a session, including repeated views of a single page.
Pages / SessionNUMERICThe average number of pages viewed during a session, including repeated views of a single page.
% New SessionsNUMERICThe percentage of sessions by users who had never visited the property before.
% New SessionsNUMERICThe percentage of sessions by users who had never visited the property before.
% Search RefinementsNUMERICThe percentage of the number of times a refinement (i.e., transition) occurs between internal keywords search within a session.
% Sessions with SearchNUMERICThe percentage of sessions with search.
% Sessions with SearchNUMERICThe percentage of sessions with search.
Previous Page PathTEXTA page visited before another page on the same property, typically used with the pagePath dimension.
Product Adds To CartNUMERICNumber of times the product was added to the shopping cart (Enhanced Ecommerce).
Product CategoryTEXTAny product variation (size, color) supplied by the ecommerce application for purchased items, not compatible with Enhanced Ecommerce.
Product CheckoutsNUMERICNumber of times the product was included in the check-out process (Enhanced Ecommerce).
Product Detail ViewsNUMERICNumber of times users viewed the product-detail page (Enhanced Ecommerce).
Product List ClicksNUMERICNumber of times users clicked the product when it appeared in the product list (Enhanced Ecommerce).
Product List CTRNUMERICThe rate at which users clicked through on the product in a product list (ga:productListClicks / ga:productListViews) - (Enhanced Ecommerce).
Product List ViewsNUMERICNumber of times the product appeared in a product list (Enhanced Ecommerce).
ProductTEXTThe product name, supplied by the ecommerce tracking application, for purchased items.
Product Refund AmountNUMERICTotal refund amount associated with the product (Enhanced Ecommerce).
Product RefundsNUMERICNumber of times a refund was issued for the product (Enhanced Ecommerce).
Product Removes From CartNUMERICNumber of times the product was removed from the shopping cart (Enhanced Ecommerce).
Product Revenue per PurchaseNUMERICAverage product revenue per purchase (commonly used with Product Coupon Code) (ga:itemRevenue / ga:uniquePurchases) - (Enhanced Ecommerce).
Product SKUTEXTThe product SKU, defined in the ecommerce tracking application, for purchased items.
Google Analytics view (profile) ID (alias)TEXTAlias for Google Analytics view (profile) ID
Google Analytics view (profile) name (alias)TEXTAlias for Google Analytics view (profile) name
Quantity Added To CartNUMERICNumber of product units added to the shopping cart (Enhanced Ecommerce).
Quantity Checked OutNUMERICNumber of product units included in check out (Enhanced Ecommerce).
Quantity RefundedNUMERICNumber of product units refunded (Enhanced Ecommerce).
Quantity Removed From CartNUMERICNumber of product units removed from a shopping cart (Enhanced Ecommerce).
Redirection Time (ms)NUMERICThe total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.
Referral PathTEXTThe 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 AmountNUMERICCurrency amount refunded for a transaction (Enhanced Ecommerce).
RegionTEXTUsers' region, derived from their IP addresses or Geographical IDs. In U.S., a region is a state, New York, for example.
Region IDTEXTUsers' 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 CodeTEXTUsers' region ISO code in ISO-3166-2 format, derived from their IP addresses or Geographical IDs.
Avg. PriceNUMERICThe average revenue per item.
Avg. Order ValueNUMERICThe average revenue of an ecommerce transaction.
Revenue per UserNUMERICThe total sale revenue (excluding shipping and tax) of the transaction divided by the total number of users.
ROASNUMERICReturn On Ad Spend (ROAS) is the total transaction revenue and goal value divided by derived advertising cost.
ROINUMERICThis metric is deprecated and will be removed soon. Please use ga:ROAS instead.
RPCNUMERICRPC 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 ColorsTEXTThe color depth of users' monitors, retrieved from the DOM of users' browsers. For example, 4-bit, 8-bit, 24-bit, or undefined-bit.
Screen ResolutionTEXTResolution of users' screens, for example, 1024x738.
Search DepthNUMERICThe total number of subsequent page views made after a use of the site's internal search feature.
Destination PageTEXTThe page users immediately visited after performing an internal search on the site. This is usually the search results page.
Time after SearchNUMERICThe session duration when the site's internal search feature is used.
% Search ExitsNUMERICThe percentage of searches that resulted in an immediate exit from the property.
Search ExitsNUMERICThe number of exits on the site that occurred following a search result from the site's internal search feature.
Site Search Goal Conversion RateNUMERICThe 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 RefinementsNUMERICThe 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 PageviewsNUMERICThe number of times a search result page was viewed.
Sessions with SearchNUMERICThe total number of sessions that included an internal search.
Total Unique SearchesNUMERICTotal 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 StatusTEXTA boolean, either Visits With Site Search or Visits Without Site Search, to distinguish whether internal search was used in a session.
Sessions with SearchNUMERICThe total number of sessions that included an internal search.
Second PageTEXTThe second page in users' sessions.
Server Connection Time (ms)NUMERICTotal time (in milliseconds) all samples spent in establishing a TCP connection to this page.
Server Response Time (ms)NUMERICThe 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 SessionsTEXTThe 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 DurationNUMERICTotal duration (in seconds) of users' sessions.
Session DurationTEXTThe length (returned as a string) of a session measured in seconds and reported in second increments.
SessionsNUMERICThe total number of sessions.
Number of Sessions per UserNUMERICThe total number of sessions divided by the total number of users.
Sessions to TransactionTEXTThe number of sessions between users' purchases and the related campaigns that lead to the purchases.
Sessions with EventNUMERICThe total number of sessions with events.
Shopping StageTEXTVarious stages of the shopping experience that users completed in a session, e.g., PRODUCT_VIEW, ADD_TO_CART, CHECKOUT, etc. (Enhanced Ecommerce).
Shared URLTEXTFor a social data hub activity, this is the URL shared by the associated social network users.
Social NetworkTEXTThe social network name. This is related to the referring social network for traffic sources; e.g., Google+, Blogger.
SourceTEXTThe 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 / MediumTEXTCombined values of ga:source and ga:medium.
Speed Metrics SampleNUMERICThe 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 ContinentTEXTUsers' sub-continent, derived from their IP addresses or Geographical IDs. For example, Polynesia or Northern Europe.
Sub Continent CodeTEXTUsers' 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 PageNUMERICTime (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.
Total EventsNUMERICThe total number of events for the profile, across all categories.
Publisher ClicksNUMERICThe number of times ads from a linked publisher account (AdSense, AdX, DFP) were clicked on the site.
Publisher CoverageNUMERICCoverage 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 CTRNUMERICThe percentage of pageviews that resulted in a click on a linked publisher account (AdSense, AdX, DFP) ad.
Publisher eCPMNUMERICThe effective cost per thousand pageviews. It is the total estimated revenue from all linked publisher accounts (AdSense, AdX, DFP) per 1,000 pageviews.
Publisher ImpressionsNUMERICAn 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 / SessionNUMERICThe ratio of linked publisher account (AdSense, AdX, DFP) ad impressions to Analytics sessions (Ad Impressions / Analytics Sessions).
Publisher Monetized PageviewsNUMERICThis 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 RevenueNUMERICThe total estimated revenue from all linked publisher account (AdSense, AdX, DFP) ads.
Publisher Revenue / 1000 SessionsNUMERICThe total estimated revenue from all linked publisher accounts (AdSense, AdX, DFP) per 1,000 Analytics sessions.
Publisher Viewable Impressions %NUMERICThe 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.
RefundsNUMERICNumber of refunds that have been issued (Enhanced Ecommerce).
Total ValueNUMERICTotal value for the property (including total revenue and total goal value).
Transaction IDTEXTThe transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.
RevenueNUMERICThe total sale revenue (excluding shipping and tax) of the transaction.
Per Session ValueNUMERICAverage transaction revenue for a session.
Per Session ValueNUMERICAverage transaction revenue for a session.
TransactionsNUMERICThe total number of transactions.
ShippingNUMERICThe total cost of shipping.
Ecommerce Conversion RateNUMERICThe average number of transactions in a session.
Transactions per UserNUMERICTotal number of transactions divided by total number of users.
Ecommerce Conversion RateNUMERICThe average number of transactions in a session.
TaxNUMERICTotal tax for the transaction.
Unique Dimension CombinationsNUMERICUnique 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 EventsNUMERICThe number of unique events. Events in different sessions are counted as separate events.
Unique PageviewsNUMERICUnique 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 PurchasesNUMERICThe number of product sets purchased. For example, if users purchase 2 frisbees and 5 tennis balls from the site, this will be 2.
AgeTEXTAge bracket of users.
User BucketTEXTRandomly assigned users tag to allow A/B testing and splitting of remarketing lists. Ranges from 1-100.
User Defined ValueTEXTThe value provided when defining custom user segments for the property.
GenderTEXTGender of users.
UsersNUMERICThe total number of users for the requested time period.
User TypeTEXTA boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning.
Google Analytics view (profile) IDTEXTGoogle Analytics view (profile) ID
Google Analytics view (profile) nameTEXTGoogle Analytics view (profile) name
Bounce RateNUMERICThe percentage of single-page session (i.e., session in which the person left the property from the first page).
Count of SessionsTEXTThe 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 DurationTEXTThe length (returned as a string) of a session measured in seconds and reported in second increments.
AgeTEXTAge bracket of users.
GenderTEXTGender of users.
UsersNUMERICThe total number of users for the requested time period.
User TypeTEXTA boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning.
SessionsNUMERICThe total number of sessions.
Sessions with EventNUMERICThe total number of sessions with events.
Week of the YearTEXTThe week of the session, a two-digit number from 01 to 53. Each week starts on Sunday.
YearTEXTThe year of the session, a four-digit year from 2005 to the current year.
Month of YearTEXTCombined values of ga:year and ga:month.
Week of YearTEXTCombined values of ga:year and ga:week.

Windsor.ai: Easily connect Google Analytics to Azure

See the value and return on every marketing touchpoint

data warehouse

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

insights

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

Start a free trial today.

Integrate all your data and measure what matters.