GoranSMilovanovic (GoranSM)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Wednesday

  • Clear sailing ahead.

User Details

User Since
Mar 20 2017, 3:58 PM (56 w, 6 d)
Availability
Available
LDAP User
GoranSMilovanovic
MediaWiki User
GoranSMilovanovic

Recent Activity

Fri, Apr 20

GoranSMilovanovic added a comment to T191506: create test banners (dummy).

@Stefan_Schneider_WMDE I'm on it - T192659.

Fri, Apr 20, 3:07 PM · WMDE-New-Editors-Banner-Campaigns (Banner Campaign Spring 2018)
GoranSMilovanovic moved T192659: Test Spring Banner Campaign 2018 Setup from New Editors/Campaigns to Prioritized on the User-GoranSMilovanovic board.
Fri, Apr 20, 3:07 PM · User-GoranSMilovanovic
GoranSMilovanovic created T192659: Test Spring Banner Campaign 2018 Setup.
Fri, Apr 20, 3:07 PM · User-GoranSMilovanovic
GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.
  • Spark launches in the Dynamic Allocation mode - checked;
  • With different settings (e.g. spark.executor.instances, spark.dynamicAllocation.minExecutors), it will use several executors, but from what I see from the Spark UI on yarn.wikimedia.org it always uses only one executor at the time; however
  • that was a test on a rather small data set (~ 330K rows, 5 columns or so).
Fri, Apr 20, 4:09 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering

Wed, Apr 18

GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.

@Ottomata Everything seems to be fine thus far. However, I am not testing any really large datasets yet ( nycflights13, and that would be some 336776 rows, 16 columns).

Wed, Apr 18, 4:20 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.

@elukey The ideal situation would be to have the same version of R installed across all worker nodes. At this point, we have R 3.1.1 (2014) on Jessie hosts and R 3.3.3 (2017) on Stretch hosts. However, there were no backwards compatibility issues in R for years already, so let's not worry about this now. If it turns out that the discrepancy causes any trouble upon testing, I will report back - but I don't think it will. Thanks for support!

Wed, Apr 18, 9:37 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic renamed T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets from SparkR on Spark 2.3.0 - Cannot run program "Rscript" to SparkR on Spark 2.3.0 - Testing on Large Data Sets.
Wed, Apr 18, 12:56 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic moved T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets from Technical Wishlist to Prioritized on the User-GoranSMilovanovic board.
Wed, Apr 18, 12:55 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic added a project to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets: User-GoranSMilovanovic.
Wed, Apr 18, 12:55 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering

Tue, Apr 17

GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.
  • Elementary tests with {SparkR} conducted: works.
  • In the following hours I will be testing MLlib procedures with larger data sets.
  • Reporting back here and documenting on Analytics/Systems/Cluster/Spark on Wikitech.
  • Finally, I will try to make {sparklyr} connect (T139487) too; we will probably learn something even if it fails to connect again.
Tue, Apr 17, 6:05 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic reopened T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets as "Open".
Tue, Apr 17, 5:04 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic closed T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets as Resolved.
Tue, Apr 17, 4:39 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.

@Ottomata Fixed with the arguments to sparkR.session() and the preceding Sys.setenv() R call as in the following:

Tue, Apr 17, 4:38 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic added a comment to T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.

@Ottomata Andrew, seems like we have R on workers, thank you.
However, any operation, for example:

Tue, Apr 17, 4:17 PM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic updated the task description for T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.
Tue, Apr 17, 10:37 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic updated the task description for T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.
Tue, Apr 17, 10:36 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering
GoranSMilovanovic created T192348: SparkR on Spark 2.3.0 - Testing on Large Data Sets.
Tue, Apr 17, 10:33 AM · User-GoranSMilovanovic, Analytics-Kanban, Patch-For-Review, WMDE-Analytics-Engineering

Thu, Apr 12

