How to measure twitter reach

Today we are going to talk about how to measure twitter reach from one of my most used applications: Microsoft Excel.

The tool you have to download to do it is Analytics for Twitter and allows to query Twitter directly from Excel thanks to the free PowerPivot Add-in that needs to be installed too in order it works.

The installation of Analytics for twitter will place an Excel file in your desktop, once you open you will see that the usage is very simple, we only need to introduce our search queries separated by commas in the Excel sheet called “Topics”. The queries can be free text, hashtags or twitter alias, once we press the search button it will contact with the twitter api to extract all the info and present it to us properly formatted.

Once the search is completed we need to do two extra steps to see the information retrieved. First one is go to the PowerPivot menu and click “Update All”, when it finishes go to the menu “Data” and click “Refresh All”.

After this we can start analyzing the results of our search, which is divided in three Excel sheets:

  • Topics: Contains the main dashboard where we can see stats related to the amount of tweets, how they are published by hours, overview of the tweets’ tone.
  • People: Provides information about the users that have been tweeting about the topic we have searched and who are the most positive/negative twitters.
  • Tone: Displays detailed information about the tone of the tweets based on a dictionary we can configure to adjust it to our language or preferences.

The best of all is that you will be able to apply several filters to the information extracted, which will allow you to fine investigate the reach of the topic you have introduced.

Below you have the resulting reports based on a query where I looked for the hashtag #IE9. As you can see the reports are very attractive visually.

Analytics for Twitter - Topics

Topics

Analytics for Twitter - People

People

Analytics for Twitter - Tone

Tone

 

As you can see create reports to measure the twitter reach is very simple with Analytics for Twitter, so just download and play with it.The file contains also all the information of the features and limitations the tool has today.

How to increase returning visitors traffic and measure it

Increase returning visitors traffic is one of the metrics any web analyst has in mind, this is because it means you are obviously increasing the loyalty of your audience and helps to guarantee the continuity of your site. There are many more metrics of course like conversion, page views, bounce rates … but in this article we will focus in how to increase returning visitors.

It is not new that lot of companies try to increase its returning visitors traffic, there are many techniques to do it like subscribing by email,  forums, chats … all of them, of course, useless without good content in the site.

Probably the “easiest” way to achieve it, it is becoming the homepage of your browser, unfortunately this is a battle that is lasting from the very beginning of Internet, you saw Yahoo, NetVibes, MSN trying to become your homepage and now you can see it also with Facebook or even Google constantly telling you to do it.

Google wants to be my homepage

 

The problem is that it is very hard to compete with the big Internet players to become the browser’s homepage, but today we are going to show an easy alternative that Internet Explorer 9 and above offers us: the pinned sites.

The pinned sites allow you to pin any site to the Windows Taskbar like if the site was a Windows application. Below you can see my taskbar with my pinned sites Hotmail, Twitter, LinkedIn, Facebook and SkyDrive sharing the space with traditional Windows Applications like Outlook or the Notepad.

Pinned sites in the windows taskbar

 

Why this is better than the browser favorites?

In the first place, because according to the statistics retrieved with the improve user experience programs we know that 87% of users launch pinned apps from the taskbar (vs 18% opening sites from the favorites bar) and 33% of users have pinned at least one non-default app to the taskbar (vs 4.4% who have added a site on the favorites bar).

jose bonnin custom tasksIn the second place, because the pinned sites allow you to have a higher level of personalization and some advanced features that help to improve the user experience and easing how the user access our site.

In my site http://www.josebonnin.com I have implemented the pinned mode adding: personalized tasks that display the latest posts published, the main categories of my blog, access to the archive and how to contact with me.

There are many sites that implement the pinned mode today and some of them have shared some of their figures, the most well known case is the Huffington Post that thanks to implementing the pinned mode in their site they were able to increase among IE9 users 14% their returning visitors and 11% the number of pages visited.

 

 

There are many features of the pinned sites that you can deeply explore in the Pinned sites developer documentation. But the easiest and simplest way is to implement them is to include the next metatags in your site:

   1: <meta name="application-name" 
   2:   content="Jose Bonnin" />
   3: <meta name="msapplication-starturl" 
   4:   content="http://www.josebonnin.com" />
   5:  
   6: <meta name="msapplication-task" 
   7:   content="name=Contact;
   8:   action-uri=http://www.josebonnin.com/contact.aspx;
   9:   icon-uri=http://www.josebonnin.com/mail.ico"/>

The first metatag defines the name that will have the site once it is pinned in the taskbar, the second defines the url that will be opened.

The third will add a custom task called “Contact” that opens the URL http://www.josebonnin.com/contact.aspx

You can add as many custom tasks as you want by adding more metatags that follows the pattern of the “msapplication-task”. As I said before, there are many more options you can apply like: notifications, thumbnail buttons, custom tasks based on the context of the page, etc. just check the URL above to find all the documentation.

So, now that we know that we can increase the returning visitors by implementing pinned site features. Let’s see how we can measure it.

 

How to measure the increase of returning users thanks to the pinned mode?

Google analyticsTo do it we have to tag all the links we define in the pinned mode options using the parameters of our Analytics provider. Google Analytics for instance forces you to use at least the parameters utm_source, utm_medium and utm_campaign. You can find more info on what each parameter means and in the URL Builder.

Therefore, following the example above I would need to tag the start URL and the Contact URL, using for instance the next values: utm_source=IE9,  utm_medium=web, utm_campaign=pinnedmode.

 

 

 

 

Doing this the start URL would become http://www.josebonnin.com/?utm_source=IE9&utm_medium=web&utm_campaign=pinnedmode

