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
-
How to find out what is the best time to post to your audience on Facebook
We have been using Facebook for some time for our business and are looking to schedule our posts. We want to schedule posts when they would have maximal reach to our audience. How do we find this out? Can it be identified using Facebook Insights? Instructions or guidance here as to how to do this would be most appreciated!
Social Media | | Gavo0 -
Social Media Tool
Hello Everyone,
Social Media | | vndflkvnlkzdfnv
I'm trying to find a tool that allows me to post to twitter, facebook and google+ at the sametime. Does anyone have a recommendation? Thanks!0 -
What's the value of Twitter and Pinterest links?
Just wondering should part of my regular activities include sharing certain URL's to these social networks? Presumably it requires constantly mentioning random pages as part of an ongoing nature... Any pointers? thanks
Social Media | | bjs20101 -
How do I maximize my Twitter account for SEO?
What should I be doing to maximize my Twitter account to contribute to the SEO of my website? I have 30,000 followers and want to get some SEO out of Twitter.
Social Media | | bigeyecreative0 -
How can I gain links by creating infographics and/or memes?
It seems that both infographics and memes seem to be popular methods of creating good quality links at the moment, but how can you actually gain links by using these? When people share the graphics they will need to put an extra link in back to you and obviously most will be via social media so will not be worth that much to Google? Do I need to email these out to blogs etc?
Social Media | | harrygardiner0 -
Do links in Paper.li twitter round-ups help my SEO?
My twitter feed is picked up in the daily roundups like Paper.li. Do these links count towards my SEO effort or are they just empty. Clearly they spread my content so that great, just wondered if the links pass juice to the site.
Social Media | | GlobalLingo0 -
Impact of URL shorteners in Twitter feeds
Hello, Will use of URL shorteners [bit.ly/tiny.cc or equivalent] in Twitter feeds impact the rankings of a target pages? As I understand it Twiitter links are automatically generated as nofollows so I am assuming the published link is irrelevant. Is this still the case? If we do continue to use URL shortereners should we look at branded URL-shorteners to provide link context? Thanks.
Social Media | | Urbanfox0