• Home
  • Google Analytics
    • Customizations
    • For Ecommerce
  • Speaking
  • About
    • About Me
    • Contact Me
    • Disclaimer and Privacy Policy

Analytics Talk

Digital Analytics for Business

You are here: Home / Campaign Tracking / Google Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool

Google Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool

Posted: November 10, 2006 25 Comments

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

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

EpikOne Link Tagging Tool

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

Filed Under: Campaign Tracking Tagged With: Campaign Tracking, google-analytics, on-line-marketing, tools

Comments

  1. Art says

    June 26, 2007 at 12:44 pm

    If the Campaign Term or Name have spaces in them. It seems like yahoo search marketing doesnt accept the url that the link tagging tool generates. I just thought I would let you know.

    Reply
  2. Justin says

    June 26, 2007 at 12:46 pm

    Hi Art,

    Thanks for sharing that information. I’m sure someone will find it useful.

    Justin

    Reply
  3. Marc says

    June 28, 2007 at 2:38 am

    WOW! Awesome tool guys, I was searching for some good infos about analytics and I think I found the perfect site for that… Thanks again for this tool! It will save me TONS!!!!! of work :D :D :D :D

    Reply
  4. Julien Raby says

    September 13, 2007 at 10:25 am

    Hi Justin,

    I just finished your GA book and I wanted to thank you for all your insights. Pretty useful stuff!

    On another note, I wanted your 2 cents on a tracking issue: I always manually tag my links to get better control, but one types of report (The position report for Adwords which seems very useful) isen’t accessible when you tag links manually. Is there a way we can still use that types of report?

    Thank you for your time,

    Julien

    Reply
  5. Justin says

    September 13, 2007 at 9:43 pm

    Hi Julien,

    Thanks! I’m glad you enjoyed the book.

    Great question. I’m not 100% sure of the answer. I believe that the manually tagging should not break the keyword position report. However, I believe that the values you use in the query string parameters must match the values in AdWords (campaign name, keyword value, etc.).

    Let me know how it works.

    Reply
  6. Stephen says

    October 18, 2007 at 12:15 pm

    Do I need to be a subscriber to access the spreadsheet you have created? I get an access denied error.

    Thanks, Stephen

    BTW, I sure appreciate your articles. I’m just getting into the whole world of GA and am finding it much easier than I expected as a result of helps such as yours.

    Reply
  7. zsabc says

    February 7, 2008 at 3:26 pm

    Okay, now think I deleted my original post/with question instead of submitting it, so here is my question again. If you already have it, just delete this post.

    My problem is visible when I look at my Analytics reports, specifically when I go into Traffic/Adwords/AdwordsCampaigns, then select a specific adgroup and segment by url. In this adgroup-level report I see urls for all of my ads with revenue and other stats. So far so good. My problem is that I also see urls for other adgroups, sometimes with revenue and other stats too.

    Theoretically, the whole point for these reports is so you can see your ROI for given adgroups. If revenue from other adgroups is included, then the report is inaccurate.

    My adwords account is set on auto tagging. I also have manual tags for most urls (I know you are saying aha – that is the problem, but just hear me out). My query strings are not in the new post-Analytics format (e.g.: utm_campaign=X&utm_source=google&utm_medium=cpc). They are all in the format I used before Analytics came about (e.g.: source=google&campaign=X&adgroup=Y1). I did not think that retaining these old querystrings would be problematic. I thought that because they are not in the new format, analytics would ignore them/be unable to read them (and I could refer to them in the landing page reports to compare ad performance). Am I completely wrong? Do I have to remove ALL querystrings if I have autotagging on?

    Thanks for your time,
    ZSABC

    Reply
  8. Justin Cutroni says

    June 25, 2008 at 6:31 am

    Hi zsabc,

    It sounds like you’ve tried to link an MMC account to your Analytics account. This would result in ALL AdWords campaigns appearing in your AdWords reports. You can only link a single, standard AdWords account to a single Analytics account.

    To fix this issue you need to contact Google Analytics support ad ask them to unlink that account. Then you can relink your GA account to the correct AdWords account.

    Justin

    Reply

