custom research keyword

RizalSofian Level 1

April 23, 2017, 4:34 pm

Write the reason you're deleting this FAQ

custom research keyword

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

Comments

Please login or sign up to leave a comment

Join

TommyCarey

Hey there,

Everything you need seems to be pretty attainable, you just need to have a couple things.

An Adwords Account
Patience

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

9 years ago

Are you sure you want to delete this post?

Corzhens

I like the point number 2 which says patience. This reminds me of the first discussion that I had read about SEO service where the buyer was complaining that he had paid for the service but the traffic has not increased yet. The common comment was patience because the effect of the SEO work on the site cannot be determined regarding the time that it can take effect after a week or after a month or even after a few months. Truly patience is always an important element in life.

7 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.417270	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (89) AND gtags like'%Articles%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.417270	0.417270
0.407442	1	SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=51	0.407442	0.407442
0.340563	1	SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=62	0.340563	0.340563
0.113051	1	SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='content-writing' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 200, 40	0.113051	0.113051
0.111617	1	SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='domains' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 40	0.111617	0.111617
0.070578	1	SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='domains' LIMIT 1	0.070578	0.070578

SEOClerks

custom research keyword

custom research keyword

Comments

Please login or sign up to leave a comment

TommyCarey

Corzhens

Invalid SQL

Expensive SQL

Suspicious SQL

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='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='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='2988' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2988' 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='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=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()