About this Dataset

CalHHS Open Data Portal - Google Analytics Data

Universal Analytics data from Google Analytics for the CalHHS Open Data Portal. This data was captured using the depreciated Universal Analytics tool and is no longer available on the web via Google UI or Google APIs. It has been loaded here so that users and the metrics dashboard can access the data.
Organization: State of California
Last updated: 2024-11-27T00:52:06.424986
Tags: calhhs, center-for-data-insights-and-innovation, googleanalytics, metrics, opendata

Tables

GA - Date And Users

@usgov.ca_gov_calhhs_open_data_portal_google_analytics_data_08de3.ga_date_and_users

20.93 KB
1954 rows
2 columns


CREATE TABLE ga_date_and_users (
  "date" VARCHAR,
  "users" BIGINT
);

GA - Date, Pages, And Events

@usgov.ca_gov_calhhs_open_data_portal_google_analytics_data_08de3.ga_date_pages_and_events

55.21 KB
6219 rows
8 columns


CREATE TABLE ga_date_pages_and_events (
  "event_action" VARCHAR,
  "event_category" VARCHAR,
  "date" VARCHAR,
  "total_events" BIGINT,
  "page_path_1" VARCHAR,
  "page_path_2" VARCHAR,
  "page_path_3" VARCHAR,
  "page_path_4" VARCHAR
);

GA - Dates, Pages, Page Views

@usgov.ca_gov_calhhs_open_data_portal_google_analytics_data_08de3.ga_dates_pages_page_views

731.83 KB
176723 rows
7 columns


CREATE TABLE ga_dates_pages_page_views (
  "event_action" BIGINT,
  "page_title" VARCHAR,
  "date" VARCHAR,
  "pageviews" BIGINT,
  "page_path_1" VARCHAR,
  "page_path_2" VARCHAR,
  "page_path_3" VARCHAR
);

GA - Users By Location

@usgov.ca_gov_calhhs_open_data_portal_google_analytics_data_08de3.ga_users_by_location

451.89 KB
18812 rows
5 columns


CREATE TABLE ga_users_by_location (
  "city" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "users" BIGINT
);