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
-
What is a good amount of social shares per week / day?
As the title says. What is your idea of a good amount of social shares to be given per day or week or month for a website?
Social Media | | Zoolander1 -
Bespoke Twitter Feed
Buongiorno from 19 Degrees C wetherby UK 🙂 Ok here goes... is it possible to umbed a twitter feed on a web page that only shows specific hash tag group(s) eg #commercial property. Grazie tanto,
Social Media | | Nightwing
David0 -
3 month intern plan, thoughts/opinions appreciated
Just looking for some opinions here. I'll be hiring a summer intern to help with marketing, spreading the word, and link building. Just wanted to get some feedback on what I'm thinking of having them do. 1. Run back link checks on all competitor websites and ask the owner/webmaster if they'd consider linking to us. 2. Directory submit to any relative directories that pass link juice. 3. Find relevant websites or forums and ask for links, run broken link checker while on their site as well. Maybe offer their audience some sort of freebee or special product/e-book. 4. Create hang outs on Google +, groups on Linkedin.com, Quora etc. Follow relevant Twitter followers and post content regularly. Trying to think of a few other things as well. Looking forward to your opinions. Thanks.
Social Media | | arkana0 -
Where to find good SEO freelancers?
Can anyone recommend any good SEO freelancers for on-site and off-site SEO work on a monthly basis? On sites like elance, freelancer, etc. it's basicly impossible to find any good services due to so many bad "companies" offering all the same thing.
Social Media | | wadap0 -
How to coordinate blog, facebook and twitter.
I have a small law firm with a website including a blog, as well as accounts with Twitter and FB. I usually write a blog on the website then reference and link to that blog from twitter and FB. I also do short blogs that are basically links to other interesting articles about my field, and link to those as well. Is this helpful or correct from he perspective of SEO for the website? Is there a particular way to do this? I have much to learn so any comments are welcome. Many thanks.
Social Media | | NCCompLawyer0 -
Twitter lists - Transferring from 1 account to another
Hi Does anybody know how to transfer Twitter lists from 1 account to another ? Twitter says this isnt possible but is anyone aware of any software that can do this (or technique) ? Both accounts have the same owner Many Thanks Dan
Social Media | | Dan-Lawrence0 -
Just how popular are some #Twitter Groups
Good Morning from 14 degrees C wetherby UK 🙂 As i sat on my grassy knoll puffing on a pipe overlooking the English country Land I wondered... just how do you measure the volume of users using hash tag twitter groups.... or put another way imagine you say to a client "Ok one idea is to get this friday meal deal promoted on #FF" The client then says... "So how many twitter users use the #FF" It a blunt but legit question & one I couldnt answer right now. So my question is please... "Is there a tool to measure frequency of use with regards to twitter hash tag groups" Thanks in advance 🙂
Social Media | | Nightwing0 -
Buying Twitter/Facebook Followers
So i have a client that sends me a link once a week about buying followers for social media profiles. Each time i tell him if it seems to good to be true... then its too good to be true! What are your guys thoughts, experiences, feelings? Here are a few examples: http://www.targetedtraffic.int.tc http://www.fbfandamonium.com
Social Media | | kchandler0