Supernova home
Documentation menu

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

google_analytics.admin_properties14 columns
property_idstringpk

Source field property_id.

resource_namestring

Source field resource_name.

display_namestring

Source field display_name.

property_typestring

Source field property_type.

accountstring

Source field account.

parentstring

Source field parent.

industry_categorystring

Source field industry_category.

time_zonestring

Source field time_zone.

currency_codestring

Source field currency_code.

service_levelstring

Source field service_level.

create_timedatetime

Source field create_time.

update_timedatetime

Source field update_time.

delete_timedatetime

Source field delete_time.

expire_timedatetime

Source field expire_time.

admin_data_streams#

titan.google_analytics.admin_data_streams has 14 source columns.

google_analytics.admin_data_streams14 columns
data_stream_idstringpk

Source field data_stream_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

typestring

Source field type.

display_namestring

Source field display_name.

create_timedatetime

Source field create_time.

update_timedatetime

Source field update_time.

web_measurement_idstring

Source field web_measurement_id.

web_firebase_app_idstring

Source field web_firebase_app_id.

web_default_uristring

Source field web_default_uri.

android_firebase_app_idstring

Source field android_firebase_app_id.

android_package_namestring

Source field android_package_name.

ios_firebase_app_idstring

Source field ios_firebase_app_id.

ios_bundle_idstring

Source field ios_bundle_id.

admin_custom_dimensions#

titan.google_analytics.admin_custom_dimensions has 8 source columns.

google_analytics.admin_custom_dimensions8 columns
custom_dimension_idstringpk

Source field custom_dimension_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

parameter_namestring

Source field parameter_name.

display_namestring

Source field display_name.

descriptionstring

Source field description.

scopestring

Source field scope.

disallow_ads_personalizationboolean

Source field disallow_ads_personalization.

admin_custom_metrics#

titan.google_analytics.admin_custom_metrics has 9 source columns.

google_analytics.admin_custom_metrics9 columns
custom_metric_idstringpk

Source field custom_metric_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

parameter_namestring

Source field parameter_name.

display_namestring

Source field display_name.

descriptionstring

Source field description.

measurement_unitstring

Source field measurement_unit.

scopestring

Source field scope.

restricted_metric_typejson

Source field restricted_metric_type.

admin_key_events#

titan.google_analytics.admin_key_events has 10 source columns.

google_analytics.admin_key_events10 columns
key_event_idstringpk

Source field key_event_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

event_namestring

Source field event_name.

create_timedatetime

Source field create_time.

deletableboolean

Source field deletable.

customboolean

Source field custom.

counting_methodstring

Source field counting_method.

default_value_numeric_valuedecimal(28,2)

Source field default_value_numeric_value.

default_value_currency_codestring

Source field default_value_currency_code.

admin_google_ads_links#

titan.google_analytics.admin_google_ads_links has 9 source columns.

google_analytics.admin_google_ads_links9 columns

admin_audiences#

titan.google_analytics.admin_audiences has 12 source columns.

google_analytics.admin_audiences12 columns
audience_idstringpk

Source field audience_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

display_namestring

Source field display_name.

descriptionstring

Source field description.

membership_duration_daysinteger

Source field membership_duration_days.

ads_personalization_enabledboolean

Source field ads_personalization_enabled.

exclusion_duration_modestring

Source field exclusion_duration_mode.

event_trigger_event_namestring

Source field event_trigger_event_name.

event_trigger_log_conditionstring

Source field event_trigger_log_condition.

filter_clausesjson

Source field filter_clauses.

create_timedatetime

Source field create_time.

admin_calculated_metrics#

titan.google_analytics.admin_calculated_metrics has 9 source columns.

google_analytics.admin_calculated_metrics9 columns
calculated_metric_idstringpk

Source field calculated_metric_id.

resource_namestring

Source field resource_name.

property_idstring

Source field property_id.

display_namestring

Source field display_name.

descriptionstring

Source field description.

metric_unitstring

Source field metric_unit.

restricted_metric_typejson

Source field restricted_metric_type.

formulastring

Source field formula.

invalid_metric_referenceboolean

Source field invalid_metric_reference.

dimensions#

titan.google_analytics.dimensions has 7 source columns.

google_analytics.dimensions7 columns
api_namestringpk

Source field api_name.

property_idstring

Source field property_id.

ui_namestring

Source field ui_name.

descriptionstring

Source field description.

categorystring

Source field category.

custom_definitionboolean

Source field custom_definition.

deprecated_api_namesjson

Source field deprecated_api_names.

metrics#

titan.google_analytics.metrics has 10 source columns.

