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
-
Can you redirect old abandoned Twitter/Facebook accounts?
My client has a Facebook profile and a Twitter account that they have abandoned. These pages also have old branding and we would like to redirect these pages in some way to the current Facebook and Twitter accounts. I did find this article but it's 3 years old and not sure this is works: http://www.thesearchagents.com/2011/12/how-to-do-a-301-redirect-on-twitter-even-though-twitter-doesnt-allow-it/ What's the best way to do this?
Social Media | | RosemaryB0 -
Can I filter the results of an user comparison by language/country?
Is it possible to filter the follower list after comparing the followers of 2 twitter accounts? E.g comparing Twitter acc. A and B, select followers of both, receive follower list --> no language/country filter available. Any chance?
Social Media | | lcourse0 -
Opinions on offering an incentive/discount for Facebook sharing
I often see sites offering a discount for liking their Facebook page, but very rarely do I see sites offering a discount for sharing a link or their page. What are your opinions of this, is it something that Facebook could frown upon? Are people likely to just share, get the discount and then remove the post etc?
Social Media | | azu250 -
What should I do on a limited budget of $2,000/mo
Hello everyone I have started a new small business which currently we do only PPC marketing. We are spending roughly $1,700 per week in this medium, and would rather invest this money into getting ourselves organic. I am trying to figure out how we can best invest what money we have without stopping the PPC campaign, as we are only a month old with a limited budget ($2,000 month to spend on SEO). Our website right now has a fair amount of content, and we are blogging 3x a week at around 700-1000 words average per blog. We have zero backlinks at the moment, or at least from what I can see on opensiteexplorer, and of course this is expected. I have used seomoz to optimize my pages, and keyword tool to figure out which keywords we want to go after. Some of the better keywords available seem like it would be very hard to get on Google first page as most of the links are authorative .edu/.gov links. So we dont know exactly where to invest now. All our pages are optimized well via the seomoz tool, we get an A on all our pages for certain keywords. It seems to me the next step would be back links building, but I want to make sure and hire a reputable company (going to use the SEOMOZ recommended list) so we dont have issues in the future. Before doing so I was hoping to get some input from everyone here as to what might be the best path to take on a limited budget. What are my priorities lets say if we could rank them? I should probably mention we are on facebook with 50 likes and about 50 shares via the blogs. We are ranking on some of our keywords (only one first page on bing/yahoo, none on google), but I take this as a good sign for only having this website up for about 10 days. We have another website at first put up really quickly by a friend, then went to our new site. Thanks for the help
Social Media | | DemiGR1 -
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 -
How to find the Hash tag with more reach?
Hi, every week I want to post one of the Audi cars on twitter http://www.kfz.net/autobilder/audi/ so this week my tweet would be: Alfa Romeo 156 Fotos http://bitly.com/alfaromeo156 #carpics **Question: **I used the hashtag "#carpics" to get some reach. Is there a tool on the internet where I can see how often hashtags are used? eg. should I choose #carpics or #autopics ?
Social Media | | Autoschieber0 -
Hoping someone could take some time to give me some feedback / advice. Thanks!
Hey guys, I want to give you a bit of background to help you understand what I'm trying to do, and the motivation why. I understand that there are a variety of opinions and beliefs regarding what I'm trying to do online, and I hope this post doesn't turn into a list of everyone's views, or a place for someone to say mean / disrespectful things regarding what I'm doing. I feel like this group is a professional one, so I don't think any of what I've mentioned above will be a problem. Last year we were surprised to learn (in the delivery room) that our first child was born with Down syndrome. Not having any interaction with anyone with Down syndrome I had no idea what my new life was going to be like and set out to find some information online (videos, blogs, etc.) I was surprised to learn that there isn't much quality content out there. Much of the information is outdated, cheesy, lame, etc...In fact many of the videos that I found by searching online about Down syndrome were by people making fun of those born with Down syndrome (comedians, etc.) Very few of them gave me any sort of idea what the future over our family was going to be like. A few months went by, I met many many parents and others who personally knew someone with Down syndrome whose lives have been greatly enriched by their interaction. In addition to that I realized that our life was much more normal than I could have ever imagined. In addition I released that there have been tremendous medical advances in the last two decades and today children born with Down syndrome can attend regular classes, attend college, get married, have jobs, and live productive life's. They no longer ride "short buses", forced to stay in special needs classes, or destined to live a life in some sort of institution. I was surprised that our son (at 3 weeks old) was going to physical / occupational / speech therapy at such a young age. The idea today is that children born with Down syndrome work hard at a young age to stay ahead of the curve. I couldn't believe the things they had him doing at such a young age. (At just a few months old they had him on a treadmill so he could get a head start on learning to walk! ----> http://noahsdad.com/treadmill/) All of that to say, I decided I wanted to be an online resource to help give people an idea of what life is really like raising a child born with Down syndrome. I do a daily one minute video where I'm creating an online narrative by telling his story every day.
Social Media | | NoahsDad
I have a growing Facebook page (http://facebook.com/noahsdadcom) and twitter account (http://noahsdad.com/) and our blog readership is growing everyday.
I own a lot of good domains, and am trying to figure out the best way to use them to create awareness. I've been trying to read about SEO as much as I can. I've only been going on NoahsDad.com since May and my page rank is 4. (I'm not sure if that really means anything, but just wanted to share it.) All of the SEO info can be a bit overwhelming and I'm not sure I'm doing things the best way. I was wondering if someone would mind taking a look at my site and I'll be happy to give any info you need (info from google webmaster tools / antlytics, etc…).
I think I'm doing all the 'basics." But I'm not sure what I need to be doing to really step it up. I think the tag line / title page for the home page could be changed up, and perhaps doing some different things on my home page. When I first started my idea was to have a few different categories, Noah's Minute (which is where I was going to put my daily video), resources (posts counting helpful info), Noah's Mom, MD (medical posts by my wife who is a doctor), twitter/iPhone photos (I used one of these catigories and excluded it from my home page to post random pictures form twitter).. Not that I'm 6 months into it, I've relaized that it didn't work out the way I thought at first..every post is a Noah's Minute post pretty much (and lots of twitter pictures)…and the Noah's minute posts could be broken down into sub - categories. Or…I could not have a "noah's minute" category and change my catagories to "resources" "therapy" "toys" "how-to's" etc…and break up what I used to call "Noah's Minute" into those categories..if that makes sense. The reason I didn't do that before is that I wanted someone to be able to watch every video in the order they were created to see the whole story..since I'm doing one minute every day, someone could come and watch his story unfold from birth until present day..but I guess you wouldn't really need a category for that…you could just go to the last page of the blog. The key words I'm trying to rank well for (and I know some of these wont't be possible) are: Down syndrome Down syndrome videos Down syndrome facts Down syndrome information Down syndrome Blogs (I actually own the domain downsyndromeblogs.com as well..I wanted to make a list type website where i list out a lot of the good blogs on down syndrome) Down syndrome families Down syndrome pictures Down syndrome toys (I own this domain also…thinking of doing an amazon affliate page or something..) Down syndrome physical therapy Down syndrome occupitonal thearpy Down snydrome speech thearpy Also there are some mis-spelling of these terms that I would like to try to rank for as well..and I'm not sure how to do that in a post without my post looking like I made an error. I know that is a lot of info, but I wanted to lay everything out there. I'll be happy to post any more details that anyone needs to help me out.
Thanks again and I'm looking forward to the feedback. Rick NoahsDad.com UPDATE: I thought I would include a picture for you guys to see what your dealing with...! 🙂 Warning: His cuteness is contiguous! down-syndrome-cute-boy-halloween1.jpg26