Archive for June, 2010

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 (Facebook and Twitter).

I tried to figure out where each of those channels would fit into the what matters most diagram from Avinash’s post (I know I’m missing some so I left an empty space below each segment for additional ideas), and then those channel’s strategies, KPI’s and KPI Targets.

Click to Enlarge

I really enjoyed this exercise and get how effective this would be for any organization to get everyone on the same page. It gives the people at the top an accurate idea of what the site is really worth and it gives the analysts a direction to start doing segmented analysis to discover problems to fix what directly affect net income.

Download the Web Analytics Framework.

Comments (17)

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 tool to find the Local Monthly Searches (local means it gives you the results based on the specified location and language above the search button) for that keyword and paste those in column B.

3. Do a search for those keywords using the allintitle: operator and paste the amount of results into column C. Use the allintitle: operator so that you get a more accurate number of sites you’ll be competing with that use your keyword in their page title. Also put in a quote like this: allintitle:” so that it keeps your keyphrase together.

4. The spreadsheet is pre-formated to calculate the average popularity and competition of of those keywords once you do steps 1 -3 and will highlight in red the ones that are harder and green for the ones that are easier.

Download the SEO keyword competition tool in excel.

Let me know what you think!

*If one of the keywords is much more popular than the others it will skew the average quite a bit which all the other keywords are based on, so try using words that have similar popularity.

* The amount of search results for a given keyword is not the only factor for the competition of a keyword. The amount of backlinks to those pages is just as important, if not more so.

Comments (2)

Earning And Cultivating Attention On Top Of A Movement

The best marketing tactics I know of are 1. earning attention instead of buying it and 2. making stuff for your fans rather than finding fans for your stuff. Those tactics work even better when built on top of a movement. When the attention being earned is from people who identify themselves as part of that movement and want to be connected to other like-minded people. Then the brand works to become the connecting point.

My favorite part of this strategy is that it fits online perfectly, cost little and size of the business doesn’t matter.

Earning attention is about thinking of yourself as a publisher of helpful content related to a movement that people want rather than a marketer who is trying to interrupt. This content is then spread (if its good) throughout the group that identifies themselves as part of the movement and invites them to come back and sign up. Then the brand has the ability of delivering anticipated, personal and relevant messages to the people who want to get them. Repeat.

I’m going to write more about the different tactics of this strategy in upcoming posts so stay tuned.

Comments (2)

What I Would Do If I Was In A Band And Wanted To Make Money

I love music. I was in a short lived band once and still have: being in a touring band at the top of my do-before-I-die lists. I saw this info graphic that shows how little musicians earn online and then I read this article about how last week had the fewest number of albums sold in one week since Soundscan began compiling data in 1994, and it started me thinking about how I would do it if I were in a band that people cared about. So this is what I would do.

Disclaimer: Musicians don’t want to think of themselves as marketers or entrepreneurs but I believe that’s exactly what small musicians need to see themselves as to make money in this new digital world. I say, Get over it.

First, I would like to describe my strategy and then below I’ll put the tactics. The main trust of my strategy is sumed up well with this quote by Cory Doctorow, “It’s very hard to monetize fame, but impossible to monetize obscurity.” You’ll never sell anything if no one listens to you, so how do you get as many people as possible to listen to you? Share your music and get others to do the same. A fact of the internet is that If the product you make becomes digital, expect that the product you make will be copied. Let your music be copied and shared as much as possible.

The second side to this strategy is that once you can distribute something digitally, for free, it will spread as long as it’s good. If it spreads, you can use it as a vehicle to allow people to come back to you and register, to sign up, to give you permission to interact and to keep them in the loop. The spread of your digital music in an effort to create a well maintained following is the core of being a successful self-published musician.

The bands that create communities, connect people and spread ideas are the ones that will win. Seth Godin defines permission as an asset to be earned. “The ability (not the right, but the privilege) of delivering anticipated, personal and relevant messages to people who want to get them,” is his definition of permission marketing and that is the biggest tool in the independant musicians tool belt. Most good bands have a message that their fans rally behind: anti-war, fun, unity – whatever. Your band needs to seek out those groups that agree with your message and want to be connected – and then the band works to become the connecting point.

Let me tell you what this strategy is not: You are not trying to get discovered by some self claimed gatekeeper who decides what the masses get to listen to. I would never try to join a label. What’s the point? All the tools necessary to self publish and distribute to the world are there already at your fingertips.

Onto the tactics:
1. Sell whats scarce. Music as a digital product is anything but scarce. And you don’t want it to be, you want everyone possible to listen to your music. Meanwhile, the one thing that you can’t digitize and distribute with full fidelity is a live show, limited edition t-shirts, special edition album covers and community. This is where you’ll make money.

2. To sell that stuff, you need to find your audience. I would make a band blog where I would write about what’s going on with the band as well as writing on the topics that the band is founded upon. Also there would be a music section for people to stream any song I had written. Next to each song I would put the Facebook Like button so people could Like individual songs which gets the song sent to their news feed in Facebook for all their friends to see. This would also allow me to message any of those people who Liked a song later on. Also next to each song would be a link to Tweet the song, email the song, embed the song on their own site or any other kind of sharing possible.

A downloadable high quality version of my music would be available if the person gave me their email address. Along with the download I would include album art, liner notes and stencils for printing out and spray painting the band name or image. I would also include a message to invite the downloader to share the music with their friends. Next to the download button would be a donate button to anyone who wanted to chip something in for getting the music.

I would also make a Facebook fan page, twitter account and YouTube channel for my band where the content from the band blog would be syndicated. All of these different avenues allows people to consume my music in their preferred place. If they want to listen to my music on Facebook but hate Twitter, or vice versa, I would make it possible.

I would make a YouTube channel and make music videos for every song I record. They don’t need to be high production cost videos just whatever speaks to the fans.

I would make a flicker group for fans to upload images from shows or themselves being a part of the music.

3. Once you find your audience, turn them into family. Kevin Kelly says you really only need 1,000 true fans to make a living. Making music for your fans instead of finding fans for your music. All sharing tactics above have the same goal in mind – get as many people as possible to listen and then capture their email to create your fan database. The fans in the database are your biggest asset. I would turn my music into a subscription service. They are the ones you send anticipated, personal and relevant messages to. They get first dibs on listening to new music. They get alternate tracks. They get asked for their feedback and see that their feedback gets put into practice. They get to talk to each other on the blog. They get exclusive fan club stickers and patches. They also can buy tickets to shows before eveyone else, buy the limited-run t-shirts before everyone else and get first dibs on buying special edition delux albums.

The internet is the best thing to ever happen to music. In an age when it’s cheaper and easier than ever to design something, to make something, to bring something to market, bands win.

Comments (1)

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 trying out well thought out keywords first, and then using the data for making the decisions of how to refine your keyword list second.
Search Query Report
This is what I mean…

Make a tight group of specific keywords all in the same theme that don’t deviate too much. Your list may be only 5 or less words for one adgroup. Make them broad match.
So if you’re selling karaoke machines your adgroup may be, “iPod Karaoke” with keywords like “karaoke machine with ipod dock”, “ipod dock karaoke machine”, “ipod karaoke”, “karioke ipod”. Then once the adgroup has ran for a couple days run a search query report. This report will allow you to discover all the keyword variations that triggered your ads and give you lots of inspiration for expanding your campaign with more adgroups and keywords, as well as all the keywords that you don’t want your ads showing up for which you can add as negatives. So with your search query report you may discover lots of searches for “portable karaoke machines”, “karaoke systems”, “black karaoke ipod system” and “karaoke modules under $25.99″ which would all make for great new adgroups with targeted adtext and landing pages.

Not only will this keyword strategy give you ideas of how to expand your keywords, it will also give you insight into how much these new keywords will cost if you started to bid on them seeing how you can see their avg. cpc in the report. You may stumble upon a few words that fit just right and are cheap.

Instead of engaging in the never ending quest of discovering the perfert keywords before you launch, give this keyword strategy a try and choose the keywords that that your visitors actually use supported by the data.

Leave a Comment