Jdlrobson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/131599
Change subject: Rewrite menu-daily as a ui click tracking graph
......................................................................
Rewrite menu-daily as a ui click tracking graph
Add last modified history page and profile page to mix
Change-Id: I31a52ea6f1c0b41a50d20924c0d6d43f59ee0b4d
---
M dashboards/reportcard.json
D datasources/menu-daily.json
A datasources/ui-daily.json
D graphs/menu-daily.json
A graphs/ui-daily.json
M mobile/config.yaml
R mobile/ui-daily.sql
7 files changed, 8 insertions(+), 6 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/99/131599/1
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
index 647fc0a..8820943 100644
--- a/dashboards/reportcard.json
+++ b/dashboards/reportcard.json
@@ -43,7 +43,7 @@
"graph_ids": [
"mobile-options",
"thanks-daily",
- "menu-daily",
+ "ui-daily",
"watchlist-activity",
"diff-activity"
]
diff --git a/datasources/menu-daily.json b/datasources/menu-daily.json
deleted file mode 100644
index 8af0b73..0000000
--- a/datasources/menu-daily.json
+++ /dev/null
@@ -1 +0,0 @@
-{"format": "csv", "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/menu-daily.csv";,
"timespan": {"start": "2013/05/0", "step": "1d", "end": "2013/03/19"}, "type":
"timeseries", "id": "menu-daily", "columns": [{"type": "date", "label": "Day"},
{"type": "int", "label": "Home"}, {"type": "int", "label": "Random"}, {"type":
"int", "label": "Uploads"}, {"type": "int", "label": "Watchlist"}, {"type":
"int", "label": "Nearby"}, {"type": "int", "label": "Settings"}, {"type":
"int", "label": "Login"}, {"type": "int", "label": "Logout"}, {"type": "int",
"label": "Profile (Beta only)\r\n"}]}
diff --git a/datasources/ui-daily.json b/datasources/ui-daily.json
new file mode 100644
index 0000000..2efa33f
--- /dev/null
+++ b/datasources/ui-daily.json
@@ -0,0 +1 @@
+{"format": "csv", "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/ui-daily.csv";,
"timespan": {"start": "2013/05/0", "step": "1d", "end": "2013/03/19"}, "type":
"timeseries", "id": "ui-daily", "columns": [{"type": "date", "label": "Day"},
{"type": "int", "label": "Home"}, {"type": "int", "label": "Random"}, {"type":
"int", "label": "Uploads"}, {"type": "int", "label": "Watchlist"}, {"type":
"int", "label": "Nearby"}, {"type": "int", "label": "Settings"}, {"type":
"int", "label": "Login"}, {"type": "int", "label": "Logout"}, {"type": "int",
"label": "Profile"}, {"type": "int", "label": "Last modified history"},
{"type": "int", "label": "Last modified profile\r\n"}]}
diff --git a/graphs/menu-daily.json b/graphs/menu-daily.json
deleted file mode 100644
index 44e29dc..0000000
--- a/graphs/menu-daily.json
+++ /dev/null
@@ -1 +0,0 @@
-{"root": {"scaling": "linear", "minWidth": 750, "nodeType": "canvas",
"disabled": false, "width": "auto", "id": "menu-daily", "minHeight": 500,
"children": [{"disabled": false, "nodeType": "axis", "options": {"tickFormat":
"MMM YY", "dimension": "x", "orient": "bottom"}}, {"disabled": false,
"nodeType": "axis", "options": {"tickFormat": "MMM YY", "dimension": "y",
"orient": "left"}}, {"disabled": false, "nodeType": "grid", "options":
{"ticks": 10, "dimension": "x"}}, {"disabled": false, "nodeType": "grid",
"options": {"ticks": 10, "dimension": "y"}}, {"nodeType": "callout", "target":
"latest", "disabled": false, "steps": ["1y", "1M"], "metricRef": 0, "options":
{"deltaPercent": true, "colorDelta": true, "dateFormat": "MMM YYYY"}},
{"disabled": false, "nodeType": "legend", "options": {"valueFormat": ",.2s",
"dateFormat": "MMM YYYY"}, "label": "Aug 2012"}, {"disabled": false,
"nodeType": "line-group", "options": {"palette": "wmf_projects", "scale":
"log", "stroke": {"opacity": 1, "width": 2}, "dateFormat": "MMM YYYY"},
"children": [{"disabled": false, "index": 0, "metric": {"source_id":
"menu-daily", "type": "int", "source_col": 1}, "nodeType": "line", "options":
{"stroke": {"width": 2}, "dateFormat": "MMM YYYY", "noLegend": false, "label":
"Home"}}, {"disabled": false, "index": 0, "metric": {"source_id": "menu-daily",
"type": "int", "source_col": 2}, "nodeType": "line", "options": {"stroke":
{"width": 2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Random"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 3}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Uploads"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 4}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Watchlist"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 5}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Nearby"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 6}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Settings"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 7}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Login"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 8}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Logout"}},
{"disabled": false, "index": 0, "metric": {"source_id": "menu-daily", "type":
"int", "source_col": 9}, "nodeType": "line", "options": {"stroke": {"width":
2}, "dateFormat": "MMM YYYY", "noLegend": false, "label": "Profile (Beta
only)\r\n"}}]}], "height": 500}, "graph_version": "0.6.0", "name": "Main menu
activity"}
\ No newline at end of file
diff --git a/graphs/ui-daily.json b/graphs/ui-daily.json
new file mode 100644
index 0000000..bea02e2
--- /dev/null
+++ b/graphs/ui-daily.json
@@ -0,0 +1 @@
+{"root": {"scaling": "linear", "minWidth": 750, "nodeType": "canvas",
"disabled": false, "width": "auto", "id": "ui-daily", "minHeight": 500,
"children": [{"disabled": false, "nodeType": "axis", "options": {"tickFormat":
"MMM YY", "dimension": "x", "orient": "bottom"}}, {"disabled": false,
"nodeType": "axis", "options": {"tickFormat": "MMM YY", "dimension": "y",
"orient": "left"}}, {"disabled": false, "nodeType": "grid", "options":
{"ticks": 10, "dimension": "x"}}, {"disabled": false, "nodeType": "grid",
"options": {"ticks": 10, "dimension": "y"}}, {"nodeType": "callout", "target":
"latest", "disabled": false, "steps": ["1y", "1M"], "metricRef": 0, "options":
{"deltaPercent": true, "colorDelta": true, "dateFormat": "MMM YYYY"}},
{"disabled": false, "nodeType": "legend", "options": {"valueFormat": ",.2s",
"dateFormat": "MMM YYYY"}, "label": "Aug 2012"}, {"disabled": false,
"nodeType": "zoom-brush", "options": {"allowY": true, "allowX": true}},
{"disabled": false, "nodeType": "line-group", "options": {"palette":
"wmf_projects", "scale": "log", "stroke": {"opacity": 1, "width": 2},
"dateFormat": "MMM YYYY"}, "children": [{"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 1},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Home"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 2},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Random"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 3},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Uploads"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 4},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Watchlist"}}, {"disabled": false, "index":
0, "metric": {"source_id": "ui-daily", "type": "int", "source_col": 5},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Nearby"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 6},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Settings"}}, {"disabled": false, "index":
0, "metric": {"source_id": "ui-daily", "type": "int", "source_col": 7},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Login"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 8},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Logout"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 9},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Profile"}}, {"disabled": false, "index": 0,
"metric": {"source_id": "ui-daily", "type": "int", "source_col": 10},
"nodeType": "line", "options": {"stroke": {"width": 2}, "dateFormat": "MMM
YYYY", "noLegend": false, "label": "Last modified history"}}, {"disabled":
false, "index": 0, "metric": {"source_id": "ui-daily", "type": "int",
"source_col": 11}, "nodeType": "line", "options": {"stroke": {"width": 2},
"dateFormat": "MMM YYYY", "noLegend": false, "label": "Last modified
profile\r\n"}}]}], "height": 500}, "graph_version": "0.6.0", "name": "UI
activity"}
\ No newline at end of file
diff --git a/mobile/config.yaml b/mobile/config.yaml
index d0f3678..3d5a02f 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -104,8 +104,8 @@
frequency: hourly
starts: 2013-11-01
timeboxed: true
- menu-daily:
- title: Main menu activity
+ ui-daily:
+ title: UI activity
frequency: hourly
starts: 2014-01-01
timeboxed: true
diff --git a/mobile/menu-daily.sql b/mobile/ui-daily.sql
similarity index 73%
rename from mobile/menu-daily.sql
rename to mobile/ui-daily.sql
index a5c1aa3..699454e 100644
--- a/mobile/menu-daily.sql
+++ b/mobile/ui-daily.sql
@@ -7,7 +7,9 @@
sum(if(event_name = 'hamburger-settings', 1, 0)) as Settings,
sum(if(event_name = 'hamburger-login', 1, 0)) as Login,
sum(if(event_name = 'hamburger-logout', 1, 0)) as Logout,
- sum(if(event_name = 'hamburger-profile', 1, 0)) as 'Profile (Beta only)'
+ sum(if(event_name = 'hamburger-profile', 1, 0)) as 'Profile',
+ sum(if(event_name = 'lastmodified-history', 1, 0)) as 'Last modified
history',
+ sum(if(event_name = 'lastmodified-profile', 1, 0)) as 'Last modified
profile'
from
MobileWebClickTracking_5929948
where
--
To view, visit https://gerrit.wikimedia.org/r/131599
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I31a52ea6f1c0b41a50d20924c0d6d43f59ee0b4d
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Jdlrobson <jrob...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
