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

Jump to page
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

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:
Screen Shot File organization.png
2. Use Notepad (Windows OS), Textedit (Mac OS) or Kate / gedit (Linux OS) and saved as a TXT file. Make sure to remove “Rich Text Formatting” and save the file as “Plain Text”.

Plaintext file upload.png

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.