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
-
How long it takes for Twitter carousel to appear under your website in google results
Dear Moz community, Not later than 7 days ago I did impelement twitter markup to a website including : as well as twitter markup to all blog/article posts The question: I mentioned Moz (when you search for this brand name in Google) it shows a recent tweets carousel, how long it takes for it appear on our website and should I do any additional fixes for it to appear ? BWctKyu
Social Media | | admiral990 -
Does anyone have a great way to determine where your new Twitter followers are finding you?
We are enjoying some good success with finding new Twitter followers for our account, but the majority of the new followers do not seem to be coming as a result of our posts. How can I determine where these new followers are finding us? Google Analytics can explain those coming from our website but what about the others? Thanks to all for helping!
Social Media | | tempegov
Kris0 -
Recommendations for a collaborative workflow for an integrated content marketing / social media campaign?
We are currently using an excel spreadsheet that is a homemade checklist of all of the various places we want to post. We take one topic, and we make various formats (video, promotional image, blog article, press release) and we list all of the posts we want to make in all of the channels (Twitter, LinkedIn, FB, instagram, pinterest, etc.). Is there any articles that describe a more streamlined way to do this? We have tried basecamp but looking for other options. We have a small team of about 5 people that collaborate to design, write, and post the content. I was looking for an article that describes the workflow that might simplify the communication and execution of this process. Thanks!
Social Media | | larahill1 -
Social Media Tool
Hello Everyone,
Social Media | | vndflkvnlkzdfnv
I'm trying to find a tool that allows me to post to twitter, facebook and google+ at the sametime. Does anyone have a recommendation? Thanks!0 -
Connecting Twitter accounts?
Does anyone know if it is possible to connect 2 separate Twitter accounts? The marketing department in my company set up the official Twitter feed. However, one of the employees took it upon themselves to set up another one and built up a good following. Now a lot of people are getting confused to which one is the official one. It would be great it we could merge the two, but I've been looking all morning and can't seem to find a way. Any help?
Social Media | | AAttias0 -
Google+ & Twitter, what do I post?
Hello, My site is bobweikel.com What do I post on Google+ and Twitter? How often? Can my posts be the same for all 3: facebook, google+, and Twitter
Social Media | | BobGW0 -
Do you build tools meant to be shared on Facebook?
I have some neat ideas for calculators and fun tools that I'll implement on one of my sites from time to time. I'm not convinced that I am getting the most SEO value out of them however, and would love to discuss what others do. Let's say I create a calculator that let's someone "cartoon themselves" (fictitious example). So, I'd create the tool and then I would put a button in a prominent place on the page to encourage people to share to FB. I configure my page so that the title and meta description are enticing for others who would see the story in their friend's news feed, so something like: I just cartooned myself on example.com! Upload a photo and see what you look like as a cartoon! You won't believe the results! So, this gets me some traffic, but nothing has gone super viral yet. I have a few pages like this that have garnered a few links, but not nearly as many as I would like. I promote the page on digg and other sites as well but this brings very poor returns. When you make a tool like this, do you do a lot of promotion? Have any tips for me? (btw...it's possible that my tools are just not as "shareable" as I think!)
Social Media | | MarieHaynes0 -
What Tools Do You Use For SEO Social Media Audits?
Hi, With a the growing trend towards social media signals starting to have a decent impact on Search Engine algorithms, i'd like to know what tools people use for "social media site audits". I generally use a fair amount of manual observations for social media profiles such as profile completeness. Hubspot offer a few really nice tools over at http://grader.com/ that allows a quick 'score' for an account. I then take a look at the 'buzz' around a company over a few mediums such as Twitter Search, Google blog search, BoardReader, HowSociable.com and SocialMention.com Facebook Insights is good (if you own the domain) for testing the number of likes. Im still yet to see a decent tool for testing entire domains for # retweets, Diggs etc. What are your favourite tools for SEO Social Media Audits?
Social Media | | DigitalLeaf0