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.com / referral - What is it?
Hi Moz community! Coming to you today to ask a two fold question about a mysterious source/medium combination and also social medium data in general. First question relates to the attached image named 'Facebook Referral.' We've made sure to apply correct tags to all of our campaigns, both organic and paid, and are having a difficult time figuring out where this source/medium comes from which is a bit troubling as it actually has pulled in some revenue over the past couple of months The second question is around general Facebook data. Our Facebook business manager is vastly over reporting clicks to landing pages. For instance, we saw about 1,700 clicks to site as reported by Facebook business manager, whereas Google Analytics only registered about 950. I know data between the two channels rarely lines up perfectly, but this seems like a rather wide variance. Can someone help me to understand this, and let me know if there is anyway to reduce the occurrence of one or both of the issues we're facing. Thanks! referral.PNG
Social Media | | amichaels0 -
Can you redirect old abandoned Twitter/Facebook accounts?
My client has a Facebook profile and a Twitter account that they have abandoned. These pages also have old branding and we would like to redirect these pages in some way to the current Facebook and Twitter accounts. I did find this article but it's 3 years old and not sure this is works: http://www.thesearchagents.com/2011/12/how-to-do-a-301-redirect-on-twitter-even-though-twitter-doesnt-allow-it/ What's the best way to do this?
Social Media | | RosemaryB0 -
Tool like Followerwonk for Facebook?
Hi For Twitter using Followerwonk you can gauge the influence on what a person/brand is using a tool like Follwerwonk helping you find the most influential twitter users based on a number of metrics. But is there a similar tool for Facebook which shows which brands/companies Facebook sites have the most influence. Or is the best way to gauge this is just on their number of likes? which is not really accurate
Social Media | | ocelot0 -
I have 3 different niches - Should I create 3 different Social Profiles/hubs?
So I have 3 completely different niches. As in B2B vs. B2C, as well as markets that are not related whatsoever. Unless your grandmother that likes to sew, just so happens to also love to demolish giant buildings (lol, I never thought about how polar opposite my niches were until I re-read that sentence). Anyways, I guess the company should also have profiles/hubs, but what about for Outreach? I feel like outreach should be done by a personal profile, since outreach is all about networking and building relationships. Any direction/help/tips here? Thanks everyone, Tyler A.
Social Media | | TylerAbernethy0 -
What is the most effective way to keep spam out of twitter
When using twitter for business how to we prevent phishing and spamming issues, or at least minimize them
Social Media | | BrianScott0 -
How do you generate followers on twitter?
Hi, How do you generate followers on twitter? I see a lot of people are saying follow others to gain more followers, use #tags and engage with other peoples tweets. But with the last point, all the tweets I find under search are spam. As an example, if you searched 'SEO' all you are going to get is lots of ' view this article' type tweets. It's almost like there is more business/spam then actual real people. Cheers
Social Media | | activitysuper0 -
Best way to set up a directory / list site?
I have a domain called DownSyndromeBlogs.com There is nothing there now, but what I want to do is create a directory type site where I list lots of different blogs about Down syndrome (my son was born with Down syndrome, so it's a passion of mine.) Is there a good way to use that domain other than just a simple directory? Is it worth it to do some sort of "all top" like site? Maybe listing the RSS of each blog and pulling in a spinet of info? Or have people rank and view them? My purpose for buying the domain was two fold: 1. To give people searching for blogs about Down syndrome a good list of where to find them, and 2. To help direct people back to our site about Down syndrome, NoahsDad.com Another thing I was thinking about was somehow asking people to submit their site to DownsyndromeBlogs.com and perhaps ask for their email address or other contact info (since the people wanting to put their blog on the list would be the same people I would want to know about my main blog - NoahsDad.com) Or maybe there is another thing I'm missing all together..like making that some sort of 'social network' or buddy press for people wanting to blog about Down syndrome..but there are already many other sties out there like that. One thing I was curious about is SEO...if it's not a blog, and i"m not constantly putting up new and fresh content, will anyone ever be able to find the site via google search? (If that makes sense.) If I just do a directory page the page will be some what static and only updated when I add a new url. I'm open to any feedback / suggestions/ advice. Thanks.
Social Media | | NoahsDad0 -
Impact of URL shorteners in Twitter feeds
Hello, Will use of URL shorteners [bit.ly/tiny.cc or equivalent] in Twitter feeds impact the rankings of a target pages? As I understand it Twiitter links are automatically generated as nofollows so I am assuming the published link is irrelevant. Is this still the case? If we do continue to use URL shortereners should we look at branded URL-shorteners to provide link context? Thanks.
Social Media | | Urbanfox0