GoranSMilovanovic moved T187537: Usage metrics from Technical Wishlist to Current/Deprioritized on the User-GoranSMilovanovic board.
Thu, Apr 12, 9:34 AM · User-GoranSMilovanovic, German-Community-Wishlist, Move-Files-To-Commons, TCB-Team
GoranSMilovanovic moved T181704: Track how many paragraphs usually are involved in an edit conflict from Current/Deprioritized to Technical Wishlist on the User-GoranSMilovanovic board.
Thu, Apr 12, 9:34 AM · User-GoranSMilovanovic, User-Addshore, Patch-For-Review, WMDE-QWERTY-Sprint-2017-12-05, WMDE-QWERTY-Team, TCB-Team, Two-Column-Edit-Conflict-Merge
GoranSMilovanovic added a project to T187537: Usage metrics: User-GoranSMilovanovic.
Thu, Apr 12, 9:04 AM · User-GoranSMilovanovic, German-Community-Wishlist, Move-Files-To-Commons, TCB-Team
GoranSMilovanovic closed T182008: How often are new editors involved in edit conflicts as Resolved.
Thu, Apr 12, 8:34 AM · WMDE-Analytics-Engineering, Analytics, User-GoranSMilovanovic, MW-1.31-release-notes (WMF-deploy-2018-01-02 (1.31.0-wmf.15)), Patch-For-Review, WMDE-QWERTY-Sprint-2017-12-05, WMDE-QWERTY-Team, TCB-Team, Two-Column-Edit-Conflict-Merge
GoranSMilovanovic closed T182008: How often are new editors involved in edit conflicts, a subtask of T181058: Investigate when edit conflicts happen, as Resolved.
Thu, Apr 12, 8:34 AM · WMDE-QWERTY-Team, Two-Column-Edit-Conflict-Merge, TCB-Team
GoranSMilovanovic closed T182008: How often are new editors involved in edit conflicts, a subtask of T183223: Analytics: Grafana board with insights into edit conflicts, as Resolved.
Thu, Apr 12, 8:34 AM · User-GoranSMilovanovic, Two-Column-Edit-Conflict-Merge, TCB-Team, German-Community-Wishlist
GoranSMilovanovic closed T186697: Analysis of advanced search usage as Resolved.
Thu, Apr 12, 8:26 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic closed T186697: Analysis of advanced search usage, a subtask of T143310: Implement a way to access keywords such as "incategory", "intitle" via the Search special page, as Resolved.
Thu, Apr 12, 8:26 AM · Advanced-Search, Wikimedia-Hackathon-2017, TCB-Team, German-Community-Wishlist-Main-Wishes, German-Community-Wishlist
GoranSMilovanovic closed T187039: Measure change in keyword usage with AdvancedSearch as Resolved.
Thu, Apr 12, 8:25 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic closed T187039: Measure change in keyword usage with AdvancedSearch, a subtask of T186697: Analysis of advanced search usage, as Resolved.
Thu, Apr 12, 8:25 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic closed T187038: Measure usefulness of special:search page with advancedSearch as Resolved.
Thu, Apr 12, 8:24 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic closed T187038: Measure usefulness of special:search page with advancedSearch, a subtask of T186697: Analysis of advanced search usage, as Resolved.
Thu, Apr 12, 8:24 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic closed T192045: WDCM Dashboards are currently down due to maintaince as Resolved.

Discard, please. All the WDCM dashboards are running nicely now. Closing the ticket.

Thu, Apr 12, 3:35 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T171258: WDCM: Process Module Scaling/migrate to Production from WDCM to Prioritized on the User-GoranSMilovanovic board.
Thu, Apr 12, 3:25 AM · User-Addshore, Patch-For-Review, WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T180891: WDCM: Optimize WDCM Shiny Dashboards from WDCM to Prioritized on the User-GoranSMilovanovic board.
Thu, Apr 12, 3:24 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T184109: WDCM: Wikidata Usage Biases from Prioritized to WDCM on the User-GoranSMilovanovic board.
Thu, Apr 12, 3:24 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic lowered the priority of T192045: WDCM Dashboards are currently down due to maintaince from High to Low.
Thu, Apr 12, 3:24 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic added a comment to T184109: WDCM: Wikidata Usage Biases.

The first version of this Dashboard is finally deployed: http://wdcm.wmflabs.org/WDCM_BiasesDashboard/, and can be announced.

Thu, Apr 12, 3:22 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic closed T191164: WDCM Geo Dashboard: some categories are not shown as Resolved.

This is fixed. A bug was related to the leaflet maps implementation in R.

Thu, Apr 12, 3:05 AM · User-GoranSMilovanovic
GoranSMilovanovic updated subscribers of T192045: WDCM Dashboards are currently down due to maintaince.
  • All dashboards are updated and running.
Thu, Apr 12, 3:04 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic added a comment to T192045: WDCM Dashboards are currently down due to maintaince.
  • The WDCM system update is currently rolled-back to December 2017.
  • The dashboards will be available with old data until the current maintenance operation is completed.
Thu, Apr 12, 1:11 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic reopened T192045: WDCM Dashboards are currently down due to maintaince as "Open".
Thu, Apr 12, 1:11 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic placed T192045: WDCM Dashboards are currently down due to maintaince up for grabs.
Thu, Apr 12, 1:10 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic closed T192045: WDCM Dashboards are currently down due to maintaince as Resolved.

