- 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