---
title: Google Analytics
description: Connect Google Analytics, understand its sync behavior, and query every table and column it writes.
species: reference
---
# Google Analytics

Connect Google Analytics with Google OAuth and at least one property. The source writes 67 fixed tables under `titan.google_analytics`.
```sql
select
  property_id,
  resource_name,
  display_name
from titan.google_analytics.admin_properties
limit 10
```

## Connect Google Analytics

1. Open **Apps**, choose **Connect app**, and select **Google Analytics**.
2. Enter Google OAuth and at least one property.
3. Review the tables, then save the source.
4. Watch **Sync history** until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

## Sync behavior

The primary property writes to google_analytics. Additional properties write to google_analytics_<property_id>. Reports can be sampled or thresholded by the source.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only.

## Table reference

### `admin_properties`

`titan.google_analytics.admin_properties` has 14 source columns.

```columns table=google_analytics.admin_properties
property_id                             string pk           Source field `property_id`.
resource_name                           string              Source field `resource_name`.
display_name                            string              Source field `display_name`.
property_type                           string              Source field `property_type`.
account                                 string              Source field `account`.
parent                                  string              Source field `parent`.
industry_category                       string              Source field `industry_category`.
time_zone                               string              Source field `time_zone`.
currency_code                           string              Source field `currency_code`.
service_level                           string              Source field `service_level`.
create_time                             datetime            Source field `create_time`.
update_time                             datetime            Source field `update_time`.
delete_time                             datetime            Source field `delete_time`.
expire_time                             datetime            Source field `expire_time`.
```

### `admin_data_streams`

`titan.google_analytics.admin_data_streams` has 14 source columns.

```columns table=google_analytics.admin_data_streams
data_stream_id                          string pk           Source field `data_stream_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
type                                    string              Source field `type`.
display_name                            string              Source field `display_name`.
create_time                             datetime            Source field `create_time`.
update_time                             datetime            Source field `update_time`.
web_measurement_id                      string              Source field `web_measurement_id`.
web_firebase_app_id                     string              Source field `web_firebase_app_id`.
web_default_uri                         string              Source field `web_default_uri`.
android_firebase_app_id                 string              Source field `android_firebase_app_id`.
android_package_name                    string              Source field `android_package_name`.
ios_firebase_app_id                     string              Source field `ios_firebase_app_id`.
ios_bundle_id                           string              Source field `ios_bundle_id`.
```

### `admin_custom_dimensions`

`titan.google_analytics.admin_custom_dimensions` has 8 source columns.

```columns table=google_analytics.admin_custom_dimensions
custom_dimension_id                     string pk           Source field `custom_dimension_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
parameter_name                          string              Source field `parameter_name`.
display_name                            string              Source field `display_name`.
description                             string              Source field `description`.
scope                                   string              Source field `scope`.
disallow_ads_personalization            boolean             Source field `disallow_ads_personalization`.
```

### `admin_custom_metrics`

`titan.google_analytics.admin_custom_metrics` has 9 source columns.

```columns table=google_analytics.admin_custom_metrics
custom_metric_id                        string pk           Source field `custom_metric_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
parameter_name                          string              Source field `parameter_name`.
display_name                            string              Source field `display_name`.
description                             string              Source field `description`.
measurement_unit                        string              Source field `measurement_unit`.
scope                                   string              Source field `scope`.
restricted_metric_type                  json                Source field `restricted_metric_type`.
```

### `admin_key_events`

`titan.google_analytics.admin_key_events` has 10 source columns.

```columns table=google_analytics.admin_key_events
key_event_id                            string pk           Source field `key_event_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
event_name                              string              Source field `event_name`.
create_time                             datetime            Source field `create_time`.
deletable                               boolean             Source field `deletable`.
custom                                  boolean             Source field `custom`.
counting_method                         string              Source field `counting_method`.
default_value_numeric_value             decimal(28,2)       Source field `default_value_numeric_value`.
default_value_currency_code             string              Source field `default_value_currency_code`.
```

### `admin_google_ads_links`

`titan.google_analytics.admin_google_ads_links` has 9 source columns.

