Understanding Anchor Text
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 48 and date > date_sub(now(),interval 600 minute)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'text anchor page ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (48,'text anchor page user seo website web information term design blog why click content link links linked site value prime ','text anchor understanding ') on duplicate key update date = now(), body = 'text anchor page user seo website web information term design blog why click content link links linked site value prime ', title = 'text anchor understanding '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 48 and ID != 0
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 48
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 48
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'text anchor page ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (48,'text anchor page user seo website web information term design blog why click content link links linked site value prime ','text anchor understanding ') on duplicate key update date = now(), body = 'text anchor page user seo website web information term design blog why click content link links linked site value prime ', title = 'text anchor understanding '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 48
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 48
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'text anchor page ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (48,'text anchor page user seo website web information term design blog why click content link links linked site value prime ','text anchor understanding ') on duplicate key update date = now(), body = 'text anchor page user seo website web information term design blog why click content link links linked site value prime ', title = 'text anchor understanding '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 48
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now()' at line 15]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 48, ID, (0+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 48 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 48 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '48') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page')
group by id
having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (48,0,0)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_I]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_ID = 48 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
When people ask me for one thing to help their SEO, I say page titles as they are the most changeable element that is often underutilized … and then I also inform them that SEO is a process combining many elements, not just one or two fixes so they realize that by adding page titles their traffic will not sky rocket.
I then point out that if they want to improve their web site’s usability (ease of use) as well as their SEO then take a look at their anchor text. That usually results in a "huh?" look on their face.
So if your new to the term anchor text, below is a simple definition.
- Anchor text is the visible, clickable text in a hyperlink on a web page. An example is easily shown as: this is anchor text.
How does anchor text benefit the user of a website?
Links provide the user the route to learn/read/view more information or data on that item linked. Above I linked the text "this is anchor text" to Wikipedia’s page on anchor text to give you, my reader more information on it. For a small business website, this link can direct users to a page that elaborates more on those terms, service or product. As a user is reading your content, you allow them to click into areas to get more information on what has caught there attention.
I get asked this a lot: Why link the text in your content area if your navigation is already linking to this page?
It’s not redundant to link the term or text in your content to appropriate areas of your site. You are making it EASIER for your user to learn more on something right as they see the term and it’s linked. Why make their eye’s redirect up to your nav to get there. they see the term they are most interested in, let them click to get more information now!
How does anchor text benefit your SEO?
Search algorithms place more importance on words/text appearing in links. Why? Because if you are going to elaborate, provide a page in your website with info on just that topic, or cite other sources (other website pages), then the search engines reward that. It brings more focus to the page and is of more value to the user … and the engines want to make users happy with their results (SERPs).
In another post I’ll address how anchor text in the links pointing to your site from other sites have great effect on your SEO, but lets get this mastered on your own site first.
Correctly using anchor text.
So now that you’re getting the basics and understanding the value, lets make sure you are linking correctly. Below are two sentences, both get the user to the same page within the Prime website, but the first example provides the anchor text value we are looking for.
Good: Prime Advertising & Design is a Minnesota web design firm.
Bad: Prime Advertising & Design is a Minnesota web design firm. Click for more
There are many great blog posts on anchor text by other blogs and here are a few I recommend reading to strengthen your anchor text knowledge:
- Anchor Text Matters from Quart Mountains Blog covering online marketing
- Anchor Your Text from Blog-Op on optimization
- Anchor Text and Blog Effects on Low Competition SEO Markets for terms like an Arizona Pool Builder
No related posts.
Posted on April 19th, 2007 by Jeff Wagner
Filed under: content, seo, small business, web design
If you like what you're reading, please subscribe to this blog.
Many thanks for the link.
Thanks for linking through, Aaron. Great looking site you have here.
Your welcome guys, I enjoyed your posts. Kevin, yours was the one that pushed me to post on this, so thank you especially. Yours was well thought out … as are many of your posts.