Page MenuHomePhabricator

Add 'Pages Improved' data to downloadable Wikitext report
Closed, ResolvedPublic2 Estimated Story Points

Description

The Pages Improved reports give details on all Main space pages edited during an event. This Wikitext version of the report provides event organizers with a quick way to post event data on wiki so others will see it.

  • Metric definitions: This report presents a subset of the metrics defined in T210775, which describes the CSV version of the this report. All metric here use the same definitions.

Report Content

Metrics/layout

  • The left-most column of the report will be a list of (linked) page titles.
  • The metrics in each row will be presented/calculated as they apply to the particular article listed in the left column. E.g., [x] Bytes changed" means bytes changed for that article (as opposed to the same figure on the Event Summary reports, where it gives the total for the whole event).
    • Metrics formatted as links: Unlike the CSV version of this report, this Wikitext version presents certain fields as links: -[x] "Title": combine page title with page URL to form links
      • "More page metrics": combine the URL with the word "XTools"
  • Sortable columns: Table columns will be sortable (see mockup).
  • Default sort The default table sort will be by Avg. daily pageviews, descending
    • TABLE MOCKUP: For wikitext styling, layout, etc., follow the link to a sample table (screenshot below).

Screen Shot 2018-10-11 at 11.22.17 AM.png (1,042×187 px, 57 KB)

The column headings will be, in order (pls use this approved wording):

  • Title [present as link, see above]
  • Wiki
  • Edits during event [method defined in T206821]
  • Bytes changed during event [method defined in T206821]
  • Avg. daily pageviews [method defined in T206817]
  • Incoming links [method defined in T214219]
  • More page metrics [present as link, see above]

Descriptive info

At the top of the table, provide the following information. See mockup for design and layout.

  • Pages Improved * Event name
  • Last updated yyyy-mm-dd hh:mm (timezonecountry/city) [Note: this is the time of the last Update, not the download, and the timezone of the event not the user]
  • About these figures [links to help doc defined in T210896]

Event Timeline

jmatazzoni triaged this task as Medium priority.
jmatazzoni updated the task description. (Show Details)

@MusikAnimal, a question about the Pageviews, cumulative metric above:

This is a per-page breakout version of the Views to pages improved metric we defined for the the Event Summary reports (T205561, T206692). There, we said this metric would count pageviews “from creation until last data update.” But since these metrics are meant to provide some measure of impact, that really makes no sense for Pages Improved, since all the pageviews to the article prior to the event are irrelevant.

So how can make this metric more relevant? E.g., can we:

  • Count from the last edit made during the the event? Or
  • Count from the end of the event?

I like the first of those a little better, since the event may be ongoing at the time of the report. But either would be fine. Are they hard to do? Is one harder than the other??

Niharika removed the point value 2 for this task.Jan 15 2019, 6:12 AM
jmatazzoni renamed this task from Add 'Pages Improved' data to downloadable Wikitext report to Add 'Pages Improved' data to downloadable Wikitext report (release II).Jan 15 2019, 11:39 PM
jmatazzoni renamed this task from Add 'Pages Improved' data to downloadable Wikitext report (release II) to Add 'Pages Improved' data to downloadable Wikitext report .Jan 30 2019, 11:41 PM
jmatazzoni updated the task description. (Show Details)

Hmm, I found an inconsistency in the Avg. Daily Pageview numbers in the Pages Improved vs. Event Summary reports. To reproduce:

  • Download the Pages Improved csv for the event "At Least One of All Contribution Types" (In the Program joe's testing events).
  • Add up the Avg. Daily Pageviews number, only for en.wiki pages. As of 2019-03-28 18:13, that comes to 13,515.
  • Compare to the onscreen per-wiki breakdown for the same figure. The total is 12,937.

Is that a bug? I could understand if adding up all the individual page daily averages gives a somewhat different number from whatever method we use to calculate the aggregate daily average. But we're only talking about 12 pages, so a variance of almost 600 pages seems like a lot.

@MaxSem, @dom_walden you did what do you think?

(Note: I checked Bytes and Edits in the same way, and they were both internally consistent.)

@dom_walden, I proofed the Wikitext table against the spec and can confirm that the language and formatting are as specified. That leaves you to concentrate on checking the accuracy.

I also checked to make sure that the number of Pages Improved and the number of Wikidata items reported here are consistent with the numbers reported in the Summary report. (We've decided to include the Wikidata items in this report, since we dropped the originally planned Wikidata report.)

@MaxSem, @dom_walden you did what do you think?

It seems to consistently report higher averages then those on https://tools.wmflabs.org/pageviews/, on all the wikis, on both the csv and wikitext report. I haven't been able to work out what is going on.

Most of the testing of the accuracy of the figures has been done in the CSV report in T210775.

I took one event and compared the figures, line by line, between CSV and Wikitext. They matched.

jmatazzoni moved this task from Product sign-off to Done on the Community-Tech-Sprint board.

Just to see what would happen, I downloaded Wikitext for a 1200-page event. It worked just great! Resolving this. Thanks guys .