06 Feb 2012

The Easiest Reputation Management Tool (Google Spreadsheet)

UPDATE: The spreadsheet is currently down. We are working on it right now. Please check back!

easy reputation management tool

If you have read my previous articles, you are likely to know that I love tools and tables. If you haven’t, just trust my word or read further.

I’ve been an earlier adopter of Google Spreadsheets for the same reason: they are almost as great as Excel for making cool handy tables and they can be turned into fun-to-use and easy-to-share free tools!

What I am going to share today is one Google Spreadsheet which will make your daily reputation monitoring task a breeze: all you need to do is to copy the spreadsheet, bookmark it and open it daily. Even if you haven’t yet started monitoring your brand name mentions, you will do that from now on. Guaranteed. Just because it’s that easy and fun!

Copy the document

Now let’s start playing.


What Does The Document Do?

Reputation management spreadsheet

The “Easy Reputation Management Spreadsheet” generates search results from three sources:

  • Generic Google search results (30 top results)
  • Google search results for the past 24 hours (30 results)
  • Twitter search results (top 100 tweets)

Each page found in top 30 Google search results for your name has the following data:

  • Tweets (according to Tweetmeme);
  • Facebook Shares; Facebook LIKES; Facebook comments + Facebook total interaction score.

This way you will see how well your brand name does in Google and how actively it is being discussed in social media simply by clicking through Google Spreadsheets tabs. As easy as that!

To use the spreadsheet, simply provide your brand name in the yellow cell in each tab (1, 2, 3):

Reputation management Google spreadsheet tabs

You may want to play with different search operators for more interesting results:

  • Exact match ["brand name"] (works great for the first tab)
  • In-body mentions ["brand name" -intitle:"brand name" OR "brandname" -intitle:"brandname"] (work best for both generic and recent Google search results – first two tabs). In-body mentions are often unlinked, so these often turn into fabulous link opportunity.
  • All search tricks from this old post of mine(“Twitter search results” tab):
    • Filter out RTs ["brand name" -rt]
    • Filter out links to find *real* opinions and discussions ["brand name" -filter:links]
    • Filter out your own Tweets ["brand name" -from:username]

Reputation management: Twitter brand search


Troubleshooting

Tweet count is lower than what your page button shows: Unlike Facebook, Twitter makes it almost impossible to tell  exactly how many times each page has been shared so far. Official Twitter API caches the number and returns some absolutely useless data. Tweetmeme is more reliable but it’s still somewhat inaccurate. That being said, that’s not an exact science. The most important thing is, if there was any interaction at all and how it compares to other sources.

Tweet count shows “Service invoked too many times in a short time: urlfetch. Try Utilities.sleep(1000) between calls.” or other errors: You’ll see errors now and then because there is no perfect way to update scripts or schedule requests from the cells, so if you see such an error try searching for something else. Or re-save the “tweetMemeCount” and “FacebookLikes” scripts by going: Tools -> Script Manager -> Select the script and click “edit” and then “Save” in the new window. This will force the script to re-run.

There are some weird results saying “images for..” or “related to…”: Our scraper may include blended search results, so just ignore them.

Something else is not working? Google changes search results mark-up now and then to kill scrapers (unlike our scraper, there are quite a few malicious ones). Facebook and Tweetmeme API are subject to change as well. So if you want anything to be updated in the document, please let me know by commenting here. I’ll do my best to update the document once anything stops working!


Credits

I am not that geeky to create the scripts myself. So here’s what I’ve been using:

Updates:

  • 2012/2/22: Updated to fit the new Google results. We had to come up with the additional parser to get actual URLs from Google redirects – feel free to copy it for free!

