Posts from Weblogs

Feature Friday: Embedding Spreadsheets In WordPress

So yesterday morning was a bit nuts. I decided to flush out some thoughts on valuations that I had talked about on stage at LeWeb. I started writing a post that would become this. I started building a spreadsheet that would become this.

I had an 8:30am breakfast and as it got closer and closer to 8am, I realized I was screwed. I had cut and pasted certain rows from the google sheet into my post and they were not fitting properly on the screen. As I played around with the underlying code, it just got worse. I was digging myself into a hole.

So at 8:10am, I made a decision. I wrote a note to everyone that the post was messed up, jumped into the shower, and got to my breakfast about 5mins late.

When I got to the office after my breakfast, I learned that a meeting I had in my calendar was not happening. Oh happy day. I love when that happens.

So I googled for a wordpress plugin that allows the embedding of google sheets and found this one.

It is called Inline Google Spreadsheet Viewer and it gives you a wordpress shortcode that looks like this:

gdoc key

If you want to embed a google sheet in a blog post, you install the plugin, you insert that shortcode, and you put the URL of the public/open google sheet into the ” ” and that’s it.

What I could not figure out how to do was to embed different tabs from the same sheet, so I ended up creating four different sheets and embedding each one separately.

But it all worked out fine. Within ten minutes I had cleaned up my post and put that to bed. Had I known about this plugin when I started the post around 7:30am, I could have easily polished the whole thing off and even had time to shave in the shower. Fortunately, it takes days for my beard to show up :)

AVC’s Creative Commons License

I get asked to write stuff for other publications all the time. I tell them that I don’t write anywhere other than AVC.com, but if they have an idea for something they’d like me to write about, they should suggest it, and I might write about it here.

All of the content that is published at AVC can be reposted without my permission anywhere that is not commingled with hate, porn, or spam. All I require is attribution and a link back to the original post here at AVC. That is my creative commons license. I used to have a link to this creative commons license at the bottom of the page on AVC but we lost it in the redesign. I suppose I should get it back on there.

So if you would like me to write something for your publication, send me an email, I might write about it here, and then you can repost it on your publication.

Comments Are Dead, Long Live Comments

Yet another mainstream media site took down comments this week. In the post explaining the move, Walt Mossberg and Kara Swisher explained that “as social media has continued its robust growth, the bulk of discussion of our stories is increasingly taking place there, making onsite comments less and less used and less and less useful.”

That led to a fair bit of discussion around the notion that “commenting is dead.” And like many things that are “dead”, the truth is that they are flourishing elsewhere.

Just this week we had a post here at AVC with 880 comments, which is not a record but is damn close to one. Commenting activity has been fairly steady here at AVC over the past two years with comments down a bit and voting on comments up a bit:

comment history comment history

But let’s look elsewhere on the web.

Let’s take Reddit where comments are the center of activity. They are growing faster than pretty much any site out there and are now #38 globally and #10 in the US according to Alexa. And the time spent on site is a whopping 17mins.

reddit

 

Let’s look at Buzzfeed, another super fast growing content site. Buzzfeed uses Facebook comments as they drive a lot of traffic from Facebook to Buzzfeed. But the comment activity at Buzzfeed is strong and some posts, like this one, get over 1000 comments. Buzzfeed is a top 30 site in the US and is a top 100 site globally.

buzzfeed

 

Here are some stats from Disqus, a USV portfolio company that powers the comments here at AVC (from their about page):

– 20 million comments a month

– 80 million votes on comments a month

– 1 bn visits to disqus comments a month

– 2mm new commenter sign ups a month

And although they don’t show trends on their about page (they should), all of these numbers are up and to the right year after year after year.

Commenting is alive and well on the web and mobile. It’s just dead on sites that would prefer to have the conversation happen elsewhere. AVC is not one of those places, and even though I sometimes find the discussions hard to take here, I am committed to making this a two way experience for everyone who wants it to be.

Tipping Tuesday

One of the most promising use cases for Bitcoin is micropayments. And one of the most promising use cases for micropayments is funding content. There are two primary ideas for how to do this with micropayments.

1) A paywall that requires a tiny micropayment to read something (like a penny or less).

2) A tip mechanism. Think of a facebook like or a twitter star with money attached.

We are testing out the latter on AVC starting today. Our portfolio company Coinbase launched a tip button today.

You will notice a tip icon at the bottom of this post (and every post at AVC). If you click on that tip icon, you will see this dialog box:

coinbase popup

For those that don’t know, CSNYC is a non-profit I helped to start that is bringing computer science education to the NYC public school system. They will be the beneficiary of all tipping here at AVC.

