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 to see who shared my link on twitter
I post many blog posts on twitter, but How to see who shared my link on twitter? What I need to search to find out this?
Social Media | | varunrupal0 -
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 -
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 -
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 -
Does social bookmarking still work? If so can anyone recommend a tool
Hello everything, I'm trying to find a tool I can use for my domain : www.van-plus.com to get it socially bookmarked? Can anyone recommend anything? Thanks in advance!
Social Media | | vanplus0 -
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 -
Twitter Username: Keyword or Company Name?
Hello everybody! I'm in doubt with which one is the best: To have a Twitter profile name with: 1)the company's name.
Social Media | | seomasterbrasil
Of course it's good for branding, but it's a B2B, industrial market. 2)a relevant keyword.
Will it bring traffic, considering that is a B2B, that works different. The question is: does Google gives relevance to username with keyword in it? If yes, have it a great value, or should I use the company name? Thanks! =]0 -
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