We just started using anaconda, rather than pip/virtualenv, to manage dependencies in the codebase for our data warehouse. The combination of pip and virtualenvs with requirements.txt files has served us well, but we switched because conda is more standard for analytics work, and because it’s by far the easiest way to…
At the end of 2015, which feels like many, many years ago, I wrote a post on the top comments of the year which started like this:
Around the end of the year, the data team gets a lot of requests from the editorial teams to pull which posts had the highest traffic that year. Usually, they’re looking to figure out which of the posts they wrote that year did the best - but there are always posts that were published in previous years that gain…
This is a lot late, but since I went to the Online News Association conference in Denver last month, one of the presentations has been on my mind.
Last week, Google AMP celebrated its first birthday. Gizmodo was included in Google’s list of AMP users, along with The Washington Post, Wired, Slate, plista and Relay Media.
Two weeks ago was the Online News Association’s 2016 Conference, at the Hyatt Regency Denver. I went to listen, learn, and see if there are any tips I can bring back to GMG.
Do you ever find yourself using the same formula, day in and day out, and think, “Wow, I wish Excel just had a function for this.” Turns out, you can create your own functions in Excel to do whatever you want (for the most part)!
This week, we got A/B testing working on our AMP pages. While we really like AMP, we had more trouble than I expected due to some rough edges and components of the AMP documentation that I think are slightly misleading, so I figured I would write down my experiences here.
A few weeks ago, one of my editors pointed out that Gawker’s traffic graphs on Quantcast looked less ‘spike-y’ and asked me if I had noticed. I pulled up a graph of our traffic over the last 2+ years and immediately saw what she was referring to.
Excel’s built-in conditional formatting options are great for a lot of use cases, but what if we wanted to highlight a whole row when one of it’s cells meets some criteria, instead of just highlighting the one cell? Or what if we want to highlight a cell only if the cell is greater than 10 AND the cell in column A…
It’s becoming clear that Airbnb completed a large removal of New York City listings right before releasing data to the press last year. However, the manipulation may have never been discovered if not for a real estate trade reporter following up on tips from hosts. But as one of the few people who saw the data, I want…
Gawker Media is excited to introduce our new email newsletters!
I started appreciating the wonders of conditional formatting when I was working in Ad Operations and in charge of a daily delivery report, which was basically a giant data dump on all currently live ad units. It was my job to parse through the data and figure out which units were at risk of underdelivering (and losing…
Most of us at Gawker Media are happy to say goodbye to this garbage year, but our community of commenters was as good as ever in 2015.
Here at Gawker, we’ve dabbled with A/B testing before, but 2015 was the first year we started taking testing seriously. A/B tests are now an integral part of our product workflow, helping us make smarter, better informed decisions.