BearND has uploaded a new change for review.
https://gerrit.wikimedia.org/r/156205
Change subject: +app edit reports for previews, saveAttempts, successful edits
......................................................................
+app edit reports for previews, saveAttempts, successful edits
Change-Id: I8595744985258eadf378a62f0ab7ef6bf18decb9
---
M dashboards/apps.json
M dashboards/reportcard.json
A datasources/app-edits-preview.json
A datasources/app-edits-save-attempt.json
M datasources/app-edits-starts.json
A datasources/app-edits-success.json
A graphs/app-edits-preview.json
A graphs/app-edits-save-attempt.json
A graphs/app-edits-success.json
A mobile/app-edits-preview.sql
A mobile/app-edits-save-attempt.sql
A mobile/app-edits-success.sql
M mobile/config.yaml
13 files changed, 627 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/05/156205/1
diff --git a/dashboards/apps.json b/dashboards/apps.json
index 6473305..7683937 100644
--- a/dashboards/apps.json
+++ b/dashboards/apps.json
@@ -6,7 +6,10 @@
{
"name": "Apps",
"graph_ids": [
- "app-edits-starts"
+ "app-edits-starts",
+ "app-edits-preview",
+ "app-edits-save-attempt",
+ "app-edits-success"
]
}
]
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
index d950940..44bbe83 100644
--- a/dashboards/reportcard.json
+++ b/dashboards/reportcard.json
@@ -41,7 +41,10 @@
{
"name": "Apps",
"graph_ids": [
- "app-edits-starts"
+ "app-edits-starts",
+ "app-edits-preview",
+ "app-edits-save-attempt",
+ "app-edits-success"
]
},
{
diff --git a/datasources/app-edits-preview.json
b/datasources/app-edits-preview.json
new file mode 100644
index 0000000..4193114
--- /dev/null
+++ b/datasources/app-edits-preview.json
@@ -0,0 +1,33 @@
+{
+ "name": "Apps - Impressions on edit summary and preview page (per day)",
+ "timespan": {
+ "start": "2014/06/25",
+ "step": "1d"
+ },
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/app-edits-preview.csv";,
+ "notes": "data excludes test wiki",
+ "format": "csv",
+ "slug": null,
+ "shortName": "app-edits-preview",
+ "type": "timeseries",
+ "id": "app-edits-preview",
+ "columns": [
+ {
+ "type": "date",
+ "label": "date"
+ },
+ {
+ "type": "int",
+ "label": "Total"
+ },
+ {
+ "type": "int",
+ "label": "Android"
+ },
+ {
+ "type": "int",
+ "label": "iOS"
+ }
+ ],
+ "desc": ""
+}
diff --git a/datasources/app-edits-save-attempt.json
b/datasources/app-edits-save-attempt.json
new file mode 100644
index 0000000..e6e6baf
--- /dev/null
+++ b/datasources/app-edits-save-attempt.json
@@ -0,0 +1,33 @@
+{
+ "name": "Apps - Impressions on Save button (number of save attempts per
day)",
+ "timespan": {
+ "start": "2014/06/25",
+ "step": "1d"
+ },
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/app-edits-save-attempt.csv";,
+ "notes": "data excludes test wiki",
+ "format": "csv",
+ "slug": null,
+ "shortName": "app-edits-save-attempt",
+ "type": "timeseries",
+ "id": "app-edits-save-attempt",
+ "columns": [
+ {
+ "type": "date",
+ "label": "date"
+ },
+ {
+ "type": "int",
+ "label": "Total"
+ },
+ {
+ "type": "int",
+ "label": "Android"
+ },
+ {
+ "type": "int",
+ "label": "iOS"
+ }
+ ],
+ "desc": ""
+}
diff --git a/datasources/app-edits-starts.json
b/datasources/app-edits-starts.json
index 500cb86..b172eea 100644
--- a/datasources/app-edits-starts.json
+++ b/datasources/app-edits-starts.json
@@ -5,7 +5,7 @@
"step": "1d"
},
"url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/app-edits-starts.csv";,
- "notes": "",
+ "notes": "data excludes test wiki",
"format": "csv",
"slug": null,
"shortName": "app-edits-starts",
diff --git a/datasources/app-edits-success.json
b/datasources/app-edits-success.json
new file mode 100644
index 0000000..da32407
--- /dev/null
+++ b/datasources/app-edits-success.json
@@ -0,0 +1,33 @@
+{
+ "name": "Apps - Number of successfully saved edits (per day)",
+ "timespan": {
+ "start": "2014/06/25",
+ "step": "1d"
+ },
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/app-edits-success.csv";,
+ "notes": "data excludes test wiki",
+ "format": "csv",
+ "slug": null,
+ "shortName": "app-edits-success",
+ "type": "timeseries",
+ "id": "app-edits-success",
+ "columns": [
+ {
+ "type": "date",
+ "label": "date"
+ },
+ {
+ "type": "int",
+ "label": "Total"
+ },
+ {
+ "type": "int",
+ "label": "Android"
+ },
+ {
+ "type": "int",
+ "label": "iOS"
+ }
+ ],
+ "desc": ""
+}
diff --git a/graphs/app-edits-preview.json b/graphs/app-edits-preview.json
new file mode 100644
index 0000000..9ea918e
--- /dev/null
+++ b/graphs/app-edits-preview.json
@@ -0,0 +1,155 @@
+{
+ "graph_version": "0.6.0",
+ "name": "Apps - Impressions on edit summary and preview page (per day)",
+ "notes": "",
+ "slug": "app-edits-preview",
+ "shortName": "",
+ "root": {
+ "scaling": "linear",
+ "nodeType": "canvas",
+ "minWidth": 750,
+ "minHeight": 500,
+ "height": 500,
+ "disabled": false,
+ "width": "auto",
+ "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"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "zoom-brush",
+ "options": {
+ "allowY": true,
+ "allowX": true
+ }
+ },
+ {
+ "nodeType": "callout",
+ "target": "latest",
+ "disabled": false,
+ "steps": [
+ "1y",
+ "1M"
+ ],
+ "metricRef": 0,
+ "options": {
+ "deltaPercent": true,
+ "dateFormat": "MMM YYYY",
+ "colorDelta": true
+ }
+ },
+ {
+ "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": "app-edits-preview",
+ "type": "int",
+ "source_col": 1
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Total",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 1,
+ "metric": {
+ "source_id": "app-edits-preview",
+ "type": "int",
+ "source_col": 2
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Android",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 2,
+ "metric": {
+ "source_id": "app-edits-preview",
+ "type": "int",
+ "source_col": 3
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "iOS",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "id": "app-edits-preview",
+ "desc": ""
+}
diff --git a/graphs/app-edits-save-attempt.json
b/graphs/app-edits-save-attempt.json
new file mode 100644
index 0000000..fafed44
--- /dev/null
+++ b/graphs/app-edits-save-attempt.json
@@ -0,0 +1,155 @@
+{
+ "graph_version": "0.6.0",
+ "name": "Apps - Impressions on Save button (number of save attempts per
day)",
+ "notes": "",
+ "slug": "app-edits-save-attempt",
+ "shortName": "",
+ "root": {
+ "scaling": "linear",
+ "nodeType": "canvas",
+ "minWidth": 750,
+ "minHeight": 500,
+ "height": 500,
+ "disabled": false,
+ "width": "auto",
+ "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"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "zoom-brush",
+ "options": {
+ "allowY": true,
+ "allowX": true
+ }
+ },
+ {
+ "nodeType": "callout",
+ "target": "latest",
+ "disabled": false,
+ "steps": [
+ "1y",
+ "1M"
+ ],
+ "metricRef": 0,
+ "options": {
+ "deltaPercent": true,
+ "dateFormat": "MMM YYYY",
+ "colorDelta": true
+ }
+ },
+ {
+ "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": "app-edits-save-attempt",
+ "type": "int",
+ "source_col": 1
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Total",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 1,
+ "metric": {
+ "source_id": "app-edits-save-attempt",
+ "type": "int",
+ "source_col": 2
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Android",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 2,
+ "metric": {
+ "source_id": "app-edits-save-attempt",
+ "type": "int",
+ "source_col": 3
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "iOS",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "id": "app-edits-save-attempt",
+ "desc": ""
+}
diff --git a/graphs/app-edits-success.json b/graphs/app-edits-success.json
new file mode 100644
index 0000000..fd0ab4a
--- /dev/null
+++ b/graphs/app-edits-success.json
@@ -0,0 +1,155 @@
+{
+ "graph_version": "0.6.0",
+ "name": "Apps - Number of successfully saved edits (per day)",
+ "notes": "",
+ "slug": "app-edits-success",
+ "shortName": "",
+ "root": {
+ "scaling": "linear",
+ "nodeType": "canvas",
+ "minWidth": 750,
+ "minHeight": 500,
+ "height": 500,
+ "disabled": false,
+ "width": "auto",
+ "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"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "zoom-brush",
+ "options": {
+ "allowY": true,
+ "allowX": true
+ }
+ },
+ {
+ "nodeType": "callout",
+ "target": "latest",
+ "disabled": false,
+ "steps": [
+ "1y",
+ "1M"
+ ],
+ "metricRef": 0,
+ "options": {
+ "deltaPercent": true,
+ "dateFormat": "MMM YYYY",
+ "colorDelta": true
+ }
+ },
+ {
+ "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": "app-edits-success",
+ "type": "int",
+ "source_col": 1
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Total",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 1,
+ "metric": {
+ "source_id": "app-edits-success",
+ "type": "int",
+ "source_col": 2
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Android",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ },
+ {
+ "disabled": false,
+ "index": 2,
+ "metric": {
+ "source_id": "app-edits-success",
+ "type": "int",
+ "source_col": 3
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "iOS",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "id": "app-edits-success",
+ "desc": ""
+}
diff --git a/mobile/app-edits-preview.sql b/mobile/app-edits-preview.sql
new file mode 100644
index 0000000..336e030
--- /dev/null
+++ b/mobile/app-edits-preview.sql
@@ -0,0 +1,13 @@
+-- see also app-edits-starts
+SELECT COUNT( * ) AS Total,
+ SUM( IF( userAgent LIKE '%Android%', 1, 0) ) AS Android,
+ SUM( IF( userAgent LIKE '%Darwin%' OR userAgent LIKE '%iPhone
OS%', 1, 0) ) AS iOS
+
+FROM {{ tables.edits_app }}
+
+WHERE event_action = 'preview'
+ AND wiki != 'testwiki'
+ AND timestamp >= '{from_timestamp}'
+ AND timestamp < '{to_timestamp}'
+
+GROUP BY DATE( timestamp )
diff --git a/mobile/app-edits-save-attempt.sql
b/mobile/app-edits-save-attempt.sql
new file mode 100644
index 0000000..22ae9fe
--- /dev/null
+++ b/mobile/app-edits-save-attempt.sql
@@ -0,0 +1,13 @@
+-- see also app-edits-starts
+SELECT COUNT( * ) AS Total,
+ SUM( IF( userAgent LIKE '%Android%', 1, 0) ) AS Android,
+ SUM( IF( userAgent LIKE '%Darwin%' OR userAgent LIKE '%iPhone
OS%', 1, 0) ) AS iOS
+
+FROM {{ tables.edits_app }}
+
+WHERE event_action = 'saveAttempt'
+ AND wiki != 'testwiki'
+ AND timestamp >= '{from_timestamp}'
+ AND timestamp < '{to_timestamp}'
+
+GROUP BY DATE( timestamp )
diff --git a/mobile/app-edits-success.sql b/mobile/app-edits-success.sql
new file mode 100644
index 0000000..d0fae0f
--- /dev/null
+++ b/mobile/app-edits-success.sql
@@ -0,0 +1,13 @@
+-- see also app-edits-starts
+SELECT COUNT( * ) AS Total,
+ SUM( IF( userAgent LIKE '%Android%', 1, 0) ) AS Android,
+ SUM( IF( userAgent LIKE '%Darwin%' OR userAgent LIKE '%iPhone
OS%', 1, 0) ) AS iOS
+
+FROM {{ tables.edits_app }}
+
+WHERE event_action = 'saved'
+ AND wiki != 'testwiki'
+ AND timestamp >= '{from_timestamp}'
+ AND timestamp < '{to_timestamp}'
+
+GROUP BY DATE( timestamp )
diff --git a/mobile/config.yaml b/mobile/config.yaml
index e3dce07..d83e1c5 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -60,6 +60,21 @@
frequency: hourly
timeboxed: true
starts: 2014-06-25
+ app-edits-preview:
+ title: Apps - Impressions on edit summary and preview page
(per day)
+ frequency: hourly
+ timeboxed: true
+ starts: 2014-06-25
+ app-edits-save-attempt:
+ title: Apps - Impressions on Save button (number of save
attempts per day)
+ frequency: hourly
+ timeboxed: true
+ starts: 2014-06-25
+ app-edits-success:
+ title: Apps - Number of successfully saved edits (per day)
+ frequency: hourly
+ timeboxed: true
+ starts: 2014-06-25
successful-logins:
title: Successful logins (per day)
frequency: hourly
--
To view, visit https://gerrit.wikimedia.org/r/156205
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I8595744985258eadf378a62f0ab7ef6bf18decb9
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: BearND <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
