SEOClerks

Clear
Sign In Join

What is BEST way to do On-Page SEO???

  • citadelsystems Level 1
    • 5

    Write the reason you're deleting this FAQ

    What is BEST way to do On-Page SEO???

    I have currently 10 keywords I'm trying to have onpage seo setup 100% perfectly for.

    I'm wondering is the best way to get things in order is to get a seomoz account and run its onpage seo tool? I ran a test on ibp, and it said it was about 72% optimized.

    Just wanted to hear your thoughts, and looking for the best solution

    #seo SEO
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    fmfame

    fmfame

    i use seopressor or seobump tool for wp.work wonders.
    14 years ago

    Are you sure you want to delete this post?

    ciciliamax

    ciciliamax

    I used seopressor. @seoabhay, how good is clickbump? Haven't tried it yet.
    14 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    The best way to do on-page SEO is to provide content that is exactly what the person or searcher is looking for. If you know what that is then you can create content that will be valuable to them and go on to get you more shares and more traffic to your site.

    There is much evidence now that longer articles rank better as well. I'm not talking about articles that are 600 words but those that are at least 2500 words long and have lots of unique high res images in them and are broken up into different parts with good use of h2, h3, h4 tags in them.

    However it can take too long for some people to write articles like that and they don't have the patience for it so they publish shorter articles instead. These don't rank as well. So it's much better to put the extra amount of time and work into your articles and do more research to provide high quality articles that are valuable to the reader by providing them exactly what they're looking for.

    Considering how most people are searching for a problem to a solution, if you can come up with that solution, you can come up with great content they will find valuable. I'm not talking about filling it with filler content. I'm talking about explaining in detail how your solution works and why it's the best and only solution that they need to their problems.

    So think big and make your articles big. Post really long articles that are valuable and useful to the reader in every word you type. Get that right, and you wont really even have to spend much time on all the other facets of on-page SEO.

    You could always hire an expert freelancer for that on here though. What is BEST way to do On-Page SEO???
    10 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    If you are on the keywords for the onpage SEO then you probably need to write good contents to go with it. Good content means a well written article or write up that has no grammatical and spelling errors. The content is unique which is not copied from another website. When uploading the said contents, you can include the keywords that you have selected but those keywords should be directly relevant to the content that you are uploading to your website.
    8 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.27940797805786

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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='894'1SELECT 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='894'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='9399'1SELECT * FROM seoclerks.members WHERE USERID='9399'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=93991SELECT googleplus_profile FROM seoclerks.members WHERE USERID=9399

    		/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=894 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=894 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='894' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='894' 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=7008 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=7008 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=7132 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=7132 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=39344 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=39344 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=160208 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=160208 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='894'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='894'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='894' AND status='1' AND (question like '% On-Page SEO???%' OR question like '%On-Page%' OR question like '%SEO???%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='894' AND status='1' AND (question like '% On-Page SEO???%' OR question like '%On-Page%' OR question like '%SEO???%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='53446' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='53446' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='122401' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='122401' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='588378' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='588378' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='215966' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='215966' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='134' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='134' 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=894%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=894%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='7939.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='7939.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='4674.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4674.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT 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='600657.jpg'1SELECT 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 asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.1134421SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 12411 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Youtube Subscribers Likes Views Social Media%' ) LIMIT 40.1134420.113442