Google Analytics 360 integration summary

Stitch’s Google Analytics 360 integration replicates data using the BigQuery API. Refer to the Schema section for a list of objects available for replication.

Google Analytics 360 feature snapshot

A high-level look at Stitch's Google Analytics 360 (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Beta

Supported by

Stitch

Stitch plan

Enterprise

API availability

Available

Singer GitHub repository

singer-io/tap-ga360

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Table-level reset

Unsupported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Google Analytics 360

Google Analytics 360 setup requirements

To set up Google Analytics 360 in Stitch, you need:

  • An Enterprise Stitch plan. Google Analytics 360 integrations can be added on as part of an Enterprise plan. Reach out to Stitch support for more info.
  • A Google BigQuery and Google Analytics 360 account. You need to have your BigQuery account configured to export to Google Analytics 360. To learn how to configure this export, use Google’s step-by-step instructions.

Step 1: Locate your Project ID and Dataset ID

  1. Login to Google and go to your Google Cloud Console.
  2. To locate your list of projects, click on the navigation menu in the upper left-hand corner of the page.
  3. Hover over IAM & Admin to pop open its menu. Select Manage Resources.
  4. On this page, navigate to the project that includes the dataset you want to replicate data from and click on it.
  5. Your Project ID and all of your Dataset IDs will be visible. Make note of the Project ID and Dataset ID that you want to replicate and keep it readily available for the Google Analytics 360 integration configuration page.

Step 2: Create a GCP IAM service account

Step 2.1: Define the service account details

  1. Navigate to the IAM Service Accounts page in the GCP console.
  2. Select the project you want to use by using the project dropdown menu, located near the top left corner of the page:

    Highlighted project selection menu in the Google Cloud Platform console

  3. Click + Create Service Account.
  4. On the Service account details page, fill in the field as follows:
    • Service account name: Enter a name for the service account. For example: Stitch
    • Serivce account description: Enter a description for the service account. For example: Replicate Stitch data
  5. Click Create.

Step 2.2: Assign service account permissions

BigQuery read-only roles Next, you’ll assign permissions to the service account.

  1. On the Service account permissions page, click the Role field.
  2. In the window that displays, select one of the following BigQuery roles:
    • BigQuery Data Viewer
    • BigQuery Job User
    • BigQuery User
  3. Click + Add Another Role.
  4. Repeat steps 2 and 3 until all BigQuery roles have been assigned.
  5. Click Continue.

Step 2.3: Create a JSON project key

Create project key section, highlighted in the Google Cloud Platform console

The last step is to create and download a JSON project key. The project key file contains information about the project, which Stitch will use to complete the setup.

  1. On the Grant users access to this service account page, scroll to the Create key section.
  2. Click + Create Key.
  3. When prompted, select the JSON option.
  4. Click Create.
  5. Save the JSON project key file to your computer. The file will be downloaded to the location you specify (if prompted), or the default download location defined for the web browser you’re currently using.

Step 3: Add Google Analytics 360 as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Google Analytics 360 icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Google Analytics 360” would create a schema called stitch_google_analytics_360 in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the GA 360 Dataset ID and GA 360 Project ID fields, enter the Project and Dataset IDs you retrieved in Step 1.
  6. In the Service Account JSON field, paste the JSON project key you obtained in Step 2.3.

Step 4: Define the historical sync

The Sync Historical Data setting will define the starting date for your Google Analytics 360 integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Google Analytics 360’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 5: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Google Analytics 360 integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 6: Set tables and columns to replicate

To complete the setup, you’ll need to select the tables and columns you want to replicate to your data warehouse.

Check out the Schema section to learn more about the available tables in Google Analytics 360 and how they replicate.

  1. In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A green checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.

Initial and historical replication jobs

After you finish setting up Google Analytics 360, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Google Analytics 360 replication

For each day of export in Google Analytics 360, Google Analytics 360 creates a table with the format ga_sessions_YYYYMMDD. The YYYYMMDD portion of the table’s name corresponds to the date the data is for.

