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
-
Best free twitter monitoring tool to monitor who is not following you back
Hello Mozers Could someone recommend a free monitoring tool to keep a handle on who is not following you back on Twitter?
Social Media | | Catherine_Selectaglaze0 -
Is it possible to get demographic data for a certain section of the website and only that area and not the whole site? Tools? Analytics? Suggestion.
I have a /blog/ section of the site that we would like to have separate demographic data for. But I am unable to figure out the way to create it in a custom report. Is there steps I need to include?
Social Media | | rumster0 -
Looking for new insights on link building for an SEO/Marketing Agency
I work Online Visibility/SEO for a marketing agency and we're looking for new ways to generate higher external links. We mostly do local B2B SEO - as well as our competitors. If anyone knows any great tips for social media, blogging, content, etc. send them over here!
Social Media | | CGR-Creative0 -
Which FREE tools do you use for Facebook Page analysis?
Hello. Could you tell me, which free tools do you use for analysing Facebook Pages? It should connect with FB Insights. (no just information from "outside") thanks a lot 🙂
Social Media | | mysho0 -
Twitter based competition
I have a client who wants to run a twitter based competition. The idea is as follows. tweet the url of your favorite product from clients website, with #hashtag . so potentially there could be 100+ tweets referencing three or four unique urls on the clients website. What I am interested in is there any SEO benefit to be gained from this.
Social Media | | dmccarthy0 -
Twitter campaign - need some feedback
Hi I am helping my wife optimize e-com site selling childrens clothing. I am learning SEO from scratch and have no real computer background (physician IRL). Been doing okay - member here for less then 2 months and are ranking 12th and 14th for 2 main keywords (frontpage) and 4 other keywords on first page (producer names on separate pages) (6th -9th spot). All of course absolutely whitehat. I havent done a twitter campaign yet. just recently opened twitter account but have 3 or 4 followers willing to retweet ( they all have 700-1000 followers in right segment). I have very limited twitter knowledge. Here is my idea and just shoot at it if you think i should do it otherwise: it will be in norwegian but ill do it in english just for you 🙂 follow @companyname(epleskrinet) #childrensclothing (which is name i use for company on facebook) and retweet and take part to have your chance to win a 'giftcard' of x USD. (www.epleskrinet.no) I am planning to put a box/picture referring to competition on frontpage. Feel free to critique me, thanks for help.
Social Media | | danlae0 -
Does it make sense to have one facebook/twitter account for multiple websites?
If you have several different websites with related themes, does it make sense to just have a facebook or twitter page for the company to make managing the account more manageable?
Social Media | | thappe0