# Google Analytics 360 (v1) Information note **Google Analytics 360 integrations are an upgraded feature** Google Analytics 360 integrations are an upgraded feature that’s available during the free trial or for customers on an Advanced or Premium plan. For more info about Stitch Advanced, contact the [Stitch Sales team](https://www.stitchdata.com/contact/). Information note **Google Analytics 360 is in beta** Google Analytics 360 is currently in beta. The info in this guide is subject to change. Information note **Google Analytics 360 extraction is supported by Stitch** This integration is powered by [Singer's](https://www.singer.io/) Google Analytics 360 tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-ga360). For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport). ## Google Analytics 360 integration summary Stitch’s Google Analytics 360 integration replicates data using the [BigQuery API](https://cloud.google.com/bigquery/docs/reference/rest). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#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](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Beta | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Advanced | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.

Available | | **Singer GitHub repository** | [singer-io/tap-ga360](https://github.com/singer-io/tap-ga360) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.

Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.

Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported

Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | ## Connecting Google Analytics 360 ### Google Analytics 360 setup requirements To set up Google Analytics 360 in Stitch, you need: * **A Stitch Advanced plan.** * **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](https://support.google.com/analytics/answer/3416092?hl=en&ref_topic=3416089). ### 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](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#define-service-account-details) * [Step 2.2: Assign service account permissions](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#assign-service-account-permissions) * [Step 2.3: Create a JSON project key](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#create-json-project-key) #### Step 2.1: Define the service account details 1. Navigate to the [IAM Service Accounts page](https://console.cloud.google.com/iam-admin/serviceaccounts) 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](https://help.qlik.com/en-US/stitch/images/destinations/bigquery-gcp-project-menu.png)Highlighted project selection menu in the Google Cloud Platform consoleHighlighted 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](https://help.qlik.com/en-US/stitch/images/destinations/bigquery-readonly-roles.png)BigQuery read-only rolesBigQuery 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](https://help.qlik.com/en-US/stitch/images/destinations/bigquery-create-project-key-file.png)Create project key section, highlighted in the Google Cloud Platform consoleCreate 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](https://app.stitchdata.com/). 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](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#retrieve-project-dataset-ids). 6. In the **Service Account JSON** field, paste the JSON project key you obtained in [Step 2.3](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#create-gcp-iam-service-account). ### Step 4: Define the historical replication start date The Sync Historical Data setting defines 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](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 5: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). 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: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 6: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Google Analytics 360 integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue 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. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### 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.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### 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. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## 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](https://support.google.com/analytics/answer/3437719?hl=en) 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 reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. This is the latest version of the Google Analytics 360 integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### ga\_session\_hits This table contains information about Google Analytics session hits. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | visitId

fullVisitorId

visitStartTime

hitNumber | | **Useful links** | [ga_session_hits schema on GitHub](https://github.com/singer-io/tap-ga360/blob/master/tap_ga360/schemas/ga_session_hits.json "Opens in new tab: ga_session_hits schema on GitHub")

[Google Analytics 360 API method](https://support.google.com/analytics/answer/3437719?hl=en&ref_topic=3416089 "Opens in new tab: Google Analytics 360 API method") | ga\_session\_hits table foreign keys | Join ga\_session\_hits with | on | | --- | --- | | [ga_sessions](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#ga-sessions) | ```
ga_session_hits.visitId = ga_sessions.visitId
```

```
ga_session_hits.fullVisitorId = ga_sessions.fullVisitorId
```

```
ga_session_hits.visitStartTime = ga_sessions.visitStartTime
``` | ga\_session\_hits table schema | **appInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand appInfo

appId

STRING

appInstallerId

STRING

appName

STRING

appVersion

STRING

exitScreenName

STRING

landingScreenName

STRING

screenDepth

STRING

screenName

STRING

| | --- | | **contentGroup**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand contentGroup

contentGroup1

STRING

contentGroup2

STRING

contentGroup3

STRING

contentGroup4

STRING

contentGroup5

STRING

contentGroupUniqueViews1

NUMBER

contentGroupUniqueViews2

NUMBER

contentGroupUniqueViews3

NUMBER

contentGroupUniqueViews4

NUMBER

contentGroupUniqueViews5

NUMBER

previousContentGroup1

STRING

previousContentGroup2

STRING

previousContentGroup3

STRING

previousContentGroup4

STRING

previousContentGroup5

STRING

| | **contentInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand contentInfo

contentDescription

STRING

| | **customDimensions**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand customDimensions

index

NUMBER

value

STRING

| | **customMetrics**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand customMetrics

index

NUMBER

value

NUMBER

| | **customVariables**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand customVariables

customVarName

STRING

customVarValue

STRING

index

NUMBER

| | **dataSource**

STRING | | **eCommerceAction**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand eCommerceAction

action_type

STRING

option

STRING

step

NUMBER

| | **eventInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand eventInfo

eventAction

STRING

eventCategory

STRING

eventLabel

STRING

eventValue

NUMBER

| | **exceptionInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand exceptionInfo

description

STRING

exceptions

NUMBER

fatalExceptions

NUMBER

isFatal

BOOLEAN

| | **experiment**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand experiment

experimentId

STRING

experimentVariant

STRING

| | **fullVisitorId**

STRING | | **hitNumber**

NUMBER | | **hour**

NUMBER | | **isEntrance**

BOOLEAN | | **isExit**

BOOLEAN | | **isInteraction**

BOOLEAN | | **isSecure**

BOOLEAN | | **item**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand item

currencyCode

STRING

itemQuantity

NUMBER

itemRevenue

NUMBER

localItemRevenue

NUMBER

productCategory

STRING

productName

STRING

productSku

STRING

transactionId

STRING

| | **latencyTracking**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand latencyTracking

domContentLoadedTime

NUMBER

domInteractiveTime

NUMBER

domLatencyMetricsSample

NUMBER

domainLookupTime

NUMBER

pageDownloadTime

NUMBER

pageLoadSample

NUMBER

pageLoadTime

NUMBER

redirectionTime

NUMBER

serverConnectionTime

NUMBER

serverResponseTime

NUMBER

speedMetricsSample

NUMBER

userTimingCategory

STRING

userTimingLabel

STRING

userTimingSample

NUMBER

userTimingValue

NUMBER

userTimingVariable

STRING

| | **minute**

NUMBER | | **page**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand page

hostname

STRING

pagePath

STRING

pagePathLevel1

STRING

pagePathLevel2

STRING

pagePathLevel3

STRING

pagePathLevel4

STRING

pageTitle

STRING

searchCategory

STRING

searchKeyword

STRING

| | **product**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand product

customDimensions

ARRAY

index

NUMBER

value

STRING

customMetrics

ARRAY

index

NUMBER

value

NUMBER

isClick

BOOLEAN

isImpression

BOOLEAN

localProductPrice

NUMBER

localProductRefundAmount

NUMBER

localProductRevenue

NUMBER

productBrand

STRING

productListName

STRING

productListPosition

NUMBER

productPrice

NUMBER

productQuantity

NUMBER

productRefundAmount

NUMBER

productRevenue

NUMBER

productSKU

STRING

productVariant

STRING

v2ProductCategory

STRING

v2ProductName

STRING

| | **promotion**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand promotion

promoCreative

STRING

promoId

STRING

promoName

STRING

promoPosition

STRING

| | **promotionActionInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand promotionActionInfo

promoIsClick

BOOLEAN

promoIsView

BOOLEAN

| | **publisher**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand publisher

adsClicked

NUMBER

adsPagesViewed

NUMBER

adsRevenue

NUMBER

adsUnitsMatched

NUMBER

adsUnitsViewed

NUMBER

adsViewed

NUMBER

adsenseBackfillDfpClicks

NUMBER

adsenseBackfillDfpImpressions

NUMBER

adsenseBackfillDfpMatchedQueries

NUMBER

adsenseBackfillDfpMeasurableImpressions

NUMBER

adsenseBackfillDfpPagesViewed

NUMBER

adsenseBackfillDfpQueries

NUMBER

adsenseBackfillDfpRevenueCpc

NUMBER

adsenseBackfillDfpRevenueCpm

NUMBER

adsenseBackfillDfpViewableImpressions

NUMBER

adxBackfillDfpClicks

NUMBER

adxBackfillDfpImpressions

NUMBER

adxBackfillDfpMatchedQueries

NUMBER

adxBackfillDfpMeasurableImpressions

NUMBER

adxBackfillDfpPagesViewed

NUMBER

adxBackfillDfpQueries

NUMBER

adxBackfillDfpRevenueCpc

NUMBER

adxBackfillDfpRevenueCpm

NUMBER

adxBackfillDfpViewableImpressions

NUMBER

adxClicks

NUMBER

adxImpressions

NUMBER

adxMatchedQueries

NUMBER

adxMeasurableImpressions

NUMBER

adxPagesViewed

NUMBER

adxQueries

NUMBER

adxRevenue

NUMBER

adxViewableImpressions

NUMBER

dfpAdGroup

STRING

dfpAdUnits

STRING

dfpClicks

NUMBER

dfpImpressions

NUMBER

dfpMatchedQueries

NUMBER

dfpMeasurableImpressions

NUMBER

dfpNetworkId

STRING

dfpPagesViewed

NUMBER

dfpQueries

NUMBER

dfpRevenueCpc

NUMBER

dfpRevenueCpm

NUMBER

dfpViewableImpressions

NUMBER

measurableAdsViewed

NUMBER

viewableAdsViewed

NUMBER

| | **referer**

STRING | | **refund**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand refund

localRefundAmount

NUMBER

refundAmount

NUMBER

| | **social**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand social

hasSocialSourceReferral

STRING

socialInteractionAction

STRING

socialInteractionNetwork

STRING

socialInteractionNetworkAction

STRING

socialInteractionTarget

STRING

socialInteractions

NUMBER

socialNetwork

STRING

uniqueSocialInteractions

NUMBER

| | **sourcePropertyInfo**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand sourcePropertyInfo

sourcePropertyDisplayName

STRING

sourcePropertyTrackingId

STRING

| | **time**

NUMBER | | **transaction**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transaction

affiliation

STRING

currencyCode

STRING

localTransactionRevenue

NUMBER

localTransactionShipping

NUMBER

localTransactionTax

NUMBER

transactionCoupon

STRING

transactionId

STRING

transactionRevenue

NUMBER

transactionShipping

NUMBER

transactionTax

NUMBER

| | **type**

STRING | | **visitId**

NUMBER | | **visitStartTime**

NUMBER | ### ga\_sessions This table contains information about general Google Analytics sessions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | fullVisitorId

visitId

visitStartTime | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [ga_sessions schema on GitHub](https://github.com/singer-io/tap-ga360/blob/master/tap_ga360/schemas/ga_sessions.json "Opens in new tab: ga_sessions schema on GitHub")

[Google Analytics 360 API method](https://support.google.com/analytics/answer/3437719?hl=en&ref_topic=3416089 "Opens in new tab: Google Analytics 360 API method") | ga\_sessions table foreign keys | Join ga\_sessions with | on | | --- | --- | | [ga_session_hits](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics-360#ga-session-hits) | ```
ga_sessions.visitId = ga_session_hits.visitId
```

```
ga_sessions.fullVisitorId = ga_session_hits.fullVisitorId
```

```
ga_sessions.visitStartTime = ga_session_hits.visitStartTime
``` | ga\_sessions table schema | **channelGrouping**

STRING | | --- | | **clientId**

STRING | | **customDimensions**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand customDimensions

index

NUMBER

value

STRING

| | **date**

DATE-TIME | | **device**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand device

browser

STRING

browserSize

STRING

browserVersion

STRING

deviceCategory

STRING

flashVersion

STRING

javaEnabled

BOOLEAN

language

STRING

mobileDeviceBranding

STRING

mobileDeviceInfo

STRING

mobileDeviceMarketingName

STRING

mobileDeviceModel

STRING

mobileInputSelector

STRING

operatingSystem

STRING

operatingSystemVersion

STRING

screenColors

STRING

screenResolution

STRING

| | **fullVisitorId**

STRING | | **geoNetwork**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand geoNetwork

city

STRING

cityId

STRING

continent

STRING

country

STRING

latitude

STRING

longitude

STRING

metro

STRING

networkDomain

STRING

networkLocation

STRING

region

STRING

subContinent

STRING

| | **socialEngagementType**

STRING | | **totals**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand totals

bounces

NUMBER

hits

NUMBER

newVisits

NUMBER

pageviews

NUMBER

screenviews

NUMBER

sessionQualityDim

NUMBER

timeOnScreen

NUMBER

timeOnSite

NUMBER

totalTransactionRevenue

NUMBER

transactionRevenue

NUMBER

transactions

NUMBER

uniqueScreenViews

NUMBER

visits

NUMBER

| | **trafficSource**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand trafficSource

adContent

STRING

adwordsClickInfo

OBJECT

adGroupId

NUMBER

adNetworkType

STRING

campaignId

NUMBER

creativeId

NUMBER

criteriaId

NUMBER

criteriaParameters

STRING

customerId

NUMBER

gclId

STRING

isVideoAd

BOOLEAN

page

NUMBER

slot

STRING

targetingCriteria

OBJECT

boomUserlistId

NUMBER

campaign

STRING

campaignCode

STRING

isTrueDirect

BOOLEAN

keyword

STRING

medium

STRING

referralPath

STRING

source

STRING