Stitch uses the YYYYMMDD portion of the table’s name to incrementally replicate data. When a new export with a YYYYMMDD value is greater than the previous export, Stitch will replicate the data for that day in full.

Google Analytics 360 imports data into daily session tables several times throughout the day. For the current day, data isn’t final until the daily import is complete. Refer to Google’s documentation for more info on this process.

Because Google Analytics 360 performs data imports several times a day, you may notice differences between your data in Google Analytics 360 and the data replicated by Stitch. Allow a full day to see complete updates for the previous day’s data.


Google Analytics 360 table schemas

Replication Method :

Key-based Incremental

Replication Key :

ga_sessions_YYYYMMDD

Primary Key :

visitId : fullVisitorId : visitStartTime : hitNumber

API endpoint :

BigQuery Export schema

This table contains information about Google Analytics session hits.

visitId
NUMBER

An identifier for this session.

Reference:

fullVisitorId
STRING

The unique visitor ID - also known as client ID.

Reference:

visitStartTime
NUMBER

The timestamp expressed as POSIX time.

Reference:

hitNumber
NUMBER

The sequenced hit number. For the first hit of each session, this is set to 1.

Reference:

appInfo
OBJECT

This section will be populated for each hit with type = APPVIEW or EXCEPTION.

appId
STRING

The ID of the application.

appInstallerId
STRING

ID of the installer (e.g., Google Play Store) from which the app was downloaded.

appName
STRING

The name of the application.

appVersion
STRING

The version of the application.

exitScreenName
STRING

The exit screen of the session.

landingScreenName
STRING

The landing screen of the session.

screenDepth
STRING

The number of screenviews per session reported as a string. Can be useful for historgrams.

screenName
STRING

The name of the string.

ga_session_hits (table), appInfo (attribute)

contentGroup
OBJECT

This section contains information about content grouping. For more information about content groups, click here.

contentGroup1
STRING

The content group on a property. A content group is a collection of content that provides a logical structure that can be determined by tracking-code or page-title/URL regex match, or predefined rules.

contentGroup2
STRING

The content group on a property. A content group is a collection of content that provides a logical structure that can be determined by tracking-code or page-title/URL regex match, or predefined rules.

contentGroup3
STRING

The content group on a property. A content group is a collection of content that provides a logical structure that can be determined by tracking-code or page-title/URL regex match, or predefined rules.

contentGroup4
STRING

The content group on a property. A content group is a collection of content that provides a logical structure that can be determined by tracking-code or page-title/URL regex match, or predefined rules.

contentGroup5
STRING

The content group on a property. A content group is a collection of content that provides a logical structure that can be determined by tracking-code or page-title/URL regex match, or predefined rules.

contentGroupUniqueViews1
STRING

The number of unique content group views. Content group views in different sessions are counted as unique content group views. Both the pagePath and pageTitle are used to determine content group view uniqueness.

contentGroupUniqueViews2
STRING

The number of unique content group views. Content group views in different sessions are counted as unique content group views. Both the pagePath and pageTitle are used to determine content group view uniqueness.

contentGroupUniqueViews3
STRING

The number of unique content group views. Content group views in different sessions are counted as unique content group views. Both the pagePath and pageTitle are used to determine content group view uniqueness.

contentGroupUniqueViews4
STRING

The number of unique content group views. Content group views in different sessions are counted as unique content group views. Both the pagePath and pageTitle are used to determine content group view uniqueness.

contentGroupUniqueViews5
STRING

The number of unique content group views. Content group views in different sessions are counted as unique content group views. Both the pagePath and pageTitle are used to determine content group view uniqueness.

previousContentGroup1
STRING

Content group that was visited before another content group.

previousContentGroup2
STRING

Content group that was visited before another content group.

previousContentGroup3
STRING

Content group that was visited before another content group.

previousContentGroup4
STRING

