Thunderbird/Support/Google Big Query Sample SQL queries

2025-09-22 Combined SUMO Answer rate for both TB Desktop and Android

• staff only link to Google Big Query
• results 1983/15754 = 12.6% solved rate:

tb_desktop_and_android_2024_aaq	solved_tb_desktop_android_2024
15754	1983

Working query

SELECT
  COUNT(*) as tb_desktop_and_android_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_desktop_android_2024
FROM
  sumo.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE '%thunderbird%'
;

2025-08-18 queries have changed to project 'sumo-prod', folder 'moz-fx-sumo-prod' and dataset is 'sumo'

• The pre August 18, 2025 queries on the rest of this page will no longer work when moz-fx-data-sumo-prod is deleted in a few days or months therefore :-)
• They will work if you change the project (top left corner of the screen) to sumo-prod and the folder to moz-fx-sumo-prod and the table to sumo.metrics_thunderbird_questions <-- This is left as an exercise for the reader :-)

Working query

• staff only link to BQ query

SELECT *  FROM `sumo.metrics_thunderbird_questions` LIMIT 1000

Count All Solved Android Desktop Questions in 2024

• staff only link to BQ query
• results (4% solved):

tb_android_2024_aaq,solved_tb_android_2024
311,12

SELECT
  COUNT(*) as tb_android_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_android_2024
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird-android'
;

Count All Solved Thunderbird Desktop Questions in 2024

• staff only link to BQ query
• results (13% solved):

tb_desktop_2024_aaq,solved_tb_desktop_2024
15506,1970

SELECT
  COUNT(*) as tb_desktop_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_desktop_2024
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird'
;

Count All Thunderbird Desktop Questions in 2024

SELECT
  COUNT (*)
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird'
;