Making Search Funnel Reports Actionable

I’ve been messing around with the new Search Funnel Reports in AdWords trying to figure out how to use the data that it provides. Here are a few conclusions that I’ve come to that I think are actionable. Path Analysis Under Top Paths in the left hand column, drill down to “keyword path (clicks)” under […]

SEO Dashboard In Excel

I made a dashboard for tracking SEO in excel. The link to download it is at the bottom if you’re interested in playing around with it. I tried to make something that not only shows what the current state is at-a-glance, but also allows for discovering insights for diving deeper. There’s also a little section […]

Web Analytics Framework Example

Inspired by Avinash’s last post on ensuring a clear line of site with web metrics, I took a stab at creating a web analytics framework for a medium sized eCommerce site. This theoretical site is using the following marketing channels: paid search (brand and non-brand keywords), comparison shopping engines, affiliates, email, display advertising and social media […]

SEO Keyword Competition Tool In Excel

Here’s a little SEO tool built in Excel for getting an idea of how difficult a keyword will be to rank well in Google. It comes with a couple big caveats** but I think the overall idea works. Here’s how to use it: 1. Put your keyword choices in column A. 2. Use Google’s keyword […]

Data Driven Keyword Strategy

The search query report in AdWords provides a great way to expand your keywords in a data-driven way. There are a lot of keyword tools out there to help you discover which keywords you should be bidding on so that your keyword list is perfect right out of the gate. I like the approach of […]

Where The Web Is Heading

Where Mobile, Social, Local and Personal all intersect. That’s where the web the heading. One in five searches on Google is a local search. (That number goes way when the user is searching on a mobile phone). 17% off all time spent on the internet is on social networks. Up from 6% a year ago. […]