Page MenuHomePhabricator
Paste P9230

superset test_search_satisfaction_hourly datasource export
ActivePublic

Authored by EBernhardson on Oct 2 2019, 6:38 PM.
Tags
None
Referenced Files
F30525019: raw.txt
Oct 2 2019, 6:38 PM
Subscribers
None
- columns:
- column_name: search_count_norm
description: Sample corrected search_count
filterable: false
groupby: false
- column_name: dym_clicked
type: STRING
verbose_name: Clicked a Suggested Query
- column_name: hit_interact
type: STRING
verbose_name: Clicked a Search Result
- column_name: is_dym
type: STRING
verbose_name: Shown Suggested Query Results
- column_name: dym_shown
type: STRING
verbose_name: Shown a Query Suggestion
- column_name: is_autorewrite_dym
type: STRING
verbose_name: Search Automatically Rewritten
- column_name: search_count
type: FLOAT
- column_name: ua_browser_family
type: STRING
- column_name: ua_os_family
type: STRING
- column_name: country_code
type: STRING
- column_name: hits_returned
type: STRING
- column_name: continent
type: STRING
- column_name: country
type: STRING
- column_name: wiki
type: STRING
- column_name: bucket
datasource_name: test_search_satisfaction_hourly
metrics:
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"zero_initial_results_norm_count\"\
,\r\n \"filter\": {\r\n \"type\": \"or\",\r\n \"fields\": [\r\n \
\ {\"type\": \"selector\", \"dimension\": \"is_autorewrite_dym\", \"value\"\
: \"true\"},\r\n {\"type\": \"selector\", \"dimension\": \"hits_returned\"\
, \"value\": \"0\"}\r\n ]\r\n },\r\n \"aggregator\": {\r\n \"type\"\
: \"longSum\",\r\n \"name\": \"zero_initial_results_norm_count\",\r\n \
\ \"fieldName\": \"search_count_norm\"\r\n }\r\n}\r\n"
metric_name: zero_initial_results_norm_count
metric_type: sum
verbose_name: Zero Initial Search Results
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"is_dym_norm_count\",\r\n\
\ \"filter\": {\r\n \"type\": \"selector\",\r\n \"dimension\": \"is_dym\"\
,\r\n \"value\": \"true\"\r\n },\r\n \"aggregator\": {\r\n \"type\"\
: \"longSum\",\r\n \"name\": \"sum__search_count_norm\",\r\n \"fieldName\"\
: \"search_count_norm\"\r\n }\r\n}\r\n"
metric_name: is_dym_norm_count
metric_type: sum
verbose_name: Searches Shown Suggested Query Results
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"dym_shown_norm_count\"\
,\r\n \"filter\": {\r\n \"type\": \"selector\",\r\n \"dimension\": \"\
dym_shown\",\r\n \"value\": \"true\"\r\n },\r\n \"aggregator\": {\r\n \
\ \"type\": \"longSum\",\r\n \"name\": \"sum__search_count_norm\",\r\n\
\ \"fieldName\": \"search_count_norm\"\r\n }\r\n}"
metric_name: dym_shown_norm_count
metric_type: sum
verbose_name: Searches Shown a Query Suggestion
- d3format: .1%
json: "{\r\n \"type\": \"arithmetic\",\r\n \"name\": \"is_autorewrite_dym_norm_percent\"\
,\r\n \"fn\": \"/\",\r\n \"fields\": [\r\n {\"type\": \"fieldAccess\",\
\ \"name\": \"is_autorewrite_dym_norm_count\", \"fieldName\": \"is_autorewrite_dym_norm_count\"\
},\r\n {\"type\": \"fieldAccess\", \"name\": \"zero_initial_results_norm_count\"\
, \"fieldName\": \"zero_initial_results_norm_count\"}\r\n ]\r\n}"
metric_name: is_autorewrite_dym_norm_percent
metric_type: postagg
verbose_name: Percentage of Zero Result Searches Automatically Rewritten
- d3format: .1%
json: "{\r\n \"type\": \"arithmetic\",\r\n \"name\": \"dym_clicked_norm_percent\"\
,\r\n \"fn\": \"/\",\r\n \"fields\": [\r\n {\"type\": \"fieldAccess\",\
\ \"name\": \"dym_clicked_count\", \"fieldName\": \"dym_clicked_norm_count\"\
},\r\n {\"type\": \"fieldAccess\", \"name\": \"dym_shown_count\", \"fieldName\"\
: \"dym_shown_norm_count\"}\r\n ]\r\n}\r\n"
metric_name: dym_clicked_norm_percent
metric_type: postagg
verbose_name: Percentage of Impressions Clicking a Suggested Query
- d3format: .1%
json: "{\r\n \"type\": \"arithmetic\",\r\n \"name\": \"hit_interact_norm_percent\"\
,\r\n \"fn\": \"/\",\r\n \"fields\": [\r\n {\"type\": \"fieldAccess\",\
\ \"name\": \"hit_interact_norm_count\", \"fieldName\": \"hit_interact_norm_count\"\
},\r\n {\"type\": \"fieldAccess\", \"name\": \"search_count_norm_sum\", \"\
fieldName\": \"search_count_norm_sum\"}\r\n ]\r\n}"
metric_name: hit_interact_norm_percent
metric_type: postagg
verbose_name: Percentage of Searches Clicking a Search Result
- d3format: .1%
json: "{\r\n \"type\": \"arithmetic\",\r\n \"name\": \"is_dym_norm_percent\"\
,\r\n \"fn\": \"/\",\r\n \"fields\": [\r\n {\"type\": \"fieldAccess\",\
\ \"name\": \"is_dym_count\", \"fieldName\": \"is_dym_norm_count\"},\r\n \
\ {\"type\": \"fieldAccess\", \"name\": \"search_count\", \"fieldName\": \"\
search_count_norm\"}\r\n ]\r\n}\r\n"
metric_name: is_dym_norm_percent
metric_type: postagg
verbose_name: Percentage of Searches Shown Suggested Query Results
- d3format: .1%
json: "{\r\n \"type\": \"arithmetic\",\r\n \"name\": \"dym_shown_norm_percent\"\
,\r\n \"fn\": \"/\",\r\n \"fields\": [\r\n {\"type\": \"fieldAccess\",\
\ \"name\": \"dym_shown_count\", \"fieldName\": \"dym_shown_norm_count\"},\r\
\n {\"type\": \"fieldAccess\", \"name\": \"search_count_sum\", \"fieldName\"\
: \"search_count_norm_sum\"}\r\n ]\r\n}"
metric_name: dym_shown_norm_percent
metric_type: postagg
verbose_name: Percentage of Searches Shown a Query Suggestion
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"dym_clicked_norm_count\"\
,\r\n \"filter\": { \"type\": \"selector\", \"dimension\": \"dym_clicked\"\
, \"value\": \"true\"},\r\n \"aggregator\": {\"type\": \"longSum\", \"name\"\
: \"sum__search_count_norm\", \"fieldName\": \"search_count_norm\"}\r\n}\r\n"
metric_name: dym_clicked_norm_count
metric_type: sum
verbose_name: Searches Clicking a Suggested Query
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"hit_interact_norm_count\"\
,\r\n \"filter\": {\"type\": \"selector\", \"dimension\": \"hit_interact\"\
, \"value\": \"true\"},\r\n \"aggregator\": {\"type\": \"longSum\", \"name\"\
: \"sum__search_count_norm\", \"fieldName\": \"search_count_norm\"}\r\n}\r\n"
metric_name: hit_interact_norm_count
metric_type: agg
verbose_name: Searches Clicking a Search Result
- json: "{\r\n \"type\": \"filtered\",\r\n \"name\": \"is_autorewrite_dym_norm_count\"\
,\r\n \"filter\": {\"type\": \"selector\", \"dimension\": \"is_autorewrite_dym\"\
, \"value\": \"true\"},\r\n \"aggregator\": {\"type\": \"longSum\", \"name\"\
: \"sum__search_count_norm\", \"fieldName\": \"search_count_norm\"}\r\n}\r\n"
metric_name: is_autorewrite_dym_norm_count
metric_type: agg
verbose_name: Searches Automatically Rewritten
- json: '{"type": "longSum", "name": "sum__search_count_norm", "fieldName": "search_count_norm"}'
metric_name: search_count_norm_sum
metric_type: sum
verbose_name: Search Requests