Yes, it’s a long title for an Excel Spreadsheet used to create utm tracking scheme variables for Google Analytics. I’m just doing a tiny bit of keyword stuffing here so the page gets found and people can use the spreadsheet I made if they like.
The Poor Site’s Tracking Method!
The big web sites may be able to afford the high end analytics solutions, but most sites starting out are stuck with love using Google Analytics. It’s an extremely capable product, especially in that it’s free. There’s a variety of other beacon / JavaScript based solutions out there, but I’ve found even those using these tools typically also have Google. In many cases, tracking codes are done for you. For example, if you’re using adwords and have hooked in your accounts properly the gclid variable should show up free, no effort on your part. And over time, Google has added other referrals such as social referrals to help. Moreover, increasingly third parties, (such as sharing tools like AddThis or ShareThis), also make it easier on you. Still, there are times when you just have to make your own. For those times I’ve found a sheet like the one attached below to be useful. Admittedly, it can be a pain to create your original schema and maintain things like this. But it’s not all that bad and once you have things set up, things go pretty quickly.