Heya,
We spoke a little bit more about getting a queryable public interface for pageview data up and running and we decided the following:
1) Start importing webstatscollector pageview daily data for 2013 into mysql running on labs (not yet scheduled in a sprint)
2) Make simple datawarehouse schema for mysql db (based on the current webstatscollector datafiles)
Page Table ========== page_id page title
Fact Table ======== fact_id page_id (FK -> Page Table) pageview date pageview count bytes served
3) Collect more datapoints to determine how high of a priority mobile site article pageview counts are to decide whether we should add this to webstatscollector or not.
Best, Diederik