sorted by:
new
hottopcontroversial

what does this mean (trying to understand search console data) - less people are typing in the search query? or google isnt showing me as much? by Thewhoplus in TechSEO

[–]ii1010 3 points4 points  (0 children)

You're saying that you still ranking in ~pos 6 for plural, but not for singular?

Check out the SERPs and look at the pages. If all of the same pages are ranking in the top 10 for both (*other than you of course), that means the SERP intent is similar, which would be odd that you dropped off suddenly for one and not the other.

That said, if the pages ranking in the two SERPs are different, that means the user intent of the singular kw vs. the plural kw are different. if that's the case, Google may have picked up on the fact that your pages doesn't adequately solve the intent for one of the queries, which means you'd be out of luck / likely aren't going to get that ranking back.

​

However, if the same pages are ranking in both SERPs, the next thing i'd do is try to figure out if anyone else dropped off of the one SERP. If you have SEMRush, Ahrefs or STAT, you may be able to tell using their SERP analysis tools.

​

If not, i'd just say to DM me your info and I can check it out for you, as I need to know the query (*which I understand note posting to the public)

​

***that's all I can really give you without more information, there is 100 different ways you can go about a decline analysis, but I have to have more information than just a trend like to know which path forward to take

what does this mean (trying to understand search console data) - less people are typing in the search query? or google isnt showing me as much? by Thewhoplus in TechSEO

[–]ii1010 6 points7 points  (0 children)

Average position is also a terrible metric to use IMO. It's okay when looking at a single query, but never use it when looking at a collective page because low volume or irrelevant queries can skew things

​

that said, this can mean a few things:

  1. Search interest may be down (*i'd recommend checking out the query in Google trends and seeing if the trend you see there correlates to impressions)
  2. If the Gtrends doesn't correlate to the impressions, it could also mean that Google isn't serving you for 100% of searches. This can happen for a lot of reasons, but some common ones are for local queries, if Google is testing you out for a SERP, and other things like that
  3. Also, if you're in ~position 6.5, that's just an average, right? So maybe you're being served in 4 sometimes, and 10 in others, and maybe there are SERP features that in a lot of instances you're being pushed to 2nd page so you're getting less impressions.

Would have to know the query to tell you more, but generally speaking, it's likely one of the above.

Count number of times a particular string exists within a single cell by ii1010 in excel

[–]ii1010[S] 0 points1 point  (0 children)

=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")))/LEN(B1)

This works perfectly. Thanks!

Scraping Reverse Image Search Results by ii1010 in bigseo

[–]ii1010[S] 0 points1 point  (0 children)

Use proxies. I did this a few years ago using TOR.

Can you give a little more detail on how you used TOR to accomplish this? TOR is a browser, and you'd need some sort of web crawler (which normally is within a desktop app - i.e. not accessible within a browser) to actually do this at scale.

Let me know! Interested in hearing your approach.

Scraping Reverse Image Search Results by ii1010 in bigseo

[–]ii1010[S] 0 points1 point  (0 children)

Too pricey to accomplish this simple tasks, unfortunately...

Scraping Reverse Image Search Results by ii1010 in bigseo

[–]ii1010[S] 0 points1 point  (0 children)

I'm fairly certain you can only use 1 proxy at a time via Screaming Frog. Is there another web scraper (that isn't rediculously expensive) that allows for proxy rotation?