Keyword Not in top 100 dropped on Ahrefs

Drake83 Level 3

June 4, 2017, 8:27 am

Write the reason you're deleting this FAQ

Keyword Not in top 100 dropped on Ahrefs

I was tracking keywords with Ahrefs and had a few phrases in the top 100. They weren't very close to the top 10, near the 50-100 range. I started building guest post backlinks to them (all random/begin anchors with no matching keywords) which were all high quality with 500+ words on domains that are typically DR30+. They weren't moving much but today I logged in and saw they were not in the top 100 and Ahrefs has:

not in top 100 dropped
 

for several of those keywords. I checked the URL for each of them and they were all still indexed. I can also find them searching for other, related terms. What exactly does that mean? I couldn't find anything on Ahrefs but obviously the URL isn't dropped. Does it simply mean it dropped out of the top 100?

Comments

Please login or sign up to leave a comment

Join

idealmike

Sometimes when your rankings drop like that (most times in fact) they come back again but better. That's what I've found when this has happened to me before anyway. I've had sites drop out of the top 100 overnight but then come back a day or two later with better rankings than before. It could be with all those new links you've been building to your site that Google is dancing you around and working out your new rankings in the SERPs. The best thing to do now (well the only real thing you can do now) is to wait a couple days more and see if your site comes back within the top 100 for those keywords as it usually does but better.

So this isn't necessarily a bad thing for you. It could be a good thing! But it could also mean that your site has well and truly been outranked and ranked where Google thinks it should be. If I was you, I would check WMT (Webmaster Tools / Search Console) to see if there are any messages in there as that can tell you why. It could be they've detected some "unusual activity" as they like to call it and if that's the case, you may need to do a bit of a clean up but that's worst case scenario.

Hope this helps and good luck!

9 years ago

Are you sure you want to delete this post?

Makefort

Well, by reading what you have said, I would guess it's most likely the first thing. I find it quite hard to believe that such a sudden drop could happen overnight. Just do like he said, wait for a few days and see what's going to happen.

9 years ago

Are you sure you want to delete this post?

Corzhens

Sometimes I get discouraged whenever I would read a discussion about SEO methods that look very complicated like this one. The keyword tracking requires time and patience not to mention the analysis that you would have to do on the result. What if the keyword dropped in its ranking, is there a need to change the keyword for a more effective ranking? I consider myself a newbie in SEO and I am just beginning to learn the use of proper keywords.

7 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.461313	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 (64) AND gtags like'%signa%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.461313	0.461313
0.104383	1	SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 24741 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Writing Articlesreview%' ) LIMIT 4	0.104383	0.104383

SEOClerks

Keyword Not in top 100 dropped on Ahrefs

Keyword Not in top 100 dropped on Ahrefs

Comments

Please login or sign up to leave a comment

idealmike

Makefort

Corzhens

Invalid SQL

Expensive SQL

Suspicious SQL

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='22926'	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='22926'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='6289'	1	SELECT * FROM seoclerks.members WHERE USERID='6289'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=6289	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=6289	/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=22926 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=22926 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22926' 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='22926' 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=118395 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=118395 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=118404 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=118404 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=170892 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=170892 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='22926'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='22926'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='22926' AND status='1' AND (question like '%Keyword top 100 dropped Ahrefs%' OR question like '%Keyword%' OR question like '%dropped%' OR question like '%Ahrefs%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='22926' AND status='1' AND (question like '%Keyword top 100 dropped Ahrefs%' OR question like '%Keyword%' OR question like '%dropped%' OR question like '%Ahrefs%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
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='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='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='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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=22926%' 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=22926%' 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()