Everett
Level X4
Write the reason you're deleting this FAQ
I'm not sure if this discussion exists, but I am making it because I need some answers and need to rant/vent!
Okay you SEO gods, and goddesses, what do you do about competing with your competition when you know that your website is of more quality. When does the search engines decide to rank your website higher because your content is of far superior quality than your competition? When will your website get all the major search engine attention?
The problem:
I have a website, which i won't disclose, that is competing against another website in the same niche as my own. Their quality of services, and content is not as superior as my own, but I'm still ranking much lower with almost the same exact keywords, but a bit different. Their website has been around longer than mine but I started to rank my keywords before they decided to steal my own keywords and now they are ranking higher for them..
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19628' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='19628' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='2951' | 1 | SELECT * FROM seoclerks.members WHERE USERID='2951' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=2951 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=2951 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19628 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=19628
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19628' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='19628' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107412 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=107412
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107444 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=107444
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107691 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=107691
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=119685 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=119685
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19628' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19628' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='19628' AND status='1' AND (question like '%Competitors stealing keywords, ranking higher?! %' OR question like '%Competitors%' OR question like '%stealing%' OR question like '%keywords,%' OR question like '%ranking%' OR question like '%higher?!%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19628' AND status='1'
AND (question like '%Competitors stealing keywords, ranking higher?! %' OR question like '%Competitors%' OR question like '%stealing%' OR question like '%keywords,%' OR question like '%ranking%' OR question like '%higher?!%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='840' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='840' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='6509' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6509' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19628%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=19628%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
idealmike
Have you done competitor analysis on their site? Have you collected a list of all of their backlinks and tried to build them to your own site? Sometimes doing this alone can be enough to put you on par with that site and can surely help as well. Sometimes you may find it has links that you can't get right away so easily. I mean some you can build yourself, but others you may have to do a bit more legwork. Let's say they have some guest posts on some big sites. To get those you would have to contact the site owners of that site and ask to write a guest post for them as well. Or perhaps they have some footer links on a site that they're doing some kind of link exchange with. Those you wont be able to build yourself unless you contact the owners of that site and ask if they want to do link exchange with. Or perhaps they have paid for some links on some site. Again, you may have to contact the site owners of that site and ask if they will be willing to sell you links as well. Basically, do all you can do to build all the same kinds of links as they have.
Also look at their social count too. Check and run their site URL through social signal checkers and see how many shares, likes etc they have across Facebook, other social networking sites etc. Then try to add more to your site so that you have about the same amount or more than they do. Social signals play a large role in ranking positions today.
You'll have to do all of that. And try to keep building high quality backlinks from related sites in your niche. Use blog commenting and forum posting (commenting on blogs and joining forums in your niche and posting to them). Reach out to other sites and blogs in your niche and ask them if you can guest post for them. Also look into buying some kind of good SEO service on your site and never stop adding content and backlinks and new social signals to your new content and even your old content as well. This will all help in the long run!
Hope this helps. Ah, sounds like that competing site has one major factor going for it that yours doesn't. Age. Even though your site is better, has better, longer? content. That competing site has a lot more authority than your site because it has more age behind it. A massive ranking factor. Have you done competitor analysis on their site? Have you collected a list of all of their backlinks and tried to build them to your own site? Sometimes doing this alone can be enough to put you on par with that site and can surely help as well. Sometimes you may find it has links that you can't get right away so easily. I mean some you can build yourself, but others you may have to do a bit more legwork. Let's say they have some guest posts on some big sites. To get those you would have to contact the site owners of that site and ask to write a guest post for them as well. Or perhaps they have some footer links on a site that they're doing some kind of link exchange with. Those you wont be able to build yourself unless you contact the owners of that site and ask if they want to do link exchange with. Or perhaps they have paid for some links on some site. Again, you may have to contact the site owners of that site and ask if they will be willing to sell you links as well. Basically, do all you can do to build all the same kinds of links as they have. Also look at their social count too. Check and run their site URL through social signal checkers and see how many shares, likes etc they have across Facebook, other social networking sites etc. Then try to add more to your site so that you have about the same amount or more than they do. Social signals play a large role in ranking positions today. You'll have to do all of that. And try to keep building high quality backlinks from related sites in your niche. Use blog commenting and forum posting (commenting on blogs and joining forums in your niche and posting to them). Reach out to other sites and blogs in your niche and ask them if you can guest post for them. Also look into buying some kind of good SEO service on your site and never stop adding content and backlinks and new social signals to your new content and even your old content as well. This will all help in the long run! Hope this helps.
Are you sure you want to delete this post?