Loading ...
Sorry, an error occurred while loading the content.

28533Re: URL excel creator for tracking all external campaigns

Expand Messages
  • Alla
    Oct 6, 2011
    • 0 Attachment
      It's very interesting, Birger. I'll have a look at it.
      Many thanks,
      Alla

      --- In webanalytics@yahoogroups.com, "friedrichs04" <bf@...> wrote:
      >
      > Hi Alla,
      >
      > I assume
      >
      > SUBSTITUTE(E3,"","-"..
      >
      > is a work around in order to create correct URLs. :)
      >
      > Too bad that Excel doesn't provide a function like URLENCODE(A1) to properly encode a text string.
      >
      > Since we also provide Excel templates to our clients and URL encoding was always a hassle our developers wrote an Excel plugin that adds the functions URLENCODE and URLDECODE. This is very helpful for us and our clients.
      >
      > We released the plugin to the public and it can be downloaded from here:
      >
      > http://www.dc-storm.de/news/URLencode+%26+URLdecode+als+Excel-Funktion/#download
      >
      > Sorry, the installation instructions are in German. But you might get it from the screen shots how to add it via Excel's Add-In manager.
      >
      > If anybody is going to use the plugin I'm happy to get/see any feedback, shares, tweets etc. :)
      >
      > Regards,
      > Birger
      >
      >
      > --- In webanalytics@yahoogroups.com, "Alla" <alla.omelchenko@> wrote:
      > > Hi Kris
      > >
      > > Use Concatenate function
      > >
      > > The formula may look something like
      > >
      > > =J3&"&utm_campaign="&LOWER(SUBSTITUTE(E3," ","-"))&"&utm_source="&LOWER(SUBSTITUTE(G3," ","-"))&"&utm_medium="&LOWER(SUBSTITUTE(F3," ","-"))&IF(NOT(ISBLANK(H3)),"&utm_content="&LOWER(SUBSTITUTE(H3," ","-")),"")&IF(NOT(ISBLANK(I3)),"&utm_term="&LOWER(SUBSTITUTE(I3," ","-")),"")
      > >
      > > where J3 is your destination url. I used ampersand as I have other tags in front but you van replace it with the question mark.
      > > Previous columns contain your GA tag parameters.
      > >
      > > Alla
      > >
      >
    • Show all 15 messages in this topic