Bearloga has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/379834 )
Change subject: Track sister search prevalence
......................................................................
Track sister search prevalence
Change-Id: I413d37930d959a212fa8fd7c1dfb35898a5f793f
---
M modules/metrics/search/config.yaml
A modules/metrics/search/sister_search_prevalence.sql
2 files changed, 33 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/discovery/golden
refs/changes/34/379834/1
diff --git a/modules/metrics/search/config.yaml
b/modules/metrics/search/config.yaml
index 00c4524..2181168 100644
--- a/modules/metrics/search/config.yaml
+++ b/modules/metrics/search/config.yaml
@@ -204,6 +204,12 @@
starts: 2017-06-01
funnel: true
type: script
+ sister_search_prevalence:
+ description: Prevalence of sister search results on Wikipedia search
result pages; broken up by language
+ granularity: days
+ starts: 2017-07-01
+ funnel: true
+ type: sql
srp_survtime:
description: Estimates (via survival analysis) of how long Wikipedia
searchers stay on full-text search results page after getting there from
autocomplete search, split by English vs French and Catalan vs other languages.
granularity: days
diff --git a/modules/metrics/search/sister_search_prevalence.sql
b/modules/metrics/search/sister_search_prevalence.sql
new file mode 100644
index 0000000..7b85464
--- /dev/null
+++ b/modules/metrics/search/sister_search_prevalence.sql
@@ -0,0 +1,27 @@
+SELECT
+ DATE('{from_timestamp}') AS date, wiki_id,
+ SUM(has_iw) AS `has sister results`,
+ SUM(IF(has_iw, 0, 1)) AS `no sister results`
+FROM (
+ SELECT DISTINCT
+ wiki_id, session_id, query_hash, has_iw
+ FROM (
+ SELECT DISTINCT
+ wiki AS wiki_id,
+ event_uniqueId AS event_id,
+ event_searchSessionId AS session_id,
+ MD5(LOWER(TRIM(event_query))) AS query_hash,
+ INSTR(event_extraParams, '"iw":') > 0 AS has_iw -- sister project
results shown
+ FROM TestSearchSatisfaction2_16909631
+ WHERE timestamp >= '{from_timestamp}' AND timestamp < '{to_timestamp}'
+ AND event_source = 'fulltext'
+ AND event_action = 'searchResultPage'
+ AND event_subTest IS NULL
+ ) AS events
+) AS searches
+GROUP BY date, wiki_id
+HAVING wiki_id RLIKE 'wiki$'
+ AND `has sister results` > 0
+ AND `no sister results` > 0
+ AND (`has sister results` + `no sister results`) > 20
+ORDER BY date, wiki_id;
--
To view, visit https://gerrit.wikimedia.org/r/379834
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I413d37930d959a212fa8fd7c1dfb35898a5f793f
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/discovery/golden
Gerrit-Branch: master
Gerrit-Owner: Bearloga <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
