1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to audit scraped list of twitter followers?

Discussion in 'Twitter' started by bakkies, Apr 13, 2017.

  1. bakkies

    bakkies Newbie

    Joined:
    Mar 24, 2017
    Messages:
    10
    Likes Received:
    0
    Gender:
    Male
    Hi guys

    I am using follow-liker to scrape user profiles into a CSV.

    I am hoping to filter the lists , to remove company accounts and fake profiles. Using the remaining list for targeted ads on Twitter.

    Is there a tool to help filter a CSV list of twitter names like described?

    Note, I have little to no programming background

    Mark
     
  2. Dark Comedy

    Dark Comedy Junior Member

    Joined:
    Dec 16, 2016
    Messages:
    138
    Likes Received:
    28
    Gender:
    Male
    Hi Mark,

    noticed on other threads, you and I are doing a lot of the same things. We should keep in touch. Happy to answer any of your questions.

    When I extract all the IDs, I bring em into google sheets. Google sheets is where I do filtering and culling of the crap. This part can be tedious if you don't use some special google sheets (or excel) formulas. There's little basic formulas that can help remove the junk. For example =unique gets rid of any duplicates. Also "delete all rows containing ___" is good too. But yeah, I recommend checking out some of the basic tools google sheets has to offer. I too knew nothing about google sheets til I had to learn for this very reason. quick youtube tutorials told me exactly what to do and it was easy to comprehend.
     
  3. bakkies

    bakkies Newbie

    Joined:
    Mar 24, 2017
    Messages:
    10
    Likes Received:
    0
    Gender:
    Male

    Awesome, glad to have found someone testing out similar strategies. Very keen to keep in contact and learn from each other..... Regarding google sheets, this is the solution I am currently using. However as you mention, it is tedious..... I was hoping to find a better tool that would allow a more sophisticated approach. Ideally, where I can identify and separate fake and corporate accounts so I am left with a focused audience that I can market efficiently. I know there are various social CRM solution like Zoho etc.... Im not sure if anyone has used them and if thy are able to filter large lists of twitter accounts. ?