Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Chart Example

SELECT DATE_TRUNC('day',occurred_at), ...utorial.yammer_events GROUP BY 1 ORDER BY 1
Published Untitled Query

SELECT * FROM benn.stores
Published Stores

SELECT county, store, COUNT(*) FROM benn.stores GROUP BY 1,2
Published Percent of Announcements Making Top 3

Percent of funding announcements in the Crunchbase newsletter that make the the feature...
Published User Logins

Creating a bar chart to better understand your users.
Published Signup Funnels

Creating signup funnel analysis in Mode.
Published TechCrunch Stories

TechCrunch stories a day, from July 28 to Sept 21, 2014.
Published Rounds by Day of Week

Average number of announcements in the Crunchbase newsletter by the day of the week.
Published watisthis

SELECT COUNT(*) FROM stores
Published A/B Test Result - Days Engaged

A/B test result for days engaged for the publisher update.
Published Announcements by Day of Week by Round Type

Number of announcements in the Crunchbase newsletter by type and day
Published Funding in Top 3 Items

Average and median round sizes for funding announcements in the featured section of Cru...
Published Funding by Newsletter Position

Average and median round size by position in Crunchbase newsletter.
Published Funding by ORder

SELECT level_order, AVG(amount_raised)... NOT NULL ) a GROUP BY 1 ORDER BY 1
Published Funding by Day

SELECT DATE_TRUNC('week',date) AS week, ..._level = 'major_list' GROUP BY 1 ORDER BY 1
Published Newsletter Investor Order

SELECT i.investor, AVG(r.level_order) ... GROUP BY 1 HAVING COUNT(*) >= 5 ORDER BY 2
Published Raised Order and Level ORder

SELECT company, amount_raised, ...= 'dollar' AND amount_raised IS NOT NULL
Published Funding by DOW

SELECT EXTRACT('dow' FROM date) AS day, ...= 'dollar' ) a GROUP BY 1 ORDER BY 1
Published Dollar Pct

SELECT COUNT(CASE WHEN denomination = 'dollar...newsletters WHERE email_level = 'major_list'
Published Who is Commenting on Net Neutrality? - Congressional DistrictMap

Congressional Districts by Comments-per-Capita. Data sources: Bayes Impact (FCC comment...