5 Essential Spreadsheets for Social Media Analytics. Ann Smarty is a search marketer and full-time web entrepreneur.
Ann blogs on search and social media tools. Her newest project, My Blog Guest, is a free platform for guest bloggers and blog owners. Follow Ann on Twitter @seosmarty. Social media analytics and tracking can be very time-consuming and expensive. You'll find quite a few smart social media monitoring tools, but what if you can't afford them? That's why many social media marketers and power users are in constant search of free, efficient alternatives. Most of the scripts that run the spreadsheets are "public," meaning you can access them from the Tools + Script Gallery menu (this also means they were reviewed and approved by Google Spreadsheets team). 1.
GetTweets is a simple and fast Google Spreadsheet script that lets you quickly export Twitter search results into a spreadsheet. Increase the number of results returned — up to 1,500. Spreadsheet details: Public script? 2. Public script? 3. Public script? 4. Public scripts? Top Ten Favorite Social Media Tools For Daily Use. There are many online tools I use every single day to manage my social media marketing effectiveness.
In my recent interview with Darren Hardy for the May 2011 issue of SUCCESS Magazine, I talked about many of these tools. During our interview, Darren asked if I would put together my top ten list of social media resources for readers of SUCCESS. Of course I said yes – here they are! (It’s a delight and honor to be one of three featured expert interviews on the CD that comes with the magazine, along with Peter Guber – author of Tell to Win, and leadership guru, John C. Maxwell. Here’s my top ten tools: 1. A fantastic free online tool to manage multiple social media profiles, pre-schedule updates for specific days and times, monitor keywords and analyze statistics. 2. The top link shortening service, ideal for Twitter but just as useful for Facebook and even email marketing to track clicks. Plus, be sure to add the bit.ly sidebar to easily shorten and tweet any weblink. How to monitor social media mentions in five minutes a day - TNW Lifehacks. One of social media’s biggest obstacles is the amount of time required to do it properly.
But it is an obstacle that can be overcome if you put some simple and effective processes in place. In this tutorial I’m going to walk you through a system that will help you stay on top of the bulk of your social media mentions. The best part? Once set up, you only need five minutes a day to make it work for you. Step One: Set up a ‘monitoring’ folder The system I’m going to show you makes the most of the bookmark folders function within all major browsers.
In this example I’ve called it ‘Monitoring’ and this is where I’ll store my tools and pre-set searches (the reason for this will become more apparent later in this post). Step Two: Gathering your tools Now that our folder is set up, we can start to pull in the various tools we’ll use for monitoring purposes. The tools you’ll need include: We’re after relevant data, not data for the sake of it. Step Three: Tailoring your search parameters.