Content group that was visited before another content group.

previousContentGroup5
STRING

Content group that was visited before another content group.

ga_session_hits (table), contentGroup (attribute)

contentInfo
OBJECT

This section will be populated for each hit with type = APPVIEW.

contentDescription
STRING

The description of the content being viewed as passed to the SDK.

ga_session_hits (table), contentInfo (attribute)

customDimensions
ARRAY

This section contains any user-level or session-level custom dimensions that are set for a session. This is a repeated field and has an entry for each dimension that is set.

index
INTEGER

The index of the custom dimension.

value
STRING

The value of the custom dimension.

ga_session_hits (table), customDimensions (attribute)

customMetrics
ARRAY

This section contains any hit-level custom metrics. This is a repeated field and has an entry for each metric that is set.

index
NUMBER

The index of the custom metric.

value
NUMBER

The value of the custom metric.

ga_session_hits (table), customMetrics (attribute)

customVariables
ARRAY

This section contains any hit-level custom variables. This is a repeated field and has an entry for each variable that is set.

customVarName
STRING

The custom variable name.

customVarValue
STRING

The custom variable value.

index
NUMBER

The index of the custom variable.

ga_session_hits (table), customVariables (attribute)

dataSource
STRING

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.

eCommerceAction
OBJECT

This section contains all of the ecommerce hits that occurred during the session. This is a repeated field and has an entry for each hit that was collected.

action_type
STRING

The action type.

option
STRING

This field is populated when a checkout option is specified. For example, a shipping option such as option = Fedex.

step
NUMBER

This field is populated when a checkout step is specified with the hit.

ga_session_hits (table), eCommerceAction (attribute)

eventInfo
OBJECT

This section is populated for each hit with type = EVENT.

eventAction
STRING

The event action.

eventCategory
STRING

The event category.

eventLabel
STRING

The event label.

eventValue
NUMBER

The event value.

ga_session_hits (table), eventInfo (attribute)

exceptionInfo
OBJECT

This section is populated for each hit with type = EXCEPTION.

description
STRING

The exception description.

exceptions
NUMBER

The number of exceptions sent to Google Analytics.

fatalExceptions
NUMBER

The number of exceptions sent to Google Analytics where isFatal is set to true.

isFatal
BOOLEAN

If the exception was fatal, this is set to true.

ga_session_hits (table), exceptionInfo (attribute)

experiment
ARRAY

This row and the nested fields are populated for each hit that contains data for an experiment.

experimentId
STRING

The ID of the experiment.

experimentVariant
STRING

The variation or combination of variations present in a hit for an experiment.

ga_session_hits (table), experiment (attribute)

hour
NUMBER

The hour in which the hit occurred. This value can be 0 to 23.

isEntrance
BOOLEAN

If this hit was the first pageview or screenview hit of a session, this is set to true.

isExit
BOOLEAN

If this hit was the last pageview or screenview hit of a session, this is set to true.

isInteraction
BOOLEAN

If this hit was an interaction, this is set to true. If this was a non-interaction hit (i.e., an event with interaction set to false), this is false.

isSecure
BOOLEAN

This field is deprecated.

item
OBJECT

This section will be populated for each hit with type = ITEM.

currencyCode
STRING

The local currency code for the transaction.

itemQuantity
NUMBER

The quantity of the product sold.

itemRevenue
NUMBER

Total revenue from the item, expressed as the value passed to Analytics multiplied by 10^6 (e.g., 2.40 would be given as 2400000).

localItemRevenue
NUMBER

Total revenue from this item in local currency, expressed as the value passed to Analytics multiplied by 10^6 (e.g., 2.40 would be given as 2400000).

productCategory
STRING

The category of the product.

productName
STRING

The name of the product.

productSku
STRING

The SKU or product ID.

transactionId
STRING

The transaction ID of the ecommerce transaction.

ga_session_hits (table), item (attribute)

latencyTracking
OBJECT

