Learning and Evaluation/Archive/Learning modules/1Cohort File Format

Jump to page
As of 2019-03-25 Wikimetrics is inoperative. See Phabricator task. Please use https://eventmetrics.wmflabs.org instead to get metrics for your event. Part 1. Wikimetrics Overview Wikimetrics Training Overview What is Wikimetrics? Data organization of Wiki pages Program vs Project How does Wikimetrics Work? Data Analysis with Wikimetrics Available Metrics Part 2. Making Your Cohort File The Cohort File Usernames, User IDs, and Cohorts Collecting your Cohort Obtaining Consent Cohort Upload Options Cohort File Format Cross Project Cohorts Part 3. Using the Wikimetrics Tool Logging into Wikimetrics Upload Cohort Name your cohort Cohort Description Set Default Project Upload File Cohort Validation Invalid Users Remove Cohort Create Report Video: Upload Cohort Create Analysis Report Pick Cohorts Pick Metrics 1. Bytes Added 2. Edits 3. Pages Created 4. Threshold 5. Survival Important Tips and Tricks Configure Output Run Report and Report Output Video: Run Report Cohort Storage and Sharing Using your new data Conclusion Questions and Troubleshooting Feedback

  Wikimedia Training Wikimetrics Menu

File Format for your Cohort

Once you have obtained consent, its time to prepare your file. There are 2 options for uploading your cohort:

1. Prepare a CSV or TXT file, which the following will cover.
2. Copy/paste a list of usernames into wikimetrics. Format usernames in the text box using the txt option below

Cohorts remain on Wikimetrics indefinitely and you are unable to change the cohort name once the cohort is uploaded.

A CSV file is simply a Comma Separated Value file. These can be created in two different ways:

1. Using spreadsheet software, and saving as CSV. There should be one username per cell in the first column:

2. Use Notepad (Windows OS) or Textedit (Mac OS) and saved as a TXT file. Make sure to remove “Rich Text Formatting” and save the file as “Plain Text”.

Some of the more common mistakes with Wikimetrics usernames include:

• Make sure usernames are spelled correctly, including capitalization.
• Make sure to remove hidden formatting or trailing spaces. Hidden formatting can be found with a word processor, which sometimes have a "show formatting" option.