kennchronic
Level 1
Write the reason you're deleting this FAQ
I want to build a website and optimize it for high search visibility. I have many keywords in my niche that I want to optimize my website for.
How can I choose the right keywords that can make my website's optimization fruitful and will make ranking easier?
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='9921' | 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='9921' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='81697' | 1 | SELECT * FROM seoclerks.members WHERE USERID='81697' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=81697 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=81697 | /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=9921 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=9921
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9921' 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='9921' 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=38765 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=38765
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=38774 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=38774
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=154217 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=154217
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9921' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9921' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9921' AND status='1' AND (question like '%How I choose correct keywords I optimize web site?%' OR question like '%choose%' OR question like '%correct%' OR question like '%keywords%' OR question like '%optimize%' OR question like '%site?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9921' AND status='1'
AND (question like '%How I choose correct keywords I optimize web site?%' OR question like '%choose%' OR question like '%correct%' OR question like '%keywords%' OR question like '%optimize%' OR question like '%site?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='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='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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=9921%' 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=9921%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /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 |
TommyCarey
I'll use "Internet Marketing" as an example since a lot of people who will be reading this probably know what that is.
In the United States there are 50 states and you can target each one individually. This will help you start building a long tailed keyword list since you can add keywords like "Illinois Internet Marketing" "Texas Internet Marketing" "Florida Internet Marketing" and so on. That will give you a set of 50 high quality keywords to add into your list.
You can now target specific counties in each state. There are roughly 3,200 counties in the United States and that will jump your keyword list pretty high. I'm going to use Illinois as an example since that's where I live. You can target keywords like "Cook County Internet Marketing" "Dupage County Internet Marketing" "Will County Internet Marketing". I would assume you won't get as many clicks with this method because even I have never been like "Oh, I should search for something I want based on the county I'm in!". There's a small chance this will work well, but if you're targeting these keywords by just addint articles to your website which are targeting a specific county, then it won't hurt.
There are roughly 20,000 towns within the United States that you can target and build your list exponentially
In Conclusion:
If you wanted to put together an enormous list, without cherry picking, you could use the above method to generate roughly 23,250 additional keywords for each of your main keywords. An enormous list, yes. But I'm sure you can figure out a way to alter this method and cherry pick the absolute best keywords that will have a low CPC and a very high ROI ;) I know I've done this before for one of my websites and found a keyword I was paying $0.05 per click and making around a 2,000% ROI.
My advice:
Take your time.
Crunch all the data.
Cherry Pick only the best keywords.
Start your work and monitor everything like a hawk.
Thanks,
Razzy First start with your main keywords and branch off from there. I'll use "Internet Marketing" as an example since a lot of people who will be reading this probably know what that is. In the United States there are 50 states and you can target each one individually. This will help you start building a long tailed keyword list since you can add keywords like "Illinois Internet Marketing" "Texas Internet Marketing" "Florida Internet Marketing" and so on. That will give you a set of 50 high quality keywords to add into your list. You can now target specific counties in each state. There are roughly 3,200 counties in the United States and that will jump your keyword list pretty high. I'm going to use Illinois as an example since that's where I live. You can target keywords like "Cook County Internet Marketing" "Dupage County Internet Marketing" "Will County Internet Marketing". I would assume you won't get as many clicks with this method because even I have never been like "Oh, I should search for something I want based on the county I'm in!". There's a small chance this will work well, but if you're targeting these keywords by just addint articles to your website which are targeting a specific county, then it won't hurt. There are roughly 20,000 towns within the United States that you can target and build your list exponentially :D I'll use Illinois as an example since I'm from Chicago and I don't have to research any suburbs around me in order for this to make sense lol :D So, you can now expand your list by targeting keywords like "Chicago Internet Marketing" "Naperville Internet Marketing" "Kankakee Internet Marketing" and so on. You'll want to cherry pick the cities/towns in order to get the best results and reduce your list so that you don't go insane with all the keywords. Target cities/towns based on their population and you will reduce your work load and increase your profits. Why? because the towns/cities with a higher population tend to have more revenue flowing through them. I live in a town that has 140,000 people in it and I know there are millionaires all over the place, that's who you want to target. You can most likely find a list on wikipedia that shows all the states in a town based on population. I wouldn't target anything under 30,000 people since your list is going to get fairly large if you pick anything lower. [u][b][size=160]In Conclusion:[/size][/b][/u] If you wanted to put together an enormous list, without cherry picking, you could use the above method to generate roughly 23,250 additional keywords for each of your main keywords. An enormous list, yes. But I'm sure you can figure out a way to alter this method and cherry pick the absolute best keywords that will have a low CPC and a very high ROI ;) I know I've done this before for one of my websites and found a keyword I was paying $0.05 per click and making around a 2,000% ROI. [size=160][u][b]My advice:[/b][/u][/size] Take your time. Crunch all the data. Cherry Pick only the best keywords. Start your work and monitor everything like a hawk. Thanks, Razzy
Are you sure you want to delete this post?