JDBC Driver for Google Analytics

Build 22.0.8509

Traffic

Retrieves all Traffic data.

Table Specific Information

Select

Google Analytics only allows up to 10 Metrics and 7 Dimensions in a single query. Therefore, when issuing a query that selects all columns, only the default Metric columns will be selected for tables with more than 10 Metrics. The default Dimensions will be used unless you explicitly select other dimension columns. The following query uses Date instead of the default Source and Medium dimensions:

SELECT Date, Sessions, PercentNewSessions, NewUsers, BounceRate, PageviewsPerSession, AvgSessionDuration, GoalConversionRateAll, Transactions, RevenuePerTransaction, TransactionRevenue FROM Traffic
Filters can also be used in the WHERE clause. Dimension fields support the =, !=, LIKE, and NOT LIKE operators. Metric fields support =, !=, >, >=, <, and <= operators. This query will return the number of Sessions using Google Chrome:
SELECT Browser, Sessions FROM Traffic WHERE Browser LIKE '%Chrome%'
All reports in Google Analytics must cover a specific date range. The default behavior is to pull the last month of data if the StartDate and EndDate inputs are left unset. To override this behavior, the values can be set directly in the query. For example:
SELECT * FROM Traffic WHERE StartDate = '90daysAgo' AND EndDate = 'Today'
The default dimension for the table will be used unless another dimension is specified in the select columns, the DefaultFilter, or the Dimensions column in the WHERE clause. See Retrieving Google Analytics Data for more information about SELECT * queries. The following queries return the same results:
SELECT Source, Medium, Sessions, Users, PercentNewSessions, NewUsers, BounceRate, PageviewsPerSession, AvgSessionDuration, GoalConversionRateAll, Transactions, TransactionRevenue FROM Traffic

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Date Date True The date of the session formatted as YYYYMMDD.
Year Integer True The year of the session. A four-digit year from 2005 to the current year.
Month Integer True The month of the session. An integer from 01 to 12.
Week Integer True The week of the session. A number from 01 to 53. Each week starts on Sunday.
Day Integer True The day of the month. A number from 01 to 31.
Hour Integer True An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
Language String True The language provided by the HTTP Request for the browser. Values are given as an ISO-639 code.
Country String True The country of users, derived from IP addresses.
City String True The cities of property users, derived from IP addresses.
Browser String True The names of browsers used by users to your website. For example, Internet Explorer or Firefox.
OperatingSystem String True The operating system used by your users. For example, Windows, Linux , Macintosh, iPhone, iPod.
DeviceCategory String True The type of device: desktop, tablet, or mobile.
ChannelGrouping String True The channel grouping the data is returned for.
Source String True True The source of referrals to your property
Medium String True True The type of referrals to your property.
UserType String True A boolean indicating if a user is new or returning.
LandingPagePath String True The first page in a user session or landing page.
Campaign String True When using manual campaign tracking, this value is the value of the utm_campaign campaign tracking parameter. When using AdWords autotagging, this value is the name(s) of the online ad campaign that you use for your property. Otherwise, this value is: not set.
SocialNetwork String True Name of the social network. This can be related to the referring social network for traffic sources or to the social network for social data hub activities.
Sessions Integer False True Counts the total number of sessions.
Users Integer False True Total number of users to your property for the requested time period.
PercentNewSessions Double False True The percentage of sessions by people who had never visited your property before.
NewUsers Integer False True The number of users whose visit to your property was marked as a first-time session.
BounceRate Double False True The percentage of single-page session.
PageviewsPerSession Double False True The average number of pages viewed during a session on your property.
AvgSessionDuration Double False True The average duration of user sessions represented in total seconds.
GoalConversionRateAll Double False True The percentage of sessions that resulted in a conversion to at least one of your goals.
Transactions Integer False True The total number of transactions.
RevenuePerTransaction Decimal False The average revenue for an e-commerce transaction.
TransactionRevenue Decimal False True The total sale revenue provided in the transaction, excluding shipping and tax.
TransactionRevenuePerSession Decimal False Average transaction revenue for a session on your property.
StartDate String Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
EndDate String End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
Dimensions String A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.
Metrics String A comma-separated list of metrics to retrieve in addition to the columns defined in the schema.
CohortTypes String Available only when using the V4 API. A comma-separated list of cohort types. The default value is FIRST_VISIT_DATE
CohortStartDates Date Available only when using the V4 API. A comma-separated list of cohort start dates.
CohortEndDates Date Available only when using the V4 API. A comma-separated list of cohort end dates.
SamplesReadCounts String Comma separated list of samples read counts when the response data is sampled.
SamplingSpaceSizes String Comma separated list of samples space sizes counts when the response data is sampled.
Segments String Segments the data returned for your request. Either a SegmentId or a custom segment.
Profile Integer Profile ID or website URL to retrieve data from.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509