```columns table=google_analytics.admin_google_ads_links
google_ads_link_id                      string pk           Source field `google_ads_link_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
customer_id                             string              Source field `customer_id`.
can_manage_clients                      boolean             Source field `can_manage_clients`.
ads_personalization_enabled             boolean             Source field `ads_personalization_enabled`.
create_time                             datetime            Source field `create_time`.
update_time                             datetime            Source field `update_time`.
creator_email_address                   string              Source field `creator_email_address`.
```

### `admin_audiences`

`titan.google_analytics.admin_audiences` has 12 source columns.

```columns table=google_analytics.admin_audiences
audience_id                             string pk           Source field `audience_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
display_name                            string              Source field `display_name`.
description                             string              Source field `description`.
membership_duration_days                integer             Source field `membership_duration_days`.
ads_personalization_enabled             boolean             Source field `ads_personalization_enabled`.
exclusion_duration_mode                 string              Source field `exclusion_duration_mode`.
event_trigger_event_name                string              Source field `event_trigger_event_name`.
event_trigger_log_condition             string              Source field `event_trigger_log_condition`.
filter_clauses                          json                Source field `filter_clauses`.
create_time                             datetime            Source field `create_time`.
```

### `admin_calculated_metrics`

`titan.google_analytics.admin_calculated_metrics` has 9 source columns.

```columns table=google_analytics.admin_calculated_metrics
calculated_metric_id                    string pk           Source field `calculated_metric_id`.
resource_name                           string              Source field `resource_name`.
property_id                             string              Source field `property_id`.
display_name                            string              Source field `display_name`.
description                             string              Source field `description`.
metric_unit                             string              Source field `metric_unit`.
restricted_metric_type                  json                Source field `restricted_metric_type`.
formula                                 string              Source field `formula`.
invalid_metric_reference                boolean             Source field `invalid_metric_reference`.
```

### `dimensions`

`titan.google_analytics.dimensions` has 7 source columns.

```columns table=google_analytics.dimensions
api_name                                string pk           Source field `api_name`.
property_id                             string              Source field `property_id`.
ui_name                                 string              Source field `ui_name`.
description                             string              Source field `description`.
category                                string              Source field `category`.
custom_definition                       boolean             Source field `custom_definition`.
deprecated_api_names                    json                Source field `deprecated_api_names`.
```

### `metrics`

`titan.google_analytics.metrics` has 10 source columns.

```columns table=google_analytics.metrics
api_name                                string pk           Source field `api_name`.
property_id                             string              Source field `property_id`.
ui_name                                 string              Source field `ui_name`.
description                             string              Source field `description`.
category                                string              Source field `category`.
custom_definition                       boolean             Source field `custom_definition`.
deprecated_api_names                    json                Source field `deprecated_api_names`.
type                                    string              Source field `type`.
expression                              string              Source field `expression`.
blocked_reasons                         json                Source field `blocked_reasons`.
```

### `daily_active_users`

`titan.google_analytics.daily_active_users` has 2 source columns.

```columns table=google_analytics.daily_active_users
date                                    date pk             Source field `date`.
active1day_users                        integer             Source field `active1DayUsers`.
```

### `weekly_active_users`

`titan.google_analytics.weekly_active_users` has 2 source columns.

```columns table=google_analytics.weekly_active_users
date                                    date pk             Source field `date`.
active7day_users                        integer             Source field `active7DayUsers`.
```

### `four_weekly_active_users`

`titan.google_analytics.four_weekly_active_users` has 2 source columns.

```columns table=google_analytics.four_weekly_active_users
date                                    date pk             Source field `date`.
active28day_users                       integer             Source field `active28DayUsers`.
```

### `website_overview`

`titan.google_analytics.website_overview` has 9 source columns.

```columns table=google_analytics.website_overview
date                                    date pk             Source field `date`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
sessions                                integer             Source field `sessions`.
sessions_per_user                       decimal(28,6)       Source field `sessionsPerUser`.
average_session_duration                decimal(28,6)       Source field `averageSessionDuration`.
screen_page_views                       integer             Source field `screenPageViews`.
screen_page_views_per_session           decimal(28,6)       Source field `screenPageViewsPerSession`.
bounce_rate                             decimal(28,6)       Source field `bounceRate`.
```

### `devices`

`titan.google_analytics.devices` has 12 source columns.