Trackbacks

  1. this just in » Google Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool says:
    November 10, 2006 at 3:25 pm

    […] Google Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool […]

    Reply
  2. Analytics Talk » Google Analytics Campaign Tracking Pt. 0: An Overview says:
    November 14, 2006 at 11:39 pm

    […] Part 2: EpikOne Link Tagging Tool […]

    Reply
  3. Analytics Talk » 2006 » November » 25 says:
    March 4, 2007 at 9:52 pm

    […] Google Analytics Campaign Tracking Part 3: Reports and AnalysisTop 5 Google Analytics Resolutions for 2007Web Analytics: It’s About ProcessRegular Expression Testing ToolGoogle Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool […]

    Reply
  4. Analytics Talk » Google Analytics Campaign Tracking Part 3: Reports and Analysis says:
    March 4, 2007 at 9:54 pm

    […] In Part 1 of this series I explained link tagging, the technology that Google Analytics uses to track on-line marketing campaigns. In Part 2 I discussed how to tag your links and posted a tool that I use to quickly tag large numbers of marketing URLs. Today, in Part 3, I’ll start to pull this whole thing together by walking through a very basic analysis. […]

    Reply
  5. Web Developer and Design Reference Book says:
    June 11, 2007 at 6:13 am

    […] Google Analytics Campaign Tracking Pt. 2: The EpikOne Link Tagging Tool […]

    Reply
  6. Help Google Analytics Make Sense of Your Marketing Campaigns » Ambient and Transparent says:
    July 29, 2008 at 3:51 pm

    […] For editing a large number of URLs it may make sense to use a spreadsheet like the one provided by our friends at epikone.com […]

    Reply
  7. Internet Marketing for Real Estate » Tracking print advertising with ListingNumber and Google Analytics says:
    August 26, 2008 at 6:03 pm

    […] I’ve spent the afternoon playing with Google Docs to make a form-based tool so you can create your own campaign tagged links. My spreadsheet relies very very heavily on the excellent work of Justin Cutroni over at EpikOne. The main changes to his original link tagger are that I modified it for use with Google Forms so it’s slightly more automated. […]

    Reply
  8. Free Destination URL Builder | .eduGuru says:
    October 1, 2008 at 6:01 pm

    […] rereading a two year old post over on Analytics Talk it inspired me to go create my own Destination URL builder for Google Analytics.  It’s really a […]

    Reply
  9. Free Destination URL Builder and Tracking Tool - Octane-Sia.Com says:
    January 22, 2009 at 7:08 pm

    […] ACIDpunk on Jan.23, 2009, under Webmaster Tools After rereading a two year old post over on Analytics Talk it inspired me to go create my own Destination URL builder for Google Analytics.  It’s really a […]

    Reply
  10. Google URL Builder(Google URL 生成工具) » 深圳网站分析| Web Analytics ShenZhen says:
    September 14, 2011 at 8:54 am

    […] URL Builder from Justin Cutroni: http://cutroni.wpengine.com/2006/11/10/google-analytics-campaign-tracking-pt-2-the-epikone-link-tagging-tool/ […]

    Reply
  11. Comment utiliser le Générateur de Google Analytics pour suivre vos campagnes en ligne par URL et estimer leur valeur | says:
    October 15, 2011 at 4:43 am

    […] Il s’avère qu’il ya un outil gratuit dans la boîte à outils Google, que vous pouvez utiliser pour rendre ces liens spéciaux, appelé : outil de création d’URL. Si vous avez juste un ou deux liens à convertir, il est idéal. Si vous avez plusieurs liens à suivre, utilisez la technique décrite sur ce blog (en anglais) […]

    Reply
  12. Google Analytics Campaign URL Builder says:
    October 25, 2011 at 4:11 am

    […] lot of campaigns that require GA campaign parameters.  For these situations, Excel tools like the URL Builder from Justin Cutroni are more […]

    Reply
  13. COMMENT UTILISER LE GENERATEUR DE GOOGLE ANALYTICS POUR SUIVRE VOS CAMPAGNES EN LIGNE PAR URL ET ESTIMER LEUR VALEUR | Freelance en communication Atelier F.KA - Cunning Communication says:
    November 7, 2011 at 9:36 am

    […] Il s’avère qu’il ya un outil gratuit dans la boîte à outils Google, que vous pouvez utiliser pour rendre ces liens spéciaux, appelé : outil de création d’URL. Si vous avez juste un ou deux liens à convertir, il est idéal. Si vous avez plusieurs liens à suivre, utilisez la technique décrite sur ce blog (en anglais) […]

    Reply
  14. 4+ Tips for Effectively Tagging URLs says:
    December 19, 2011 at 7:30 am

    […] tracking variables and a built in formula does the rest. Here’s a link to the file. (Thanks to Justin Cutroni for sharing this with […]

    Reply
  15. [Poll] What Tools Do You Use for Social Media URL Tracking? says:
    November 2, 2012 at 11:45 am

    […] URL Builder, and EpikOne spreadsheet tool are a couple I’ve used in the […]

    Reply
  16. Is There Any Way To Automate _utm Tagging? | Data Runs DeepData Runs Deep says:
    February 18, 2013 at 5:33 pm

    […] link taggers (for want of a better term) have long been able to use EpikOne’s Link Tagging Tool which uses spreadsheet formulas to create trackable links with all the parameters you need. It does […]

    Reply
  17. Can Google Analytics Track Email Opens? says:
    April 10, 2013 at 7:32 am

    […] Excel document for creating URL’s […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

My Books

Google Analytics by Justin Cutroni
Learn More on Amazon.com

Performance Marketing co-authored by Justin Cutroni
Learn More on Amazon.com

Recent Posts

  • Understanding the Google Analytics Cohort Report
  • Using Offline and Online data to drive Google Analytics Remarketing
  • Understanding Cross Device Measurement and the User-ID
  • Universal Analytics: Now out of beta!
  • Advanced Content Tracking with Universal Analytics

Categories

  • About Google Analytics (25)
  • Analysis (52)
  • Analytics Strategy (3)
  • Campaign Tracking (14)
  • Ecommerce (8)
  • Event Tracking (10)
  • Remarketing (2)
  • Reporting (10)
  • Resources (7)
  • Tag Management (5)
  • Tips (25)
  • Tracking (52)
  • Uncategorized (64)
  • Universal Analytics (9)
  • Web Analytics (15)

Copyright © 2023 ·News Pro Theme · Genesis Framework by StudioPress · WordPress