RizalSofian
Level 1
Write the reason you're deleting this FAQ
Hi,
I need 50 keywords in depth analysis based on User Intent (25 commercial keywords and 25 informational keywords) for my niche site.
Keyword research and competition research requirement:
1. Search volume has min > 100 per month each keyword and at least 5 keywords has search per month min > 500 (Local Searches) from total 25 keywords.
2. Each Keyword Difficulty Score has to < 30 and in the google top 10 results should has competitor with Domain Authority (DA)
< 25.
3. Each keyword has No e-commerce lean (less than 7 e-commerce sites on top 10 google search engine)
Is this a reasonable goal, attainable?
How much does is it cost?
Kind regards
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='22265' | 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='22265' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='578093' | 1 | SELECT * FROM seoclerks.members WHERE USERID='578093' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=578093 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=578093 | /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=22265 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=22265
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22265' 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='22265' 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=116673 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=116673
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=170335 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=170335
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22265' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22265' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22265' AND status='1' AND (question like '%custom research keyword %' OR question like '%custom%' OR question like '%research%' OR question like '%keyword%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22265' AND status='1'
AND (question like '%custom research keyword %' OR question like '%custom%' OR question like '%research%' OR question like '%keyword%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='840' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='840' 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='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='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='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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=22265%' 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=22265%'
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='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
Everything you need seems to be pretty attainable, you just need to have a couple things.
Is this a reasonable goal, attainable?
It's definitely reasonable. I just set up a test campaign in about 20 minutes through adwords in order to figure out the estimated amount of traffic I could get for my budget. All you have to do is set up a campaign for your website, you don't have to activate it, and when you get to the keyword section it will ask for a few keywords or your domain in order to give you suggestions. Add your main keyword into the field and press enter. Usually you'll get a good amount of keywords, and if you're only looking for 50 keywords then you'll be just fine
My test campaign that I set up had around 300 keywords in them and they varied a lot. Some of the keywords were estimated to get around 10 searches a month while others were showing 10,000 searches. Obviously the 10k searched keywords will cost me more if I were running an actual PPC campaign, but I was just doing keyword research
How much does is it cost?
If you use Adwords then it won't cost you anything. You can do what I said above and when you get to the keyword stage just don't click "Save and Continue" and your campaign won't go live
I use Adwords all the time to do some keyword research because they give you estimated searches and estimated clicks. This means you can figure out how many clicks you could be getting from a keyword compared to another. Sometimes a great looking keyword might not have the best CTR for some reason, it's rare but it does happen.
- Razzy Hey there, Everything you need seems to be pretty attainable, you just need to have a couple things. [list=1][*][b]An Adwords Account[/b][/*][*][b]Patience[/b][/*][/list] [size=90][u][b]Is this a reasonable goal, attainable? [/b][/u][/size] It's definitely reasonable. I just set up a test campaign in about 20 minutes through adwords in order to figure out the estimated amount of traffic I could get for my budget. All you have to do is set up a campaign for your website, you don't have to activate it, and when you get to the keyword section it will ask for a few keywords or your domain in order to give you suggestions. Add your main keyword into the field and press enter. Usually you'll get a good amount of keywords, and if you're only looking for 50 keywords then you'll be just fine :D My test campaign that I set up had around 300 keywords in them and they varied a lot. Some of the keywords were estimated to get around 10 searches a month while others were showing 10,000 searches. Obviously the 10k searched keywords will cost me more if I were running an actual PPC campaign, but I was just doing keyword research :D [size=90][u][b]How much does is it cost?[/b][/u][/size] If you use Adwords then it won't cost you anything. You can do what I said above and when you get to the keyword stage just don't click "Save and Continue" and your campaign won't go live :D I use Adwords all the time to do some keyword research because they give you estimated searches and estimated clicks. This means you can figure out how many clicks you could be getting from a keyword compared to another. Sometimes a great looking keyword might not have the best CTR for some reason, it's rare but it does happen. - Razzy
Are you sure you want to delete this post?