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/

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. Google Meets Miss Manners, Encourages Searchers To Thank Those Who +1'd Content DEAR MISS GOOGLE: When I searched for something using your service, I found a friend had +1′d one of the of listings. What should one do in this case? GENTLE SEARCHER: It’s always polite in these situations to thank your kind friend. In fact, I’ve added a new “Thank” feature allowing you to do exactly this, though Google+. Yes, a new Google+ feature has been spotted in the wild that further blends organic results with social information. Early today State of Search and charliesaidthat noticed a thank you link on an organic listing next to the Google+ users who +1′d a result.

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.

Google I/O day 1: Android 3.1, Ice Cream Sandwich, movies and more By JR Raphael (@jr_raphael) Whew! Google just wrapped up the opening keynote session for day one of its I/O developers' conference -- and boy oh boy, is there a lot of Android news. Here's a quick wrap of all the highlights. How to change your WordPress Permalink Structure In the past we frequently recommend people change their permalink structure. In this post, we’ll explain why you should consider changing your permalink structure and how to go about it. Why change your WordPress permalink structure?

The future of Android, visualized By JR Raphael Well, gang, after weeks of waiting and wondering, we finally have a pretty good picture of what the future of Android will look like. At the Mobile World Congress in Barcelona this week, Google and some of its hardware partners divulged new details about the Android road map -- what versions are in the works and how tablets and smartphones will ultimately coexist. In short, we'll likely see a second edition of Android Gingerbread, version 2.4. WordPress › Support » Modify upload date? vloo, Thanks for posting this update, for the link to your plugin and the offer to share the code. As I wrote in my earlier post, there's no technical barrier to changing the upload date, but I have philosophical reservations about it. I'd prefer to leave it as the "date uploaded to WordPress".

Google Drive Offers 5GB Free Storage, Rumored Release in Third Week of April Source: TalkAndroid Google will soon join the likes of Apple's iCloud, DropBox, Box and Microsoft's SkyDrive with its own cloud storage service, Drive. According to TalkAndroid, the leaked screenshot obtained by its source pointed to a free 5GB storage space for users. In addition, the source mentioned that Google is likely to be launching the service in the third week of April. However, there are conflicting reports about the amount of free storage space that Google Drive will be offering.

TablePress: The New Best WordPress Table Plugin? - ManageWP I have been a fan of WP-Table Reloaded for a long time. For over a year it has served me very well by allowing me to easily create complex tables from within WordPress. It comes loaded with a glut of great features such as simple importing and live table sorting/search functionality. The feature set is impressive and the plugin is completely free and available for download from WordPress.org. Having said that, I’ve always kept my eyes open for a better WordPress table plugin, because in my opinion plugins often thrive when placed within a competitive environment. With 2012 drawing to a close I can finally say that I have found a plugin that not only matches WP-Table Reloaded but in fact surpasses it in terms of features, performance and usability.

5 Tips for Creating and Maintaining Customer Loyalty Enjoyment: Just getting the job done is not enough. Your product should be a delight to use. Invest in usability and product design and make your product truly intuitive. How do you know you are doing a good job at this? There's a good chance your customers are on Twitter, recommending the product to colleagues.Great Support: Build wizards to walk your customer through how to successfully use your app. If there is a bug, reach out with a solution.

Comparison of Five Email Subscription Solutions for WordPress Update: MailPoet now offers post notifications! Check out the video. Are we just as good as the choices above? How To Use Firefox Profiles & Run Multiple Firefox Profiles At Once Firefox stores your browser data – bookmarks, history, preferences, extensions, and everything else – in a directory known as a profile. Each user account has a single profile by default, but you don’t have to restrict yourself to just one — you can create multiple profiles and even run multiple Firefox instances with different profiles as the same time. Set up separate profiles for work use, personal use, extension testing, secure browsing – anything you like. With separate profiles, you can also log into a website with different user accounts at the same time – say, to have two Gmail inboxes open at the same time. Google Chrome makes this easy with its support for multiple user accounts, but Firefox has the same feature – it’s just hidden.

Related: