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 -
On a website, is the most effective user experience for the social media icons to open new tabs?
There is debate around what is most effective for user experience. When a user clicks on the social media icons on our site, should a new tab be opened for the social media page or should the website redirect to the social media page?
Social Media | | Sable_Group0 -
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 -
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 -
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 -
Twitter lists - Transferring from 1 account to another
Hi Does anybody know how to transfer Twitter lists from 1 account to another ? Twitter says this isnt possible but is anyone aware of any software that can do this (or technique) ? Both accounts have the same owner Many Thanks Dan
Social Media | | Dan-Lawrence0 -
When is the Blogscape tool online again?
Can anyone tell me when i can start working with Blogscape, so i can start monitoring my social media? It's out of order for a while now and i am just wondering. Thanks in advance Best Regards Jonas
Social Media | | jonasdenda0 -
Multiple twitter accounts for Different countries...
Ok, so we currently operate in the UK, Australia, Ireland, Spain and France. Currently we have a different twitter accounts for each Country. This can be difficult to manage as we are going it all from the UK. I can understand that having separate accounts for foreign language countries is perhaps suitable (we have foreign staff tweeting in their native tongue), but my question is this: Is it worth just tweeting all English speaking activity from one account. I mean at the end of the day we are one company, and also our activity in other countries won't effect our followers, in fact wouldn't it just make them realise we are a global brand? What are the advantages and disadvantages of gradually deleting the other accounts and tweeting all English stuff from the one account? Cheers,
Social Media | | esendex0