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
-
Facebook Page - About/Description/General About/Mission - Questions
Hi, Im just setting up a FB fan page for a client How terrible is it to use clients websites home page descriptive copy as the Facebook page long description ? Language is in Turkish which i don't speak so i'm not able to edit a new version of it just for FB and no budget to hire Turkish speaker to come up with something. So was going to copy & paste but that would be duplicate with HP obviously. How important is it to fill in 'Mission Statement' & 'General About' ? Especially if long description likely to already include that info ? I think long descrip is important for FB pages on seo etc etc but a good one eliminates importance of 'Mission' & 'General About', or is it still advisable to fill these in or are they just extra boxes for flexibility ? I take it when it comes to securing a vanity url (once we hit 25+ fans) for a foreign language version FB page it should ideally be brand name (which includes a keyword) in the local/target language ? The page name is already the brand name in English but since contains keyword is it best to rename into local target language similarly to the url for consistency and local targeting or better to keep one in Turkish and one in English ? Many Thanks Dan
Social Media | | Dan-Lawrence0 -
2013 - Google Places/Business to Google Plus Local
Hi, Much of the reading I've done has suggested that existing Google Places/Business Page (with "About" and "Photos" on top) will be automagically "upgraded" to Google Plus Local pages (with "About" and "Photos" and "Reviews" and all the other Google Plus items). However, is there a way to force an upgrade? I have a Google Places/Business Page and when I go to "manage page" it basically wants me to create a separate Google + Page for the Business. Is this the correct thing to do? Do I need to create a Google + Page for the company first, and then try to merge the Places listing with the new Google + Page for the business? Thank your for helping me clear this up!
Social Media | | Titan5520 -
Identifying members on Twitter
We are a member based company. Membership is by business not individual. So for instance if your widget business is a member anyone with a johndoe@widget.com email address can sign up and use all our content, portals, etc. I want to take emails and figure out if they are on Twitter. I know Twitter allows you to search your contact list but this wouldn't be that. It would be a list of emails I create. Are there any tools or suggestions to do this in a efficient way besides searching each individual name on Twitter? Thanks for the help.
Social Media | | inhouseninja0 -
Recommended/Convenient Social Share Plug-In for Agencies w/Multiple Accounts!
Hi! What is a recommended social media share plug-in (SEO-friendly) to implement across multiple websites (desktop & mobile) for an agency? Also, does the suggested social share plug-in provide a dashboard to review multiple accounts via one location?
Social Media | | RezStream80 -
Google Auth and brands/individuals problem
So you can auth pages with personal google+ profiles - and its being suggested by some that this could now help rankings if that person has lots of people in their circles. So what about brand/companies content? why cant they auth the content with their Google+ profile to get the content ranking better. It doesn't seem right an individual blogger can do this but a company cannot who has written lots of guides. An example is a holiday company has written some awesome content on resorts around the World - how to use the auth for that content to rank higher? - currently only possible to link up an individual as writing the content not the brand/company itself. Any suggestions on this much appreciated. I do not want to lose any gain there might be from this new bonus given from Google.
Social Media | | pauledwards0 -
Twitter Username: Keyword or Company Name?
Hello everybody! I'm in doubt with which one is the best: To have a Twitter profile name with: 1)the company's name.
Social Media | | seomasterbrasil
Of course it's good for branding, but it's a B2B, industrial market. 2)a relevant keyword.
Will it bring traffic, considering that is a B2B, that works different. The question is: does Google gives relevance to username with keyword in it? If yes, have it a great value, or should I use the company name? Thanks! =]0 -
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 -
What is more important, tweets/shares or traditional link building?
SMM has a presence that is just growing and growing. I'm hearing all these back and forth talks about how tweets/shares are influencing rankings more than traditional link building would. If so, would this be a short term ranking improvement, long term? What percentage would you say SMM (ranking factor) has when ranking a website in the SERPS.
Social Media | | Brother220