What Google Analytics Can’t Do

An overview about what Google Analytics can’t tell you in its reports

Google analytics

One of the key factors of getting your site a visible ranking is to know how well it performs with search engines and with your site visitors. Google Analytics (GA) is a web analytics tool that reports performance metrics of your website as well as give you insights into your web visitors’ behaviors and their activities while they are on the site. Performance metrics/indicators can vary depending on the priorities and goals of your site, but basically they include metrics like average time on site, number of page views, number of visitors and unique visitors, bounce rate, entry and exit points, goal conversion and so on. Those metrics are fundamental as they quickly let you know the overall health of your site, how it is performing against your goals. Google Analytics reports basic metrics and much more, but what can’t it tell you?


Display Excel Data On a Web Page

How to quickly display data from a Microsoft Excel spreadsheet to a webpage online

Display Excel data on website

At the company where I’m working we have a marketing calendar in MS Excel showing schedule for different marketing events and activities. The file is maintained by marketing and regularly updated with new speaking engagement opportunities or changes of venues to current events. And every time we updated it, we put a copy on a network or shared drive so that other people can access it. Later, we made it a little easier to access by putting a link to the Excel file on a web page.


Create Image Map / Hotspot in Dreamweaver CS4

How to create a clickable image map in Dreamweaver CS4/CS5

Create image map in Dreamweaver

An image map or a clickable image map is a web image containing (sub-)areas that linked to different content or web pages. Each clickable area is often referred to as a hotspot. Image map is useful in presenting and organizing information where you let web visitors see the big picture and also give them the option to click around and explore the areas of interest. An example would be something like the image on the left with four distinctive areas constructed by the puzzle pieces. Each puzzle piece may represent one of your products or services or anything else.


Create a Pull-Down List/Drop-down Menu

How to turn a pull-down or drop-down list into a drop-down menu (without and easier than using Dreamweaver)

Pulldown menu

I have another short and pretty popular post about how to Create a Drop-down Menu with Dreamweaver. The drop-down menu discussed in that post is different from the pull-down menu mentioned here although most of the times people use the terms “drop-down” and “pull-down” interchangeably. The menu we are talking about here is done by using the <select> and <option> tags and looks like the thumbnail on the left.


MS Office 2010 Menu/Ribbon Reference

Cross-reference between MS Office 2003 and MS Office 2010

MS Office 2010 reference

As a long time MS Office 2003 user – since 2003, switching to MS Office 2010 was not an easy ride because almost all the 2003 menus are changed in the 2010 version. Even the term “menu” was changed to “ribbon” in 2010. The good thing is Microsoft understood the confusion and created a reference between Office 2003 to Office 2010. The reference can be viewed online as an interactive application [with Microsoft Silverlight] or downloaded for offline use as MS Excel spreadsheets. You can find the links to the reference library at the end of this post. However, before going there, there are some tips I want to share first. Hopefully, you’ll find them useful.