Google Sheets

How Many Articles Can I Peruse in a Workday?

how many articles can i read in a dayAnd Can I Finish This Blog Post Before My Fiance Goes to Bed?

It seriously freaks me out when my fiance goes to bed before me. I have no idea why. He's just going to the next room and won't even completely close the day because the cat needs to be able to go in and out. But, I can't stand the notion of him asleep before me, with all of the lights out in the rest of the apartment. It's too much. I don't like it. When he shuts the light off by desk and I hear that 'click,' I start winding down as quickly as possible (not the right way to wind down, I know) so I can go to bed as soon as I can. It just feels late when he goes to bed before me and it feels like a sign I just shouldn't be up too much longer or else bad things will happen.

Anyway... Articles!

So, my first step to hustling is to get a record outside of our app and CMS of every article that we cover. We easily cover 400 stories a day: 20 to 30 stories per vertical plus another 100 or so for top news. No, I'm not going to read all 400 of those articles each day. That's not possible. But, a Google Sheet for each vertical with an easy glance at that day's 20 or 30 stories is much more digestible. With an easy glance of the source link and the description, I can pick out a couple of stories that look extra interesting or that look like they may have excellent facts, quotes or statistics that would make great social media content.

To build social media communities and, ultimately, fuel growth and get installs, our channels needs to present more online than what we're doing now. Our Twitter handles need to offer more than the lede sentence and the link to the update. The main handle needs to do more than tweet a lede and the original source link with the author tagged. All of that content is great, but because it's not much different from what's offered in the apps, there's little value in both downloading the app(s) and in following us on social media. Sure, someone may miss the story on the app and then catch on Twitter, or vice versa, but even that's kind of a poor value proposition. A major factor in making social media work for you is to have content tailored to the platform, where even though we're sharing the same story across Facebook, Twitter on our app, it should not look identical across the three platforms.

Separate Content for Our Newsletter

With the stories in a Google Sheet, I can avoid looking at the updates directly to have a fresh interpretation of the articles. A fresh interpretation is needed for our upcoming newsletter, although I do not know exactly the contents of this newsletter. I sent a survey to our mailing list since we haven't emailed them in over a year (hey, it wasn't my list to begin with, so I didn't have any idea who was on this list or why they were there). This survey asked how often they'd like the newsletter, what they would like it in and why they signed up in the first place. From the responses I've received, it's looking like this will be a weekly email that features summaries of our top stories. To be able to put such a newsletter together, I need to know everything we've covered for the week and then decide our top drones story, our top video games and a couple of our top breaking stories etc.

Getting this done shouldn't be a problem. The next step now is learning first-hand how many articles I can peruse in a given amount of time. Today, I'm going to give myself one hour and see how many articles I can get through. The day afterward, I may do 90 minutes or two hours, depending on my schedule and how well today goes. The goal is to see if this is a viable solution to a) finding great social media content in the stories we already cover and b) useful in finding ideas to cover for the upcoming newsletter.

If it doesn't work, then I'm not sure what I would do. At the moment, I need to be able to do this on my own.

Is The Doc Filled with News or Noise?

news or noise, determining news over noise,
news or noise, determining news over noise,

At work, the editorial team and I used to have a document called, well, "The Doc." The Doc was a Google Sheet where we placed all the stories we intended to cover and we simply went through the stories in order. We broke the order if an important story broke that needed to get into the app and into Top News right away, but besides that we went in chronological order. Stories first on the doc were first in the app, and we did our best to ensure that we placed stories on a wide variety of topics and from a wide variety of sources on the doc. It doesn't look good in the feed when there are too many stories in a row from one source or on one topic and we don't want to come across as an app that favors certain topics or sources.

Filling the Doc Was My Favorite Thing to Do

I thoroughly enjoyed "filling the doc," as the task was called when The Doc needed to be refilled and I was good at it. I could easily find 30 stories in 30 minutes for the doc, maybe more. One way I was able to do this was that, at all times, I was fully aware of 90 percent of the stories we covered in the past 24 hours. The knowledge meant I didn't have to spend as much time checking for duplicates, since I just knew whether or not we had the story. The only time I would check for a duplicate was if the story I found was an update to a previous story or is part of a developing story. With developing and ongoing stories, it's much harder to keep everything straight versus a one-time story. Another tactic that made me so efficient was that I utilized Google News to find stories from credible sources on specific topics. I would search terms like, "North Korea," "marijuana," "sex" and "space" to find stories on those particular topics. Using Google News in this fashion was much better way than searching Twitter or following specific hashtags to find stories on these specific topics.

I loved "filling the doc." I loved encountering all sorts of different stories on all sorts of different topics. It certainly helped that I was pretty good at it too. It was especially thrilling to find a "gem," an interesting, well-written and/or very important story that hadn't yet become a big deal or that wasn't being covered by other/more mainstream outlets. Two "gems" that I personally found were the Ice Bucket Challenge and the first photos of Officer Darren Wilson in the aftermath of the Michael Brown shooting. I ended up on the Ice Bucket Challenge early because Michelle Wie was one of the first celebrities to participate in the challenge, and since I'm originally from Hawaii, I care about everything Michelle Wie. I wish I could claim being on Michael Brown story before it turned into Ferguson and the subsequent movement, but I really don't recall coming across the story. The Darren Wilson photos I remember, since it took several days for the Ferguson Police Department to release his name, and photos were only uncovered on Facebook after the public had his name confirmed.

I Want to Bring This Back Somehow

I'm not quite sure how to bring back The Doc and in what capacity, but I think there is value in finding so many stories in such a short amount of time (more so than the fact that I enjoy the task). Part of that value is finding the "gems" before those stories become part of the mainstream conversation. Another part of the value is finding stories that wouldn't have become part of any conversation or wouldn't have come to the surface for exposure without The Doc and spending the time to find all sorts of stories. Typically, news sites showcase stories according to the same categories: World, U.S., Politics, Local, Weather, Business, Entertainment, Sports, Tech, Arts, Health, Science etc. Maybe Food, maybe Travel, maybe Cars, maybe Lifestyle to encompass several of the topics previously mentioned.

All news stories worth covering must fall into those categories. Very rarely is the Sports category segmented into football, baseball, basketball etc. unless you're a sports publication like ESPN, for example. Otherwise, it just gets filed under Sports. Only so many Sports stories can be covered or featured in a day. Because there are limits to everyone's time and attention regarding the number of stories to read and feature, only the most popular sports are going to be featured unless something really big, incredible or viral happens in a sport like lacrosse, climbing, rugby, ultimate frisbee etc, like rugby war goddess Georgia Page. Her bloody nose is awesome for a day, but the next time anyone is covering women's rugby and encouraging women to play the sport (which is what Page wants out of all of the media hype and exposure) is probably the next time another woman breaks her nose during an impressive tackle.

Let's Talk about What's Not Being Talked About Because Much of It is Probably Important or Interesting

Rugby is important and interesting to someone, and those someones aren't just people in the United Kingdom where rugby is a much more popular sport. Topics like design, books, social media, education, the environment, architecture and more don't have to be reserved for niche publications, in my opinion. There are plenty of stories that are worth discussing, worth knowing about and worth sharing in these topics. It seems like many topics only become important or only get covered when it easily comes with a salacious headline or an eye-catching photo or video.

Overall, news should be what you make of it and what you find important or interesting, not what the local television news says or what the mainstream media decides to cover or to air on primetime. It's only when the time is spent to scour the interwebs for those sorts of stories that the conversation can start on topics we don't normally talk about, for whatever reason.