#Mysteryfollower – part 3: suspended and blocked

I see more changes to the follower statistics than I expected after I created my #mysteryfollower script on my twitter account. I see accounts being removed from the XML resultat because they are blocked or suspended. These accounts are still listed on the web. I guess that is because the website probably isn’t updated as frequently as the API. I will implement a check in my script when I lose a follower – to see if the account was blocked or suspended. And if that is why the account is removed, I’ll hide it in my report – because I don’t need to know that spammers and bots have been removed.

The fine-tuned SQLs work as they should now, so the next step is to do some minor changes to the database design to enable the script to work for more than one account – I’ll start by adding my Norwegian twitter account: @nicolairygh. I guess more than one account will make more tuning necessary.