This section contains information about events in the Navigation Timing API.

domContentLoadedTime
NUMBER

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).

domInteractiveTime
NUMBER

The time (in milliseconds), including the network time from users’ locations to the site’s server, the browser takes to parse the document (DOMInteractive).

domLatencyMetricsSample
NUMBER

Sample set (or count) of pageviews used to calculate the averages for site speed DOM metrics.

domainLookupTime
NUMBER

The total time (in milliseconds) all samples spent in DNS lookup for this page.

pageDownloadTime
NUMBER

The total time (in milliseconds) to download this page among all samples.

pageLoadSample
NUMBER

The sample set (or count) of pageviews used to calculate the average page load time.

pageLoadTime
NUMBER

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.

redirectionTime
NUMBER

The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.

serverConnectionTime
NUMBER

Total time (in milliseconds) all samples spent in establishing a TCP connection to this page.

serverResponseTime
NUMBER

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.

speedMetricsSample
NUMBER

The sample set (or count) of pageviews used to calculate the averages of site speed metrics.

userTimingCategory
STRING

For easier reporting purposes, this is used to categorize all user timing variables into logical groups.

userTimingLabel
STRING

The name of the resource’s action being tracked.

userTimingSample
NUMBER

The number of hits sent for a particular userTimingCategory, userTimingLabel, or userTimingVariable.

userTimingValue
NUMBER

Total number of milliseconds for user timing.

userTimingVariable
STRING

Variable used to add flexibility to visualize user timings in the reports.

ga_session_hits (table), latencyTracking (attribute)

minute
NUMBER

The minute in which the hit occurred. this value can be from 0 to 59.

page
OBJECT

This section is populated for each hit with type = PAGE.

hostname
STRING

The hostname of the URL.

pagePath
STRING

The URL path of the page.

pagePathLevel1
STRING

This dimension rolls up all the page paths in the 1st hierarchical level in pagePath.

pagePathLevel2
STRING

This dimension rolls up all the page paths in the 2nd hierarchical level in pagePath.

pagePathLevel3
STRING

This dimension rolls up all the page paths in the 3d hierarchical level in pagePath.

pagePathLevel4
STRING

This dimension rolls up all the page paths into hierarchical levels. Up to 4 pagePath levels may be specified. All additional levels in the pagePath hierarchy are also rolled up in this dimension.

pageTitle
STRING

The page title.

searchCategory
STRING

If this was a search-results page, this is the category selected.

searchKeyword
STRING

If this was a search results page, this is the keyword entered.

ga_session_hits (table), page (attribute)

product
ARRAY

This row and nested fields will be populated for each hit that contains Enhanced Ecommerce PRODUCT data.

customDimensions
ARRAY

This section is populated for all hits containing product scope Custom Dimensions.

index
NUMBER

The product scope Custom Dimensions index.

value
STRING

The product scope Custom Dimensions value.

ga_session_hits (table), customDimensions (attribute)

customMetrics
ARRAY

This section is populated for all hits containing product scope Custom Metrics.

index
NUMBER

The product scope Custom Metrics index.

value
NUMBER

The product scope Custom Metrics value.

ga_session_hits (table), customMetrics (attribute)

isClick
BOOLEAN

Whether users clicked this product when it appeared in the product list.

isImpression
BOOLEAN

TRUE if at least one user viewed this product when it appeared in the product list.

localProductPrice
NUMBER

The price of the product in local currency, expressed as the value passed to Analytics multiplied by 10^6.

localProductRefundAmount
NUMBER

The amount processed as part of a refund for a product in local currency, expressed as the value passed to Analytics multiplied by 10^6.

localProductRevenue
NUMBER

The revenue of the product in local currency, expressed as the value passed to Analytics multiplied by 10^6.

productBrand
STRING

The brand associated with the product.

productListName
STRING

Name of the list in which the product is shown, or in which a click occurred. For example, Home Page Promotion, Also Viewed, Recommended For You, Search Results List, etc.