```columns table=google_analytics.devices
date                                    date pk             Source field `date`.
device_category                         string pk           Source field `deviceCategory`.
operating_system                        string pk           Source field `operatingSystem`.
browser                                 string pk           Source field `browser`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
sessions                                integer             Source field `sessions`.
sessions_per_user                       decimal(28,6)       Source field `sessionsPerUser`.
average_session_duration                decimal(28,6)       Source field `averageSessionDuration`.
screen_page_views                       integer             Source field `screenPageViews`.
screen_page_views_per_session           decimal(28,6)       Source field `screenPageViewsPerSession`.
bounce_rate                             decimal(28,6)       Source field `bounceRate`.
```

### `locations`

`titan.google_analytics.locations` has 12 source columns.

```columns table=google_analytics.locations
date                                    date pk             Source field `date`.
country                                 string pk           Source field `country`.
region                                  string pk           Source field `region`.
city                                    string pk           Source field `city`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
sessions                                integer             Source field `sessions`.
sessions_per_user                       decimal(28,6)       Source field `sessionsPerUser`.
average_session_duration                decimal(28,6)       Source field `averageSessionDuration`.
screen_page_views                       integer             Source field `screenPageViews`.
screen_page_views_per_session           decimal(28,6)       Source field `screenPageViewsPerSession`.
bounce_rate                             decimal(28,6)       Source field `bounceRate`.
```

### `pages`

`titan.google_analytics.pages` has 5 source columns.

```columns table=google_analytics.pages
date                                    date pk             Source field `date`.
host_name                               string pk           Source field `hostName`.
page_path_plus_query_string             string pk           Source field `pagePathPlusQueryString`.
screen_page_views                       integer             Source field `screenPageViews`.
bounce_rate                             decimal(28,6)       Source field `bounceRate`.
```

### `traffic_sources`

`titan.google_analytics.traffic_sources` has 11 source columns.

```columns table=google_analytics.traffic_sources
date                                    date pk             Source field `date`.
session_source                          string pk           Source field `sessionSource`.
session_medium                          string pk           Source field `sessionMedium`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
sessions                                integer             Source field `sessions`.
sessions_per_user                       decimal(28,6)       Source field `sessionsPerUser`.
average_session_duration                decimal(28,6)       Source field `averageSessionDuration`.
screen_page_views                       integer             Source field `screenPageViews`.
screen_page_views_per_session           decimal(28,6)       Source field `screenPageViewsPerSession`.
bounce_rate                             decimal(28,6)       Source field `bounceRate`.
```

### `user_acquisition_first_user_medium`

`titan.google_analytics.user_acquisition_first_user_medium` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_medium
date                                    date pk             Source field `date`.
first_user_medium                       string pk           Source field `firstUserMedium`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_source`

`titan.google_analytics.user_acquisition_first_user_source` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_source
date                                    date pk             Source field `date`.
first_user_source                       string pk           Source field `firstUserSource`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_source_medium`

`titan.google_analytics.user_acquisition_first_user_source_medium` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_source_medium
date                                    date pk             Source field `date`.
first_user_source_medium                string pk           Source field `firstUserSourceMedium`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_source_platform`

`titan.google_analytics.user_acquisition_first_user_source_platform` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_source_platform
date                                    date pk             Source field `date`.
first_user_source_platform              string pk           Source field `firstUserSourcePlatform`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_campaign`

`titan.google_analytics.user_acquisition_first_user_campaign` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_campaign
date                                    date pk             Source field `date`.
first_user_campaign_name                string pk           Source field `firstUserCampaignName`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_google_ads_ad_network_type`

`titan.google_analytics.user_acquisition_first_user_google_ads_ad_network_type` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_google_ads_ad_network_type
date                                    date pk             Source field `date`.
first_user_google_ads_ad_network_type   string pk           Source field `firstUserGoogleAdsAdNetworkType`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `user_acquisition_first_user_google_ads_ad_group_name`

`titan.google_analytics.user_acquisition_first_user_google_ads_ad_group_name` has 10 source columns.

```columns table=google_analytics.user_acquisition_first_user_google_ads_ad_group_name
date                                    date pk             Source field `date`.
first_user_google_ads_ad_group_name     string pk           Source field `firstUserGoogleAdsAdGroupName`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
total_users                             integer             Source field `totalUsers`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_source_medium`

`titan.google_analytics.traffic_acquisition_session_source_medium` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_source_medium
date                                    date pk             Source field `date`.
session_source_medium                   string pk           Source field `sessionSourceMedium`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_medium`

