How to Build a Twitter List of Your Employee Advocates

I've had a little fun this afternoon - well, it's Friday after all!  I'm trying to build one list of SAP employees on Twitter so that I can tune into what they're interested in and also figure out who our top employee advocates are in the business.  Pretty crucial if you want to build a brand advocacy program. Thanks to the help of a few useful tools my tasks didn't take me too long either so happy days.  I wanted to share the process on my blog - partly so I don't forget in the future and partly because I thought it might be useful for others looking to learn how to build a Twitter list.

If you are interested in setting up your Social Media Policy, click here to download our FREE Social Media Policy eBook to help your manage your online reputation.

Here goes...

• If you need to find employees on Twitter then I suggest you take a look at the search functionality on FollowerWonk - a nice little tool that allows you to search for keywords in the bio field of Twitter accounts.  You'll get some unwanted results but by and large, it's pretty accurate.
• 
• Otherwise, search Twitter for existing lists.  Chances are that someone else may already have compiled a list of people relating to your company.  There are some great tips on how to do this on this blog post.
• I found a few different SAP Employee Twitter lists on twitter so I used a smart little tool that allows you to copy other people's Twitter lists into your own Twitter account so you don't have to follow people individually nor create a list from scratch.  It's really quick.

• Once I created my own version of the lists in my Twitter account, I pulled them up in SocialBro and exported each list into an Excel Sheet.  I copied and pasted the Twitter Handle columns from each into one worksheet and ran the command that identifies duplicate entries some really easy instructions on how to do that here.

• Now I can see all the duplicates and all the ones that are unique - which are the ones that I need to add into my final list on Twitter.  I copy and paste all of those into one column on a spreadsheet and save the file as a .txt file.
• I went back into SocialBro and imported the .txt file as a new list on my Twitter account - nice and simple when you watch the video in the link.

• I then added them all to one of my existing lists - I used the biggest list I copied over at the start of this process (which happened to be @jbecher SAP list).
• So, now I have a consolidated list of SAP tweeters all in once place - unless I've missed anyone.  If I have, tweet me and I'll add you to the list :-)