Change Details

As an initial version of the sample content dataset, we want to have a dataset available in Superset to answer potential content related questions around US Election. - Last 12 months of data, daily granularity - Top 500 pages by page views over the past year (initially top 3 wikis by traffic from US: enwiki, zhwiki, eswiki) - Topics as an array (from joining with isaacj.article_topics_outlinks_2020_09 on wiki_db and pageid) - Page views (by access_method & agent_type) - Log-transformed proportion of total views (easier to store than a tiny decimal) - Edit count (by user_is_anonymous & user_is_bot) We can then write Presto queries to make it explorable datasources and create a dashboard in Superset

As an initial version of the sample content dataset, we want to have a dataset available in Superset to answer potential content related questions around US Election. - Last 12 months of data, daily granularity - Top 500 pages by page views over the past year (initially top 3 wikis by traffic from US: enwiki, zhwiki, eswiki) - Topics as an array (from joining with isaacj.article_topics_outlinks_2020_09 on wiki_db and pageid) - Page views (by access_method & agent_type) - Log-transformed proportion of total views (easier to store than a tiny decimal) - Edit count (by user_is_anonymous & user_is_bot) We can then write Presto queries to make it explorable datasources and create a dashboard in Superset with following information: - top articles daily/monthly with pageviews/edits topics by wikis - pageviews and edits for politics and society related topics by wikis

As an initial version of the sample content dataset, we want to have a dataset available in Superset to answer potential content related questions around US Election. - Last 12 months of data, daily granularity - Top 500 pages by page views over the past year (initially top 3 wikis by traffic from US: enwiki, zhwiki, eswiki) - Topics as an array (from joining with isaacj.article_topics_outlinks_2020_09 on wiki_db and pageid) - Page views (by access_method & agent_type) - Log-transformed proportion of total views (easier to store than a tiny decimal) - Edit count (by user_is_anonymous & user_is_bot) We can then write Presto queries to make it explorable datasources and create a dashboard in Superset with following information: - top articles daily/monthly with pageviews/edits topics by wikis - pageviews and edits for politics and society related topics by wikis