Write the reason you're deleting this FAQ
Keyword research is the main thing that will determine if you're getting into a good niche that can be dominated quickly or if it's going to take time. It's also a good way to figure out if it's worth targeting at all because the amount of time you'd have to put into the website may not be worth your time in order to make money in the long run. I say this because by the time you rank one competitive niche website you could have 10 low competitive niche sites ranked and making money. Sure your high competitive niche website would be making more money than you could count, but the success rate for these types of websites is extremely low.
Now the thing with keyword research is that you can figure out rough estimate on how much traffic a particular search will get, but you can never estimate the profits. You can be selling a $100 item and getting ranked for keywords with 10,000 searches a month and not making a single sale. On the other hand you can be ranked for dozens of keywords that are getting 1,000 searches a month and getting sales everyday. The amount of searches a keyword is getting doesn't always relate to an increase in sales, so you'll have to pick your main keywords strategically.
Over the years I've had plenty of clients sign up with me for my SEO and Online Marketing services and they give me a list of around 50 keyword, which 45 of them are extremely difficult to rank for in 1 to 3 months. What I do is I ask them for a list of keywords to target and also so I can get a good idea of what they want to target. I don't tell them that I will target exactly the keywords they're giving me because a happy client is one that sticks with you, but not ranking for their keyword list makes them mad
I'll figure out what keywords are getting 1,000 to 5,000 searches per month and I will target these first because they will usually rank quicker than the 30,000+ searched keywords. Now some of you are saying "Well if they don't rank for the keywords they sent you, won't they be pissed off?" and that has definitely happened, but not usually. It usually doesn't happen because they are getting 1,000s of new visitors coming to their website each week from the low competition keywords that I've targeted and they don't care anymore because of the sale increase I have gotten them in less than 3 months lol
Now I will always target those highly difficult keywords, but they are my main priority with a new client because they hardly ever rank in the "happy client" timeline of less than 90 days 
Keyword research comes second nature to me and it's always a part of my game plan, but that might not be the case for a lot of newer webmasters and online marketers. But don't worry, because I'm going to help you out a little bit
A couple ways to do some free keyword research:
The suggestions are: seo marketplace, seoclerks facebook likes, roundshelf, gigbuys seoclerks vs fiverr, seoclerks instagram followers, seoclerks youtube and seoclerks twitter followers. If you were targeting a specific niche, not SEOclerks, you can add these keywords into your SEO plan because you know people are already searching them 

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='22404' | 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='22404' | /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 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=22404 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=22404
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22404' 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='22404' 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=116646 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=116646
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=132924 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=132924
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=157129 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=157129
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22404' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22404' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22404' AND status='1' AND (question like '%Some info keyword research you.%' OR question like '%Some%' OR question like '%info%' OR question like '%keyword%' OR question like '%research%' OR question like '%you.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22404' AND status='1'
AND (question like '%Some info keyword research you.%' OR question like '%Some%' OR question like '%info%' OR question like '%keyword%' OR question like '%research%' OR question like '%you.%')
-- 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='1508' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1508' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=22404%' 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=22404%'
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='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 |
idealmike
I'm sure I'm just preaching to the choir there for you! lol but for a lot of other people that's still a lesson they will learn the hard way unfortunately. As lots of people new to doing SEO will usually go OTT on it and the bad/sad thing is, a lot of SEO's wont tell them that, they'll just sale them their service, take their money, do the SEO and hope the client is happy. And that's what it's like when it comes to buying/selling SEO services as well and that's fair enough. But still, good keyword research is pivotal today regardless to if you're a site that already enjoys good rankings or you're a new site just starting out for the first time.
Are you sure you want to delete this post?