i dont know how the vlook up works but i do the same thing and then i use the hilight duplucates and then filter them with colour and then in the followers tab the one’s which are all hilighted are the likers and the one’s not are non-likers!
how can we differentiate which “ghost followers” are not engaging on our posts because they are simply non-engaging versus the followers who do not engage because they never see our posts. As we know, IG doesn’t show our post to everyone, so we could be removing what we think are ghost followers, when in reality they could be people that would engage if they saw our posts. Thus we might be removing quality followers by doing this.
That’s the single biggest issue that I have with this. For example I have a few IRL friends who I know love my content and they’ve come up as ghost followers. None of them had seen my posts show up on their feed for months so they actively liked some of my content and now they see it again.
Hey, that’s a good question and tbh, there is no 100% full proof way to do this.
My suggestion is to modify the filters when extracting ghost followers.
For example, instead of checking the last 12 posts, you can check the last 30 or 50. You can also check when they last posted on their account, whether they have a profile pic or even if they posted at least once in story.