ajlancer
Level X3
Write the reason you're deleting this FAQ
Most SEO beginners ask such questions. I am asking them below on their behalf. I am not going to publish a tutorial by asking and answering them myself. My intention here is that all SEO experts will get to answer such questions. This will help both experts and beginners who are looking for SEO answers.
> How long will I have to wait to be on page one of Google search?
> How much money will I need to pay to have my site optimized?
> Is coding experience essential for SEO if I am performing SEO for myself?
> How do I choose the right keywords to target?
And I have many more questions, but first I would like to know some of your answers to these four questions.
Thanks by Ajlancer
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 `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='10084' | 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='10084' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='4987' | 1 | SELECT * FROM seoclerks.members WHERE USERID='4987' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=4987 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4987 | /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=10084 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=10084
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10084' 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='10084' 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=39442 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=39442
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=39449 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=39449
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=39490 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=39490
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=163862 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=163862
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=166305 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=166305
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10084' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10084' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='10084' AND status='1' AND (question like '%Some common SEO beginner questions answer them?%' OR question like '%Some%' OR question like '%common%' OR question like '%beginner%' OR question like '%questions%' OR question like '%answer%' OR question like '%them?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10084' AND status='1'
AND (question like '%Some common SEO beginner questions answer them?%' OR question like '%Some%' OR question like '%common%' OR question like '%beginner%' OR question like '%questions%' OR question like '%answer%' OR question like '%them?%')
-- 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='3738' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3738' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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=10084%' 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=10084%'
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='311920.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='311920.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='212316.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.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 |
| Avg Time | Count | SQL | Max | Min |
idealmike
That's a great question to ask an SEO before you hire them just to see what they say. Of course, nobody can tell you that but we know it depends on competition. For really high competition, it could take a long time. That can be a few months to a few years. For low competition it might not take as long and could be done in a few weeks to a few months. Sometimes sooner, sometimes later, for both competitions depending on the speed that on-page SEO is done and the type of off-page SEO you do. So if an SEO says they can rank your site on the 1st page of Google within a week for high competition keywords, run a mile! A genuine SEO would say something like what said in that it would depend on the competition and the on-page/off-page SEO.
I can actually get virtually anything you want ranking on the first page of Google results with Reddit. But more on that later...
Well it doesn't cost anything to bring your website on Google or any other search engine. They do that for free, for you. It's their job to search for websites and help you find other websites by searching for them. That's why they're called "search engines" end cheap witty sarcasm lol
But to put your site on them on the 1st page of Google is another matter altogether! You can use Adwords to do that from as little as 0.01 - 0.10 cpc for low competition keywords or from 1.00 - 5.00 cpc for high competition keywords. That will put you on the 1st page for people that don't use ad blocking scripts and use Google. But this price would be defined by the competition level again because for high competition stuff the SEO needed will be more than low competition stuff so you will pay a bit more. Each SEO will have their own SEO services and methods and prices for each. A lot of SEO's provide services of some sort at a certain price too. So you can buy that as many times as you need until you're on the first page. So it will cost however much that costed, however many times you needed it.
No not all all. These days everything is either on/off buttons or drag n' drop. Webmasters don't need to get into the nuts and bolts of their website any more to make nice looking websites or make any changes. However some markup language like HTML/PHP/CSS could well come in handy but they're fairly easy to learn. You certainly wont need any coding language to do off-page SEO as that will mostly involve just writing content and building links and anyone can do that. But for on-page SEO it could come in handy if you know about good usage of the right types of webpage tags like h1, h2, h3, b, u, i, tags and how links work how to make them open in a new window etc that kind of thing can come in handy but you can do all of that with every single website editor that provides a rich editor like this one.
By using the discomfigulator so the gizmatronicon can checkulackulate the statalizerater and show you the best keywords by the amount of searches they get. That's a good way but it's not always accurate due to what's hot or what's not right now ie; trend.
AKA Google Adwords Keyword Planner Tool. [quote][b]> How Long does it take to become first page on search engine?[/b][/quote] That's a great question to ask an SEO before you hire them just to see what they say. Of course, nobody can tell you that but we know it depends on competition. For really high competition, it could take a long time. That can be a few months to a few years. For low competition it might not take as long and could be done in a few weeks to a few months. Sometimes sooner, sometimes later, for both competitions depending on the speed that on-page SEO is done and the type of off-page SEO you do. So if an SEO says they can rank your site on the 1st page of Google within a week for high competition keywords, run a mile! A genuine SEO would say something like what said in that it would depend on the competition and the on-page/off-page SEO. I can actually get virtually anything you want ranking on the first page of Google results with Reddit. But more on that later... [quote][b]> How much does it cost to bring my website on Google or other search engine?[/b][/quote] Well it doesn't cost anything to bring your website on Google or any other search engine. They do that for free, for you. It's their job to search for websites and help you find other websites by searching for them. That's why they're called "search engines" end cheap witty sarcasm lol But to put your site on them on the 1st page of Google is another matter altogether! You can use Adwords to do that from as little as 0.01 - 0.10 cpc for low competition keywords or from 1.00 - 5.00 cpc for high competition keywords. That will put you on the 1st page for people that don't use ad blocking scripts and use Google. But this price would be defined by the competition level again because for high competition stuff the SEO needed will be more than low competition stuff so you will pay a bit more. Each SEO will have their own SEO services and methods and prices for each. A lot of SEO's provide services of some sort at a certain price too. So you can buy that as many times as you need until you're on the first page. So it will cost however much that costed, however many times you needed it. [quote][b]> Is coding experience essential for SEO if I like to work myself?[/b][/quote] No not all all. These days everything is either on/off buttons or drag n' drop. Webmasters don't need to get into the nuts and bolts of their website any more to make nice looking websites or make any changes. However some markup language like HTML/PHP/CSS could well come in handy but they're fairly easy to learn. You certainly wont need any coding language to do off-page SEO as that will mostly involve just writing content and building links and anyone can do that. But for on-page SEO it could come in handy if you know about good usage of the right types of webpage tags like h1, h2, h3, b, u, i, tags and how links work how to make them open in a new window etc that kind of thing can come in handy but you can do all of that with every single website editor that provides a rich editor like this one. [quote][b]> How do I choose excellent keywords to target?[/b][/quote] By using the discomfigulator so the gizmatronicon can checkulackulate the statalizerater and show you the best keywords by the amount of searches they get. That's a good way but it's not always accurate due to what's hot or what's not right now ie; trend. AKA Google Adwords Keyword Planner Tool.
Are you sure you want to delete this post?