and the contact URL http://www.josebonnin.com/contact.aspx?utm_source=IE9&utm_medium=web&utm_campaign=pinnedmode

After you do this you will be able to measure as with any other campaign all the traffic coming to your site through the pinned sites.

 

This is all, feel free to share how much have you increased your returning visitors thanks to the pinned sites.

Consumerization of IT

Consumerization of IT means that enterprises are seeing how their businesses are being affected by consumer devices and services, which normally include new devices like smartphones or tablets and services like cloud-based applications or social networks. Or as we can read in the Wikipedia “consumerization is a stable neologism that describes the trend for new information technology to emerge first in the consumer market and then spread into business organizations, resulting in the convergence of the IT and consumer electronics industries, and a shift in IT innovation from large businesses to the home.”

Enterprises see how these new technologies are changing the way people communicate and work. Today nobody is surprised to see how employees have contact with customers or partners using consumer services like Messenger, Skype; social networks like Twitter, LinkedIn or even Facebook, or that employees share documents internally using consumer SaaS services like Skydrive or DropBox

Another perfect example are the smartphones, a device that was designed for the enterprise, but that is having now its apogee in the consumer space thanks in big part to the disruption that the iPhone created in the market. Any smartphone today allow us carrying the work home, this was the initial idea, but this has also the reverse consequences that means we can also take our personal life to the office.

Whether we like or not we have crossed the line that divides our personal and business life too many time ago, lot of times fostered by the companies themselves in an effort to involve more and more the employees into their work.

The problem is that CIOs and IT Professionals need to face this situation, which is growing very fast especially now that the Internet Generation has fully joined the job market, and will be multiplied by several orders of magnitude when the generation that born fully connected and holding a device in their hands hits the workforce. This tech-savvy generation is not demanding the change, instead it is brutally driving the change.

The main challenges CIOs and IT Pros will need to resolve to avoid frustrating and to fulfill the expectations of these new workers are among other things:

  • how to certify soon new devices for their enterprises
  • how to provide a common experience across disparate devices
  • how to secure the communications
  • how to protect personal information
  • how to increase the capacity of their systems to support the new demand

The good news is that all these challenges don’t come alone, they come also with lot of opportunities, because the Consumerization of IT can boost productivity with new ways of communicate and being connected, we have seen also how the use of Social Networks for instance drives higher levels of NSAT among customers and increased loyalty. Embracing public cloud services can also help to improve cost and efficiency by reducing IT costs and provide better application performance...

The consumerization of IT needs to be addressed today, not tomorrow. Like it happens with the cloud movement resistance to the consumerization of IT is futile.

 

If you have two extra minutes you can check also this funny video.

 

Use Skydrive from Windows Explorer

For those who do not know SkyDrive yet, it is a free online storage that offers 25 GB and has been around since beginning of 2008, it's interface has been completely rebuilt this week to make use of HTML5.

SkyDrive provides other additional features like:

- The possibility to create, view and edit Microsoft Word, Excel, PowerPoint and OneNote files without having Microsoft Office installed on your computer.

- A versioning management system that allows you to rollback to earlier versions of your documents.

- Create photo slide shows, so you can view your photos online without having to download to another PC.

- Share documents online with different levels of permissions.

In addition, if you have a Windows Phone 7 you might benefit also of SkyDrive. Since you can upload automatically from your Windows Phone 7 the pictures taken and access/upload your Office documents.

After the brief introduction to SkyDrive, I would like to explain how to use SkyDrive from Windows Explorer instead of having to use the web interface. To do it we will map a network folder in Windows Explorer to SkyDrive.

- First of all you need to create or access your SkyDrive account on http://www.skydrive.com

- Click on any of the folders available under the section Documents. This will allow you to see your unique id in the URL, which now should have the format of https://cid-xxxxxxxxxxxxxxxx.office.live.com or https://cid-xxxxxxxxxxxxxxxx.photos.live.com

- The xxxxxxxxxxxxxxxx above contains your unique id, let’s say that is, just copy the id and open Windows Explorer.

- Select the option “Map network drive” and in the textbox belonging to “Folder” type \\docs.live.net@SSL\xxxxxxxxxxxxxxxx\^2Documents replacing the fake id by your unique id and “Documents” by the name of the SkyDrive folder you want to map.

Yu will be prompted to introduce your Live Id credentials and after this you will have access to SkyDrive from Windows Explorer as with any other folder.

Samsung 9 Series

Yesterday we received at the office the new Samsung 9 Series notebook that was first introduced at CES. I should confess that the first time I saw this notebook I immediately fell in love.

Samsung 9 Series

Samsung has done a great design exercise with this device. The external case is very slick with almost no sharp angles, instead the lines follow a nice subtle curve. All the connectors, which include Micro HDMI, headphone, mic-in, RJ45, 2 USBs and even a MicroSD slot, are hidden in small slots that you can open only when needed.

The weight, 1.3 Kg and the size 32.7 cm x 22.6 cm with a thickness of only 1.7 cm are just amazing and places this computer in the same range of the MacBook Air or the Lenovo ThinkPad X1.

Samsung 9 Series thick

The display follows the same high quality pattern with a 400 nits, HD Led Backlit anti-glare display with an Intel HD Graphics 3000.

This is not just a small computer, it’s a serious and powerful device with 3 year warranty and great specifications:

  • Intel Core i5 Processor 2537M
  • 4GB DD3 (8GB Max.)
  • 128 GB Solid State Drive

All this and more for approx. $1600 and a battery life that gives you up to 7 hours to go.