962
edits
Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions
Thunderbird/Support/Google Big Query Sample SQL queries (view source)
Revision as of 03:09, 23 September 2025
, 23 Septemberadd combined 2024 query
(fix typos) |
(add combined 2024 query) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__TOC__ | __TOC__ | ||
== 2025-08-18 queries have changed to project 'sumo-prod', folder 'moz-fx-sumo-prod' and dataset is | == 2025-09-22 Combined SUMO Answer rate for both TB Desktop and Android == | ||
* The pre August 18, 2025 queries on the rest of this page will no longer work when <code>moz-fx-data-sumo-prod</code> is deleted therefore :-) | * staff only [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-sumo-prod!2sus-central1!3s0008cda2-52ed-4801-89e5-a7db5d4a26e7!2e1 link to Google Big Query] | ||
* results 1983/15754 = 12.6% solved rate: | |||
<pre> | |||
tb_desktop_and_android_2024_aaq solved_tb_desktop_android_2024 | |||
15754 1983 | |||
</pre> | |||
===Working query=== | |||
<div class="mw-collapsible mw-collapsed" data-expandtext="show query"> | |||
<pre> | |||
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%' | |||
; | |||
</pre> | |||
</div> | |||
== 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 <code>moz-fx-data-sumo-prod</code> is deleted in a few days or months therefore :-) | |||
* They will work if you change the project (top left corner of the screen) to <code>sumo-prod</code> and the folder to <code>moz-fx-sumo-prod</code> and the table to <code>sumo.metrics_thunderbird_questions</code> <-- This is left as an exercise for the reader :-) | * They will work if you change the project (top left corner of the screen) to <code>sumo-prod</code> and the folder to <code>moz-fx-sumo-prod</code> and the table to <code>sumo.metrics_thunderbird_questions</code> <-- This is left as an exercise for the reader :-) | ||