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
-
Twitter stats
I am trying to increase the position of one of my deeper links (my site.com/targetpage) trying to use twitter to up this page as a new strategy. I have 18 on OSE for my twitter metrics but none on the deeper link (i havent tried yet for this). How do i actually get the a twitter metric score for this deeper link? Does the tweet have to be the actual target page URL? Or is it a twitter share button on the page? Confused how it works. Thanks, Chris
Social Media | | cjkimber0 -
What should I do on a limited budget of $2,000/mo
Hello everyone I have started a new small business which currently we do only PPC marketing. We are spending roughly $1,700 per week in this medium, and would rather invest this money into getting ourselves organic. I am trying to figure out how we can best invest what money we have without stopping the PPC campaign, as we are only a month old with a limited budget ($2,000 month to spend on SEO). Our website right now has a fair amount of content, and we are blogging 3x a week at around 700-1000 words average per blog. We have zero backlinks at the moment, or at least from what I can see on opensiteexplorer, and of course this is expected. I have used seomoz to optimize my pages, and keyword tool to figure out which keywords we want to go after. Some of the better keywords available seem like it would be very hard to get on Google first page as most of the links are authorative .edu/.gov links. So we dont know exactly where to invest now. All our pages are optimized well via the seomoz tool, we get an A on all our pages for certain keywords. It seems to me the next step would be back links building, but I want to make sure and hire a reputable company (going to use the SEOMOZ recommended list) so we dont have issues in the future. Before doing so I was hoping to get some input from everyone here as to what might be the best path to take on a limited budget. What are my priorities lets say if we could rank them? I should probably mention we are on facebook with 50 likes and about 50 shares via the blogs. We are ranking on some of our keywords (only one first page on bing/yahoo, none on google), but I take this as a good sign for only having this website up for about 10 days. We have another website at first put up really quickly by a friend, then went to our new site. Thanks for the help
Social Media | | DemiGR1 -
What to Post on Facebook for maximum traffic/likes
Hello, I am just now starting on my facebook page for my personal development coaching website. Here it is: http://www.facebook.com/pages/Bob-Weikel-Associates/217292791620485 I have to be careful not to spam my collegues and friends with like requests. How do I get started gaining relevant traffic and likes?
Social Media | | BobGW0 -
Will we penalized for using social media contests to gain fans/followers in the future?
To help build up my company's website, we've been making a huge push in social media and to gain followers on our social pages, we've recently been running a couple of contests. So far it's been a great success - more traffic to the social media pages and more traffic to the website. We are considering making the contests a regular part of our social media & SEO strategy. In the past, our social media strategy has relied completely on "organic" likes (no incentives to follow our company's page) and posted content articles, pictures, etc. In the past month or so, we've began to use giveaway contests as a way to gain followers. Since focusing more on running contests, we've seen a huge increase in actively on our social media pages. We've continued to regularly post content articles, interesting pictures, etc, during the contests, but haven't see the same level of engagement that we do with the contest posts. Right now, it's looking like there is no down-side to running the contests as we're seeing an increase in traffic on the social pages, getting some additional traffic to posts and on our site, but before we start to completely commit to this strategy, I have a couple of questions: Is there a reason we shouldn't continue to run these contest to increase fans and interaction? How likely is it that Google will penalize us in the future for gaining followers through contests (instead of "organic" followers that followed us without an incentive)? There are some fans/followers that are serial contest entrants and are always entering a contest - could having too many of these fans raise a red flag for Google and the other search engines? How often is too often to be running a social media contest? Basically, I want to make sure that we are using social media as a long term SEO tool and are setting ourselves up to be successful in the future and not get penalized for gaining followers the wrong way. Any tips, strategies or advice is very much appreciated. Thank you!
Social Media | | airnwater0 -
Ways to get the most out of your content/blog posts?
I've been working on posting more content on my blog and now I need a workflow to help me get more exposure on my posts. Currently this is what I'm doing: 1- Write Post 2- Add it to my favorites in Stumbled Upon 3- Post it to Facebook 4- Pin it in Pinterest I would love some more ideas. My goal at this point is to gain greater web exposure. I would love to be they type of blog others actively follow.
Social Media | | continuumphoto0 -
Finding google + influencers
I'm trying to sink my teeth into the power (or future power) of Google +. I would like to find people who are already well connected with Google + (in the military space). I can easily find Twitter and Facebook lists to see who is being followed and who the active users are, is there anything like that for Google +?
Social Media | | StreetwiseReports0 -
Which tool you best recommend for Social Media management, engagement, and monitoring. reputeme.com - trackur.com - viralheat.com - sproutsocial.com?
Please consider the pricing, ease of use, and accuracy, also, perhaps the social networks being monitored( as far as I am concern it's only trackur that monitors google+) Also if you have other recommendation, that would be awesome too. Thank you. PS: I love seomoz Social Media reporting, I just have other requirements too. Thanks.
Social Media | | TofSalcedo841 -
Moderate blog comments Yes/No? Facebook comment plugin?
I was reading outbound marketing and they suggest that a good blog "does not" moderate comments. I have always taken the moderate approach, but their thought was this inhibits a conversation from taking place on the blog. I am wondering what thoughts others may have on this and its potential positive and negative impacts, both SEO and in general. Also I am thinking about using a Facebook plugin with my blogposts. I think this may be a good way to help get social visibility... Has anyone tried this yet?
Social Media | | mmaes0