Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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 -
Twitter Analytics: Follower Count & Reporting Inconsistencies
Our number of followers on Twitter has suddenly dropped (yet not dropped) in a really weird way. Twitter Analytics shows follower counts in two places: Monthly increases in followers, and then also in the Audience Insights tab, where you can see three months of follower counts mapped in a chart. Month-to-month, the total number of followers continues to rise. What’s inconsistent, however, is the total number of aggregate followers shown in the cart. Twitter just dropped our to total count of followers by about 600. But it’s not like we just suddenly lost 600 followers last month (in fact we gained far more than that), but rather that Twitter seems to have adjusted the aggregate numbers across the board retroactively for all months. So while month-to-month continues to show gains, overall, we still went down. The only way we would have even noticed this, by the way, is because we have a record of the OLD total follower count that Twitter had previously displayed as recently as last month. So confusing. We’re trying to figure out what happened, and the only thing that seems to make sense is that Twitter may have done a huge spam account purge, and instead of making it look like we suddenly lost a lot of followers, they just updated the aggregate total # of followers across all time……? [For the record, we do not buy followers, but we don’t always do the best job at blocking spam followers when the do follow us either.] Any advice would be appreciated, thanks. 🙂
Social Media | | mirabile0 -
Facebook Page - About/Description/General About/Mission - Questions
Hi, Im just setting up a FB fan page for a client How terrible is it to use clients websites home page descriptive copy as the Facebook page long description ? Language is in Turkish which i don't speak so i'm not able to edit a new version of it just for FB and no budget to hire Turkish speaker to come up with something. So was going to copy & paste but that would be duplicate with HP obviously. How important is it to fill in 'Mission Statement' & 'General About' ? Especially if long description likely to already include that info ? I think long descrip is important for FB pages on seo etc etc but a good one eliminates importance of 'Mission' & 'General About', or is it still advisable to fill these in or are they just extra boxes for flexibility ? I take it when it comes to securing a vanity url (once we hit 25+ fans) for a foreign language version FB page it should ideally be brand name (which includes a keyword) in the local/target language ? The page name is already the brand name in English but since contains keyword is it best to rename into local target language similarly to the url for consistency and local targeting or better to keep one in Turkish and one in English ? Many Thanks Dan
Social Media | | Dan-Lawrence0 -
Best option for Facebook Page/Usernames?
Hey guys My first post here! currently trialling seomoz and impressed so far 🙂 My question relates to a choice of Facebook page/username for a client whose preference is to refer to their online business name by the domain name, where this business name includes his two most important keywords. So as an example: firstsecondthird.co.uk Now in terms of seo that's fine as search engines factor in keywords in the domain name, and even referring to domain name in website copy does not seem to pose too many issues. However on Facebook I've noticed that if we go with page name of: FirstSecondThird (obsiously we can't add .co.uk - I've used camel case for readability) then when using the facebook search the page does NOT get listed for any of the keywords as it appears it only matches on whole strings. So I'm going to recommend that he changes Faceook page name to First Second Third (with spaces) even though client does not really like this option. Do you guys think that makes sense? Also if I do make that change should I also go with fixed Username of First-Second-Third i.e. with hyphens or stick with one long string i.e. FirstSecondThird, which matches the domain name? Any advice appreciated. PS hope this is under right topic- several others seemed applicable Thanks
Social Media | | redactuk0 -
Does buying thousands of Facebook Fans/Likes affect SEO?
To begin with, please pardon me if this question is ignorant. I'm completely new to this whole social media thing, and somewhat feel it is overhyped. I find it really difficult to believe that social media will actually help the majority of small business owners out there like me, and that most of them are probably being misled about the powers of social media to increase sales. Because it's mentioned so frequently, I've decided to delve into it a bit more to see how this could possibly help me business. Over the past few weeks, I've become familiar with a company that sells Facebook Likes, Twitter followers, as well as YouTube and SoundCloud plays. Since my official Twitter and FaceBook accounts really didn't have that many followers, I decided to buy a few thousand followers for each account. Initially, I bought them because I wondered what would happen if a customer that visited my online store happened to go to those Twitter and Facebook pages. If I personally see a Facebook page with few followers, I probably wouldn't give them my business. I would want to go with a company that seems to generate a bunch of traffic to their pages. Originally, I only had about 200 Facebook followers (now called Likes, it seems) and maybe 25 Twitter followers. I now have over 12,000 Twitter followers and 2,000 Facebook Likes. I may end up buying more since the service was pretty quick and affordable. I'd like to know if Google factors Likes and followers into it's formula for creating SERPS. Will my website rank higher if I have 10,000 likes, rather than only 200? If so, would it be a notable increase? FWIW, I found that more people organically started following my Facebook and Twitter accounts once I had more followers. I didn't change anything about how I maintained the page; I just had more people following them. One other thing of note: these companies are almost certainly using fake/hacked accounts to like various pages around Facebook/Twitter. You can tell because my Facebook page says some city in Croatia has the most amount of 'likes' of my page. Do you think this might come into play at all? Thanks for any and all help!
Social Media | | CHEATERS0 -
Youtube SEO: Does your channel name / user name matter?
My predecessor left me a gift of what is arguably the worst kind of Youtube channel name: Our company's name condensed to an acronym with some additional gibberish that may or may not have meant something to her. In short: Our channel name will never be searched for, will never provide any ranking boost. Now our Youtube success has been very marginal so far: 31 subscribers, 7,300 video views. Given that situation, should I seriously consider scrapping my channel and starting something new with a keyword targeted channel name? Or does channel name matter so little that I should hold on to my 7300 video views?
Social Media | | AdoptionHelp0 -
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 -
Buying Twitter/Facebook Followers
So i have a client that sends me a link once a week about buying followers for social media profiles. Each time i tell him if it seems to good to be true... then its too good to be true! What are your guys thoughts, experiences, feelings? Here are a few examples: http://www.targetedtraffic.int.tc http://www.fbfandamonium.com
Social Media | | kchandler0
