All right. So I didn’t win Dan’s design challenge. Iain’s report and a number of others had both more information and more story than mine. But the contest has led to some more thinking and some action. Feeds All my feeds are now in Google Reader. Now I get stats. That led me to realize I read (scanned, processed, whatever) 1,128 posts last Friday. I’m averaging about 600 a day. That seems excessive especially considering that 90% are read between 9:00 PM and 11:00 PM. So I looked at the top feeds by number of posts per day and saw the top one was a Yahoo Pipes mashup of digg, del.icio.us, reddit, and Slashdot. It was something like 250+ posts a day. Way too much noise compared to real value. Cut it. I also dropped Gizomodo (12 posts a day) and am looking at pruning more feeds. Hopefully this isn’t coming across as a #11 on Pete’s list of common edtech blog posts. I’m not overloaded. I’m just looking to be a little more efficient and am using data to help me make those judgments. Annual Report I’ve been thinking about my submission for the annual report and realize I did a few things wrong. I liked what I did. It was pretty. However, it was really more about looking […]
flickr photo shared by Lynn Friedman under a Creative Commons ( BY-NC-ND ) license We’re still messing with manipulating data in Google Sheets. I hate to think of humans going through and manually parsing things that the machine should do so I’m putting all this out in the hopes of saving someone somewhere some time. It’s also meant to help our internal people see how it works so it might be more broadly applied. In this case, we’re just looking for a line break and using that to cut out a chunk of text. This Stack Overflow post gave me the char(10) piece so I could find the line break. You can see the details above and more on unicode characters here. It’s broken in two pieces for clarity. Piece one finds the number of characters prior to the line break. The second piece takes that number of letters from the left. I find manipulating text in spreadsheets to be a constant and practical use of algebra.
Because I love Alan. Here’s the API version in Google Script to grab YouTube stats. It does a bit more than the previous XPath version and you can set it to be triggered repeatedly. I’m going to add a loop to add multiple videos etc. in the near future but it’s a good start for anyone who’s doing research on stuff like this. It is funny what you might notice when you can see the data like this. I triggered it manually twice just to get a few lines in there. Notice that between the first two entries there are no additional views but a chunk more likes/dislikes. Makes me wonder if people are just weighing in without watching or if the data are collected differently resulting in some delay. Here’s the scriptIt took me a good while to realize I need to do the  piece to navigate the first element. My best friend is Logger.log(yourVariable) in Google Script. When I finally got methodical enough and used it to spit out the variable results at each level, I was able to figure it out. and it’s pretty well commented up. You’ll need an API key. 🙂 You do see some weird stuff in the raw JSON. Like there’s a Favorites field. Does that exist in YouTube? I didn’t really […]