18+ SEO Excel Functions SEO and Excel are like chocolate and peanut butter - great together. Here are 18 Excel functions (and two formulas) that can make SEO just a little bit easier. SEO Excel Functions The LEN function returns the number of characters in a cell. Analytic.ly Provides Real-Time and Historical Twitter Analysis For brands, developers and curious users, PeopleBrowsr is rolling out an interesting new tool. Analytic.ly helps people and companies "visualize, study and measure" Twitter conversations happening all over the web through general and custom reports and graphs.Topics and trends are stored and indexed, so researchers (be they corporate or otherwise) can get data on conversations with some historical context, as well as real-time stats. The user interface is simple and friendly, with a robust custom dashboard for subscribers. Subscriptions for premium features start at $20 per month. This is one of the most full-featured apps we've seen for analyzing Twitter data.
Social Media Reference Link Social Media Reference Link / curated by @JuliusDesign Facebook Logo & Brand Guidelines Facebook Promotions: What You Need to Know Are you thinking of running a contest or promotion on Facebook? Have the rules imposed by Facebook confused you? Look no further. This article will provide an in-depth look at Facebook’s promotional rules. The Tricky Rules How To Get More Twitter Followers Is your website business on Twitter? Twitter has become one of the fastest-growing social media sites with top celebrities and high-profile entrepreneurs joining the ranks. Because of its mass popularity, people and brands have run to its doors hoping to capitalize on the millions of users. You would think that because Twitter is so popular with hundreds of millions of users worldwide that virtually anyone could acquire followers. Yet, most people find difficulty growing their profiles and this anomaly is one of the most talked about subjects in social media. Acquiring Twitter followers is not difficult.
10 Little Known Social Media Tools You Should Be Using Editor's note: A version of this article previously appeared at KISSmetrics.com. Social media is everywhere. It's in our homes, places of worship, schools and, of course, our businesses. Everywhere you look, people are using social media and are talking about it. And it seems that every week a new type of social site pops up. And as the number of social networking sites grows, so does the number of services that are created to measure, track and monitor those services. The Most Complete Twitter Application List Available - 2011 Edition I believe this is the best, most complete and accurate list of valuable Twitter applications available on the internet right now. To be fair, I absolutely have merged and plagiarized other older and outdated lists that I found (the larger ones are credited below). However, I spent a good deal of time to clean out the dead applications, delete the apps that were overly quirky or being developed, focus more on the apps that increase productivity, and add in many of the new great apps that have come out over the past six months - particularly in the productivity / business apps section where my primary interest lies. I have also tagged the tools that cost money / have a premium option ($) as well as if they have a valuable free option (F/$). Finally, while application selection can be a personal thing, I tagged my favorite app (*) in each category.
69 Free Social Media Monitoring Tools [UPDATE 2013] If you want to know what’s happening with your brand’s social networking sites you need social media monitoring tools. Before you reach for your wallet and start to spend money try out some of the free social media monitoring services. This way you will get an understanding of what is available and if you need any paid services to monitoring social media. Social media monitoring definitionThe activity of tracking social media channels. Organizations measure and use social media analytics tools to find out what is being discussed about them, their competition and other topics of interest.
Free PSD: Facebook Fanpage Template Lets face it, designers sometimes need to make a mock-up that doesn’t actually exist which sometimes can be time consuming and extremely irritating. Facebook fanpages have been a very hot topic for clients recently. They are wanting to break into the social media scene. FYC is releasing a mock-up Facebook Fanpage with editable text, posting times and anything else you can think of. Our Twitter PSD Freebie generated such a good response that we decided to give this away as well.
Making Your Website Mobile Friendly Did you ever wonder how your website looks on a mobile device? Some webmasters believe their mobile website “appearance” does not affect their business. What they don’t realize is that the unfortunate result of an un-optimized mobile site is reduced conversions and potential profits down the drain. According to a report by eMarketer (Source: Hubspot), by the end of 2012, mobile internet users will reach 113.9 million, up 17.1% from 2011, and smartphone users will reach 106.7 million. How many of these users access your website from a mobile device? If you don’t know, find this information in your Google Analytics. How Bottlenose Can Help Turn Twitter into a High Signal Channel Reviewing Bottlenose On Saturday I discovered the Bottlenose service and quickly realised how it can enhance my Twitter, Facebook and other channels to enable me to quickly find content of interest to me. Within a few minutes of using the service I found myself agreeing with Mashable that “Bottlenose is a Game Changer for Social Media Consumption” and ReadWriteWeb that the service is “More intelligent than basic consumer dashboards like TweetDeck and HootSuite“. I came across Bottlenose from a tweet posted by @suebecks.
8 Excellent Twitter Analytics Tools to Extract Insights from Twitter Streams Twitter is now the third most popular social network, behind Facebook and MySpace (Compete, 2009). A year ago, it has over a million users and 200,000 active monthly users sending over 3 million updates per day (TechCrunch, 2008). Those figures have almost certainly increased since then. With the torrential streams of Twitter updates (or tweets), there's an emerging demand to sieve signals from noises and harvest useful information. Enter Twitter Analytics, Twitter Analysis, or simply just Analytwits (in the tradition of Twitter slang). These analytics tools are growing in numbers; even Twitter is developing them.