Comments

  1. Dewaldt Huysamen February 7, 2012 at 1:02 AM

    Hi there,

    Facebook likes says unknow function and only displays NAME

  2. Ann Smarty February 7, 2012 at 9:41 AM

    Dewaldt, please see the troubleshooting section. After you have copied the spreadsheet, go to Script Manager (Tools menus), select FacebookLikes scrip, click edit and then (in the new tab where the script editor opens) click “Save” – that will re-run the script on your copy.

    Or just try searching for a different word.

  3. Kirsten February 7, 2012 at 8:05 PM

    Awesome spreadsheets. We use similar ones to set up our campaigns. Google Documents are excellent because you can share them with other users who can edit (or read-only) which is helpful if you have more than one person on a team working on the same project. Thanks for the great article!

  4. Megan February 10, 2012 at 9:37 AM

    I tried opening the google docs link and when I try to “make a copy” that option is grayed out.
    Any ideas?

  5. Ann Smarty February 10, 2012 at 9:50 AM

    @Megan, I’ve just had a few tough moments trying to figure the problem out :)

    Now I got it: you should be signed in into Google in order to copy it!

  6. Sandra February 14, 2012 at 5:04 AM

    Hey Ann,

    Really an amazing spreadsheet!!!!!
    I just have some troubles using it… no matter what word I put in the yellow section 99% of the found Google links starting with “/url?q=http://…” and than I get the answer “Cannot read property “url_count” from undefined.” in the Tweets section and all Facebook parts contain a 0.

    Do u have an idea why?
    Thx a lot :)

  7. jaine February 14, 2012 at 2:17 PM

    hi there! quick question, i’m having trouble getting data from the tweetmeme column. it says “cannot read property in URL_Count from undefined”. but i don’t know how to define it. any help would be great, thanks!

  8. Ann Smarty February 16, 2012 at 1:02 PM

    Hey Jane, please try some tricks from Troubleshooting section of the article ->

    You’ll see errors now and then because there is no perfect way to update scripts or schedule requests from the cells, so if you see such an error try searching for something else. Or re-save the “tweetMemeCount” and “FacebookLikes” scripts by going: Tools -> Script Manager -> Select the script and click “edit” and then “Save” in the new window. This will force the script to re-run.

  9. Ann Smarty February 18, 2012 at 10:43 AM

    Quick update: Looks like our script that fetched search results stopped working. We are on it!

  10. Ann Smarty February 22, 2012 at 3:23 PM

    Update! The spreadsheet is working again! We had to come up with the additional parser to get actual URLs from Google redirects – feel free to copy it for free!

  11. Shaira March 7, 2012 at 3:57 AM

    Hi,

    Google results,Tweets (Tweetmeme) & Facebook Share says: error: Unknown function name GETTARGETURL..

    How to fix this? Any ideas?

    1. Admin Ninja March 7, 2012 at 8:39 AM

      Shaira, please see the troubleshooting section. After you have copied the spreadsheet, go to Script Manager (Tools menus), select FacebookLikes scrip, click edit and then (in the new tab where the script editor opens) click “Save” – that will re-run the script on your copy.

  12. Michael April 24, 2012 at 12:28 AM

    I copied the spreadsheet, and nothing seems to be working on it. I get the following error in the Page Name column: The xPath query did not return any data. I would say the Tweets column is working, except that it returns 0, even for google or twitter as search terms. In the Facebook Shares column, I get: Unreadable response from Facebook: TypeError: Cannot call method “getElement” of null. (line 41).

    I tried going to Tools, Script Manager, but that just pops up a box that says Script Manager and nothing else. I tried going to Tools, Script Editor. This showed me the names of the scripts, but if I click on any of them, they are blank.

    1. Admin Ninja April 24, 2012 at 7:50 AM

      Thanks for the head-ups, Michael! We are working to fix it asap

  13. Thomas Reisser January 8, 2013 at 3:59 AM

    Hi there, is this tool abandoned or are you still working on a fix?

  14. twitter_wildmantweets February 4, 2013 at 2:58 PM

    I too am very interested in whether this post will ever be updated with the working spreadsheet again. I hope so thanks! :)

  15. Per Pettersson January 8, 2014 at 6:38 AM

    Is the spreadsheet working again? I hope so. It would be fun to play around with.

Leave a Reply