In Part 1 of this series I explained that Google Analytics campaign tracking is based on a technology called link tagging. Link tagging is the process of adding business information to the URLs that we use in our on-line ads. But how do we actually tag these links? Some marketing campaigns can have hundreds, or thousands, of destination URLs. Google has provided a tool for us called the URL Builder. It’s great if you only have one or two links to tag, but it can’t handle hundreds of links.
To manage our link tagging effort we’ve created a tool in Google Spreadsheets that automatically generates tagged destination URLs. All you need to do is fill in the values for the Google Analytics tracking variables and a built in formula does the rest. Here’s a link to the file. Please help yourself :)
How to Use The Tool
1. Click on the above link to open the Google Spreadsheet. Once open, use the menu in the top left corner (File > Export >xls) to export the file to your hard drive.
2. Once you have the file on your machine, open it using MS Excel.
3. Delete all the demo data in the file EXCEPT the equation in cell G8. Cell G8 contains the equation that does all the work.
4. Enter your campaign information into the corresponding columns. Enter a dash (-) for all variables that you are not using. You should always use the campaign, medium and source variables.
5. Add the destination URL to the destination URL cell. Don’t worry if your destination URL already contains query string variables, the tool is smart enough to handle them.
6. Cell G8 will automatically build your destination URL.
7. Continue entering your campaign data in new rows.
8. Copy the formula in cell G8 to other rows. The tagged destination URL will be created automatically.
After you have your destination URLs you can paste them into your on-line ads.
Let me know if you find this tool useful or a complete pain in the as*. Got a better tool and feel like sharing? Post a comment below!
*** Note: EpikOne assumes no liability for those that choose to use this file. ***