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

28526Re: URL excel creator for tracking all external campaigns

Expand Messages
  • Alla
    Oct 5, 2011
    • 0 Attachment
      --- In webanalytics@yahoogroups.com, "Kris" <afojay@...> wrote:
      >
      > Hello everyone,
      >
      > Is there anyone here that can help with creating an excel document that automatically names tracking url's. Presently, I need this for all marketing campaigns that go out, PPC, SEO, display and afffiliates.
      >
      > Thanks.
      >

      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