What is the SEO Analytics Dashboard mean and what can we use it for? The owner of each and every website feels that it is important to get a real picture of the operation of the site in the form of different indicators.
Measuring Website Performance
The Unique Visitors are those visitors that visit the site at least once on a given day. If there is more than one search from the same IP address in the statistics we have to consider it unique.
The next important indicator is the Bounce rate. With the help of this you can analyze how many percent of the visitors leave the website after looking at only one page. The Bounce rate is the real key performance indicator , if the values are between 30-50%, than everything is all right. It is worth to pay attention when making a homepage to urge visitors to stay on the site for more browsing.
We can be satisfied if the indicator is the lowest possible.
The Average Time shows usually how much time each visitor spends with reading articles. Here the higher indicator is better.
The New visits of course, shows the number of new visitors. In the bottom four row of the chart we can see those factors that show the source of the real traffic. Following the usual practices these are: Google or Bing search engines, referring sites, direct traffic and other sources.
SEO Analytics Dashboard – Under the Hood
Using our template you can give a snapshot of current performance and direct your goals for future improvement. Here are our main SEO indicators:
Let’s see the most interesting part; we will say a few words about the operation of Excel dashboards.
The first column shows the current daily information and the change in % (this can be positive or negative according to the color of the arrows).
The second column shows yesterday’s status, the third one shows statistics from 30 days earlier. We have set the markers using conditional formatting and built-in shapes.
You can use icons or the well-tried red-yellow-green traffic lights.
Check the Trends using Sparklines!
Trends serve two kinds of purposes. Partly we make assumptions from past data and on the other hand we can make predictions / forecasts.
In previous articles we wrote about the use of sparklines. We had a good use of it making the dashboard now.
As you can see on the picture we have used the occurrences of the past 45 days.
This looks good, isn’t it?
One more important thing about trends: we designed the dashboard that the number of days can be freely adjustable in the trend cell.
If you change the current default parameter than you can automatically see the period chosen by you so we save you from the trouble drawing the chart.
Download SEO Analytics Dashboard
We hope that with the help of the template you can track the indicators you own website more simply.
Our conception is still the same we make everything on the site downloadable for free.