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.

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 @sarahgoodall and I'll add you to my list :-)

Originally Posted on Tribal Impact - How to Build a Twitter List of Your Employee Advocates

Sarah Goodall is the Managing Director of Tribal Impact. She has spent 20+ years in B2B Marketing, most recently leading social business for SAP in EMEA where she trained over 3000 employees as part of the global social selling and advocacy program.  She believes that organisations need to shift their focus from social media marketing towards conversation led marketing. After all, people talk to people…not logos.  Through training, tools and content Tribal Impact focuses on supporting B2B marketing and communication professionals that are ready for this new approach to social media.