google_analytics.metrics10 columns
api_namestringpk

Source field api_name.

property_idstring

Source field property_id.

ui_namestring

Source field ui_name.

descriptionstring

Source field description.

categorystring

Source field category.

custom_definitionboolean

Source field custom_definition.

deprecated_api_namesjson

Source field deprecated_api_names.

typestring

Source field type.

expressionstring

Source field expression.

blocked_reasonsjson

Source field blocked_reasons.

daily_active_users#

titan.google_analytics.daily_active_users has 2 source columns.

google_analytics.daily_active_users2 columns
datedatepk

Source field date.

active1day_usersinteger

Source field active1DayUsers.

weekly_active_users#

titan.google_analytics.weekly_active_users has 2 source columns.

google_analytics.weekly_active_users2 columns
datedatepk

Source field date.

active7day_usersinteger

Source field active7DayUsers.

four_weekly_active_users#

titan.google_analytics.four_weekly_active_users has 2 source columns.

google_analytics.four_weekly_active_users2 columns
datedatepk

Source field date.

active28day_usersinteger

Source field active28DayUsers.

website_overview#

titan.google_analytics.website_overview has 9 source columns.

google_analytics.website_overview9 columns
datedatepk

Source field date.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

sessionsinteger

Source field sessions.

sessions_per_userdecimal(28,6)

Source field sessionsPerUser.

average_session_durationdecimal(28,6)

Source field averageSessionDuration.

screen_page_viewsinteger

Source field screenPageViews.

screen_page_views_per_sessiondecimal(28,6)

Source field screenPageViewsPerSession.

bounce_ratedecimal(28,6)

Source field bounceRate.

devices#

titan.google_analytics.devices has 12 source columns.

google_analytics.devices12 columns
datedatepk

Source field date.

device_categorystringpk

Source field deviceCategory.

operating_systemstringpk

Source field operatingSystem.

browserstringpk

Source field browser.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

sessionsinteger

Source field sessions.

sessions_per_userdecimal(28,6)

Source field sessionsPerUser.

average_session_durationdecimal(28,6)

Source field averageSessionDuration.

screen_page_viewsinteger

Source field screenPageViews.

screen_page_views_per_sessiondecimal(28,6)

Source field screenPageViewsPerSession.

bounce_ratedecimal(28,6)

Source field bounceRate.

locations#

titan.google_analytics.locations has 12 source columns.

google_analytics.locations12 columns
datedatepk

Source field date.

countrystringpk

Source field country.

regionstringpk

Source field region.

citystringpk

Source field city.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

sessionsinteger

Source field sessions.

sessions_per_userdecimal(28,6)

Source field sessionsPerUser.

average_session_durationdecimal(28,6)

Source field averageSessionDuration.

screen_page_viewsinteger

Source field screenPageViews.

screen_page_views_per_sessiondecimal(28,6)

Source field screenPageViewsPerSession.

bounce_ratedecimal(28,6)

Source field bounceRate.

pages#

titan.google_analytics.pages has 5 source columns.

google_analytics.pages5 columns
datedatepk

Source field date.

host_namestringpk

Source field hostName.

page_path_plus_query_stringstringpk

Source field pagePathPlusQueryString.

screen_page_viewsinteger

Source field screenPageViews.

bounce_ratedecimal(28,6)

Source field bounceRate.

traffic_sources#

titan.google_analytics.traffic_sources has 11 source columns.

google_analytics.traffic_sources11 columns
datedatepk

Source field date.

session_sourcestringpk

Source field sessionSource.

session_mediumstringpk

Source field sessionMedium.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

sessionsinteger

Source field sessions.

sessions_per_userdecimal(28,6)

Source field sessionsPerUser.

average_session_durationdecimal(28,6)

Source field averageSessionDuration.

screen_page_viewsinteger

Source field screenPageViews.

screen_page_views_per_sessiondecimal(28,6)

Source field screenPageViewsPerSession.

bounce_ratedecimal(28,6)

Source field bounceRate.

user_acquisition_first_user_medium#

titan.google_analytics.user_acquisition_first_user_medium has 10 source columns.

google_analytics.user_acquisition_first_user_medium10 columns
datedatepk

Source field date.

first_user_mediumstringpk

Source field firstUserMedium.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

user_acquisition_first_user_source#

titan.google_analytics.user_acquisition_first_user_source has 10 source columns.

google_analytics.user_acquisition_first_user_source10 columns
datedatepk

Source field date.

first_user_sourcestringpk

Source field firstUserSource.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

user_acquisition_first_user_source_medium#

titan.google_analytics.user_acquisition_first_user_source_medium has 10 source columns.

