background preloader

5 Essential Spreadsheets for Social Media Analytics

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? 5.

http://mashable.com/2012/02/09/social-media-analytics-spreadsheets/

Related:  Tech BLog

WordPress SEO: The Only Guide You Need Last Update August 3rd, 2014 As many of you will know, I love WordPress. I use it on most of my affiliate sites which make me thousands of dollars per month and I also use it on my blogs, such as this one. I’m certainly not alone when it comes to utilising this CMS though — tens of millions of sites online are powered by the software. Neuroscience Makes Strong Case for Engagement, Personalization in Marketing Recently, Facebook sponsored a study run by NeuroFocus -- found via Search Engine Land-- intended to quantitatively determine how people respond to websites and website ads. The results had some interesting findings for marketers who are wondering how their site structure and ad campaigns affect how users react to their website. Let's just dive right in to those results and see what marketers can learn from their experiments. What the Study Looked At NeuroFocus used devices to measure the brainwaves of searchers when visiting websites, and looked to see if any patterns emerged.

20 free tools to evaluate social media These tools are not for measurement, but instead evaluation. They will give you some form of meaningful data to use in reports—plus they don’t cost anything. This is by no means an extensive list. Others exist, but even a few of them together will provide you with meaningful intelligence.

4 Unique Approaches for Measuring Social Media ROI Krista Neher | February 15, 2012 | 2 Comments inShare103 A look at the creative ways to measure (or at least validate) your social media efforts. Yahoo's New Visualization Beautifully Shows What's Happening on the Web Yahoo has launched a new webpage that visualizes what's happening on the web in near real time — and it's totally beautiful. The Content Optimization Relevance Engine (C.O.R.E.) HTML5 site hopes to show users the "behind the scenes" process Yahoo uses to match readers with content on their personalized homepage, using technology developed in a Yahoo research lab a few years ago. While Yahoo's homepage used to be arranged by editors, it now uses an algorithm to match individual user preferences. "We can provide users with insights through the lens of the 700 million users that come to our site each month," Todd Beaupre, Yahoo's senior director of product management, personalization and social platforms, told Mashable.

The Most Flexible Recent Posts Widget Plugin for WordPress Recently I had a client that needed to display a grid of images in a sidebar widget, each one of which would link to a different page. Previously they had hard coded all the images and links as HTML in a text widget but this was understandably a pain for the client to maintain and update. I previously used Special Recent Posts as my go-to plugin for this type of thing (although I’m not sure it could handle Pages) but the free version is no longer being updated so I needed a new solution. Fortunately I found the Flexible Posts Widget plugin – the best featured posts widget I think you’ll ever need.

Advertisers, This Is What an NFL Fan Looks Like [INFOGRAPHIC] Just two NFL teams will remain after Sunday's league semifinals, setting up a final showdown for Super Bowl XLVI glory. But the Super Bowl isn't just a huge event for the players, coaches and fans involved. It's also make-or-break time for the television advertisers who pay a premium for the right to reach an audience of more than 100 million rapt viewers. But exactly who will these advertisers target? And what will they spend to do it? 2 ways to measure social media successfully Social media measurement was one of many hot topics in 2011. Chances are it will be a hot topic in 2012, and every year thereafter until we have a standard set of metrics for brands to use. Unfortunately, there is a slim chance we will find a standard set of metrics for every brand. Brand goals differ, as do the metrics tied to those goals. It has been this way in public relations for years, and will likely be the same for social media as well.

What the media can learn from Facebook Facebook sees content as an abundant resource to learn from, value and exploit, says Jeff Jarvis. Photograph: Justin Sullivan/Getty Images What if we in media are not in the content business? Oh, yes, we will produce content; that's what we do. Web App Analyzes Tweets in Real Time for a Record of Historic Events If you've tweeted a lot about the Occupy movement, the Syrian Protests or the Egyptian Revolution, Twitris may have considered what you said and recorded it. Dr. Amit P. Google, Yahoo Both Fail At Moneyballing Oscar Predictions Both Google and Yahoo used search data to create their own Oscar ballots. Turns out, their predictions were terribly wrong. At best, Google may have correctly predicted Meryl Streep winning, depending on how you read things. But overall, neither of them really got the winners right.

40+ Social Media Dashboard Tools for Tracking Stuff As part of my on-going work developing social media for business units, I’m often asked about what types of tools I used for tracking all that ‘social media stuff.’ Let me talk about how I go about creating a social media dashboard The basic answer is that I don’t have one tool (I have dozens, if not hundreds.) The real answer is that I am not tracking social media. I am tracking key performance indicators (KPI) I don’t care if it is a shipping problem or a viral YouTube video.

Related:  Chiffres & Usagescose utiliTools