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. 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. Public script? 3. Public script? 4. Public scripts? 5.
Educational Financial Videos - Investopedia Videos
Ad will close in 15 seconds. Sign in Register Videos What's a T Bond? What's a Prospectus? Understanding Interpersonal Skills What's a Command Economy? More Videos Latest Connect With Investopedia © 2015, Investopedia, LLC. Partners:
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? Do you think these positions and the salaries make sense, given the rise of social media? Infographic courtesy of OnwardSearch Every week we post a list of social media and web job opportunities.
7 Reasons Facebook Should Not Be Blocked At Work
Many workplaces nowadays find it prudent to prevent their employees from surfing certain websites. Leading that pack of blocked websites is Facebook. Facebook is a true phenomena in our social lives today, and many employers feel that leaving Facebook open for free surfing will cause a major waste of time and loss of productivity. But is it true? Is blocking Facebook really that smart? Many people feel that blocking Facebook at work is a mistake, but can’t quite convince their bosses. Social Connections Many bad things can be (and are) said about Facebook. A good working environment is one in which there are good social connections. True, you can do that from home, but the odds of doing it when you come back from a 9 hour workday are much smaller. Breaks Are Important Many employers seem to think that breaks are bad. Some people go for a smoke every hour, and that’s OK with everyone. Cellphones How efficient can blocking websites be when most people have smartphones? Inspiration Happiness
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.
Lockhart's Lament Math Education Is Wrong
Wikimedia CommonsA 3-D representation of a 4-D shape called a 24-cell polychoron. Mathematics is one of humanity's most creative and poetic endeavors. And it is a disaster that it isn't taught this way to students. "A Mathematician's Lament" is a classic polemic (later expanded and published as a book) written by math teacher Paul Lockhart. The essay is a devastating and passionate assault on the mechanistic way mathematics is taught in most of our schools. A Student's Nightmare Lockhart begins with a vivid parable in which a musician has a nightmare in which music is taught to children by rote memorization of sheet music and formal rules for manipulating notes. The problem is that this abstract memorization and formal-method-based "music" education closely resembles the "math" education that most students receive. This goes against what math is really about. Playing With Triangles Lockhart uses a geometry problem to illustrate. Paul Lockhart This answers our question: The Soul of Mathematics
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+13125784550jennifer.brusa@booz.com DallasJoe SimsPartner+12147126636joe.sims@booz.com DubaiKarim SabbaghPartner+97143900260karim.sabbagh@booz.com DüsseldorfRoman FriedrichPartner+492113890165roman.friedrich@booz.com FrankfurtOlaf AckerPartner+496997167453olaf.acker@booz.com Booz & Company Show transcript Commo
