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. Social media analytics and tracking can be very time-consuming and expensive. 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. FacebookLikes script evaluates Facebook user interaction for any given range of URLs. Facebook like count.Facebook share count.Facebook comment count.Overall Facebook interaction. 3. 4.

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. Here they are: 1. Gives you stats on websites, including global rank, country rank, number of sites linking in, and good basic audience data, including demographics. 2. Like a lot of services, Amplicate operates a “fermium” model. Amplicate also has a blog with useful information. 3. Board Reader will search for mentions across forums (including sites like Quora) and will also churn out a chart based on mentions over time. 4. Along with companies like Radian6 and Lithium, the Canadian research firm Sysomos is one of the giants in professional sentiment analysis. We’ve had periodic problems connecting to the site, but when it’s live, the site is good for a free service. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.

10 Tips for Creating a Social Media Policy for Your Business Policy. It can be a dirty word, especially in social media communities. Why? However, great social media policies support, protect and empower high-quality engagement. As Beth Kanter writes, “Trust is cheaper than control.” This article will explain how social media policies differ from other policies and give you 10 tips to help create an effective social media policy. Why Social Media Policies? Social media policies are different. The risks are uncertain. Given an uncertain environment and unclear risks, how do we move forward? There are hundreds of sample social media policies on the Internet. However, in order to create policies that work – really work – we must first lay the groundwork. Here are 10 strategies you can implement today. #1: Gather Your Team A social media policy cannot be written by one person alone. A team approach ensures that key areas of risk are managed properly and that any future challenges that may arise are handled appropriately. #2: Focus on Creating Culture

Facebook Lets Businesses Plug In CRM Email Addresses To Target Customers With Hyper-Relevant Ads No one got just how powerful it was that Facebook recently said it would allow ad targeting to lists of email addresses. Today at the Dreamforce conference it became clear, as Facebook ad chief David Fischer formally launched “Custom Audience” ads and how they tie into CRM. I’m convinced they’re going to be hugely profitable for advertisers and Facebook. Why? A hotel company like Starwood has email addresses of its customers and could target “Come stay at the luxurious St. On August 30, Facebook told press that Custom Audiences was coming, but now it’s live with eight ads providers. Salesforce who brought in Fischer for its Dreamforce conference is uniquely suited to take advantage of custom audience ads because it owns both its massively popular eponymous customer relationship management system, but also a Facebook ads buying system Brighter Option that it got with its acquisition of Buddy Media this summer. Here are a few more examples of industries that could use custom audience ads:

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. Communications professionals should be leery of approaches that encourage them to measure social media like we measure advertising, or any other communications discipline. Not only do AVEs assume that PR and advertising carry the same value within an organization, but the math behind some of the calculations is suspect at best. If it's unlikely that we will find a standard measurement method and unwise to measure social media as we do other communications disciplines, what can we achieve? 1. 2. What measurement challenges have you faced? (Image via)

The Social Media Salary Guide [INFOGRAPHIC] Social Media Week is upon us, so we thought it would be appropriate to delve into the social media industry and see how its salaries stack up. Social media is an evolving and cutting-edge field, so it should come as no surprise that you can make a great living managing a brand's presence on Twitter, Facebook, YouTube, Tumblr, LinkedIn, Google+, Pinterest, Instagram, Foursquare and other social platforms. In the infographic below, produced by OnwardSearch, you can see where the social media jobs are concentrated, the breakdown of job titles in the industry, and how much dough the average social mediate is bringing home each year. (The graphic shows the 25th and 75th percentiles for salary, pulled from Indeed). Does this stack up with what you've seen in the industry? Infographic courtesy of OnwardSearch Every week we post a list of social media and web job opportunities.

Google acquiert Wildfire, spécialiste du marketing des médias sociaux Pour consolider son marketing des réseaux sociaux, Google vient de se payer Wildfire. Google a acquis Wildfire Interactive, une société de marketing des médias sociaux, visant à créer de nouvelles opportunités de business pour ses clients. Fondé il y a quatre ans, Wildfire se situe à Redwood City, en Californie, et aide les marques à optimiser leur présence sur les différents réseaux sociaux. La société offre une plate-forme logicielle qui s'intègre directement avec Facebook, Twitter, YouTube, et LinkedIn. Un certain nombre d'entreprises de technologies sont à la recherche de perles dans le monde des start-ups qui les aideront à offrir à leurs clients un moyen de gérer leur présence sur les réseaux sociaux. Mieux accompagner les entreprises sur le Web 2.0

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. With that said: when I think about creating a social media dashboard or using a platform to track results… I am looking at several unique business identifiers that define what tool I need for the job at hand. Who is going to use it? All of the strategy in the world boils down to getting it done. Unfortunately the tools for ‘Getting It Done’ are vast and complex. The following list of tools will hopefully lead you on your way. Basic, out-of-the-box thinking services Quick & Easy ‘good stuff’ (+FREE)