google_analytics.user_acquisition_first_user_source_medium10 columns
datedatepk

Source field date.

first_user_source_mediumstringpk

Source field firstUserSourceMedium.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

user_acquisition_first_user_source_platform#

titan.google_analytics.user_acquisition_first_user_source_platform has 10 source columns.

google_analytics.user_acquisition_first_user_source_platform10 columns
datedatepk

Source field date.

first_user_source_platformstringpk

Source field firstUserSourcePlatform.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

user_acquisition_first_user_campaign#

titan.google_analytics.user_acquisition_first_user_campaign has 10 source columns.

google_analytics.user_acquisition_first_user_campaign10 columns
datedatepk

Source field date.

first_user_campaign_namestringpk

Source field firstUserCampaignName.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(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.

google_analytics.user_acquisition_first_user_google_ads_ad_network_type10 columns
datedatepk

Source field date.

first_user_google_ads_ad_network_typestringpk

Source field firstUserGoogleAdsAdNetworkType.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(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.

google_analytics.user_acquisition_first_user_google_ads_ad_group_name10 columns
datedatepk

Source field date.

first_user_google_ads_ad_group_namestringpk

Source field firstUserGoogleAdsAdGroupName.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

total_usersinteger

Source field totalUsers.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_source_medium#

titan.google_analytics.traffic_acquisition_session_source_medium has 11 source columns.

google_analytics.traffic_acquisition_session_source_medium11 columns
datedatepk

Source field date.

session_source_mediumstringpk

Source field sessionSourceMedium.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_medium#

titan.google_analytics.traffic_acquisition_session_medium has 11 source columns.

google_analytics.traffic_acquisition_session_medium11 columns
datedatepk

Source field date.

session_mediumstringpk

Source field sessionMedium.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_source#

titan.google_analytics.traffic_acquisition_session_source has 11 source columns.

google_analytics.traffic_acquisition_session_source11 columns
datedatepk

Source field date.

session_sourcestringpk

Source field sessionSource.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_campaign#

titan.google_analytics.traffic_acquisition_session_campaign has 11 source columns.

google_analytics.traffic_acquisition_session_campaign11 columns
datedatepk

Source field date.

session_campaign_namestringpk

Source field sessionCampaignName.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_default_channel_group#

titan.google_analytics.traffic_acquisition_session_default_channel_group has 11 source columns.

google_analytics.traffic_acquisition_session_default_channel_group11 columns
datedatepk

Source field date.

session_default_channel_groupstringpk

Source field sessionDefaultChannelGroup.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

traffic_acquisition_session_source_platform#

titan.google_analytics.traffic_acquisition_session_source_platform has 11 source columns.

google_analytics.traffic_acquisition_session_source_platform11 columns
datedatepk

Source field date.

session_source_platformstringpk

Source field sessionSourcePlatform.

total_usersinteger

Source field totalUsers.

sessionsinteger

Source field sessions.

engaged_sessionsinteger

Source field engagedSessions.

events_per_sessiondecimal(28,6)

Source field eventsPerSession.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

events#

titan.google_analytics.events has 6 source columns.

google_analytics.events6 columns
datedatepk

Source field date.

event_namestringpk

Source field eventName.

event_countinteger

Source field eventCount.

total_usersinteger

Source field totalUsers.

event_count_per_userdecimal(28,6)

Source field eventCountPerUser.

total_revenuedecimal(28,2)

Source field totalRevenue.

weekly_events#

titan.google_analytics.weekly_events has 6 source columns.

google_analytics.weekly_events6 columns
year_weekstringpk

Source field yearWeek.

event_namestringpk

Source field eventName.

event_countinteger

Source field eventCount.

total_usersinteger

Source field totalUsers.

event_count_per_userdecimal(28,6)

Source field eventCountPerUser.

total_revenuedecimal(28,2)

Source field totalRevenue.

key_events#

titan.google_analytics.key_events has 5 source columns.

google_analytics.key_events5 columns
datedatepk

Source field date.

event_namestringpk

Source field eventName.

key_eventsdecimal(28,6)

Source field keyEvents.

total_usersinteger

Source field totalUsers.

total_revenuedecimal(28,2)

Source field totalRevenue.

pages_path#

titan.google_analytics.pages_path has 9 source columns.

google_analytics.pages_path9 columns
datedatepk

Source field date.

page_pathstringpk

Source field pagePath.

screen_page_viewsinteger

Source field screenPageViews.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

pages_title_screen_class#

titan.google_analytics.pages_title_screen_class has 9 source columns.

google_analytics.pages_title_screen_class9 columns
datedatepk

Source field date.

unified_screen_classstringpk

Source field unifiedScreenClass.

screen_page_viewsinteger

Source field screenPageViews.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

pages_title_screen_name#

titan.google_analytics.pages_title_screen_name has 9 source columns.

google_analytics.pages_title_screen_name9 columns
datedatepk

Source field date.

unified_screen_namestringpk

Source field unifiedScreenName.

screen_page_viewsinteger

Source field screenPageViews.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

content_group#

titan.google_analytics.content_group has 9 source columns.

google_analytics.content_group9 columns
datedatepk

Source field date.

content_groupstringpk

Source field contentGroup.

screen_page_viewsinteger

Source field screenPageViews.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

user_engagement_durationdecimal(28,6)

Source field userEngagementDuration.

ecommerce_purchases_item_name#

titan.google_analytics.ecommerce_purchases_item_name has 8 source columns.

google_analytics.ecommerce_purchases_item_name8 columns
datedatepk

Source field date.

item_namestringpk

Source field itemName.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_id#

titan.google_analytics.ecommerce_purchases_item_id has 8 source columns.

google_analytics.ecommerce_purchases_item_id8 columns
datedatepk

Source field date.

item_idstringpk

Source field itemId.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_brand#

titan.google_analytics.ecommerce_purchases_item_brand has 8 source columns.

google_analytics.ecommerce_purchases_item_brand8 columns
datedatepk

Source field date.

item_brandstringpk

Source field itemBrand.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category#

titan.google_analytics.ecommerce_purchases_item_category has 8 source columns.

google_analytics.ecommerce_purchases_item_category8 columns
datedatepk

Source field date.

item_categorystringpk

Source field itemCategory.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category_2#

titan.google_analytics.ecommerce_purchases_item_category_2 has 8 source columns.

google_analytics.ecommerce_purchases_item_category_28 columns
datedatepk

Source field date.

item_category2stringpk

Source field itemCategory2.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category_3#

titan.google_analytics.ecommerce_purchases_item_category_3 has 8 source columns.

google_analytics.ecommerce_purchases_item_category_38 columns
datedatepk

Source field date.

item_category3stringpk

Source field itemCategory3.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category_4#

titan.google_analytics.ecommerce_purchases_item_category_4 has 8 source columns.

google_analytics.ecommerce_purchases_item_category_48 columns
datedatepk

Source field date.

item_category4stringpk

Source field itemCategory4.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category_5#

titan.google_analytics.ecommerce_purchases_item_category_5 has 8 source columns.

google_analytics.ecommerce_purchases_item_category_58 columns
datedatepk

Source field date.

item_category5stringpk

Source field itemCategory5.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

ecommerce_purchases_item_category_combined#

titan.google_analytics.ecommerce_purchases_item_category_combined has 12 source columns.

google_analytics.ecommerce_purchases_item_category_combined12 columns
datedatepk

Source field date.

item_categorystringpk

Source field itemCategory.

item_category2stringpk

Source field itemCategory2.

item_category3stringpk

Source field itemCategory3.

item_category4stringpk

Source field itemCategory4.

item_category5stringpk

Source field itemCategory5.

cart_to_view_ratedecimal(28,6)

Source field cartToViewRate.

purchase_to_view_ratedecimal(28,6)

Source field purchaseToViewRate.

items_purchasedinteger

Source field itemsPurchased.

item_revenuedecimal(28,2)

Source field itemRevenue.

items_added_to_cartinteger

Source field itemsAddedToCart.

items_viewedinteger

Source field itemsViewed.

publisher_ads_ad_unit#

titan.google_analytics.publisher_ads_ad_unit has 6 source columns.

google_analytics.publisher_ads_ad_unit6 columns
datedatepk

Source field date.

ad_unit_namestringpk

Source field adUnitName.

publisher_ad_impressionsinteger

Source field publisherAdImpressions.

ad_unit_exposuredecimal(28,6)

Source field adUnitExposure.

publisher_ad_clicksinteger

Source field publisherAdClicks.

total_ad_revenuedecimal(28,2)

Source field totalAdRevenue.

publisher_ads_page_path#

titan.google_analytics.publisher_ads_page_path has 6 source columns.

google_analytics.publisher_ads_page_path6 columns
datedatepk

Source field date.

page_pathstringpk

Source field pagePath.

publisher_ad_impressionsinteger

Source field publisherAdImpressions.

ad_unit_exposuredecimal(28,6)

Source field adUnitExposure.

publisher_ad_clicksinteger

Source field publisherAdClicks.

total_ad_revenuedecimal(28,2)

Source field totalAdRevenue.

publisher_ads_ad_format#

titan.google_analytics.publisher_ads_ad_format has 6 source columns.

google_analytics.publisher_ads_ad_format6 columns
datedatepk

Source field date.

ad_formatstringpk

Source field adFormat.

publisher_ad_impressionsinteger

Source field publisherAdImpressions.

ad_unit_exposuredecimal(28,6)

Source field adUnitExposure.

publisher_ad_clicksinteger

Source field publisherAdClicks.

total_ad_revenuedecimal(28,2)

Source field totalAdRevenue.

publisher_ads_ad_source#

titan.google_analytics.publisher_ads_ad_source has 6 source columns.

google_analytics.publisher_ads_ad_source6 columns
datedatepk

Source field date.

ad_source_namestringpk

Source field adSourceName.

publisher_ad_impressionsinteger

Source field publisherAdImpressions.

ad_unit_exposuredecimal(28,6)

Source field adUnitExposure.

publisher_ad_clicksinteger

Source field publisherAdClicks.

total_ad_revenuedecimal(28,2)

Source field totalAdRevenue.

demographic_country#

titan.google_analytics.demographic_country has 8 source columns.

google_analytics.demographic_country8 columns
datedatepk

Source field date.

countrystringpk

Source field country.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_region#

titan.google_analytics.demographic_region has 8 source columns.

google_analytics.demographic_region8 columns
datedatepk

Source field date.

regionstringpk

Source field region.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_city#

titan.google_analytics.demographic_city has 8 source columns.

google_analytics.demographic_city8 columns
datedatepk

Source field date.

citystringpk

Source field city.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_language#

titan.google_analytics.demographic_language has 8 source columns.

google_analytics.demographic_language8 columns
datedatepk

Source field date.

languagestringpk

Source field language.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_age#

titan.google_analytics.demographic_age has 8 source columns.

google_analytics.demographic_age8 columns
datedatepk

Source field date.

user_age_bracketstringpk

Source field userAgeBracket.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_gender#

titan.google_analytics.demographic_gender has 8 source columns.

google_analytics.demographic_gender8 columns
datedatepk

Source field date.

user_genderstringpk

Source field userGender.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

demographic_interest#

titan.google_analytics.demographic_interest has 8 source columns.

google_analytics.demographic_interest8 columns
datedatepk

Source field date.

branding_intereststringpk

Source field brandingInterest.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_browser#

titan.google_analytics.tech_browser has 9 source columns.

google_analytics.tech_browser9 columns
datedatepk

Source field date.

browserstringpk

Source field browser.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_device_category#

titan.google_analytics.tech_device_category has 9 source columns.

google_analytics.tech_device_category9 columns
datedatepk

Source field date.

device_categorystringpk

Source field deviceCategory.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_device_model#

titan.google_analytics.tech_device_model has 9 source columns.

google_analytics.tech_device_model9 columns
datedatepk

Source field date.

device_modelstringpk

Source field deviceModel.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_screen_resolution#

titan.google_analytics.tech_screen_resolution has 9 source columns.

google_analytics.tech_screen_resolution9 columns
datedatepk

Source field date.

screen_resolutionstringpk

Source field screenResolution.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_app_version#

titan.google_analytics.tech_app_version has 9 source columns.

google_analytics.tech_app_version9 columns
datedatepk

Source field date.

app_versionstringpk

Source field appVersion.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_platform#

titan.google_analytics.tech_platform has 9 source columns.

google_analytics.tech_platform9 columns
datedatepk

Source field date.

platformstringpk

Source field platform.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_platform_device_category#

titan.google_analytics.tech_platform_device_category has 9 source columns.

google_analytics.tech_platform_device_category9 columns
datedatepk

Source field date.

platform_device_categorystringpk

Source field platformDeviceCategory.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_operating_system#

titan.google_analytics.tech_operating_system has 9 source columns.

google_analytics.tech_operating_system9 columns
datedatepk

Source field date.

operating_systemstringpk

Source field operatingSystem.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(28,2)

Source field totalRevenue.

tech_os_with_version#

titan.google_analytics.tech_os_with_version has 9 source columns.

google_analytics.tech_os_with_version9 columns
datedatepk

Source field date.

operating_system_with_versionstringpk

Source field operatingSystemWithVersion.

total_usersinteger

Source field totalUsers.

new_usersinteger

Source field newUsers.

engaged_sessionsinteger

Source field engagedSessions.

engagement_ratedecimal(28,6)

Source field engagementRate.

event_countinteger

Source field eventCount.

key_eventsdecimal(28,6)

Source field keyEvents.

total_revenuedecimal(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.