productListPosition
NUMBER

Position of the product in the list in which it is shown.

productPrice
NUMBER

The price of the product, expressed as the value passed to Analytics multiplied by 10^6.

productQuantity
NUMBER

The quantity of the product purchased.

productRefundAmount
NUMBER

The amount processed as part of a refund for a product, expressed as the value passed to Analytics multiplied by 10^6.

productRevenue
NUMBER

The revenue of the product, expressed as the value passed to Analytics multiplied by 10^6.

productSKU
STRING

The product SKU.

productVariant
STRING

The product Variant.

v2ProductCategory
STRING

The product Category.

v2ProductName
STRING

The product Name.

ga_session_hits (table), product (attribute)

promotion
ARRAY

This row and nested fields are populated for each hit that contains Enhanced Ecommerce PROMOTION information.

promoCreative
STRING

The text or creative variation associated with the promotion.

promoId
STRING

The promotion ID.

promoName
STRING

The promotion name.

promoPosition
STRING

The promotion position on site.

ga_session_hits (table), promotion (attribute)

promotionActionInfo
OBJECT

This row and nested fields are populated for each hit that contains Enhanced Ecommerce PROMOTION action information.

promoIsClick
BOOLEAN

TRUE if the Enhanced Ecommerce action is a promo view.

promoIsView
BOOLEAN

TRUE if the Enhanced Ecommerce action is a promo click.

ga_session_hits (table), promotionActionInfo (attribute)

publisher
OBJECT

adsClicked
NUMBER

adsPagesViewed
NUMBER

adsRevenue
NUMBER

adsUnitsMatched
NUMBER

adsUnitsViewed
NUMBER

adsViewed
NUMBER

adsenseBackfillDfpClicks
NUMBER

The number of clicks on AdSense ads that served as Google Ad Manager backfill.

adsenseBackfillDfpImpressions
NUMBER

The number of AdSense ad impressions that were served as Google Ad Manager backfill.

adsenseBackfillDfpMatchedQueries
NUMBER

The number of ad requests where AdSense was trafficked as backfill and returned an ad creative to the page.

adsenseBackfillDfpMeasurableImpressions
NUMBER

The number of ad impressions filled by AdSense that viewability measurements were able to take into account (includes both in-view and not-in-view ads).

adsenseBackfillDfpPagesViewed
NUMBER

The number of Google Analytics pageviews where Google Ad Manager recorded AdSense revenue.

adsenseBackfillDfpQueries
NUMBER

The number of ad requests made to AdSense by Google Ad Manager.

adsenseBackfillDfpRevenueCpc
NUMBER

The CPC revenue associated with the resultant AdSense ad clicks.

adsenseBackfillDfpRevenueCpm
NUMBER

The CPM revenue associated with the served AdSense ad impressions.

adsenseBackfillDfpViewableImpressions
NUMBER

The number of AdSense impressions that met Google Ad Manager’s viewability standard.

adxBackfillDfpClicks
NUMBER

The number of clicks on Google Ad Manager ads served as Google Ad Manager backfill.

adxBackfillDfpImpressions
NUMBER

The number of Google Ad Manager ad impressions that were served as Google Ad Manager backfill.

adxBackfillDfpMatchedQueries
NUMBER

The number of ad requests where Google Ad Manager was trafficked as backfill and returned an ad creative to the page.

adxBackfillDfpMeasurableImpressions
NUMBER

The number of ad impressions filled by Google Ad Manager that viewability measurements are able to take into account (includes both in-view and not-in-view ads).

adxBackfillDfpPagesViewed
NUMBER

The number of Google Analytics pageviews where Google Ad Manager recorded revenue.

adxBackfillDfpQueries
NUMBER

The number of ad requests made to Google Ad Manager by Google Ad Manager.

adxBackfillDfpRevenueCpc
NUMBER

The CPC revenue associated with the resultant Google Ad Manager ad clicks.

