GoalCompletions

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.

GoalCompletionLocation

String

True

True

The page path or screen name that matched any destination-type goal completion.

GoalStartsAll

Integer

False

True

The total number of starts for all goals defined for your profile.

GoalCompletionsAll

Integer

False

True

The total number of completions for all goals defined for your profile.

GoalValueAll

Double

False

True

The total numeric value for all goals defined for your profile.

GoalValuePerSession

Double

False

True

The average goal value of a session on your property.

GoalConversionRateAll

Double

False

True

The percentage of sessions that resulted in a conversion to at least one of your goals.

GoalAbandonsAll

Integer

False

True

The overall number of times users started goals without actually completing them.

GoalAbandonRateAll

Double

False

True

The rate at which goals were abandoned.

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.

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

Segments

String

Segments the data returned for your request. Either a SegmentId or a custom segment.

Profile

String

The Profile ID or website URL to retrieve data from.

Last updated