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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Profile

String

The Profile ID or website URL to retrieve data from.

Last updated