November 24, 2006 by Mike.Blakley.

Code written in C++ to enable cross checking and validation of zip codes, telephone number area codes and state codes (US only). Useful for data integrity checking. Zip code database required (not provided) but there is a link to a no cost zip code database.  Download.

Posted in Validation | No Comments »

November 23, 2006 by Mike.Blakley.

Web Log 1.6 includes tracking for RSS files, OPML and also other search engines such as AllTheWeb, Ask, Netscape, Alexa, etc. Further, there is additional documentation on auditing Internet logs, such as obtaining data from the regional internet registries (RIR), along with programs to build the IP address to country code lookup table. I post all the recent data on the site. All this software is open source and I contribute it to the public domain.

Posted in Web Log Analytics | No Comments »

November 21, 2006 by Mike.Blakley.

Techniques to convert data from a variety of sources (e.g. Excel, MS-Access, database ODBC, text files, etc. into the industry standard tab separated value format. Once data has been converted into this format, it may then be loaded into databases such as SQLite, MySQL, and is also in the proper format for data analysis using software packages such as EZ-R Stats for Windows and other software packages. View PDF

Posted in Data Validation | No Comments »

November 21, 2006 by Mike.Blakley.

Documentation showing audit techniques for the commonly used Internal Audit software functions. View document.

Posted in Data Validation | No Comments »

November 21, 2006 by Mike.Blakley.

Documentation showing audit techniques for the application of Benford’s Law.

Posted in Data Validation | No Comments »

November 21, 2006 by Mike.Blakley.

Documentation showing techniques used to identify duplicate payments. View document.

Posted in Data Validation | No Comments »

November 21, 2006 by Mike.Blakley.

Documentation showing how to use the open source SQLite database to perform common audit functions.  View.

Posted in Data Validation | No Comments »

November 21, 2006 by Mike.Blakley.

Documentation showing example screen shots for all of the menu selections for EZ-R Stats for Windows.

Posted in Audit Software | No Comments »

November 21, 2006 by Mike.Blakley.

Source code and procedures for converting an IP address in dot notation to the corresponding country code (two characters). Useful in identifying and classifying Web traffic for SEO (and other) purposes. Code is open source, public domain (no cost). This information is available for download as a “setup” file or as a zip file.

Posted in Web Log Analytics | No Comments »

November 21, 2006 by Mike.Blakley.

This is code I have contributed to the public domain - written in standard C++.  The code is available in two formats - a “setup” file and also a zip file. Note that the software produces a set of six output files (pge - ranked page visits, ref - list of referrers, ip - unique ip addresses visiting, ep - unique ip addresses downloading software, isp - list of major isp providers used.

Posted in SEO Optimization | No Comments »