Gilles has uploaded a new change for review. https://gerrit.wikimedia.org/r/169667
Change subject: Add options menu metrics ...................................................................... Add options menu metrics Change-Id: I34bafbaf75920491d71fcced93d013afd1aee1d0 Mingle: https://wikimedia.mingle.thoughtworks.com/projects/multimedia/cards/971 --- M actions/template.sql 1 file changed, 8 insertions(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia refs/changes/67/169667/1 diff --git a/actions/template.sql b/actions/template.sql index 1a6f44a..083b8cf 100644 --- a/actions/template.sql +++ b/actions/template.sql @@ -54,7 +54,11 @@ SUM(CASE WHEN event_action = 'embed-select-menu-html-large' THEN event_samplingFactor ELSE 0 END) AS 'embed-select-menu-html-large', SUM(CASE WHEN event_action = 'use-this-file-close' THEN event_samplingFactor ELSE 0 END) AS 'use-this-file-close', SUM(CASE WHEN event_action = 'download-open' THEN event_samplingFactor ELSE 0 END) AS 'download-open', - SUM(CASE WHEN event_action = 'download-close' THEN event_samplingFactor ELSE 0 END) AS 'download-close' + SUM(CASE WHEN event_action = 'download-close' THEN event_samplingFactor ELSE 0 END) AS 'download-close', + SUM(CASE WHEN event_action = 'options-open' THEN event_samplingFactor ELSE 0 END) AS 'options-open', + SUM(CASE WHEN event_action = 'options-close' THEN event_samplingFactor ELSE 0 END) AS 'options-close', + SUM(CASE WHEN event_action = 'disable-about-link' THEN event_samplingFactor ELSE 0 END) AS 'disable-about-link', + SUM(CASE WHEN event_action = 'enable-about-link' THEN event_samplingFactor ELSE 0 END) AS 'enable-about-link' FROM ( SELECT timestamp, event_action, 1 AS event_samplingFactor FROM MediaViewer_7670440 @@ -75,6 +79,9 @@ SELECT timestamp, event_action, event_samplingFactor FROM MediaViewer_9989959 WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) UNION ALL + SELECT timestamp, event_action, event_samplingFactor FROM MediaViewer_10277480 + WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) + UNION ALL SELECT timestamp, (CASE WHEN event_value = 0 THEN 'pref-optout-loggedin' ELSE 'pref-optin-loggedin' END) AS event_action, 1 AS event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property = 'multimediaviewer-enable' AND timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) ) AS MediaViewerUnioned -- To view, visit https://gerrit.wikimedia.org/r/169667 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I34bafbaf75920491d71fcced93d013afd1aee1d0 Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia Gerrit-Branch: master Gerrit-Owner: Gilles <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