300 “bits” is 0.0003 bitcoin, or roughy 10 cents. If you are logged into Coinbase on the web or on your phone, you will see the option to use Coinbase wallet to send the money. If you are not, you can type in a bitcoin wallet address and send the money. If you enable one click tip, you will send 300 bits every time you click on the tip button. You can also do this on William’s blog.

Since not all AVC readers have Coinbase wallets or own Bitcoin, we are doing a Bitcoin giveaway today on AVC to jumpstart the bitcoin tipping thing. We will give away $10 in bitcoin to the first 200 people to raise their hands, virtually, for this giveaway.

Here’s how the AVC Bitcoin Giveaway works:

2.) Receive an email back from Coinbase to “claim $10 worth of free bitcoin”
3.) Create a Coinbase account with that link
4.) Receive funds

Please don’t send that email if you don’t think you will go through this entire flow as you’ll be taking one of the 200 spots.

I think that’s all there is to say about this right now. Let’s see how this goes. Should be an interesting experiment. Here are some other blogs you can tip at today:

Getting Feedback and Listening To It

When you are VC, you live in this protected environment. You sit in your office in a glass conference room with lovely views and entrepreneurs walk in and pitch you and you get to decide who you are going to back and who you are not. People tell you what they think you want to hear. That you are so smart. That you are so successful. They suck up to you. And it goes to your head. You believe it. I am so smart. I am so successful.

You have to get out of that mindset because it is toxic. My number one secret is the Gotham Gal who brings me down to earth every night, makes me do the dishes, walk the dog, and lose to her in backgammon. Actually I have not lost to her in backgammon in over twenty years because she used to beat me so badly that I couldn’t take it anymore.

But blogging is another helpful tool in reminding yourself that you are not all that. Marc Andreessen said as much in his excellent NY Magazine interview which was published yesterday. I loved the whole interview but I particularly loved this bit:

So how do you, Marc Andreessen, make sure that you are hearing honest feedback?

Every morning, I wake up and several dozen people have explained to me in detail how I’m an idiot on Twitter, which is actually fairly helpful.

Do they ever convince you?

They definitely keep me on my toes, and we’ll see if they’re able to convince me. I mean, part of it is, I love arguing.

No, really?

The big thing about Twitter for me is it’s just more people to argue with.

Keeping someone on his or her toes, making them rethink their beliefs, making them argue them, is as Marc says “fairly helpful.” That’s an understatement. It is very very helpful.

That’s the thing I love about the comments here at AVC. I appreciate the folks who call bullshit on me. There are many but Brandon, Andy, and Larry are common naysayers. They may come across as argumentative, but arguing is, as Marc points out, useful.

The comments are also a place where people play the suck up game. It isn’t necessary to do that and I don’t appreciate it. It makes me uneasy.

So I would like to thank the entire AVC community for being a sounding board for my ideas, for pushing back when I am off base, and for resisting the suck up whenever the urge presents itself. I appreciate it very much.

Search Vs Social

Back in 2008 and 2009, probably because of our investment in Twitter, I was obsessed with looking at acquisition traffic from search and social and comparing the two. Here’s an example of a post I wrote at that time looking at the two channels and comparing them.

At some point, I became convinced that websites would eventually see more acquisition traffic coming from social than they were seeing from search, which was the king dog of Internet traffic at the time. It was a hotly debated issue but, again maybe because of how long we were on Twitter, I was convinced social would be king some day.

I stopped obsessing about that issue sometime around 2010 and moved on to mobile as the thing I thought about and wrote about the most.

But today, when I was looking to see if the traffic to AVC had declined a lot while I have been away and blogging about all sorts of non work stuff (it hasn’t), I saw this chart of year to date acquisition traffic to AVC.

acquisition channels

Social, and for AVC that means Twitter and Disqus, brings 23% of the visits to AVC. Search brings less than 20%. And it’s been that way for a long time now. Well over three years.

It’s kind of funny to think that we wondered and debated about such things back in 2008 and 2009. It’s not a debate any more and its not something to wonder about. It’s reality now.

Reblogging

So we are heading off for four weeks in Europe this evening. I’m going to start reblogging a lot of older stuff as a way to keep AVC fresh while I’m not posting every day.

So I thought about what posts would be the most worthwhile to dust off and bring back. I went to Google Analytics and looked at data from the past two years to see what posts that are older than that (ie written before August 2012) got the most traffic during that time.

It’s an interesting list. There’s a lot of MBA Mondays content in there, particularly around employee equity and valuation questions. And there are a few really popular guest posts, like this one from Fake Grimlock. And there are a few classics like this one.

