Annie Cushing's Google Analytics Campaign Tagging Tool
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEHIJ
1
2
Annielytics.com
3
@AnnieCushing
4
5
Check out my comprehensive campaign tagging guide/video
6
7
If you want to use this Google Doc for yourself, log in to Google, then choose File > Make a copy ... Please don't request access to it.
8
9
Instructions and Tips for Each Column
10
Paste your URLs in this column.This should be your largest "bucket" so to speak. So instead of using a medium called twitter, use social. Instead of using a medium called mashable+banner+tower, use banners. Instead of using a medium called monthly+email, use email. Good mediums are social (or social+media), banner, affiliate, feed, etc. If you don't use social for all social tagging, these visits won't show up in GA's glorious Social Channels report!This should be wherever the link lives. So if you tweeted a link, the source should be twitter.com. If you have a banner on Mashable, the source should be mashable.com. If you're tagging a link in an email (as you should ALL links that point back to your site in emails), it should be something like your site's domain or internal, not email. That's the medium.

VERY IMPORTANT: If you're tagging links for Google+ you must set the source to plus.google.com or plus.url.google.com for it to route to your social reports correctly.
This should be intuitive and should be as specific as the data you want to collect. Use a plus sign (+) to separate words. This will insert spaces in Google Analytics reports, which are easier to read than hyphenated campaign names.To use this URL, first select the cell(s) and press Ctrl/Command-C to copy it, then right-click and choose Paste Special > Paste values only in the column to the right. Screenshot: http://screencast.com/t/8tVPxeRQ

VERY IMPORTANT: Don't select cells in this column that don't have tagged URLs in them. This will delete the formula, which auto-generates the tagged URLs. But if you lose the formula, just hover over the bottom-right corner of a cell that still has the formula and click-and-drag the fill handle up or down to sweep over all cells that are missing the formula. And if you fat finger the entire column, enter this formula in column G2:

=LOWER(IF(C2<>"",CONCATENATE("?",IF(C2<>"","utm_source="&C2,""), IF(D2<>"","&utm_medium="&D2,""), IF(E2<>"","&utm_campaign="&E2), IF(F2<>"", "&utm_content="&F2,"")),""))
Paste URLs from Column G here. Paste as values only to convert cell contents from a formula to text. To paste as values, press Ctrl/Command-C to copy it, then right-click and choose Paste Special > Paste values only in the column to the right. Screenshot: http://screencast.com/t/8tVPxeRQ
11
URLCampaign MediumCampaign SourceCampaign NameDestination URLRaw URL
12
http://www.annielytics.com/hundreds-of-tools-for-marketers/socialtwitter.comsample+campaignhttp://www.annielytics.com/hundreds-of-tools-for-marketers/?utm_medium=social&utm_source=twitter.com&utm_campaign=sample+campaignhttp://www.annielytics.com/hundreds-of-tools-for-marketers/?utm_medium=social&utm_source=twitter.com&utm_campaign=sample+campaign
13
http://www.annielytics.com/hundreds-of-tools-for-marketers/?id=43102emailmailchimpmy+campaign+namehttp://www.annielytics.com/hundreds-of-tools-for-marketers/?id=43102&utm_medium=email&utm_source=mailchimp&utm_campaign=my+campaign+namehttp://www.annielytics.com/hundreds-of-tools-for-marketers/?id=43102&utm_medium=email&utm_source=mailchimp&utm_campaign=my+campaign+name
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Loading...
 
 
 
Tagging Tool
Tips
Example Campaign