Social media - Social commerce revenues will grow sixfold in five years, says a new report While few retailers have reported sustained success with selling products on Facebook, social commerce is set to take off over the next five years as consumers and retailers become accustomed to buying from social media storefronts, according to a report by consulting firm Booz & Co. The report, “Turning ‘Like’ to ‘Buy’: Social Media Emerges as a Commerce Channel,” estimates that social commerce sales will reach $5 billion worldwide this year, with $1 billion coming from the United States. By 2015, social commerce sales will total $30 billion, with $14 billion coming from the United States. The report defines social commerce as a channel in which consumers make purchases within a social network’s platform, rather than at a retailer’s e-commerce site. And the estimates include only so-called hard goods, such as electronics, apparel and movie tickets, and not services such as a cable company offering movie downloads.

» WiziShop réinvente le Social Commerce en lançant Tilyx, un service de chat facebook Il y a des jours très importants dans une vie. Des jours que l’on attend avec impatience, que l’on a envie de partager avec le plus grand nombre… Aujourd’hui fait partie de ceux là. Cela fait plusieurs mois que nous travaillons en secret sur un projet de Social Commerce très innovant et il est maintenant temps de vous le présenter ! Comme vous le savez, l’e-commerce devient de plus en plus social. Impossible d’imaginer un site qui ne présenterait pas au moins le bouton « J’aime » de Facebook et le bouton « Tweet » de Twitter sur ses fiches produits. Avec l’expérience de nos 1500 e-commerçants, nous nous apercevons régulièrement qu’il est difficile de faire du commerce au sein de Facebook (par exemple en créant une boutique sur sa page Fan) alors la solution serait plutôt de faire entrer Facebook au sein de son site marchand ! En effet, nous avons décidé de créer un module accessible (bien évidemment) à tous les utilisateurs de WiziShop (sans surcout !)

Topsy - Real-time search for the social web With iOS 9, Search lets you look for content from the web, your contacts, apps, nearby places, and more. Powered by Siri, Search offers suggestions and updates results as you type. There are two ways to use Search on your iOS device. Quick Search Drag down from the middle of the Home screen and type what you're looking for. Siri Suggestions Drag right from the Home screen to show Search and get Siri Suggestions. Get Siri Suggestions Siri Suggestions include apps and contacts that you might be interested in. You can use Siri Suggestions with iPhone 5 and later, iPad Pro, iPad (4th generation) and later, iPad mini (2nd generation) and later, and iPod touch (6th generation). Change search settings Go to Settings > General > Spotlight Search. From here, you can turn Siri Suggestions on or off and choose which apps to include in your searches. If you don’t want Siri or Spotlight to suggest nearby locations, go to Settings > Privacy > Location Services. Last Modified:

Turning “Like” to “Buy”: Social Media Emerges as a Commerce Channel Turning “Like” to “Buy”: Social Media Emerges as a Commerce Channel by Matt Anderson, Jennifer Brusa, Jerell Price, and Joe Sims Published: January 19, 2011 The market for social commerce (s-commerce) will explode over the next five years as companies race to establish stores on social networking sites. As this growth surge happens, social commerce will take its place alongside stores, telesales, and the more traditional Web to emerge as a significant sales channel in its own right. Loading... Matt AndersonJoe Sims Jerell Price Jennifer Brusa Perspective Turning “Like” to “Buy” Social Media Emerges as a Commerce Channel Contact Information BerlinDr. ChicagoJennifer BrusaAssociate+13125784550jennifer.brusa@booz.com DallasJoe SimsPartner+12147126636joe.sims@booz.com DubaiKarim SabbaghPartner+97143900260karim.sabbagh@booz.com DüsseldorfRoman FriedrichPartner+492113890165roman.friedrich@booz.com FrankfurtOlaf AckerPartner+496997167453olaf.acker@booz.com Booz & Company Show transcript Commo

Facebook Analytics Now Available from PostRank PostRank, a social media analytics service we use every day here at ReadWriteWeb, will announce today a new Facebook application that automates the publishing of your content onto Facebook and captures reader engagement statistics to incorporate into analytics for your content across the rest of the social media world. PostRank keeps track of how content gets passed around on sites like Twitter, Delicious, Digg, Reddit and many more. The service's ability to track reader sharing and discussion on Facebook has been hampered, however, by Facebook's being closed off to outside data collection. This new solution, a Facebook app that publishers authenticate with, is a smart way to make progress towards solving that problem.

Related: