SearchEngineLand.com Excel and Conditional Format

7
Jun
0

SearchEngineLand.com wrote a great article describing the technique of

Conditional Format(ting). MS Excel definition - A format, such as cell shading or font color, that Excel automatically applies to cells if a specified condition is true.

With this feature, you can analyze your data and highlight information in a specific way.

Here’s a small excerpt of the article:

Conditional Formatting is your best weapon against the paralyzing effects of having too much data to analyze. Basically, you can highlight individual cells based on criteria you set. One of the main ways we use Excel in-house is for optimization when looking through keyword performance reports. If a keyword is, say, over our CPA goal by 150%, the keyword’s cell automatically gets filled in with red, alerting us to that issue. Conversely, if a keyword is doing well, maybe 75% of the CPA goal desired, it gets highlighted in green to let us know there’s an opportunity there. conformat

Click here for the entire article

What are the social networking sites implications on search engine optimization?

6
Jun
0

One of my latest projects has been a new website about shopping online called BuyerDude.com. This website is relatively new, and thus has little traffic. My little experiment connects all social networks such as Twitter, Facebook, Digg, Yahoo Buzz, Technorati, YouNoodle, etc. and links them together. My hope is that by having friends in each one, those pages will rank highly and thus ranking the url for BuyerDude higher… I’ll let you know how it goes. This is from my promotion page on Buyer Dude.

1. Follow Buyer Dude on Twitter

2. Become a Fan of the Buyer Dude Page on Facebook

Check out BuyerDude.com on Facebook

3. Bookmark BuyerDude.com on Delicious

Buyer Dude's Favorite Links

4. Follow Buyer Dude on YouNoodle

Follow BuyerDude.com on You Noodle

5. Become a Fan of Buyer Dude on Digg

Follow BuyerDude.com on DIGG

6. Comment on Buyer Dude’s Wordpress Blog

Buyer Dude Blog at Wordpress

7. Buy Buyer Dude Apparel from our CafePress store

Buy Buyer Dude apparel from our CafePress.com Store

8. Post a link to BuyerDude.com on your blog or website!

9. Make BuyerDude.com your homepage or bookmark it in your browser!

10. Tell your friends!

Copyblogger’s Conversion Thoughts

4
Jun
0

CopyBlogger.com published a great article about the mindset of visitors and a few things marketers should consider when selling something online.

They answer the question “What makes people almost buy?”

  • Fear of wasting money
  • Fear of feeling stupid
  • How to kill the troll

Click here to read the entire article.

Increase your search engine position by buying text links

3
Jun
0

80%+ of searchers revise their search before going beyond page 1 in the search engines results (SERP) page. This means that if you want your website to be found you have to be on the first page. In order to get into this first page position you could buy text links from high page rank sites. By having these sites link to you, your website’s page rank will increase and so will your credibility in the search engine. Click the banner below if you’d be interested in a natural and search engine friendly text link from high page rank websites.

SEOmoz Tools

2
Jun
0
I’d like to give a shout out to the SEO professionals over at SEOmoz.org. They publish useful, relevant, and updated content on a daily basis and have valuable tools to help search engine marketers. For your convenience I’ve copied and pasted the links to all of their tools:

Linkscape

A professional quality inlink tool that uses patented SEOmoz metrics. Inlinks, anchor text distribution and more. Linkscape’s metrics are also available in the Site Intelligence Service API.

Trifecta FREE!

Trifecta

Measures metrics to estimate the relative popularity and importance of Page, Blog or Domain. Trifecta replaces SEOmoz’s Page Strength tool.

Term Target FREE!

Term Target

Helps determine how targeted a particular page is for a specified keyword by analyzing a variety of factors.

SEOmoz Firefox Toolbar FREE!

SEOmoz Firefox Toolbar

The power of Linkscape is now available inside Firefox with the SEOmoz Toolbar.

SEOmoz Labs

SEOmoz Labs

SEOmoz Labs is a place where our more adventurous PRO users can check out the bleeding edge of SEOmoz technology and product design.

Rank Tracker

Rank Tracker

Check, track, and monitor your rankings at all the major search engines, including Google, Yahoo! and Live.

Term Extractor Tool FREE!

Term Extractor

The term extractor tool analyzes the content of a given page and extracts the terms that appear to be targeted at search engines.

Crawl Test FREE!

Crawl Test

This tool helps quickly diagnose search engine crawling issues on your website - it examines title tags, http response codes, cache dates and presence in the search engine indexes.

GeoTargeting Detection Tool FREE!

GeoTargeting Detection

Discover how well your website is targeted to country specific search engines.

Keyword Difficulty

Keyword Difficulty

Used to analyze the competitive landscape of a particular keyword, this tool issues a percentage score and provides a detailed analysis of the top ranking sites at Google and Yahoo.

SEO Toolbox FREE!

SEO Toolbox

A collection of FREE Tools that will give you quick answers and aid in daily SEO activities.

The Juicy Link Finder is intended to find links that have authority - old domains with a high PageRank that rank well for the keyword you enter.

80% Of SEOs Said They Can Beat Wikipedia In Google, But can they?

1
Jun
0

SEORoundTable.com took a poll of their visitors about if they could beat Wikipedia in the Google results. They claim “yes, most SEOs believe they can beat Wikipedia’s listings in the Google results.”

But can they really? For keywords and keyword phrases having to do with commerce I would have to agree. If you’re selling something or it’s your own company listing, it wouldn’t be very hard to beat out Wikipedia. If it’s a single keyword that is strictly informational, it might be more difficult.

You can read the entire post here.

Google Wave

30
May
0

So this is my first post in the new redesign of Busines-to-Web.com so I’ll start off with some industry news.

  1. Google is releasing “Google Wave”, a social media tool to manage friends and information. Check out this movie for more info.
  2. In other news Microsoft is also releasing a new product in the form of a search engine they are naming Bing.Check out the video here.

Your New Website Story - Search Engine Optimization 101

24
Apr
0

Okay, so you’ve done all the work. It’s taken you a while but your shiny new website is finally online. You’ve put the finishing touches on it and are ready for some visitors. A day goes by and your analytics software shows nothing. That’s okay, just check where you’re at in Google. You’re not on the first page for your topic. No problem, second page is still good. Not there either? Third page. No. Fourth? Okay, type in the URL in Google. Not there? Surely you should show up for that.

You’ve now determined that Google isn’t finding your website. Easy, you have two choices. You can either submit your website URL to be indexed and after 6 or so months and you’ll show up… or you can find a site that is already indexed, get your link on it and when the search engine spider crawls that page it will follow the link to your site. You start emailing webmasters. You search “links page” in Google, look up the email address of the owner and compliment them and request a link exchange. After about 30 or 40 you get a reply. Great! The site has a Google Page Rank of 3. It’ll be indexed in the next week or so and Google will see your site.

Uh oh, what will Google see? You never realized that Google needs to be told what your website is about. But how do you do it? You need to focus on four main things. The Title Tag, the Description Tag, the Image Alt Tags, and finally the Body Content of your page.

  1. Title Tag – This is the tag in your html that looks like this… <title>This is where your title goes</title>. It tells search engines what your page is about and is what is going to be displayed on the search engines results page with a link to your site. It is important to include keywords about what the page is about. It should be 7-10 words.
  2. Description Tag – This is the tag in your html inside of your <head> and </head> tags which looks like this…. <META NAME=”description” CONTENT=”this is where your description goes”>. It is displayed under the title on the search engines results page and should hold important keywords about the page’s content.
  3. Image Alt Tags – These are html tags that should be added to every image on your website. They should describe what the image is to the search engines and should include important keywords.
  4. Body Content – Search engines love content and rank pages accordingly. If you build a website with fresh content that is updated continuously and includes many keywords related to what people will be searching for your site, you’ll do well.

Now you’ve optimized your Title, Description, and Image Alt tags and have written all about your products and/or services. You’ve included your keywords occasionally throughout the text and are ready for Google to see your pages. A week goes by and you do a search on your URL. You’re there! Now that you’ve done everything right you search one of your medium important keywords… and your #9. Well at least your on the first page, but how do you rank up?

To boost your website you need to become popular on the web. Every link pointing to your site counts as a vote and you need more votes that your competition. You search for more links pages, you search for related pages, you search through more links on those links pages. Next, you go to http://Del.icio.us, signup, and bookmark your site. You start creating content using blog services and http://Technorati.com it. You create and RSS feed for it. You http://Digg.com your story and try and get the word out. You email all your friends to go. Months go by and you’re constantly adding your website URL to everything online. You start writing press releases and distributing them for free on the internet with your URL tracing back to your website. You request links from everybody and build and build…

It’s been 6 months and you look at your analytics software. You’ve got a steady stream of visitors.

You keep your content fresh, don’t stop your link building campaign, make online partners… and it really starts to grow.

Error in my_thread_global_end(): 1 threads didn't exit