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.

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.)

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.)

Google_TrackingSchemeGenerator_20110613

If there’s an errors or you have any suggestions, please let me know.

Scott