Xfernal's Techno-Dev Mumbling

I have several sites running off a single DotNetNuke installation and I wanted to add the Google Analytics Javascript to several of the sites. I had a few options: 

1. I could change default.aspx to include the JavaScript code in the HTML head
2. I could incorporate the Urchin Javascript in a DNN Skin
3. I could go I could go into each pages Page Settings>Advanced Settings>Page Header Tags and drop the JavaScript into the textbox
4. Just run a SQL statement

Option 1 does not work because all installations would have the same JavaScript and I could not be site specific with the Google Analytics Site ID. Option 2 is probably the best option but I am lazy and did not want to update each skin and upload them each to the site. Option 3 is just ridiculous for a few of our larger sites and would take forever...so, I picked Option 4, the quick sql statement:

UPDATE Tabs SET PageHeadText = '<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
           </script>
           <script type="text/javascript">
                _uacct = "UA-xxxxxx-x";
                urchinTracker();
           </script>'
 WHERE (PortalID = 0)

Before you use this sql update statement against your DNN database, make sure you update your Google Analytics ID, "UA-xxxxxx-x", and PortalID #.

This will automatically change all pages for that portal to include the Google Urchin JavaScript. If you do not want certain pages such as the Admin pages to include this JavaScript, simply filter out any by ParentID's 

Example:

UPDATE Tabs SET PageHeadText = '<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
           </script>
           <script type="text/javascript">
                _uacct = "UA-xxxxxx-x";
                urchinTracker();
           </script>'
 WHERE (PortalID = 0) AND ParentID <> '38'

You could easily use this same script to add other HTML head code. Hope that helps!

Google allows for a LSI keyword search. By prefacing a tilde (~) before the search term in Google, LSI keyword results will be returned.

Example search: ~automobile

Results would include many “car” related results with the LSI keywords bolded.

Example Results:

Toyota.com

Honda Cars Motorcycles Watercraft ATVs Engines Generators, Acura

Buy new & used cars online, research prices & dealers, sell your ...

Car Talk

Notice “Toyota”, “Honda Cars”, “vehicle” are all bolded in the results. Very handy for getting more keywords

Sometimes the menu on a website will alter search engine results because the links in the menu change the importance of the overall page, especially if the links appear before the content of the page. So, optimizing for search engines should include trying to get the actual content of the page higher up in the HTML. Doing so might affect the overall look and feel of the page, but there are ways to get around it. I think most people are accustomed to left navigation menus and expect them to be available, so by using a simple table trick, you can move the menu of a page below the content, giving the content more importance over the menu links for better ranking.

	Main Content Goes here. Even though it appears to be right of the menu when viewed, in the source this content comes before the menu...
This is a menu

Basic HTML Example: Table-Trick.html (.52 KB)

This can easily be used in DotNetNuke skins to move items like SolPartMenu or modules in the "LeftPane" below the "Content Pane".

DNN Table Trick Example:

dnn-skin-example.html (.49 KB)

One of the best web log analysis applications is Urchin Web Analytics which was bought by Google. I had checked on the Urchin website about a month ago and saw where they were still charging $199 per month plus extra for high traffic. Now the website points to Google Analytics and it is free. All required is to register for an account and to add a JavaScript to your HTML Head. Logging into your Google account will provide detailed reports.

More importantly:

"If you have an AdWords account, you can use Google Analytics directly from the AdWords interface. Google Analytics is the only product that can automatically provide AdWords ROI metrics, without you having to import cost data or add tracking information to keywords."

You can signup here: Google Analytics