adxBackfillDfpRevenueCpm
NUMBER

The CPM revenue associated with the served Google Ad Manager ad impressions.

adxBackfillDfpViewableImpressions
NUMBER

The number of ad impressions filled by Google Ad Manager that viewability measurements are able to take into account (includes both in-view and not-in-view ads).

adxClicks
NUMBER

adxImpressions
NUMBER

adxMatchedQueries
NUMBER

adxMeasurableImpressions
NUMBER

adxPagesViewed
NUMBER

adxQueries
NUMBER

adxRevenue
NUMBER

adxViewableImpressions
NUMBER

dfpAdGroup
STRING

The Google Ad Manager Line Item ID of the ad that served.

dfpAdUnits
STRING

The IDs of the Google Ad Manager Ad Units present in the ad request.

dfpClicks
NUMBER

The number of times Google Ad Manager ads were clicked.

dfpImpressions
NUMBER

A Google Ad Manager ad impression is reported whenever an individual ad is displayed.

dfpMatchedQueries
NUMBER

The number of ad requests where a creative was returned to the page.

dfpMeasurableImpressions
NUMBER

The number of ad impressions that viewability measurements are able to take into account. This includes both in-view and not-in-view ads.

dfpNetworkId
STRING

The Google Ad Manager network ID that the ad request was sent to.

dfpPagesViewed
NUMBER

The number of Google Analytics pageviews where Google Ad Manager recorded revenue.

dfpQueries
NUMBER

The number of ad requests made to Google Ad Manager.

dfpRevenueCpc
NUMBER

The CPC revenue associated with the resultant ad clicks, based on the rate-field value for each clicked ad in Google Ad Manager.

dfpRevenueCpm
NUMBER

The CPM revenue associated with the served ad impressions, based on the rate-field value for each served ad in Google Ad Manager.

dfpViewableImpressions
NUMBER

The number of impressions that met Google Ad Manager’s viewability standard.

measurableAdsViewed
NUMBER

viewableAdsViewed
NUMBER

ga_session_hits (table), publisher (attribute)

referer
STRING

The referring page, if the session has a goal completion or transaction. If this page is from the same domain, this is blank.

refund
OBJECT

This row and nested fields are populated for each hit that contains Enhanced Ecommerce REFUND information.

localRefundAmount
NUMBER

Refund amount in local currency, expressed as the value passed to Analytics multiplied by 10^6.

refundAmount
NUMBER

Refund amount, expressed as the value passed to Analytics multiplied by 10^6.

ga_session_hits (table), refund (attribute)

social
OBJECT

This section is populated for each hit with type = SOCIAL.

hasSocialSourceReferral
STRING

A string, either Yes or No, that indicates whether sessions to the property are from a social source.

socialInteractionAction
STRING

The social action passed with the social tracking code.

socialInteractionNetwork
STRING

The the network passed with the social tracking code.

socialInteractionNetworkAction
STRING

For social interactions, this represents the social network being tracked.

socialInteractionTarget
STRING

For social interactions, this is the URL, or resource, which receives the social network action.

socialInteractions
NUMBER

The total number of social interactions.

socialNetwork
STRING

The social network name.

uniqueSocialInteractions
NUMBER

The number of sessions during which the specified social action(s) occurred at least once. This is based on the the unique combination of socialInteractionNetwork, socialInteractionAction, and socialInteractionTarget.

ga_session_hits (table), social (attribute)

sourcePropertyInfo
OBJECT

This section contains information about source property for rollup properties.

sourcePropertyDisplayName
STRING

Source property display name of Roll-Up Properties.

sourcePropertyTrackingId
STRING

Source property tracking ID of roll-up properties. This is valid for only roll-up properties.

ga_session_hits (table), sourcePropertyInfo (attribute)

time
NUMBER

The number of milliseconds after the visitStartTime when this hit was registered. The first hit has a hits.time of 0

transaction
OBJECT

This section is populated for each hit with type = TRANSACTION.

