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 -
How to promote website/blog on FB, Twitter, Pinterest etc?
Kindly provide me the guide link for FB, Twitter, Pinterest and other important social media websites to learn how to promote website/blog on them
Social Media | | bondhoward0 -
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 -
Customer/Visitor Personas
Hey All; Question regarding visitors; How, and what software should I use for my wordpress website? To gather as much visitor information? I currently use Google Analytic's - Any more thoughts as to what I should be using? Remeber a Mozinar regarding this. Anyone have the link, to video by Randfish maybe? The site is a Music video up loader for underground local bands to put their music on TV. It's for a local MAJOR University Private cable service. How do I get started on getting the persona inter-graded into my website? 😉
Social Media | | smstv
Is is just a a FB API?0 -
Just how popular are some #Twitter Groups
Good Morning from 14 degrees C wetherby UK 🙂 As i sat on my grassy knoll puffing on a pipe overlooking the English country Land I wondered... just how do you measure the volume of users using hash tag twitter groups.... or put another way imagine you say to a client "Ok one idea is to get this friday meal deal promoted on #FF" The client then says... "So how many twitter users use the #FF" It a blunt but legit question & one I couldnt answer right now. So my question is please... "Is there a tool to measure frequency of use with regards to twitter hash tag groups" Thanks in advance 🙂
Social Media | | Nightwing0 -
Twitter - business and personal acount or just one account
Hello, I have a twitter account. Do I need to make a 2nd twitter account for my business? My current username is BobWeikel If I need a 2nd account, what would my username be? My company is called Bob Weikel & Associates. Thank You!
Social Media | | BobGW1 -
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 -
Anyone know if optimal Twitter use frequency for promoting a keyword i.e how much is too much
Have a Twitter account and theres much confusion over Twitters use of planting keywords into posts and have some SEO benefit from this. Wondering if anyone has come accross an effective use of promoting keyterms on by twitter posting and how often is deemed okay? Generally see some twitter users who are obvioulsy promoting keyterms for their buisness or company who put in as much as five to ten posts in any one day for the same keyword, or keyphrase. while this looks spammy surely this is liable to be flagged by the search engines? Appreciate any insights on this.
Social Media | | callassist0