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.424990
Tags: calhhs, center-for-data-insights-and-innovation, googleanalytics, metrics, opendata

Tables

GA - Date, Pages, And Events

@usgov.ca_gov_calhhs_open_data_portal_google_analytics_data_08de3.ga_date_pages_and_events

56.53 kB
6,219 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

749.39 kB
176,723 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

462.74 kB
18,812 rows
5 columns

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