affiliation
STRING

The affiliate information passed to the ecommerce tracking code.

currencyCode
STRING

The local currency code for the transaction.

localTransactionRevenue
NUMBER

localTransactionShipping
NUMBER

Total transaction revenue in local currency, expressed as the value passed to Analytics multiplied by 10^6.

localTransactionTax
NUMBER

Total transaction tax in local currency, expressed as the value passed to Analytics multiplied by 10^6.

transactionCoupon
STRING

The coupon code associated with the transaction.

transactionId
STRING

The transaction ID of the ecommerce transaction.

transactionRevenue
NUMBER

Total transaction revenue, expressed as the value passed to Analytics multiplied by 10^6.

transactionShipping
NUMBER

Total transaction shipping cost, expressed as the value passed to Analytics multiplied by 10^6.

transactionTax
NUMBER

Total transaction tax, expressed as the value passed to Analytics multiplied by 10^6.

ga_session_hits (table), transaction (attribute)

type
STRING

The type of hit.


Replication Method :

Key-based Incremental

Replication Key :

date

Primary Key :

fullVisitorId : visitId : visitStartTime

API endpoint :

BigQuery Export schema

This table contains information about general Google Analytics sessions.

fullVisitorId
STRING

The unique visitor ID - also known as client ID.

Reference:

visitId
NUMBER

An identifier for this session.

Reference:

visitStartTime
NUMBER

The timestamp expressed as POSIX time.

Reference:

date
DATE-TIME

The date of the session in YYYYMMDD format. For more details about the replication process, refer to the Replication section.

channelGrouping
STRING

The Default Channel Group associated with an end user’s session for this View.

clientId
STRING

Unhashed version of the Client ID for a given user associated with any given visit/session.

customDimensions
ARRAY

This section contains any user-level or session-level custom dimensions that are set for a session. This is a repeated field and has an entry for each dimension that is set.

index
NUMBER

The index of the custom dimension.

value
STRING

The value of the custom dimension.

ga_sessions (table), customDimensions (attribute)

device
OBJECT

This section contains information about the user devices.

browser
STRING

The browser used.

browserSize
STRING

The viewport size of users’ browsers.

browserVersion
STRING

The version of the browser used.

deviceCategory
STRING

The type of device.

flashVersion
STRING

The version of the Adobe Flash plugin that is installed on the browser.

javaEnabled
BOOLEAN

Whether or not Java is enabled in the browser.

language
STRING

The language the device is set to use expressed as the IETF language code.

mobileDeviceBranding
STRING

The brand or manufacturer of the device.

mobileDeviceInfo
STRING

The branding, model, and marketing name used to identify the mobile device.

mobileDeviceMarketingName
STRING

The marketing name used for the mobile device.

mobileDeviceModel
STRING

The mobile device model.

mobileInputSelector
STRING

Selector (e.g., touchscreen, joystick, clickwheel, stylus) used on the mobile device.

operatingSystem
STRING

The operating system of the device.

operatingSystemVersion
STRING

The version of the operating system.

screenColors
STRING

Number of colors supported by the display, expressed as the bit-depth.

screenResolution
STRING

The resolution of the device’s screen expressed in pixel width x height.

ga_sessions (table), device (attribute)

geoNetwork
OBJECT

This section contains information about the geography of the user.

city
STRING

Users’ city, derived from their IP addresses or Geographical IDs.

cityId
STRING

Users’ city ID, derived from their IP addresses or Geographical IDs.

continent
STRING

The continent from which sessions originated, based on IP address.

country
STRING

The country from which sessions originated, based on IP address.

latitude
STRING

The approximate latitude of users’ city, derived from their IP addresses or Geographical IDs.

longitude
STRING

The approximate longitude of users’ city, derived from their IP addresses or Geographical IDs.

metro
STRING

The Designated Market Area (DMA) from which sessions originate.

networkDomain
STRING

