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
-
Social Media / Articles
Hi Mozzers, I have a couple of questions regarding starting out into social media with an e-commerce website. Most of my experience lies in niche content where a social media following is more natural. Having completed most of the site audit (at least the planning). Its time to begin planning the next move into writing articles on the blog and heading out into social media to facilitate link building whilst i finish off creating the last of the updated website content. I have plenty of subjects I can think to write about and many keywords to target with articles on the website. But I could do with some advice linking this into social media. We have youtube, google+, facebook and twitter accounts but all of them are inactive bar profile information and have almost no following. We sell technical measurement equipment across a selection of niches. My plan is as follows so far, 1. Write 5-10 amazing new articles across the selection of products
Social Media | | ATP
2. Link to them all on each social media platform to begin populating each with content
3. Populate the website homepage with links to all our social media accounts to encourage following
3b. Include adverts stating discount codes etc can be obtained by following us on social media a little unsure where to progress from this point, I have no budget available at the moment, but may be able to obtain some if I can achieve some results without. As always thanks for your time.1 -
How google find, if google + likes were fake?
How google find, if google + likes were fake? Is there any negative effects of it? For example, I have 300 google accounts, can I manually make likes?
Social Media | | bondhoward0 -
Best tools to create facebook landing page
Hello Mooooooooooz fans ! Oye, does anyone recommend a tool that can easily create and integrate landing pages ? Tks a lot !
Social Media | | JoomGeek0 -
Is there Anyway of finding out a companies facebook shares?
Is there anyway of finding out a companies facebook shares. When I checked out a competitor of one of my clients who seems to be very well placed without many links I discovered that they have over 298 facebook shares on Open Site Explorer but when I look at their site or search on facebook I cannot find any business facebook page for this company so I am really intrigued to find out where they are getting these shares from? Does anyone have any ideas?
Social Media | | dashesndots
Many thanks Tracy0 -
Any facebook likes/shares/activities analytics tools
From time to time I take a look at competitors' website and the activities on their social media channel like facebook. There are many times that their facebook likes increase much faster/more than we do while I havenot been able to figure out why they get likes much more that we do. Compared with the competitors we have very similar activities: uploading content to facebook daily and have competition every week and answer every question about our services and have faq session sometime I think our content/information are even more valuable than our competitors. I think they are possibly doing something more value-added to be able to target more people? Is that any tools that I can use to get any insight? e.g. some activities that I am not able to see? Have done some research for last few weeks but I did not manage to findout. Thanks
Social Media | | LauraHT0 -
Does promoting a new page on twitter/facebook help it get indexed faster?
I know this probably won't matter much to people who get crawled on a regular basis, but for those of us who don't, does promoting a new page on social media help it get indexed faster with google? My site rarely gets crawled, but I've recently been adding new content. When I add new content I started to promote it on facebook/twitter and I do get minimal traffic from it. I noticed that a couple of the pages seem to be indexing quicker than pages normally do for me, although I'm not sure if it's because I recently migrated to WP or what..? I know T/FB are no follow sites, but is there a chance that promoting a page may contribute to the pages getting indexed? Thanks for any insight you can shed on the matter. It's more for curiosities sake than anything else. Pete S.
Social Media | | psokoloski0 -
Find Facebook Likes and Google +1's Across An Entire Domain?
Does anyone know a good way to find the number of Facebook Likes or Google +1's across an entire domain? It looks like SEOMoz only shows these metrics for individual pages.
Social Media | | SparkplugDigital0 -
What is my user id on facebook
can someone please help I have being trying to find my user id on facebook for days now & i keeo coming up with so many diff answer 😞 I understnad my username is /glenbobquinn but because i have a user name my id is not easilty accessible Then people say hover over your profile pic and it should be in the bottom left of the screen this is what comes up https://www.facebook.com/media/set/?set=a.1416315126608.2054849.1194488854&type=1 So can anyone please tell me my **user id ** Thank you kindly
Social Media | | Socialdude0