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
-
Facebook.com / referral - What is it?
Hi Moz community! Coming to you today to ask a two fold question about a mysterious source/medium combination and also social medium data in general. First question relates to the attached image named 'Facebook Referral.' We've made sure to apply correct tags to all of our campaigns, both organic and paid, and are having a difficult time figuring out where this source/medium comes from which is a bit troubling as it actually has pulled in some revenue over the past couple of months The second question is around general Facebook data. Our Facebook business manager is vastly over reporting clicks to landing pages. For instance, we saw about 1,700 clicks to site as reported by Facebook business manager, whereas Google Analytics only registered about 950. I know data between the two channels rarely lines up perfectly, but this seems like a rather wide variance. Can someone help me to understand this, and let me know if there is anyway to reduce the occurrence of one or both of the issues we're facing. Thanks! referral.PNG
Social Media | | amichaels0 -
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 -
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 -
Changing FaceBook Username / url - do you retain your likes/fans
hi just a quickie, anyone know off hand when you change your FB username/url do you retain or lose the likes/fans ? cheers dan
Social Media | | Dan-Lawrence0 -
Tool like Followerwonk for Facebook?
Hi For Twitter using Followerwonk you can gauge the influence on what a person/brand is using a tool like Follwerwonk helping you find the most influential twitter users based on a number of metrics. But is there a similar tool for Facebook which shows which brands/companies Facebook sites have the most influence. Or is the best way to gauge this is just on their number of likes? which is not really accurate
Social Media | | ocelot0 -
My Twitter Username was CHANGED by Twitter!
My twitter user name australia was changed by twitter to Australia1_ My original user name has been given to Toursim Australia. I never saw any correspondence about this from Twitter (I may have deleted it), nor from Tourism Australia. I have managed to send 2 related support requests to twitter; Once explaining I couldn't log in - and their reply was; "The email address you're writing from does not match the email on this account. For privacy reasons, we can't offer any more information about the email." Second time that my account was suspended - they replied; "If you're writing in about Australia1_ being suspended, this account is not currently suspended" I don't believe this can be a trademark issue because you cannot trademark a place name. I would love an explanation from twitter- Any tips?
Social Media | | RR5000 -
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 -
Are links from Pinterest 'do follow'/do they have any SEO benefit?
Afternoon all, I know there is a question about Pinterest that was asked in February but I guess it was a fairly new beast then and people were still unsure about its use for marketing/SEO etc. I run an events business and on our Pinterest profile I tend to pin random stuff I find on the net, themes we are running (directly from our website) and other Pinterest users. I have received several 're-pins' and people are really starting to follow us now. What I am keen to know is whether or not having lots of followers/re-pins on Pinterest has the same effectiveness from an SEO perspective as having lots of Facebook/Twitter/Google+ followers and whether or not these re-pins are 'do follow' links or have any SEO benefit whatsoever? Many thanks Rob ps: Pinterest page is http://pinterest.com/eventa/ , if anyone has any tips on how to better utilize this then that would also be greatly appreciated 🙂
Social Media | | RobertHill0