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
-
Links to Social Media accounts, rel=nofollow/follow and rel=me
Hi guys, I just saw this rel="me" attribute and I can't find any reputable recent (within last year) information. I never heard of this and wonder if it's any beneficial in any way. At the same time, should I use nofollow or follow on links from website to social accounts? I've heard different opinions but, again, no recent relevant and trustworthy information. Please, kick me into right direction. However, when kicking, please give me some proof, rather than thoughts 🙂 Thanks!
Social Media | | DmitriiK0 -
If you post on two Twitter accounts could be rated as duplicate content
I have a personal Twitter account which is building up, but I also have a Twitter account for my holiday letting agency and until now I’ve always separated the subject of the tweets and links to my websites but I’m using Buffer which automates your tweets in advance and so I included some of the links to my business holiday letting agency articles on my personal account and people seem to like them and have shared them, but is there any risks to doing that regarding duplicate type of content? At the end of the day some the people on my personal Twitter will be interested in my agency tweets about holiday accommodation, I just want to do anything which could be termed spam.
Social Media | | persuaders0 -
Does anyone know how engagement is defined/calculated in FollowerWonk?
In a comparison of Twitter accounts, FollowerWonk shows something called Engagement % Rate. I've looked but I cannot find any information about how this score is calculated or what it is based on. Does anyone know?
Social Media | | KNect3650 -
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 -
Twitter and SEO
Hello Mozzers, I am trying to determine the effectiveness of using twitter as an SEO tactic. A site in my niche (healthcare job boards) is ranking very well for a handful of head terms. Their backlink profile is okay, but not amazing. But one thing that stands out to me is their approach to twitter, http://www.physemp.com/socialTwitter.html. It looks like they send an automated feed of their jobs to these specific twitter handles. Each of the handles has over 2,000 followers (some are legit some are bots). The site ranks for some highly competitive head terms (see attached). Can any of their ranking success be attributed to these various twitter handles? Is Google seeing these twitter feeds and associating high follower count and high tweet frequency with the URL attached to each account? Has anyone else experienced anything similar? Thanks in advanced! lMbkS
Social Media | | CJSmiles0 -
Need Help in Select Twitter UserName
I need to built a Twitter account for this site: http://www.pilatesboisfranc.com/ I know username can have effect on SEO. Unfortunately, the most popular keywords are not avaliable. Do you have suggestions: I thought: pilatesbf -pilatesBF Can you help? Thank you, BigBlaze
Social Media | | BigBlaze2050 -
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 -
Is there a way on OSE or any other site to find the 50 most socially shared URLs on a given domain?
I'd love to see which URLs on a specific domain get socially shared the most. I know I can use OSE to say figure out exactly how much social sharing has happened on let's say this URL:
Social Media | | Almonds
http://en.wikipedia.org/wiki/Barack_Obama But what if I want to figure out the top 50 most shared URLs across all of wikipedia.org. Is that possible on OSE or anywhere else? If not, do you have some ideas on how something similar could be achieved?0