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
-
Open Graph/Twitter Cards
Hi Guys, Quick question is there any benefit/point in setting up FB Open Graph and Twitter Cards for sites which don't have the tags but have social sharing buttons which correctly display the social snippets/descriptions Example: http://tinyurl.com/jaowtkd The page has social sharing buttons at the bottom, which show a description for Twitter.
Social Media | | jayoliverwright0 -
Twitter and Link Juice
Sorry if I am late to the party with this, but I thought Twitter stopped giving sites link juice? I have been running some sites through Open Site Explorer and there main links are coming from Twitter. I have other sites who are on Twitter and nothing comes up. Why is that? Thanks!
Social Media | | ClickIt0 -
Need Help in Select Twitter UserName
I need to built a Twitter account for this site: http://www.pilatesboisfranc.com/ I know username can have effect on SEO. Unfortunately, the most popular keywords are not avaliable. Do you have suggestions: I thought: pilatesbf -pilatesBF Can you help? Thank you, BigBlaze
Social Media | | BigBlaze2050 -
You have a limited budget of $2,000 (US). Do you buy links or create / seed content?
We have a client who is being told by their incumbent supplier that they should renew their annual contract to buy links on 4 domains by their incumbent SEO agency. It will cost approximately $2,000. We are recommending they produce decent content, like a video, an infographic based on data that is exclusively theirs and seed this with bloggers / real world publications / trade press / etc. The client is struggling to make a decision because he's caught between two SEO's with different approaches. He doesn't have the budget for both. He's scared of losing his position in the SERPs. So, I said I'd get some votes from other SEO's. Which would you recommend? Option 1 1,000's of links on 4 domains Option 2 Create link bait Seed using social media GO!
Social Media | | NoisyLittleMonkey0 -
Social Content Posting - Post to Facebook, Google Plus, Twitter and Linked in at the same time
Hi, Is there any means of posting new content for my companies various social profiles in the one go rather than having to log into each one? This would save a lot of time. Thanks
Social Media | | fdep0 -
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 -
Twitter profile: Personal photo vs brand graphic image
We are promoting our company on twitter, and currently using a high quality brand graphic image. We see others who use the personal photo of "evangalist" who manages the twitter account. Any advice on what works best here to encourage user engagement? A more generic "brand" identity graphic versus a real person's photo? Of course this is in conjunction with doing all of the other good Twitter things, but curious what folks recommend on the profile image.
Social Media | | sftravel0 -
Regaining Twitter
Our Twitter account had been hijacked by an ex-employee who refused to give it back. However we filed for copyright infringement and got access of our Twitter account back. The sad part is that Twitter could not leep our followers intact and we lost our fan base of over 30k followers. Now that we have control of the account, how should we go about regaining our followers? Just to give the community a better idea i'd like to point out that we are a leading news organization (dawn.com) of Pakistan. (Yes, we have internet and no we don't ride on camels!). We posted a message on our FB account that has an even greater following but didn't get a good response as most followers on FB are local whereas 70% of our readership comes from the US alone! So how would you suggest regaining followers and also, is it better to operate an RSS feed or manually select the links to share on Twitter. Thanks!
Social Media | | RishadShaikh590