The domain name of user’s ISP, derived from the domain name registered to the ISP’s IP address. Note: This is no longer supported by Google BigQuery.

networkLocation
STRING

The names of the service providers used to reach the property. Note: This is no longer supported by Google BigQuery.

region
STRING

The region from which sessions originate, derived from IP addresses.

subContinent
STRING

The sub-continent from which sessions originated, based on IP address of the visitor.

ga_sessions (table), geoNetwork (attribute)

socialEngagementType
STRING

Engagement type, either Socially Engaged or Not Socially Engaged.

totals
OBJECT

This section contains aggregate values across the session.

bounces
NUMBER

The total bounced sessions. For a bounced session, the value is 1, otherwise it is null.

hits
NUMBER

Total number of hits within the session.

newVisits
NUMBER

Total number of new users in session. If this is the first visit, this value is 1, otherwise it is null.

pageviews
NUMBER

Total number of pageviews within the session.

screenviews
NUMBER

Total number of screenviews within the session.

sessionQualityDim
NUMBER

An estimate of how close a particular session was to transacting, ranging from 1 to 100, calculated for each session. A value of 0 indicates that Session Quality is not calculated for the selected time range.

timeOnScreen
NUMBER

The total time on screen in seconds.

timeOnSite
NUMBER

Total time of the session expressed in seconds.

totalTransactionRevenue
NUMBER

Total transaction revenue, expressed as the value passed to Analytics multiplied by 10^6.

transactionRevenue
NUMBER

Note: This field is deprecated. Use totalTransactionRevenue instead.

transactions
NUMBER

Total number of ecommerce transactions within the session.

uniqueScreenViews
NUMBER

Total number of unique screenviews within the session.

visits
NUMBER

The number of sessions. This value is 1 for sessions with interaction events. The value is null if there are no interaction events in the session.

ga_sessions (table), totals (attribute)

trafficSource
OBJECT

This section contains information about the traffic source from which the session originated.

adContent
STRING

The ad content of the traffic source.

adwordsClickInfo
OBJECT

This section contains information about the Google Ads click info, if there is any, associated with the session.

adGroupId
NUMBER

The Google ad-group ID.

adNetworkType
STRING

The network type. It can be one of the following values: Google Search, Content, Search partners, Ad Exchange, Yahoo Japan Search, Yahoo Japan AFS, unknown.

campaignId
NUMBER

The Google Ads campaign ID.

creativeId
NUMBER

The Google ad ID.

criteriaId
NUMBER

The ID for the targeting criterion.

criteriaParameters
STRING

Descriptive string for the targeting criterion.

customerId
NUMBER

The Google Ads Customer ID.

gclId
STRING

The Google Click ID.

isVideoAd
BOOLEAN

True if it is a Trueview video ad.

page
NUMBER

Page number in search results where the ad was shown.

slot
STRING

The position of the ad. It can be one of the following values: RHS, Top.

targetingCriteria
OBJECT

The Google Ads targeting criteria for a click.

boomUserlistId
NUMBER

The remarketing list ID, if any, in Google Ads, derived from matching_criteria in click record.

ga_sessions (table), targetingCriteria (attribute)
ga_sessions (table), adwordsClickInfo (attribute)

campaign
STRING

The campaign value.

campaignCode
STRING

Value of the utm_id campaign tracking parameter.

isTrueDirect
BOOLEAN

TRUE if the source of the session was Direct. This field will also be TRUE if two successive but distinct sessions have exactly the same campaign details. Otherwise NULL.

keyword
STRING

The keyword of the traffic source.

medium
STRING

The medium of the traffic source.

referralPath
STRING

If trafficSource.medium is referral, then this is set to the path of the referrer.

source
STRING

The source of the traffic source.

ga_sessions (table), trafficSource (attribute)

userId
STRING

Overridden User ID sent to Analytics.

visitNumber
NUMBER

The session number for this user.

visitorId
NUMBER

Note: This field is deprecated. Use fullVisitorId instead.



Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.