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
-
Graphics tool for social media profiles etc
Hi Can anyone recommend a free or v cheap graphics tool for social media company page profiles etc Ideally looking to be able to upload a company logo that then gets converted into all profile image sizes, preferably with a banner option too and ideally with related extras like favicon creation etc Anyone know of one ? (I have tried Pablo by Buffer but does images for social posting only) All Best Dan
Social Media | | Dan-Lawrence0 -
Who are my Twitter followers?
I'd like to know how many of my twitter followers are other businesses and how many are individual customers. Is there a tool for this?
Social Media | | ShearingsGroup0 -
Is there Anyway of finding out a companies facebook shares?
Is there anyway of finding out a companies facebook shares. When I checked out a competitor of one of my clients who seems to be very well placed without many links I discovered that they have over 298 facebook shares on Open Site Explorer but when I look at their site or search on facebook I cannot find any business facebook page for this company so I am really intrigued to find out where they are getting these shares from? Does anyone have any ideas?
Social Media | | dashesndots
Many thanks Tracy0 -
Best way to keep in touch with Twitter leads
On Twitter every now and then I have a conversation with a few people that lasts couple days. Then the conversation dies down and a different conversation with a few other followers begins. What do you guys do to keep in touch with the followers from the older conversations and perhaps start new ones? Do any of the online tools help with that?
Social Media | | Heydarian0 -
Do twitter profile links in bio pass juice?
Links that are added in the "Website" field in a twitter profile are nofollow. However, links added to the "Bio" section are dofollow. This has to mean these links are passing juice correct?
Social Media | | eli.boda0 -
Twitter retweets - best practices
So, a fairly prominent organization used our company in a case study on their website. They mentioned us in a tweet and linked to the case study on their site. I'd like to promote this to my own followers as well. Is it more appropriate to write a unique tweet mentioning the organization and linking to the case study, or should I just retweet their original tweet.
Social Media | | _JP_0 -
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 -
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