Add basic stats page

[gammaw]

Stats page to include:

Project-level:

• Overall # of original article
  • Label: "EM GUIDE's total number of original articles";
• Overall # of shared article (note: same content may be shared by multiple magazines!);
  • = # of SharedURL entries
  • Label: "EM GUIDE's total number of shared articles";
• Monthly breakdown for original;
• NEW: monthly breakdown for shared;
  • "Shared articles per month";
  • "Shared articles per magazine";

Magazine-level (selectable or print all):

• Overall # of mag's (origin's) original article;
  • Label: "Magazine's total number of "own" articles";
• Overall # of mag's (origin's) shared article (this magazine shares from others);
  • Overall + per magazine breakdown;
  • Label: "Magazine's total number of shared "remote" articles" (overall);
  • Label: "Magazine's total number of shared "remote" articles per other magazine" (mag breakdown);
• Overall # of other mags sharing from this magazine (note: same content may be shared by multiple magazines!);
  • Overall + per magazine breakdown;
  • Label: "Total number of sharing of magazine's "own" articles" (overall);
  • Label: "Per other magazine total number of sharing of magazine's "own" articles" (mag breakdown);
• Overall # original (of this mag) content shared by at least one other mag;
  • Label: "Magazine's total number of "own" articles shared by at least one other magazine" (overall);
• Monthly breakdown for all metrics;
• NEW: monthly breakdown for shared;
  • "Shared articles per month";

Additional feature(s):

• CSV export (all project-level and magazine-level data in one export)

Workaround: SQL statements

[gammaw]

Monthly breakdown for all metrics (OPTIONAL);

@revnandi how about this?

• Only for original articles (rationale: we don't have the timestamps for shared URLs)
• Add timestamp for shared URL field

[gammaw]

The layout could be something like this (label + "Counter" static string):

[gammaw]

@revnandi minor change requests:

• Descending sorting on COUNTER column in tables;
• Only count PUBLISHED articles for as Original;
• Count ALL SharedURL (even if it is of an Unpublished article).