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 use LinkedIn as marketing tool
Depending on what market you're in LinkedIn seems to be extremely powerful, does anyone have any experience of marketing using LinkedIn as a platform? All suggestions and tips welcome...
Social Media | | seoman101 -
Building links to a Twitter/social account
I've seen plenty of articles about using Twitter to build links, but how about building links to a Twitter account? Does registering on sites and directories like Topsy, Twellow and Klout help? We can link to Twitter accounts on our own websites and other social profiles, and use it as our link on blog comments etc, but is there anywhere else specific?
Social Media | | Alex-Harford0 -
Any developers (php/wordpress) out there? Quick question.
This question is directly related to SEO, but I wanted to see if there was any wordpress / php pro's out there who wouldn't mind helping me with a few quick things. The biggest one is I'm trying to move this facebook like button from where it is to the line of sharers above it. The sharers are being put in by the digg digg plug in, and the facebook button is being put in by the facebook plug in. You can see it on my site, or on this plug in. Thanks! gEOa
Social Media | | NoahsDad0 -
Youtube and twitter
Does anyone have an idea how long it takes for the business profile to show up on youtube and twitter? I created profiles yesterday around mid afternoon. I searched for both today and they do not show up just yet. Thanks!
Social Media | | hawkvt10 -
Find Facebook Likes and Google +1's Across An Entire Domain?
Does anyone know a good way to find the number of Facebook Likes or Google +1's across an entire domain? It looks like SEOMoz only shows these metrics for individual pages.
Social Media | | SparkplugDigital0 -
How to get a link on Twitter box in Huffington Post?
Hey guys, got a question about the Huffington Post and its Twitter widget - see screenshot attached HuffPo seems to be aggregating links somehow under the "Top links on this topic" heading within the Twitter widget. At first I thought this was an official Twitter wdget; http://twitter.com/about/resources/widgets However, I can't find it on Twitter's site and I'm starting to think it's a custom widget possibly developed by HuffPo themselves. My question is how do I get my site to rank under their "Top links"? Is it feeding on Twitter presence or is it feeding from Google News or through something else? Many thanks in advance for any light shed on this topic Edit: Link to Huffington Post page example from screenshot Screen%252520shot%2525202011-10-24%252520at%25252017.26.54.png
Social Media | | JDauncey0 -
Tool that recognizes twitter spam accounts
I seem to remember seeing an online app mentioned here that allows you to enter a twitter username, and it reports back metrics on the likelihood of each follower being a real person or not. Does anyone have the link, or did I imagine it?
Social Media | | nbyloff0 -
Who do you follow on Twitter?
I am just getting to grips with Twitter, suppose its better later than never, and was wondering who everyone follows for SEO and Web Design. Personal i find it hard to keep up with more than five or six people with out getting information overload, and have no time for those that tweet twenty or thirty times a day about what they had for lunch or who they are meeting for drinks. If you had to pick the top five people to follow for SEO and the top five for Web Design who would you chose? I work on the SEO side of our business and i think my top five would be, in no particular order: Randfish
Social Media | | fraserhannah
bill_slawski
mattcutts
aaronwall
dannysullivan Would be interested what others think especially on the web design side as we tend to follow people we know locally. Thanks Fraser1