Beverly
Level X3
Write the reason you're deleting this FAQ
Talk to me about the 'thought process' that goes into coming up with brilliant, high ranking keywords for a website. For instance, do you make actual lists of keywords for your niche? Are you using a thesaurus and just research common synonyms or related words? Do you take the words from your competitor's site, such as by peeking at the source code? I remember back in the day, that last suggestion was very popular and I'll admit that I did that a few times 
And, possibly this is a niche specific question.
After all, if you have a recipe blog, all your keywords are going to be surrounding recipe/food related.
What about focusing on user intent as a way to generate new long-tail keywords? If a person wants to learn or do something, they will typically search for a 'how to, so that's their intent.
For instance, when a gardener searches for answers to gardening related questions, they won't just be searching for 'gardening' as that's too vague. So their search might be 'How to make marigolds grow fast in any soil?' I have read a little about user intent as it relates to keyword strategy but want to know more. I think it's a goldmine for coming up with keywords.
Possibly if you could generate a list of commonly asked questions for your niche, then that would become the basis of your keyword list.
And, maybe those questions could be integrated into a page along with highly detailed answers, much like you have with our own SEOClerks FAQ or even Yahoo Answers or any of the other big Q & A sites.
That's just one thought on coming up with really good/relevant keywords and I'd love to hear more if you know how to use this 'user intent' for keyword strategy along with some actual examples as well as any other big out of the box keyword brainstorming ideas.
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='10003' | 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='10003' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='147' | 1 | SELECT * FROM seoclerks.members WHERE USERID='147' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=147 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=147 | /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=10003 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=10003
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10003' 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='10003' 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=39283 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=39283
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=95967 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=95967
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=166018 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=166018
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10003' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10003' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='10003' AND status='1' AND (question like '%How brainstorm brilliant keywords%' OR question like '%brainstorm%' OR question like '%brilliant%' OR question like '%keywords%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10003' AND status='1'
AND (question like '%How brainstorm brilliant keywords%' OR question like '%brainstorm%' OR question like '%brilliant%' OR question like '%keywords%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='337' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='337' 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='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=10003%' 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=10003%'
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='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
User intent is something to consider of course, thinking about the sorts of things people search for that is connected to your industry. Composing lists of some of the most frequently asked questions about your product, service or niche. From one good question, you can come up with many more from it too. For example, say you had a good question such as "Which flowers grow the fastest in summertime?" From that you can come up with more questions such as "Which Flowers grow the fastest in wintertime" Or "Which flowers are the best to grow indoors" And from that you can ask the same question about but for the outdoors. Sometimes you only need to change one word and it's a whole different question and can go on to provide a completely different set of content for it too. I hope that makes sense!
Sometimes I cheat though! If you can call it cheating. But other people have already come up with many great ways to brainstorm keywords. One good site that is packed full of videos on the matter is http://keeyword.com/keyword-brainstorming/
Here's an excellent video from there for brainstorming keywords in a document.
Great question! And one that many people often struggle with at times for coming up with things to write/blog about. One thing that helps me is just searching the sites in my niche, like my competitors sites and seeing what sort of things they are writing/blogging about. That often gives me ideas and inspiration and leads to other things as well. Perhaps they have an article they've published that you think would be good on your site but you think you could do it in your own version and in a better way than they have. Such as expanding on points made within that article that they didn't really cover in much detail. I've used that and still continue to use that for ideas and inspiration for blog posts. User intent is something to consider of course, thinking about the sorts of things people search for that is connected to your industry. Composing lists of some of the most frequently asked questions about your product, service or niche. From one good question, you can come up with many more from it too. For example, say you had a good question such as "Which flowers grow the fastest in summertime?" From that you can come up with more questions such as "Which Flowers grow the fastest in wintertime" Or "Which flowers are the best to grow indoors" And from that you can ask the same question about but for the outdoors. Sometimes you only need to change one word and it's a whole different question and can go on to provide a completely different set of content for it too. I hope that makes sense! Sometimes I cheat though! If you can call it cheating. But other people have already come up with many great ways to brainstorm keywords. One good site that is packed full of videos on the matter is http://keeyword.com/keyword-brainstorming/ Here's an excellent video from there for brainstorming keywords in a document. [video]https://www.youtube.com/watch?v=OohsWwXxzbU[/video]
Are you sure you want to delete this post?