VB Programing support Access Database Microsoft Office VB.Net & SQL Server nev@NevVB.com.au Sydney, Australia (02) 9453-0456 Contact Details 28/01/2012
This page demonstrates the power of Visual Basic.Net to store, retrieve and display Visitor activity on a Website. All the colourful charts are dynamically constructed using ASP.Net and VB.Net, Microsoft's Chart software, and data previously collected and saved to a SQL Server database. This page summarises the main factors vital for Website Search Engine optimisation. The dominance of the Microsoft products (like Internet Explorer or Windows 7) does not truly reflect worldwide usage. This Website is dedicated to Microsoft's Visual Basic and Microsoft Access – so visitors to this site are more likely to be using Microsoft products.
Asynchronous Processing allows each Web page to be displayed immediately, while data collection and data storage to an SQL Server database takes place in the background.
Despite the amount of work being done by the server in accessing the database and creating the charts, the response time is good. The wonders of ASP.Net and Visual Basic Programming!
Real-time Website statistics with detailed visitor information is readily available using the ASP.Net facilities. The programmer can determine:
The following analysis shows the Keywords that were used by visitors to find this site. The listing shows the last 10 visitors that viewed more than one page.
To produce these statistics, the Website logs information on each visitor to a SQL Server database on the Web Server. The SQL database is then queried to produce the results.
Over the past three months, visitors to this Website used these Browsers:
Internet Explorer 8 has overtaken Firefox. As Windows XP declines, Internet Explorer 9 numbers will improve – as it fast, safe and supports HTML5 and CSS3. IE6 persists, mainly due to users in China, despite being outdated and insecure.
This chart shows the operating system used by the visitors.
Windows 7 has now overtaken Windows XP, mainly at the expense of the dwindling Vista. Soon Vista will be just a bad memory. Expect Windows XP numbers to rapidly decline over the next 2 years.
This chart shows the Search Engines used by the visitors.
Bing has made a very strong start and has now overtaken Yahoo! usage.
This chart shows the originating Country of the visitors.
The Clients that require Microsoft Access and Visual Basic programming usually come from Australia.
This chart shows the number of daily visitors to this Website over the last five weeks. The trend of the visitor activity will indicate the effectiveness of any Search Engine Optimization.
A high hit-rate is not necessarily desirable – but at least the Website is being found. Targeted visitors who browse more than one page are what is needed.
The landing page is the page that a visitor selects as the result of a search engine link. Almost every page on a Website could be a Landing Page. The Landing Page is important, as any visual improvement can increase the conversion rate, without requiring extensive Search Engine Optimisation (SEO).
The most popular Landing Page is usually the Home page. This needs the most attention. But the infrequently accessed pages also require Landing Page Optimisation. A chance visit could be turned into a sales conversion. All potential landing pages should be attractive – not just the home page. The goal is to inform and invite the visitor to look further.