NI Direct Search Terms 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2017_q1_q2

88.23 kB
6,231 rows
8 columns

CREATE TABLE ni_direct_search_terms_2017_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2017_q3_q4

80.23 kB
5,530 rows
8 columns

CREATE TABLE ni_direct_search_terms_2017_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2018_q1_q2

92.61 kB
6,694 rows
8 columns

CREATE TABLE ni_direct_search_terms_2018_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2018_q3_q4

79.13 kB
6,689 rows
8 columns

CREATE TABLE ni_direct_search_terms_2018_q3_q4 (
  "month_of_year" DOUBLE,
  "search_term" VARCHAR,
  "total_unique_searches" DOUBLE,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2019_q1_q2

87.42 kB
6,364 rows
8 columns

CREATE TABLE ni_direct_search_terms_2019_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2019_q3_q4

79.64 kB
5,722 rows
8 columns

CREATE TABLE ni_direct_search_terms_2019_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2020_q1_q2

105.23 kB
7,540 rows
8 columns

CREATE TABLE ni_direct_search_terms_2020_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2020_q3_q4

132.42 kB
10,112 rows
8 columns

CREATE TABLE ni_direct_search_terms_2020_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2021_q1_q2

144.44 kB
11,042 rows
8 columns

CREATE TABLE ni_direct_search_terms_2021_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2021_q3_q4

194.16 kB
14,157 rows
8 columns

CREATE TABLE ni_direct_search_terms_2021_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2022_q1_q2

121.6 kB
9,243 rows
8 columns

CREATE TABLE ni_direct_search_terms_2022_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Sources 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2016_q3_q4

577.07 kB
87,249 rows
7 columns

CREATE TABLE ni_direct_sources_2016_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2017_q1_q2

581.61 kB
88,069 rows
7 columns

CREATE TABLE ni_direct_sources_2017_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2017_q3_q4

567.19 kB
84,215 rows
7 columns

CREATE TABLE ni_direct_sources_2017_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2018_q1_q2

598.97 kB
89,147 rows
7 columns

CREATE TABLE ni_direct_sources_2018_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2018_q3_q4

567.64 kB
93,832 rows
7 columns

CREATE TABLE ni_direct_sources_2018_q3_q4 (
  "date" DOUBLE,
  "source" VARCHAR,
  "sessions" DOUBLE,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" DOUBLE,
  "new_users" DOUBLE
);

NI Direct Sources 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2019_q1_q2

1.03 MB
133,067 rows
7 columns

CREATE TABLE ni_direct_sources_2019_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2019_q3_q4

556.77 kB
81,314 rows
7 columns

CREATE TABLE ni_direct_sources_2019_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2020_q1_q2

626.69 kB
90,811 rows
7 columns

CREATE TABLE ni_direct_sources_2020_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2020_q3_q4

871.28 kB
121,466 rows
7 columns

CREATE TABLE ni_direct_sources_2020_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2021_q1_q2

1.06 MB
142,304 rows
7 columns

CREATE TABLE ni_direct_sources_2021_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2021_q3_q4

581.92 kB
93,019 rows
7 columns

CREATE TABLE ni_direct_sources_2021_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2022_q1_q2

463.6 kB
72,332 rows
7 columns

CREATE TABLE ni_direct_sources_2022_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct User Device Categories 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_user_device_categories_2016_q3_q4

19.35 kB
552 rows
7 columns

CREATE TABLE ni_direct_user_device_categories_2016_q3_q4 (
  "date" BIGINT,
  "device_category" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct User Device Categories 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_user_device_categories_2017_q1_q2

19.11 kB
543 rows
7 columns

CREATE TABLE ni_direct_user_device_categories_2017_q1_q2 (
  "date" BIGINT,
  "device_category" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Website Data

About this Dataset