Tool/Method to find users on Twitter from a CSV file
-
I'm attempting to find users to follow and receive reciprocal follows for a client on twitter.
Through the company's newsletter database, I have a CSV file of somewhere in the range of 20,000 email addresses and names.
I've been importing them 250 at a time into an empty Gmail account then connecting that with twitter each time to find some of them.
However, a lot of the PEOPLE using the email addresses on the mailing list are not on twitter but their COMPANY is. To find the company, I can obviously drop the name@ part of the email and just search by the domain but this becomes tedious real quick since it has to be one by one and cannot be bulk imported/searched.
Are there any tools/ideas out there to more easily find twitter users based on a larger set of keywords and/or domain names?
-
Hi Keri,
No luck with any other tools, unfortunately. It's still something on the to-do list.
Ryan's comment is helpful but still a lot of manual work involved unfortunately.
- Victor
-
Hi Motava,
I'm following up on older questions. Did you find a tool for this? Can you share anything with us for others looking for a similar answer?
-
Since you're looking for users and not necessarily tweets, you can scrape the company names you're interested in via a spreadsheet, and then append this URL to each unique name: http://twitter.com/#!/search/users/
Just getting rid of duplicate company names should cut down the list some, but it's still going to be a tedious process. At least with the spreadsheet you can add further columns to prioritize your work and go after the companies that are most applicable.
To cut the tedium, Mechanical Turk could then process the results for you fairly quickly.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Twitter and SEO
Hey Moz folks, I would like your input on this matter: Twitter recently made a new agreement with Google regarding the SEO & their Tweets. At the moment I have 12 different websites across 12 different markets and I`d like to know how could I use Twitter for all markets, so I can get the most out of the new deal between Twitter and Google SEO wise. If I create 12 different accounts for all my 12 websites and create tweets for all of them, it would really be a very time consuming process, but on the other hand if I only use 1 account how can I target multiple websites ? Let me know what do you think. Thanks, Andrei
Social Media | | kiraftw0 -
Add Tracking Parameters to Website Links on Facebook/Twitter
does anyone know of a way to add tracking parameters to facebook/twitter website links in the about us section so that we can understand what traffic is specifically coming from that page? I already add tracking to posts, but I am more trying to track each standard link on these social channels. I am currently running into character limits or the result looks like a long url that will most certainly deter clicks because it looks suspicious.
Social Media | | dsinger1 -
How to autofollow anyone who tweets/retweets my blog?
I'm not sure if here is the right place for this Q but since followerwonk is one of the SEOmoz tools, I thought I'd try. I want to autofollow anyone who tweets or retweets specific URLs (my blog posts on a large blog). Does anyone know how to do this? They often don't @mention me in the tweets, I just see them all on topsy. I get 50-100 a day and at the moment have been manually going through and following all those people. It's been a useful exercise so far to see what types of people are tweeting my stuff, but now it has got super tedious!
Social Media | | KateV0 -
Twitter inbound link not being indexed
Hello Mozzers! I was using open site explorer to investigate inbound links to our company website and also to our competitors. The main difference being is their top links are all coming from twitter - where as ours aren't. Now our twitter account is about 10months old maybe more and it's got the standard setup with a description and the URL. We've also been tweeting with a link directly to our site. Yet no luck? Am I missing something? Thanks, Dan
Social Media | | Sparkstone0 -
Youtube SEO: Does your channel name / user name matter?
My predecessor left me a gift of what is arguably the worst kind of Youtube channel name: Our company's name condensed to an acronym with some additional gibberish that may or may not have meant something to her. In short: Our channel name will never be searched for, will never provide any ranking boost. Now our Youtube success has been very marginal so far: 31 subscribers, 7,300 video views. Given that situation, should I seriously consider scrapping my channel and starting something new with a keyword targeted channel name? Or does channel name matter so little that I should hold on to my 7300 video views?
Social Media | | AdoptionHelp0 -
Facebook, LinkedIn, Twitter, etc. Is there value in a presence on them?
I have a client (professional practice) whose father is a marketing professor. He is pushing the client that he should have a professional page on social sites. While I believe having FB likes, shares, Tweet links, +1, etc. on the page, I really am ambivalent about building pages specifically for social media sites.
Social Media | | RobertFisher
For some of you who have tracked the efficacy of these it would be great to know your pros and cons.0