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.
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
-
Links to Social Media accounts, rel=nofollow/follow and rel=me
Hi guys, I just saw this rel="me" attribute and I can't find any reputable recent (within last year) information. I never heard of this and wonder if it's any beneficial in any way. At the same time, should I use nofollow or follow on links from website to social accounts? I've heard different opinions but, again, no recent relevant and trustworthy information. Please, kick me into right direction. However, when kicking, please give me some proof, rather than thoughts 🙂 Thanks!
Social Media | | DmitriiK0 -
How do I remove 11,000 spam facebook page likes received overnight complete with negative ratings/reviews?
My page has 11,000 spammed page likes. Only 250 are legitimate. These spammers are leaving 1 star ratings. Facebook is limiting the number of likes I can delete. I can report some fake ratings as spam but, again, facebook is limiting what I see. Any suggestions on how to proceed? Update: I found a work around for the negative ratings/reviews. I can change the category of my page to "other community" to remove the rating system from the page https://www.facebook.com/changeratings/posts/445471405558046. That still leaves me with 11,000 illegitimate likes that are stealing away from my 250 legitimate fans from seeing our posts. Should I start over?
Social Media | | jstallings0 -
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 -
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 -
Permanent URLs for Twitter?
Hi everyone - The site I am working on is going to start giving users the option to tweet that they completed an action. It reads, for example, "I just took the first step to ( ) with (site): (shortened link) via (Twitter name)" Here's my question: Should I worry about the fact that the shortened URL (we're possibly going to use Twitter's shortener T.Co, but I'm not dedicated to it) changes each time? Should we instead have a permanent short URL for the homepage (where we are going to direct people who click the link in the tweet)? Thanks!
Social Media | | JohnECF0