`titan.google_analytics.traffic_acquisition_session_medium` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_medium
date                                    date pk             Source field `date`.
session_medium                          string pk           Source field `sessionMedium`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_source`

`titan.google_analytics.traffic_acquisition_session_source` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_source
date                                    date pk             Source field `date`.
session_source                          string pk           Source field `sessionSource`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_campaign`

`titan.google_analytics.traffic_acquisition_session_campaign` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_campaign
date                                    date pk             Source field `date`.
session_campaign_name                   string pk           Source field `sessionCampaignName`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_default_channel_group`

`titan.google_analytics.traffic_acquisition_session_default_channel_group` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_default_channel_group
date                                    date pk             Source field `date`.
session_default_channel_group           string pk           Source field `sessionDefaultChannelGroup`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `traffic_acquisition_session_source_platform`

`titan.google_analytics.traffic_acquisition_session_source_platform` has 11 source columns.

```columns table=google_analytics.traffic_acquisition_session_source_platform
date                                    date pk             Source field `date`.
session_source_platform                 string pk           Source field `sessionSourcePlatform`.
total_users                             integer             Source field `totalUsers`.
sessions                                integer             Source field `sessions`.
engaged_sessions                        integer             Source field `engagedSessions`.
events_per_session                      decimal(28,6)       Source field `eventsPerSession`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `events`

`titan.google_analytics.events` has 6 source columns.

```columns table=google_analytics.events
date                                    date pk             Source field `date`.
event_name                              string pk           Source field `eventName`.
event_count                             integer             Source field `eventCount`.
total_users                             integer             Source field `totalUsers`.
event_count_per_user                    decimal(28,6)       Source field `eventCountPerUser`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `weekly_events`

`titan.google_analytics.weekly_events` has 6 source columns.

```columns table=google_analytics.weekly_events
year_week                               string pk           Source field `yearWeek`.
event_name                              string pk           Source field `eventName`.
event_count                             integer             Source field `eventCount`.
total_users                             integer             Source field `totalUsers`.
event_count_per_user                    decimal(28,6)       Source field `eventCountPerUser`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `key_events`

`titan.google_analytics.key_events` has 5 source columns.

```columns table=google_analytics.key_events
date                                    date pk             Source field `date`.
event_name                              string pk           Source field `eventName`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_users                             integer             Source field `totalUsers`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `pages_path`

`titan.google_analytics.pages_path` has 9 source columns.

```columns table=google_analytics.pages_path
date                                    date pk             Source field `date`.
page_path                               string pk           Source field `pagePath`.
screen_page_views                       integer             Source field `screenPageViews`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `pages_title_screen_class`

`titan.google_analytics.pages_title_screen_class` has 9 source columns.

```columns table=google_analytics.pages_title_screen_class
date                                    date pk             Source field `date`.
unified_screen_class                    string pk           Source field `unifiedScreenClass`.
screen_page_views                       integer             Source field `screenPageViews`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `pages_title_screen_name`

`titan.google_analytics.pages_title_screen_name` has 9 source columns.

```columns table=google_analytics.pages_title_screen_name
date                                    date pk             Source field `date`.
unified_screen_name                     string pk           Source field `unifiedScreenName`.
screen_page_views                       integer             Source field `screenPageViews`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `content_group`

`titan.google_analytics.content_group` has 9 source columns.

```columns table=google_analytics.content_group
date                                    date pk             Source field `date`.
content_group                           string pk           Source field `contentGroup`.
screen_page_views                       integer             Source field `screenPageViews`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
user_engagement_duration                decimal(28,6)       Source field `userEngagementDuration`.
```

### `ecommerce_purchases_item_name`

`titan.google_analytics.ecommerce_purchases_item_name` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_name
date                                    date pk             Source field `date`.
item_name                               string pk           Source field `itemName`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_id`

`titan.google_analytics.ecommerce_purchases_item_id` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_id
date                                    date pk             Source field `date`.
item_id                                 string pk           Source field `itemId`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_brand`

