Best use:

• Comparison

Bar charts are probably the most common excel charts when comparing one or more data series. I mostly prefer using this chart type whenever I am dealing with long description bars.

Most of us use Excel on the regular basis and are familiar with the basic functions, but Excel can do way more than that. In the following article, I present a few common statistical techniques, with all of the equations built into Excel.
Posted on:

Google Analytics by default does not allow to segment a Goal Funnel. Paditrack is a 3rd party free tool that allows to segment any goal that you have in Google Analytics. This tool pulls GA goal data retroactively, which means that you don’t have to wait two or three weeks to gather valuable data. This tool does not require any Google Analytics tracking code hack..

By using this feature you can easily segment content that was written by a particular author, than you can check their performance against other authors.

The percentage of (not provided) is getting bigger every day. I’ve seen websites with 50%+ of the keywords being not provided. So what can we do about it?

Long tail keywords are such a big part of our traffic that not focusing on them can drive to major loss in traffic as well as conversion.

Data hub activities shows us who shared your content and where, this sounds like great, the only problem is that the partner list is kind of limited to 21 social media websites.

Social Media can be a very effective traffic generator, having a traffic source that generates 40% of the visitors is great but by the end of the day we are all looking at conversions.

This is similar to Days since last visit but it focuses on ecommerce stores. It is very nice to know how many days a buyer needs until he converts. If you have his email address for lead nurturing or you have a retargeting campaign setup, then the days until transaction takes place can be lower and simultaneously,  you can have a higher number of transactions.

As I said site search metric is very important but having an idea if your site search returns quality result or not will not be possible without a taking a look at this report.

This is a must have, this information can come the most handy in content creation. If you have a blog you know exactly in what kind of content your visitors are most interested in. For ecommerce is even better, it gives you most of the time the type of products your visitors are looking for and cannot find. 2nd step is to create a category page that has all the products.

Knowing which marketing channel brings the most money to the business is always a must.

Having this information will help explaining your client how important is to increase the number of visitors.

This will tell us how much is the % of new visitors who are purchasing a product. This metric is questionable because most of the new visitors are not buying right away, they like to research many websites before they convert.

This tells you exactly how your websites engagement is. We all want to engage our visitors; we didn’t work hard for our visitors to bounce. If this report shows you a higher bounce rate than 50% than you should check out right away why this is happening.

As an international seller having this information is mandatory. Having a very high conversion rate in UK and not optimizing your website for the UK market is foolish.

For eCommerce websites this report is life changing. Knowing average purchasing quantity and average purchasing value side by side is great but combining these two and analyzing the correlation between the two metrics can be a great way to improve the up selling recommended products. 

It gives you an idea of how new visitors are influencing the number of transactions. This metric is great when you have a campaign that sends you a lot of traffic, it will tell you right away if they are converting or not

Seasonal forecasting is a technique that enables us to estimate future values of a data set that follows a recurring variation. Seasonal datasets are everywhere, an ice cream store will be very profitable during the summer season and a gift store can reach the maximum sales during the winter holidays.