Done.

Thu, Apr 12, 1:06 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic triaged T192045: WDCM Dashboards are currently down due to maintaince as High priority.
Thu, Apr 12, 1:01 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic created T192045: WDCM Dashboards are currently down due to maintaince.
Thu, Apr 12, 1:00 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic

Fri, Apr 6

GoranSMilovanovic updated subscribers of T186697: Analysis of advanced search usage.

Just to make sure, since the explanatory text still mentions "90 days", we are passing the 90 days, right? Maybe we should adapt the text then.

Fri, Apr 6, 11:10 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist

Thu, Apr 5

GoranSMilovanovic added a comment to T184057: Productionize Generation of Wikidata maps and associated data (currently at https://tools.wmflabs.org/wikidata-analysis/).

@Addshore Thanks a lot!

Thu, Apr 5, 3:06 PM · User-Addshore, Wikidata, WMDE-Analytics-Engineering
GoranSMilovanovic added a comment to T186697: Analysis of advanced search usage.

Please take a look at the Dashboard now. As of the update problem ("All the graphs seem to consider the last day to be March 1st. ") - someone has introduced a new eventLogging SQL schema for the AdvancedSearchExtension without notifying me; the Dashboard now relies on a concatenation of data from two consecutive eventLogging schemes on the first data intake, and the proceeds to work with the most recent version. All in all, everything should be fixed now.

Thu, Apr 5, 2:58 PM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic moved T187393: Wikidata items touched by humans per class from Incoming to Radar on the User-GoranSMilovanovic board.
Thu, Apr 5, 12:20 PM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T191416: track usage of Wikibase Lua functions from Technical Wishlist to Incoming on the User-GoranSMilovanovic board.
Thu, Apr 5, 12:17 PM · Wikibase-Lua, User-GoranSMilovanovic, WMDE-Analytics-Engineering, Wikidata
GoranSMilovanovic moved T191424: track number of Lexemes and Forms from Technical Wishlist to Incoming on the User-GoranSMilovanovic board.
Thu, Apr 5, 12:17 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, Wikidata, Lexicographical data
GoranSMilovanovic moved T191502: deliver daily reports from Technical Wishlist to Incoming on the User-GoranSMilovanovic board.
Thu, Apr 5, 12:17 PM · WMDE-Analytics-Engineering, User-GoranSMilovanovic, WMDE-New-Editors-Banner-Campaigns (Banner Campaign Spring 2018)
GoranSMilovanovic added a project to T191424: track number of Lexemes and Forms: User-GoranSMilovanovic.
Thu, Apr 5, 12:17 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, Wikidata, Lexicographical data
GoranSMilovanovic added a project to T191416: track usage of Wikibase Lua functions: User-GoranSMilovanovic.
Thu, Apr 5, 12:16 PM · Wikibase-Lua, User-GoranSMilovanovic, WMDE-Analytics-Engineering, Wikidata
GoranSMilovanovic claimed T191502: deliver daily reports.

@Stefan_Schneider_WMDE Got it.

Thu, Apr 5, 12:09 PM · WMDE-Analytics-Engineering, User-GoranSMilovanovic, WMDE-New-Editors-Banner-Campaigns (Banner Campaign Spring 2018)

Tue, Apr 3

GoranSMilovanovic added a comment to T186697: Analysis of advanced search usage.

-> "growing graphs"

  • I think I know the solution that will fit what you are describing. Reporting back as soon as implement it on the Dashboard.

"Also, would it be possible to display all lines at the same time, and only focus on one, if wanted?"

  • Depends on (a) whether the above mentioned visualization can support something like that, and (b) whether the data scales so that it makes sense to have different keywords represented on the same chart. I need to experiment a bit with this and than I can let you know. I will do my best to make it happen, of course.

... on the first tab (where you did not actually change anything) it looks like something is broken...

  • That means that something is wrong with the update module - fixing it is now a priority.
Tue, Apr 3, 10:06 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic moved T174896: WDCM Structure Dashboard: Refining the WDCM Taxonomy from Current/Deprioritized to WDCM on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:46 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T187396: WDCM for (S)itelinks only from Incoming to Prioritized on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:46 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T184109: WDCM: Wikidata Usage Biases from Current/Deprioritized to Prioritized on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:45 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T186697: Analysis of advanced search usage from Prioritized to Current/Deprioritized on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:44 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic moved T187038: Measure usefulness of special:search page with advancedSearch from Prioritized to Current/Deprioritized on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:44 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic moved T187039: Measure change in keyword usage with AdvancedSearch from Prioritized to Current/Deprioritized on the User-GoranSMilovanovic board.
Tue, Apr 3, 2:44 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic added a comment to T187039: Measure change in keyword usage with AdvancedSearch.

@Lea_WMDE Please review: T186697#4099426.

Tue, Apr 3, 2:44 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Please review: T186697.

Tue, Apr 3, 2:43 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T186697: Analysis of advanced search usage.

@Lea_WMDE The Advanced Search Extension Dashboard now presents the data described in:

Tue, Apr 3, 2:43 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist

Sun, Apr 1

GoranSMilovanovic triaged T191164: WDCM Geo Dashboard: some categories are not shown as High priority.
Sun, Apr 1, 10:50 AM · User-GoranSMilovanovic
GoranSMilovanovic created T191164: WDCM Geo Dashboard: some categories are not shown.
Sun, Apr 1, 10:50 AM · User-GoranSMilovanovic

Tue, Mar 27

GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.
  • A. The scale will be fixed.
  • B. Not all graphs should fit on the same panel, because the Advanced Search Extension are on a different scale (hundreds of observations vs. many thousands of observations for Special:Search). You won't be able to read anything from such charts.Q: did you mean: have one chart and a drop-down menu on the Dashboard to change the metric that is being presented?
Tue, Mar 27, 11:25 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Please, you still did not clarify what do you mean by ...within the wikimedia cluster.

Tue, Mar 27, 3:20 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team

Mon, Mar 26

GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

The charts refer to the previous 90 days.

Mon, Mar 26, 9:53 PM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Initial data acquisition is completed, you can expect the first visualization examples later during the day.

Mon, Mar 26, 5:17 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team

Mar 21 2018

GoranSMilovanovic moved T184109: WDCM: Wikidata Usage Biases from Prioritized to Current/Deprioritized on the User-GoranSMilovanovic board.
Mar 21 2018, 1:10 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic added a comment to T184109: WDCM: Wikidata Usage Biases.

(Finally - this really took a lot to complete) the Dashboard is ready to go public.

Mar 21 2018, 1:09 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic

Mar 16 2018

GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Ok, the procedure will be run on daily basis as of today, and I will develop a feature on the Advanced Search Extension dashboard for you to track the progress and visualize the data. Resources: storage is no problem, human could be (namely, me: I am doing this by combining HiveQL and R processing, and I am constantly in a doubt on whether a person with a better knowledge of HiveQL than mine could improve the current workflow; that being said, I'll see to optimize this as much as I can).

Mar 16 2018, 11:31 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Sorry, my bad, a technical thing: ETL (abbr.) = Extract-Transform-Load, a set of procedures used to re-structure the data from a database table (typically) into another table that will be used for analytics.

Mar 16 2018, 11:24 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

One question to be sure: In this data, we are not collecting searches that land on special:search, but only searches that start (and land) on the special:search form, right?

Mar 16 2018, 11:07 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic updated subscribers of T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Please have a look and let me know do you really want any analysis based on the following data.

Mar 16 2018, 10:40 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team

Mar 15 2018

GoranSMilovanovic added a comment to T184173: WD Feature Evaluation Plans.

@Lydia_Pintscher @Jan_Dittrich What is the status here?

Mar 15 2018, 10:27 PM · WMDE-Analytics-Engineering, Wikidata, User-GoranSMilovanovic
GoranSMilovanovic moved T189298: Additional Information: Monthly New Editors Report from Incoming to Prioritized on the User-GoranSMilovanovic board.
Mar 15 2018, 10:26 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic added a comment to T189298: Additional Information: Monthly New Editors Report.

@Verena The answer to your question is: nine (9). Now, to make this sound less like "42", a table is attached with the following columns: (1) the timestamp of the 10th edit, (2) the Banner Campaign, (3) the timestamp of user registration. Please let me know if you need additional information.

Mar 15 2018, 10:25 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic added a comment to T189298: Additional Information: Monthly New Editors Report.

@Stefan_Schneider_WMDE @Verena by the way

Mar 15 2018, 9:56 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic added a comment to T189298: Additional Information: Monthly New Editors Report.

@Verena I will take care of that particular question

Mar 15 2018, 9:52 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)

Mar 14 2018

GoranSMilovanovic created T189653: Please review: public data sets for the WDCM Biases Dashboard.
Mar 14 2018, 9:33 AM · Analytics-Kanban, Analytics, Analytics-Data-Quality, WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic moved T184109: WDCM: Wikidata Usage Biases from Current/Deprioritized to Prioritized on the User-GoranSMilovanovic board.
Mar 14 2018, 9:04 AM · WMDE-Analytics-Engineering, User-GoranSMilovanovic

Mar 13 2018

GoranSMilovanovic added a comment to T187039: Measure change in keyword usage with AdvancedSearch.

@Lea_WMDE if the userAgent field contains something like isAnon, then yes, otherwise, no. I don't think we have that (rather common in our RDBS tables) field in this Hive table.

Mar 13 2018, 6:57 PM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic closed T187606: Please review: new WMDE public data set on stat1005 as Resolved.
Mar 13 2018, 2:40 PM · Analytics-Kanban, Analytics-Data-Quality, WMDE-Analytics-Engineering, User-GoranSMilovanovic
GoranSMilovanovic added a comment to T187907: Count keyword usage over time.

@Lea_WMDE The following:

Mar 13 2018, 11:38 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic added a comment to T187606: Please review: new WMDE public data set on stat1005.

the asExtensionUpdate.csv file - that one that needs to be made public to support our Dashboard that runs from the CloudVPS service - is now sanitized as per your request:

Mar 13 2018, 11:27 AM · Analytics-Kanban, Analytics-Data-Quality, WMDE-Analytics-Engineering, User-GoranSMilovanovic

Mar 11 2018

GoranSMilovanovic claimed T187038: Measure usefulness of special:search page with advancedSearch.
Mar 11 2018, 12:28 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic claimed T187908: Count the times the special page Special:Search was used.
Mar 11 2018, 12:28 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187038: Measure usefulness of special:search page with advancedSearch.

@Lea_WMDE Please see T187908#4040814.

Mar 11 2018, 12:27 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic added a comment to T187908: Count the times the special page Special:Search was used.
Mar 11 2018, 12:27 AM · User-GoranSMilovanovic, Advanced-Search, TCB-Team
GoranSMilovanovic claimed T187907: Count keyword usage over time.
Mar 11 2018, 12:17 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic claimed T187039: Measure change in keyword usage with AdvancedSearch.
Mar 11 2018, 12:17 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search
GoranSMilovanovic added a comment to T187039: Measure change in keyword usage with AdvancedSearch.

@Lea_WMDE Please see T187907.

Mar 11 2018, 12:17 AM · User-GoranSMilovanovic, TCB-Team, Advanced-Search

Mar 10 2018

GoranSMilovanovic added a comment to T187907: Count keyword usage over time.

@dcausse @EBernhardson @Milimetric I will need your advise on this. Please let me know if I am missing something (I was relying on the Analytics/Data Lake/Traffic/Cirrus page to study the schema).

Mar 10 2018, 11:34 PM · User-GoranSMilovanovic, TCB-Team, Advanced-Search

Mar 9 2018

GoranSMilovanovic moved T189298: Additional Information: Monthly New Editors Report from New Editors/Campaigns to Incoming on the User-GoranSMilovanovic board.
Mar 9 2018, 11:16 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic moved T189298: Additional Information: Monthly New Editors Report from Technical Wishlist to New Editors/Campaigns on the User-GoranSMilovanovic board.
Mar 9 2018, 11:16 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic added projects to T189298: Additional Information: Monthly New Editors Report: WMDE-Analytics-Engineering, User-GoranSMilovanovic.
Mar 9 2018, 11:15 PM · User-GoranSMilovanovic, WMDE-Analytics-Engineering, WMDE-New-Editors-Banner-Campaigns (Banner-Campaign-Thanks-2018)
GoranSMilovanovic moved T181704: Track how many paragraphs usually are involved in an edit conflict from Prioritized to Current/Deprioritized on the User-GoranSMilovanovic board.
Mar 9 2018, 11:13 PM · User-GoranSMilovanovic, User-Addshore, Patch-For-Review, WMDE-QWERTY-Sprint-2017-12-05, WMDE-QWERTY-Team, TCB-Team, Two-Column-Edit-Conflict-Merge
GoranSMilovanovic moved T186697: Analysis of advanced search usage from Incoming to Prioritized on the User-GoranSMilovanovic board.
Mar 9 2018, 11:12 PM · User-GoranSMilovanovic, Advanced-Search, TCB-Team, German-Community-Wishlist
GoranSMilovanovic moved T187606: Please review: new WMDE public data set on stat1005 from Technical Wishlist to Prioritized on the User-GoranSMilovanovic board.
Mar 9 2018, 11:10 PM · Analytics-Kanban, Analytics-Data-Quality, WMDE-Analytics-Engineering, User-GoranSMilovanovic