Search
Views related to client search counts
acer_cohort
Acer Cohort
search.acer_cohort
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | acer_cohort_v1 |
Source Directory | View Definition | Metadata File
desktop_mobile_search_clients_monthly
Desktop Mobile Search Clients Monthly
search.desktop_mobile_search_clients_monthly
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | String | Yes | |
| submission_month | Date | Yes | |
| device | String | Yes | |
| normalized_engine | String | Yes | |
| normalized_app_name | String | Yes | |
| os | String | Yes | |
| country | String | Yes | |
| days_of_use | Integer | Yes | |
| searches | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| ad_click | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| tagged_sap | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | desktop_mobile_search_clients_monthly_v1 |
Source Directory | View Definition | Metadata File
desktop_search_aggregates_by_userstate
Desktop Search Aggregates By Userstate
search.desktop_search_aggregates_by_userstate
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| geo | String | Yes | |
| user_state | String | Yes | |
| client_count | Integer | Yes | |
| search_client_count | Integer | Yes | |
| sap | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| ad_clicks | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| organic | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | desktop_search_aggregates_by_userstate_v1 |
Source Directory | View Definition | Metadata File
desktop_search_aggregates_for_searchreport
Desktop Search Aggregates For Searchreport
search.desktop_search_aggregates_for_searchreport
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| geo | String | Yes | |
| locale | String | Yes | |
| engine | String | Yes | |
| os | String | Yes | |
| app_version | String | Yes | |
| dcc | Integer | Yes | |
| sap | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| ad_click | Integer | Yes | |
| organic | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| search_with_ads_organic | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | desktop_search_aggregates_for_searchreport_v1 |
Source Directory | View Definition | Metadata File
firefox_products_search_clients_engines_sources_daily
Firefox Products Search Clients Engines Sources Daily
search.firefox_products_search_clients_engines_sources_daily
Please provide a description for the query
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search | mobile_search_clients_engines_sources_daily |
| moz-fx-data-shared-prod | search | search_clients_engines_sources_daily |
Source Directory | View Definition | Metadata File
mobile_search_aggregates
Mobile Search Aggregates
search.mobile_search_aggregates
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| engine | String | Yes | |
| source | String | Yes | |
| app_name | String | Yes | |
| normalized_app_name | String | Yes | |
| app_version | String | Yes | |
| channel | String | Yes | |
| country | String | Yes | |
| locale | String | Yes | |
| distribution_id | String | Yes | |
| default_search_engine | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| client_count | Integer | Yes | |
| search_count | Integer | Yes | |
| organic | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| unknown | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| normalized_engine | String | Yes | |
| sap | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | mobile_search_aggregates_v1 |
Source Directory | View Definition | Metadata File
mobile_search_aggregates_for_searchreport
Mobile Search Aggregates For Searchreport
search.mobile_search_aggregates_for_searchreport
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| country | String | Yes | |
| product | String | Yes | |
| normalized_engine | String | Yes | |
| clients | Integer | Yes | |
| search_clients | Integer | Yes | |
| sap | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| organic | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | mobile_search_aggregates_for_searchreport_v1 |
Source Directory | View Definition | Metadata File
mobile_search_clients_engines_sources_daily
Mobile Search Clients Engines Sources Daily
search.mobile_search_clients_engines_sources_daily
A daily aggregate of baseline and metrics pings that have searches from each (client_id, engine, source) combination, partitioned by day.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| engine | String | Yes | |
| source | String | Yes | |
| app_name | String | Yes | |
| normalized_app_name | String | Yes | |
| search_count | Integer | Yes | |
| organic | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| unknown | Integer | Yes | |
| country | String | Yes | |
| locale | String | Yes | |
| app_version | String | Yes | |
| channel | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| default_search_engine | String | Yes | |
| default_search_engine_submission_url | String | Yes | |
| distribution_id | String | Yes | |
| profile_creation_date | Integer | Yes | |
| profile_age_in_days | Integer | Yes | |
| sample_id | Integer | Yes | |
| experiments | Record | No | |
| total_uri_count | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| normalized_engine | String | Yes | |
| browser_version_info | Record | Yes | |
| sap | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | mobile_search_clients_daily_v1 |
Source Directory | View Definition | Metadata File
mobile_search_clients_last_seen
Mobile Search Clients Last Seen
search.mobile_search_clients_last_seen
Captures search activity of each mobile client in the past 365 days for each submission date.
Used as the basis for LTV calculations.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| app_name | String | Yes | |
| normalized_app_name | String | Yes | |
| country | String | Yes | |
| locale | String | Yes | |
| app_version | String | Yes | |
| channel | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| default_search_engine | String | Yes | |
| default_search_engine_submission_url | String | Yes | |
| distribution_id | String | Yes | |
| profile_creation_date | Integer | Yes | |
| profile_age_in_days | Integer | Yes | |
| organic | Integer | Yes | |
| sap | Integer | Yes | |
| unknown | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| tagged_searches | Integer | Yes | |
| days_seen_bytes | Bytes | Yes | |
| days_searched_bytes | Bytes | Yes | |
| days_tagged_searched_bytes | Bytes | Yes | |
| days_searched_with_ads_bytes | Bytes | Yes | |
| days_clicked_ads_bytes | Bytes | Yes | |
| days_created_profile_bytes | Bytes | Yes | |
| engine_searches | Record | No |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | mobile_search_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
search_aggregates
Search Aggregates
search.search_aggregates
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date_s3 | Date | Yes | |
| submission_date | Date | Yes | |
| addon_version | String | Yes | |
| app_version | String | Yes | |
| country | String | Yes | |
| distribution_id | String | Yes | |
| engine | String | Yes | |
| locale | String | Yes | |
| search_cohort | String | Yes | |
| source | String | Yes | |
| default_search_engine | String | Yes | |
| default_private_search_engine | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| is_default_browser | Boolean | Yes | |
| channel | String | Yes | |
| client_count | Integer | Yes | |
| organic | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| sap | Integer | Yes | |
| ad_click | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| search_with_ads_organic | Integer | Yes | |
| unknown | Integer | Yes | |
| normalized_engine | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | search_aggregates_v8 |
Source Directory | View Definition | Metadata File
search_clients_engines_sources_daily
Search Clients Engines Sources Daily
search.search_clients_engines_sources_daily
A daily aggregate of desktop searches per (client_id, engine, source).
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date_s3 | Date | Yes | |
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| engine | String | Yes | |
| source | String | Yes | |
| country | String | Yes | |
| addon_version | String | Yes | |
| app_version | String | Yes | |
| distribution_id | String | Yes | |
| locale | String | Yes | |
| user_pref_browser_search_region | String | Yes | |
| search_cohort | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| channel | String | Yes | |
| is_default_browser | Boolean | Yes | |
| profile_creation_date | Integer | Yes | |
| default_search_engine | String | Yes | |
| default_search_engine_data_load_path | String | Yes | |
| default_search_engine_data_submission_url | String | Yes | |
| default_private_search_engine | String | Yes | |
| default_private_search_engine_data_load_path | String | Yes | |
| default_private_search_engine_data_submission_url | String | Yes | |
| sample_id | Integer | Yes | |
| subsession_hours_sum | Float | Yes | |
| sessions_started_on_this_day | Integer | Yes | |
| active_addons_count_mean | Float | Yes | |
| max_concurrent_tab_count_max | Integer | Yes | |
| tab_open_event_count_sum | Integer | Yes | |
| active_hours_sum | Float | Yes | |
| total_uri_count | Integer | Yes | |
| experiments | Record | No | |
| scalar_parent_urlbar_searchmode_bookmarkmenu_sum | Record | No | |
| scalar_parent_urlbar_searchmode_handoff_sum | Record | No | |
| scalar_parent_urlbar_searchmode_keywordoffer_sum | Record | No | |
| scalar_parent_urlbar_searchmode_oneoff_sum | Record | No | |
| scalar_parent_urlbar_searchmode_other_sum | Record | No | |
| scalar_parent_urlbar_searchmode_shortcut_sum | Record | No | |
| scalar_parent_urlbar_searchmode_tabmenu_sum | Record | No | |
| scalar_parent_urlbar_searchmode_tabtosearch_sum | Record | No | |
| scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum | Record | No | |
| scalar_parent_urlbar_searchmode_topsites_newtab_sum | Record | No | |
| scalar_parent_urlbar_searchmode_topsites_urlbar_sum | Record | No | |
| scalar_parent_urlbar_searchmode_touchbar_sum | Record | No | |
| scalar_parent_urlbar_searchmode_typed_sum | Record | No | |
| profile_age_in_days | Integer | Yes | |
| organic | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| sap | Integer | Yes | |
| ad_click | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| search_with_ads_organic | Integer | Yes | |
| unknown | Integer | Yes | |
| is_sap_monetizable | Boolean | Yes | |
| has_adblocker_addon | Boolean | Yes | |
| normalized_engine | String | Yes | |
| browser_version_info | Record | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | search_clients_daily_v8 |
Source Directory | View Definition | Metadata File
search_clients_last_seen
Search Clients Last Seen
search.search_clients_last_seen
Captures search activity of each desktop client in the past 365 days for each submission date.
Used as the basis for LTV calculations.
- Owners:
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search | search_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
search_clients_last_seen_v1
Search Clients Last Seen V1
search.search_clients_last_seen_v1
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| country | String | Yes | |
| app_version | String | Yes | |
| distribution_id | String | Yes | |
| locale | String | Yes | |
| search_cohort | String | Yes | |
| addon_version | String | Yes | |
| os | String | Yes | |
| channel | String | Yes | |
| profile_creation_date | Integer | Yes | |
| default_search_engine | String | Yes | |
| default_search_engine_data_load_path | String | Yes | |
| default_search_engine_data_submission_url | String | Yes | |
| profile_age_in_days | Integer | Yes | |
| active_addons_count_mean | Float | Yes | |
| user_pref_browser_search_region | String | Yes | |
| os_version | String | Yes | |
| max_concurrent_tab_count_max | Integer | Yes | |
| tab_open_event_count_sum | Integer | Yes | |
| active_hours_sum | Float | Yes | |
| subsession_hours_sum | Float | Yes | |
| sessions_started_on_this_day | Integer | Yes | |
| organic | Integer | Yes | |
| sap | Integer | Yes | |
| unknown | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| tagged_searches | Integer | Yes | |
| engine_searches | Record | No | |
| days_seen_bytes | Bytes | Yes | |
| days_searched_bytes | Bytes | Yes | |
| days_tagged_searched_bytes | Bytes | Yes | |
| days_searched_with_ads_bytes | Bytes | Yes | |
| days_clicked_ads_bytes | Bytes | Yes | |
| days_created_profile_bytes | Bytes | Yes | |
| days_since_seen | Integer | Yes | |
| days_since_searched | Integer | Yes | |
| days_since_tagged_searched | Integer | Yes | |
| days_since_searched_with_ads | Integer | Yes | |
| days_since_clicked_ad | Integer | Yes | |
| days_since_created_profile | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | search_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
search_revenue_levers_daily
Search Revenue Levers Daily
search.search_revenue_levers_daily
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| partner | String | Yes | |
| device | String | Yes | |
| channel | String | Yes | |
| country | String | Yes | |
| dau | Integer | Yes | |
| dau_engaged_w_sap | Integer | Yes | |
| sap | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| organic | Integer | Yes | |
| ad_click_organic | Integer | Yes | |
| search_with_ads_organic | Integer | Yes | |
| monetizable_sap | Integer | Yes | |
| dau_w_engine_as_default | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | search_revenue_levers_daily_v1 |
Source Directory | View Definition | Metadata File
search_rfm
Search Rfm
search.search_rfm
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| days_seen | Record | Yes | |
| days_searched | Record | Yes | |
| days_tagged_searched | Record | Yes | |
| days_searched_with_ads | Record | Yes | |
| days_clicked_ads | Record | Yes | |
| days_since_created_profile | Integer | Yes | |
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| country | String | Yes | |
| app_version | String | Yes | |
| distribution_id | String | Yes | |
| locale | String | Yes | |
| search_cohort | String | Yes | |
| addon_version | String | Yes | |
| os | String | Yes | |
| channel | String | Yes | |
| profile_creation_date | Integer | Yes | |
| default_search_engine | String | Yes | |
| default_search_engine_data_load_path | String | Yes | |
| default_search_engine_data_submission_url | String | Yes | |
| profile_age_in_days | Integer | Yes | |
| active_addons_count_mean | Float | Yes | |
| user_pref_browser_search_region | String | Yes | |
| os_version | String | Yes | |
| max_concurrent_tab_count_max | Integer | Yes | |
| tab_open_event_count_sum | Integer | Yes | |
| active_hours_sum | Float | Yes | |
| subsession_hours_sum | Float | Yes | |
| sessions_started_on_this_day | Integer | Yes | |
| organic | Integer | Yes | |
| sap | Integer | Yes | |
| unknown | Integer | Yes | |
| tagged_sap | Integer | Yes | |
| tagged_follow_on | Integer | Yes | |
| ad_click | Integer | Yes | |
| search_with_ads | Integer | Yes | |
| total_searches | Integer | Yes | |
| tagged_searches | Integer | Yes | |
| engine_searches | Record | No |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | search_derived | search_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File