I am going to queue up a bunch of them to autopost over the next few days while I figure out what my blogging routine is or isn’t going to be in Europe.

I’m curious to get everyone’s suggestions on this. I’ve written over 6,500 posts at AVC so I can’t just wade through them to find the best ones. I need some sort of algorithm. Another that comes to mind is most commented. I’ll take a look at that later today. Any other ideas for surfacing the best stuff to reblog?

The Personal Blog

There’s a bit of a renaissance of real personal blogging here in NYC. Two of the original NYC bloggers have, after years of writing professionally and editing others, returned to their own blogs.

It started with Lockhart Steele, the founder of Curbed, Racked, and Eater, who started that media business on his personal blog.

Then the next day, Elizabeth Spiers, the founding editor/blogger at Gawker, dusted off her blog and started writing on it again.

It feels so good to link to both of them.

There was a comment on Elizabeth’s kickoff post that suggested she go to Medium. She replied:

I already write for (and on) Medium. My most recent piece is here. But I don’t think it’s quite the same thing as maintaining a personal blog, where you control all of the visual elements and maintain a custom URL.

I wanted to reply to that comment, but could not for the life of me, log into WordPress to leave it. So I’ll blog about it instead.

There is something about the personal blog, yourname.com, where you control everything and get to do whatever the hell pleases you. There is something about linking to one of those blogs and then saying something. It’s like having a conversation in public with each other. This is how blogging was in the early days. And this is how blogging is today, if you want it to be.

When I started blogging here at AVC, I would write about everything and anything. Then, slowly but surely, it became all about tech and startups and VC. It is still pretty much that way, but I feel like I’m heading back a bit to the personal blog where I can talk about anything that I care about.

Today, that thing is the fact that the Gotham Gal and I are taking our youngest child, Josh, to college. As my friend Bob told me over email last week about sending his son off:

I am surprisingly emotional at least to me ……….. Sending Josh off as your last must be something.

Yeah, it is something. I’ll miss him a lot.

Trolling

The New York Times has a post on Trolls and Trolling today. It cites an academic named Whitney Phillips who has written a book about Trolls.

Whitney says “As long as the Internet keeps operating according to a click-based economy, trolls will maybe not win, but they will always be present.”

We’ve had our fair share of Trolls here at AVC over the years. They are most notable whenever I write something negative about Apple.

But we also get them on posts that are more personal in nature.

Yesterday I got a Kik from William who helps me moderate AVC.

trolls

The comment in question was a tasteless comment about the Gotham Gal. William deleted it as I would have.

Had it been a tasteless comment about me, I would more likely have let it stand as I’m inclined to let everyone see how warped these trolls are.

I think Whitney is right that we are unlikely to have an open Internet without trolls. They are annoying, as is comment spam and many other things, but I’d rather have an open forum where anyone can comment, than close things down and lose all that comes from the freedom to say and do what you want.

Trolls are annoying but I am certainly happy to live with them given the alternatives.

A Comment About Comment Spam

The AVC blog has been hit with a rash of comment spam in the past several weeks. Every day we take down at least five or ten of these annoying things. And some days, we take down a lot more.

The “we” is me, William, and Shana. I really appreciate their help with this chore. They’ve been helping me moderate and manage the comments here at AVC for several years now. It’s an unpaid and mostly unnoticed job. I really appreciate their help on it.

I honestly don’t understand why these spammers do this. The Disqus system has its own filters and very little of it actually gets through and into the comments. And the stuff that does get through gets taken down by us.

These past few weeks has been particularly bad. I am not sure if the problem is an increase in spam attacks or some sort of change in the Disqus filters. But whatever is causing the increase in spam, it’s pissing me off.

If you leave comments here regularly, you will certainly have experienced getting a reply that is spam. So you know how I feel about this stuff.

One of the many reasons I moved away from Typepad comments and to Disqus back in 2007 was to manage comment spam. I could not manage it on Typepad and the old AVC comments were full of the stuff. That’s why I left all of those old comments behind on Typepad when I moved to WordPress. I am not going to let that happen again.

The fight against The Internet Axis Of Evil never stops but it does change. When I wrote that post a decade ago, it was mostly about email spam and viruses. I don’t think so much about those scourges now. We’ve moved on to getting hacked and DDOS’ed and worse. The good thing about the Internet is you can do what you want on it. The bad thing about the Internet is you can do what you want on it.

So if you’ve noticed an increase in comment spam recently, you are correct in your observation. We are taking it down as fast as it comes in. Maybe the spammers will move on to somewhere more fruitful for them. Or maybe Disqus will tighten their filters a bit. Either way, we are going to keep this bar clean of that stuff. I promise you that.