Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F30525019
raw.txt
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
EBernhardson
Oct 2 2019, 6:38 PM
2019-10-02 18:38:49 (UTC+0)
Size
6 KB
Referenced Files
None
Subscribers
None
raw.txt
View Options
- 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
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8064135
Default Alt Text
raw.txt (6 KB)
Attached To
Mode
P9230 superset test_search_satisfaction_hourly datasource export
Attached
Detach File
Event Timeline
Log In to Comment