Today I’m going to show you a pretty cool trick that allows you to create a Yellow Pages-type directory from your Twitter followers, just by using the export function within SocialSafe and applying some fairly simple Microsoft Excel filters.
People often use Twitter to try to connect with and find people who may be able to help them in some way, and you’re more likely to get a response to a DM than you would if you just posted a lone tweet into the vastness that is Twitter.
Here’s what to do:
(Before you start, make sure you sync your SocialSafe journal so that you are working from the most recent data)
- From SocialSafe, use the left hand navigation to go to Accounts
- Click on ‘Select content to view’ and then click on ‘Followers’
- Click ‘Export’ and select where you’d like to save the CSV file on your machine
The rest of the instructions refer to Microsoft Excel, but it should be easy enough to work out the equivalent functions for other applications.
- Once you’ve opened the worksheet, add filters to the columns by clicking (from the ‘Editing’ section of the Home tab) ‘Sort & Filter’ > ‘Filter’.
- Locate the ‘Description’ column (usually E) and from the drop-down menu select ‘Text Filters’ > ‘Contains…’
- Enter your keyword (perhaps ‘marketing’, ‘journalist’ or ‘C++’) and hit ‘OK’.
Hey-presto, you have now found everyone following you who has your keyword in their description. You can also refine this by applying the same filtering logic to other columns, such as ‘Location’. If you were on the hunt for key influencers or wanted to see how much their opinion may be worth, you can also sort your filtered results by how many followers they have.
I’ll be the first to admit that it’s by no means perfect, nor is it an exact science. But once you know what you’re doing with the filters it’s easy enough to play around with the search terms to find people who may be able to help you in a neat and timely fashion.
We hope you find this guide to be useful, and if any of you out there have managed to come up with your own uses for exported data from SocialSafe, please share them with everyone else by leaving a comment.
Woah! I’m really enjoying the template/theme
of this site. It’s simple, yet effective. A lot of
times it’s hard to get that “perfect balance”
between usability and visual appeal.
I must say that you’ve done a very
good job with this.
Also, the blog loads super fast for me on Internet
explorer. Superb Blog!
When I initially commented I clicked the “Notify me when new comments are added” checkbox and now
each time a comment is added I get four e-mails with the same
comment. Is there any way you can remove people from that service?
Bless you!
You actually make it seem really easy with your presentation but
I to find this topic to be actually something which I feel I might by no means understand.
It seems too complicated and very huge for me.
I’m taking a look forward in your subsequent post, I will try to get the
hold of it!
I totally think that cable television is going to go away.
Or at least have to change with the times.
Hi, I wish for to subscribe for this blog to obtain most recent updates, therefore where can i do it please help.
Hi there! This post couldn’t be written any better! Reading
this post reminds me of my old room mate! He always kept
chatting about this. I will forward this write-up to him. Pretty sure he will
have a good read. Many thanks for sharing!
Usually I don’t read article on blogs, but I wish to say that this write-up very
forced me to take a look at and do so! Your writing taste has been surprised me.
Thank you, very nice article.
Nice blog! Is your theme custom made or did you download it
from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out.
Please let me know where you got your design. Many thanks
My partner and I stumbled over here from a different web
page and thought I may as well check things out. I like what I see so i am just following you.
Look forward to exploring your web page repeatedly.
Wow that was strange. I just wrote an extremely long comment but after I clicked submit my comment didn’t
appear. Grrrr… well I’m not writing all that over again.
Anyhow, just wanted to say superb blog!
We’re a gaggle of volunteers and starting a brand new scheme in our
community. Your website provided us with valuable info to work on.
You’ve performed a formidable job and our whole group will probably be grateful to you.
I don’t know whether it’s just me or if everyone else experiencing issues with your site.
It appears as though some of the written text on your
posts are running off the screen. Can somebody else please comment and
let me know if this is happening to them as well?
This might be a problem with my browser because I’ve had this happen before.
Kudos
Checking out the Domestic Galleries along America’s Eastern Shoreline is a wonderful
strategy to embrace the region’s diverse beauty.
I love tools such as this. I have the exact unit.
But the strength will get worse because it
will get older.
This law is inplace to protect both consumers and lenders.
Now that doesn’t mean that you can fetch SMS text how to get a pay day loan is up to 100 for the short period of time.
Reblogged this on salesgamechanger.
This is great, thanks… 🙂
A reblogué ceci sur Philippe TREBAUL on LINKED IN (WORD Press) and commented:
Add your thoughts here… (optional)