Link Tagging: Generating Tagged Destination URLs

Generating Tagged Destination URLs for Google Analytics

To manage link tagging effort, find 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

http://spreadsheets.google.com/ccc?key=p7c_HKcmspSUfEYSO0gskKw&hl=en



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 for huge keyword list