`titan.google_analytics.ecommerce_purchases_item_brand` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_brand
date                                    date pk             Source field `date`.
item_brand                              string pk           Source field `itemBrand`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category`

`titan.google_analytics.ecommerce_purchases_item_category` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category
date                                    date pk             Source field `date`.
item_category                           string pk           Source field `itemCategory`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category_2`

`titan.google_analytics.ecommerce_purchases_item_category_2` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category_2
date                                    date pk             Source field `date`.
item_category2                          string pk           Source field `itemCategory2`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category_3`

`titan.google_analytics.ecommerce_purchases_item_category_3` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category_3
date                                    date pk             Source field `date`.
item_category3                          string pk           Source field `itemCategory3`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category_4`

`titan.google_analytics.ecommerce_purchases_item_category_4` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category_4
date                                    date pk             Source field `date`.
item_category4                          string pk           Source field `itemCategory4`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category_5`

`titan.google_analytics.ecommerce_purchases_item_category_5` has 8 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category_5
date                                    date pk             Source field `date`.
item_category5                          string pk           Source field `itemCategory5`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `ecommerce_purchases_item_category_combined`

`titan.google_analytics.ecommerce_purchases_item_category_combined` has 12 source columns.

```columns table=google_analytics.ecommerce_purchases_item_category_combined
date                                    date pk             Source field `date`.
item_category                           string pk           Source field `itemCategory`.
item_category2                          string pk           Source field `itemCategory2`.
item_category3                          string pk           Source field `itemCategory3`.
item_category4                          string pk           Source field `itemCategory4`.
item_category5                          string pk           Source field `itemCategory5`.
cart_to_view_rate                       decimal(28,6)       Source field `cartToViewRate`.
purchase_to_view_rate                   decimal(28,6)       Source field `purchaseToViewRate`.
items_purchased                         integer             Source field `itemsPurchased`.
item_revenue                            decimal(28,2)       Source field `itemRevenue`.
items_added_to_cart                     integer             Source field `itemsAddedToCart`.
items_viewed                            integer             Source field `itemsViewed`.
```

### `publisher_ads_ad_unit`

`titan.google_analytics.publisher_ads_ad_unit` has 6 source columns.

```columns table=google_analytics.publisher_ads_ad_unit
date                                    date pk             Source field `date`.
ad_unit_name                            string pk           Source field `adUnitName`.
publisher_ad_impressions                integer             Source field `publisherAdImpressions`.
ad_unit_exposure                        decimal(28,6)       Source field `adUnitExposure`.
publisher_ad_clicks                     integer             Source field `publisherAdClicks`.
total_ad_revenue                        decimal(28,2)       Source field `totalAdRevenue`.
```

### `publisher_ads_page_path`

`titan.google_analytics.publisher_ads_page_path` has 6 source columns.

```columns table=google_analytics.publisher_ads_page_path
date                                    date pk             Source field `date`.
page_path                               string pk           Source field `pagePath`.
publisher_ad_impressions                integer             Source field `publisherAdImpressions`.
ad_unit_exposure                        decimal(28,6)       Source field `adUnitExposure`.
publisher_ad_clicks                     integer             Source field `publisherAdClicks`.
total_ad_revenue                        decimal(28,2)       Source field `totalAdRevenue`.
```

### `publisher_ads_ad_format`

`titan.google_analytics.publisher_ads_ad_format` has 6 source columns.

```columns table=google_analytics.publisher_ads_ad_format
date                                    date pk             Source field `date`.
ad_format                               string pk           Source field `adFormat`.
publisher_ad_impressions                integer             Source field `publisherAdImpressions`.
ad_unit_exposure                        decimal(28,6)       Source field `adUnitExposure`.
publisher_ad_clicks                     integer             Source field `publisherAdClicks`.
total_ad_revenue                        decimal(28,2)       Source field `totalAdRevenue`.
```

### `publisher_ads_ad_source`

`titan.google_analytics.publisher_ads_ad_source` has 6 source columns.

```columns table=google_analytics.publisher_ads_ad_source
date                                    date pk             Source field `date`.
ad_source_name                          string pk           Source field `adSourceName`.
publisher_ad_impressions                integer             Source field `publisherAdImpressions`.
ad_unit_exposure                        decimal(28,6)       Source field `adUnitExposure`.
publisher_ad_clicks                     integer             Source field `publisherAdClicks`.
total_ad_revenue                        decimal(28,2)       Source field `totalAdRevenue`.
```

### `demographic_country`

`titan.google_analytics.demographic_country` has 8 source columns.

```columns table=google_analytics.demographic_country
date                                    date pk             Source field `date`.
country                                 string pk           Source field `country`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_region`

`titan.google_analytics.demographic_region` has 8 source columns.

```columns table=google_analytics.demographic_region
date                                    date pk             Source field `date`.
region                                  string pk           Source field `region`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_city`

`titan.google_analytics.demographic_city` has 8 source columns.

```columns table=google_analytics.demographic_city
date                                    date pk             Source field `date`.
city                                    string pk           Source field `city`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_language`

`titan.google_analytics.demographic_language` has 8 source columns.

```columns table=google_analytics.demographic_language
date                                    date pk             Source field `date`.
language                                string pk           Source field `language`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_age`

`titan.google_analytics.demographic_age` has 8 source columns.

```columns table=google_analytics.demographic_age
date                                    date pk             Source field `date`.
user_age_bracket                        string pk           Source field `userAgeBracket`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_gender`

`titan.google_analytics.demographic_gender` has 8 source columns.

```columns table=google_analytics.demographic_gender
date                                    date pk             Source field `date`.
user_gender                             string pk           Source field `userGender`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `demographic_interest`

