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 -
Twitter Tool Question
I've been searching for a tool that will allow me to send mass tweets to multiple @accounts? For example, I use Topsy to see who's shared my content and want to send a follow up tweet to everyone who has, but find it time-consuming to do this manually. What I have in mind is something where I can upload a spreadsheet of Twitter names, write one tweet and for this to be tweeted at everyone on the list. I haven't found what I'm looking for so far. Does anyone know of such a tool?
Social Media | | Matt_Wilson1 -
How to Analyze Twitter Followers
I'm working on an infographic and I need a way to analyse the followers of about 25 to 50 industry twitter accounts to figure what type of people their followers are. twittersheep.com used to do exactly this, look at the profile description area of twitter and produce a tag cloud of a given twitter account's followers based on terms from their profile fields. But they are no longer online. Anyone know of another service that does this ? Or can think of another way to get this data.
Social Media | | Klarke0 -
Youtube SEO: Does your channel name / user name matter?
My predecessor left me a gift of what is arguably the worst kind of Youtube channel name: Our company's name condensed to an acronym with some additional gibberish that may or may not have meant something to her. In short: Our channel name will never be searched for, will never provide any ranking boost. Now our Youtube success has been very marginal so far: 31 subscribers, 7,300 video views. Given that situation, should I seriously consider scrapping my channel and starting something new with a keyword targeted channel name? Or does channel name matter so little that I should hold on to my 7300 video views?
Social Media | | AdoptionHelp0 -
What Social Media Buttons/Links When & Where?
Our web development team members are having a debate on when and where to add various social media buttons / links. The crux of the debate is when does adding various calls to social media services become detrimental to page load time. We have really been focusing recently on optimizing page load speed using YSlow and Google Page Speed tools to tweak templates and pages as much as possible. Our webmaster argues that we should be selective on what pages we add Google+, Facebook LIKE, Twitter/Follow buttons. e.g. just 'important' pages such as the home page. Here is a forum link that speaks of this... http://www.webmasterworld.com/google/4358033.htm Bottom line? What are your thoughts on when and where to place various social media buttons and links for Google+, Facebook LIKE and Twitter/Follow. Thanks,
Social Media | | RoyMcClean
Roy McClean P.S. We have pretty much agreed to use AddThis button set on our clients' blog pages that includes FB LIKE and SEND, Google+, Twitter and the AddThis general share buttons.1 -
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 -
I just discovered something about Addthis shares, Twitter, and rel-canonical.
Let's say I have a page on my site with the url www.mydomain.com/page1.php?id=234. Let's say it can be accessed by the url www.mydomain.com/page-this-is-a-keyword-rich-url And let's say that the second example is what I have set as my rel-canonical. I wondered what would happen when people submitted the non-canonical url to twitter. We know that Twitter shares count for something in SEO. I didn't want things to go to waste if people were landing on my short urls and sharing them on Twitter. Well, tonight, I shared one of my own urls on Twitter. I was accidentally on the short one (not the canonical), but when I shared it via addthis the long one was shared. So, Addthis must read the canonical and use this to share. Very cool. At least to me. I may possibly be the only person on the planet that understands what I just wrote, but this is a neat discovery for me.
Social Media | | MarieHaynes5 -
Social Accounts/Networks Multiple account management?
Having tried Yoono and Tweetdeck I'm leaning towards Tweetdeck for ease of use.... Managing 5 facebook accounts, 9 facebook pages and 6 twitter accounts at the moment... Any other suggestions for tool or software I should consider?
Social Media | | JohnW-UK0