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
-
Recommendations for a collaborative workflow for an integrated content marketing / social media campaign?
We are currently using an excel spreadsheet that is a homemade checklist of all of the various places we want to post. We take one topic, and we make various formats (video, promotional image, blog article, press release) and we list all of the posts we want to make in all of the channels (Twitter, LinkedIn, FB, instagram, pinterest, etc.). Is there any articles that describe a more streamlined way to do this? We have tried basecamp but looking for other options. We have a small team of about 5 people that collaborate to design, write, and post the content. I was looking for an article that describes the workflow that might simplify the communication and execution of this process. Thanks!
Social Media | | larahill1 -
Changing FaceBook Username / url - do you retain your likes/fans
hi just a quickie, anyone know off hand when you change your FB username/url do you retain or lose the likes/fans ? cheers dan
Social Media | | Dan-Lawrence0 -
Twitter cards - one account, various domains?
Hi guys, I have a number of events run by the same company, all with their own websites. For a number of reasons, these individual events don't have their own social channels. Instead, the company's main social channels are used to promote the events wherever possible. I want to implement twitter card markup into each of the sites and associate the markup with the company's main twitter account. Does anyone know whether it's possible to get twitter cards approved for one account across multiple domains? I'd hate to apply for one site using the account, only to find out I can't apply for others! So before I venture into the unknown, was hoping someone could shed some light on this. Cheers 🙂
Social Media | | cos20300 -
How do I follow more people on Twitter?
Hi my Moz friends, I like following all of you, a lot! Because I like following you all so much, but not so many of you like following ME, I have been cut off by Twitter and I'm not allowed to follow any more people until I have more people following ME. Sad Face I am sure that more than a few of you have been in this scenario. What should I do? I could dump 10-20 followers but that 's not going to be enough to pacify the Twitter Gods! Thanks guys, Dana
Social Media | | danatanseo0 -
Does buying thousands of Facebook Fans/Likes affect SEO?
To begin with, please pardon me if this question is ignorant. I'm completely new to this whole social media thing, and somewhat feel it is overhyped. I find it really difficult to believe that social media will actually help the majority of small business owners out there like me, and that most of them are probably being misled about the powers of social media to increase sales. Because it's mentioned so frequently, I've decided to delve into it a bit more to see how this could possibly help me business. Over the past few weeks, I've become familiar with a company that sells Facebook Likes, Twitter followers, as well as YouTube and SoundCloud plays. Since my official Twitter and FaceBook accounts really didn't have that many followers, I decided to buy a few thousand followers for each account. Initially, I bought them because I wondered what would happen if a customer that visited my online store happened to go to those Twitter and Facebook pages. If I personally see a Facebook page with few followers, I probably wouldn't give them my business. I would want to go with a company that seems to generate a bunch of traffic to their pages. Originally, I only had about 200 Facebook followers (now called Likes, it seems) and maybe 25 Twitter followers. I now have over 12,000 Twitter followers and 2,000 Facebook Likes. I may end up buying more since the service was pretty quick and affordable. I'd like to know if Google factors Likes and followers into it's formula for creating SERPS. Will my website rank higher if I have 10,000 likes, rather than only 200? If so, would it be a notable increase? FWIW, I found that more people organically started following my Facebook and Twitter accounts once I had more followers. I didn't change anything about how I maintained the page; I just had more people following them. One other thing of note: these companies are almost certainly using fake/hacked accounts to like various pages around Facebook/Twitter. You can tell because my Facebook page says some city in Croatia has the most amount of 'likes' of my page. Do you think this might come into play at all? Thanks for any and all help!
Social Media | | CHEATERS0 -
Twitter lists
Hello. Can someone please help me to clarify what the difference is between a twitter list 'subsciber' and a twitter list 'member'? Thanks so much.
Social Media | | E2E0 -
What would be a good way to drive traffic to a temporary post - job posting / classified ad?
I was wondering what would be the best way to drive traffic to a posting that will only last 30 days. I didn't think linking would be the answer, but wanted to get opinions. I was thinking pinging and social media (Facebook, Linkedin, Twitter)... What would your strategy be?
Social Media | | RaginCajun0 -
Why are the crawls not picking up my twitter account?
Hello everybody, For some reason, both the google crawler and the SEO Moz crawler are not picking up a twitter account I am using with my site. Maybe I am doing something wrong? My website is http://www.compare4me.ie and the twitter account is http://twitter.com/#!/compare4me Thanks in advance.
Social Media | | compare4me0