`titan.google_analytics.demographic_interest` has 8 source columns.

```columns table=google_analytics.demographic_interest
date                                    date pk             Source field `date`.
branding_interest                       string pk           Source field `brandingInterest`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_browser`

`titan.google_analytics.tech_browser` has 9 source columns.

```columns table=google_analytics.tech_browser
date                                    date pk             Source field `date`.
browser                                 string pk           Source field `browser`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_device_category`

`titan.google_analytics.tech_device_category` has 9 source columns.

```columns table=google_analytics.tech_device_category
date                                    date pk             Source field `date`.
device_category                         string pk           Source field `deviceCategory`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_device_model`

`titan.google_analytics.tech_device_model` has 9 source columns.

```columns table=google_analytics.tech_device_model
date                                    date pk             Source field `date`.
device_model                            string pk           Source field `deviceModel`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_screen_resolution`

`titan.google_analytics.tech_screen_resolution` has 9 source columns.

```columns table=google_analytics.tech_screen_resolution
date                                    date pk             Source field `date`.
screen_resolution                       string pk           Source field `screenResolution`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_app_version`

`titan.google_analytics.tech_app_version` has 9 source columns.

```columns table=google_analytics.tech_app_version
date                                    date pk             Source field `date`.
app_version                             string pk           Source field `appVersion`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_platform`

`titan.google_analytics.tech_platform` has 9 source columns.

```columns table=google_analytics.tech_platform
date                                    date pk             Source field `date`.
platform                                string pk           Source field `platform`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_platform_device_category`

`titan.google_analytics.tech_platform_device_category` has 9 source columns.

```columns table=google_analytics.tech_platform_device_category
date                                    date pk             Source field `date`.
platform_device_category                string pk           Source field `platformDeviceCategory`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_operating_system`

`titan.google_analytics.tech_operating_system` has 9 source columns.

```columns table=google_analytics.tech_operating_system
date                                    date pk             Source field `date`.
operating_system                        string pk           Source field `operatingSystem`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

### `tech_os_with_version`

`titan.google_analytics.tech_os_with_version` has 9 source columns.

```columns table=google_analytics.tech_os_with_version
date                                    date pk             Source field `date`.
operating_system_with_version           string pk           Source field `operatingSystemWithVersion`.
total_users                             integer             Source field `totalUsers`.
new_users                               integer             Source field `newUsers`.
engaged_sessions                        integer             Source field `engagedSessions`.
engagement_rate                         decimal(28,6)       Source field `engagementRate`.
event_count                             integer             Source field `eventCount`.
key_events                              decimal(28,6)       Source field `keyEvents`.
total_revenue                           decimal(28,2)       Source field `totalRevenue`.
```

## Deletes and history

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.