Cool Spreadsheet for Faster Email Link Tagging with Google Analytics

Link Tagging With Google Analytics

Google Analytics is a free open-source program to track your blog or site’s traffic metrics, etc. Many of us are familiar with the Google Analytics URL builder to tag our links in our emails.

The only problem I have that many other people seem to have with the URL builder is that it will take quite a while to tag your links if you have a lot of links in your campaigns.

Bulk Link Tag With A Google Spreadsheet

Now I know there are a lot of email services at “automagically” embed these tags for you, but if you don’t want to spend any money on them, try this this free Google Spreadsheet from epikone. Here’s an excerpt that you must read before you attempt to use this spreadsheet:

““EpikOne assumes no liability for use of this tool. Use at your own risk.
To get a better understanding of link tagging and how it is used in Google analytics please
see the following support articles:

http://www.google.com/support/analytics/bin/answer.py?answer=27252&hl=en

http://www.google.com/support/analytics/bin/answer.py?answer=27254&hl=en”

Instructions

Using this tool, you can automatically create large numbers of tagged destination URLs.

1. Delete all data EXCEPT FOR THE DATA IN G8! G8 Contains the master formula.
2. Enter a value for the various campaign tracking variables that you plan to use. IMPORTANT: for variables that you are not using enter a dash (-). DO NOT LEAVE ANY FIELDS BLANK
3. Enter the destination URL for the ad. The destination URL is the URL where the visitor will ‘land’ on your site.
4. Copy the formula to the ‘Tagged URL’ cell for your row.”

To get the full post details on tracking email with Google Analytics check out the post from Epikome.

Related posts:

1. How To Set Up Google Analytics for Facebook Fan Pages
2. Annotations of Google Analytics..How To Successfully Track What’s Working
3. Simple Link Cloaker Plugin For WordPress
4. 4 Simple Ways To Find RSS Feeds With Google Reader
5. How To Find Blogs In Your Niche With Google

Tagged as: email campaigns, emails, google, google analytic, google analytics, link tag, link tagging, tagging links, url builder

JackNguyen.com Runs On The Thesis Theme!

Thesis is the search engine optimized Wordpress theme for serious bloggers and for those without PHP or any other coding background.

For advance users, Thesis has amazing customization possibilities via Thesis hooks, design options, you can use the template over and over again without having it look like the same site. With the Developer's License you can run multiple blogs on Thesis.

Take the Thesis Video Tour & Demo.

Check Out My Thesis Review!