TommyCarey
Level X3
Write the reason you're deleting this FAQ
When you're investing loads of time into your website you sometimes get pretty biased. You may not be able to critisize your own website since you're the one doing all of the work and it would be you critiquing yourself on what you messed up. You would need to see your website in the eyes of your users and also the way Google sees your pages in order to get a good understanding of how Google will overall evaluate your website.
Some of you are saying "If I'm worried about how Google sees my website why should I be concerned what my users think?". You should be worried about what your users see because Google factors their opinions into your rankings. If your website is just optimized for the search engines and not user friendly, then you won't see much love from the search engines.
You can actually get help from your friends and family who are not into website design and optimization to see what they think would need to be fixed. If it's just cosmetic then it's not a huge problem, but if it messed up on their browser or smartphone, then you may have to go back into the code and fix a lot more to please everyone. It's better to get all of this ironed out prior to launching or spending a lot of money on marketing so that you can have quicker success.
A few things to do
Sitemap - One of the first things you should always do is set up your sitemap in order to help index all your pages when the googlebot comes to your page, and it will, to crawl your pages and index them within the Google search results. Sitemaps will list all of the pages you created and let the googlebot easily crawl everything quickly. Not having a sitemap means it could take much longer for Google and your users to find your pages, which isn't a great thing in the long run.
Robots.txt - You'll need to set up a robots.txt file in order to let the search engines know what to look at and what not to index. Anything that you have blocked in your robots.txt file will not be shown within the search engine results. Most website owners will add their contact page, TOS, Privacy, and other basic information pages within their robots.txt file.
Quality Content - Adding loads of quality content will help get your website seen a lot by Google and the other search engines. Just be sure to have optimized and high quality content in order to rank well for specific terms. Ranking for these keywords will send you traffic, but only if you are doing everything right in the eyes of the search engines lol. If your website isn't seen well when google or the other search engines spider it, you won't get ranked well even with great content. By adding fresh quality content you're increasing the chances of being loved by Google.
In Conclusion:
You'll need to step back and take a real look at your website. If your pages are a little off and you can't figure out why, don't be afraid to ask for some help from a friend or family member to see what they think. You need to be dilligent when it comes to keep your website fresh with quality content and making sure that everything is up to the standards of Google and the other search engines.
Remember to follow me 
https://www.seoclerks.com/user/Razzy
Thanks!
Razzy
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?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| 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='22366' | 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='22366' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='19821' | 1 | SELECT * FROM seoclerks.members WHERE USERID='19821' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=19821 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821 | /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=22366 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=22366
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22366' 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='22366' 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=117196 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=117196
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=117242 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=117242
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=143332 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=143332
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=152320 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=152320
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=157271 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=157271
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22366' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22366' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22366' AND status='1' AND (question like '%How Google view website%' OR question like '%Google%' OR question like '%view%' OR question like '%website%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22366' AND status='1'
AND (question like '%How Google view website%' OR question like '%Google%' OR question like '%view%' OR question like '%website%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' 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=22366%' 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=22366%'
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='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='1797.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1797.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 seoclerks.members WHERE USERID='589438.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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 |
Cristian
I would go further and add that you need to have a well-made inter-linking, meaning your pages should be logically linked between them so that the crawler can find its way up the deepest parts of your website and index every page.
But sometimes crawlers go too far, getting into filters and developing all sorts of combination URLs which get indexed, this is where you need to implement the canonical tag.
You will also want to have certain pages outside the search engines, stuff you don't want or you don't need to index in search engines, those pages should all have noindex tag or even nofollow (if you don't want crawlers to go through them). As far as crawling and indexing go, Razzy you outlined the most important factors any SEO must implement: sitemap.xml and robots.txt. I would go further and add that you need to have a well-made inter-linking, meaning your pages should be logically linked between them so that the crawler can find its way up the deepest parts of your website and index every page. But sometimes crawlers go too far, getting into filters and developing all sorts of combination URLs which get indexed, this is where you need to implement the canonical tag. You will also want to have certain pages outside the search engines, stuff you don't want or you don't need to index in search engines, those pages should all have noindex tag or even nofollow (if you don't want crawlers to go through them).
Are you sure you want to delete this post?