Gawker online dating spreadsheet
Jason Del Rey was a senior reporter covering technology, branding, and company culture for Inc. Before joining Inc., his work appeared in Newsday, The (Newark) Star-Ledger, and the Staten Island Advance, and on After weeks of digging through hundreds of gigabytes of information, Christian Rudder set out to tackle one of life's unanswered questions: Which smartphone users have the most sex?Rudder, the co-founder of Ok Cupid, a New York City-based dating site, regularly mines the company's database of customer profiles and surveys to find amusing trends like this particular smartphone statistic.
In the first post, Coyne wrote, "though we plan to discuss and manipulate user data on this blog, it will always be anonymized." Later, in a post about how to break the ice with other users, Rudder explained that sender and recipient information was removed during the data mining.Gizmodo, a technology blog owned by Gawker Media, has begun running some of Ok Cupid's posts.And Ok Cupid has been approached about possible content- and data-sharing projects by several companies, including Bundle, a new personal finance site.Over a two-week period, he runs calculations and identifies interesting statistics, then molds them into charts and graphs in Excel."I'm a long-term power user of Excel," Rudder says, "but it's probably not the easiest way." Other companies are taking notice of Ok Cupid's creative use of customer statistics.He found some startling trends when he studied how various traits of Ok Cupid members seemed to affect their interactions with potential mates.Last October, Rudder wrote a highly controversial post: "How Your Race Affects the Messages You Get." In the opening paragraph, Rudder wrote, "We've processed the messaging habits of over a million people and are about to basically prove that…racism is alive and well." The results included evidence that white men get more responses to their romantic missives than any other group.(Don't use physical compliments such as as a greeting.) Another offered statistics and advice on the best poses for profile photos.(Guys, look away from the camera; ladies, make a flirty face.) Hundreds of people commented on both posts."In addition," he wrote, "our sifting program looks at the content of messages only two or three words at a time..human has read any actual user messages." Every month, Ok Cupid's data scientist writes code to query the company's databases for relevant information.Rudder then dumps the findings into an Excel spreadsheet, which often includes as many as 30 columns and 500,000 rows of information.