If you missed today’s webinar, “SEO: 50 tips in 50 minutes,” you can get the slides here: SEO: 50 tips in 50 minutes View more presentations from Ian Lurie And, if you don’t mind giving us your e-mail address (mwahahahahahahahaha) you can get the entire recording, here: http://webinar.portent.com/webinar-vid-request/ While the Portent team and myself may [...]

SEO, optimize thyself: Get more results for your effort
Yesterday I wrote about how effort does not equal results. Results are always better. Great results come from testing and tweaking your own routine. You can set up a virtuous cycle: You get more efficient, and have more time to learn more about your job, which helps you be more efficient, and so on. I’ve [...]
New content strategies tool: The Gramanator
Announcing a new tool: The Gramanator During my MozCon content creation session today, I announced a new tool: The Gramanator. It is mighty. It is the Gramanator: Bow down before it. What it does The Gramanator will take any public Google Reader Shared Feed and: Clean it up, removing stop words. Assemble all of the [...]

Ad Comparison Tool
A few weeks back, I wrote a guest post on PPC Hero about the Profit per Impression (PPI) metric. In the post, I talk about calculating PPI manually using an Excel Spreadsheet. To that end, I created a free spreadsheet to do just that: the Ad Comparison Tool! How does the Ad Comparison Tool work? [...]
Google Apps Script Tip #1: Finding the last row
I’ve been building some custom reports for Portent in Google Spreadsheets. They do fun stuff like grab Google Analytics data, insert data from other APIs and such. One thing that nearly drove me batty, though, was figuring out how to automatically add a new row below the last row with data. Turns out, Google App [...]
Can Quora drive traffic?
I’m addicted to Quora. There, I’ve said it. I know some folks have doubts. I love StackOverflow too. But something about Quora has me on there, all the time, answering questions. I do have an ulterior motive: If I can get on there and help lots of people out, I can build an audience. If [...]
Python code to grab KeywordDiscovery API data
If you use the KeywordDiscovery API, and Python, my pain is your gain. It took me a few hours to get this to work. You can grab it and go. Here’s the function, written in my usual Python Pigdin. I don’t recommend using it without a passing knowledge of Python, but that’s up to you: [...]
My first foray into sponsored tweets. FAIL.
Note that I am using ad.ly as part of this test. I am not saying ad.ly is bad. They have a great site, a nice toolset and make no promises. I am suggesting (spoiler alert) that sponsored tweets rank in profitability somewhere below hiring alchemists to try to turn lead into gold. Sometimes, I just [...]
Using fuzzy logic to redirect broken links: Geekery
One of the easiest ways to improve your link popularity is to fix old, busted links from other sites. For example: Say I have an online store. One product page is www.mysite.com/bike-tire/tubeless. A nice webmaster decides to link to that page, but uses www.mysite.com/bike/tubless. Because that link is incorrect, anyone going to the ‘tubless’ page [...]
22 Free Keyword Tools for PPC and SEO
It happens to the best of us, one day you’re plugging along and you realize, you need to expand your keyword list, you need more niches, you need to spend more or you need to make more. So what do you do? Try any one of these free keyword tools or create your own methods [...]

