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!
What’s Different About this Google Analytics URL Builder Spreadsheet?
It’s a fairly comprehensive set of options for creating useful utm variables for Google Analtytics. The concatenation formulas in the Generator tab leave blank spaces if you’re not using a particular variable. So it’s a reasonably fast way to make some Google Analytics Tracking Code enabled links if you’re not just doing it programmatically. I’ve either had to create these myself or had to have other marketing co-workers create proper codes for links. While anyone can go to the Google Analtytics URL Builder, that can become tiresome if you have a lot of them. I made the attached sheet years ago when doing some consulting and have used it at several companies. People seem to like it. (Well, no one really likes the hassle of doing this. But they like that it can give better drill down reporting. So I figured it was time to just put it out there in case it might be useful for others.)
Please note that it’s not the URL builder in this sheet that’s really important. It’s the idea that you create a solid scheme to track what you need to track. You should build your variables with a eye towards how you want your reports – perhaps especially custom reports – to come out. You may find it useful to play with a test site or a few pages you have control over before you have a development team work to programatically embed variables across your whole site.
Anyway, here it is…
(Oh, and obviously you use this at your own risk. Your responsible for configuring your stuff appropriately. I’m not responsible for your reports or coding scheme.)
If there’s an errors or you have any suggestions, please let me know.