A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | The Rafflecopter Link Tagging Tool | |||||||||||||
2 | ||||||||||||||
3 | Instructions | *Note* | Original tool by Epik One: | https://docs.google.com/spreadsheet/ccc?key=0AtEJOHRy-eEEcDdjX0hLY21zcFNVZkVZU08wZ3NrS3c&hl=en#gid=0 | ||||||||||
4 | "Using this tool, you can automatically create large numbers of tagged destination URLs. 1. 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 2. Enter the destination URL for the ad. The destination URL is the URL where the visitor will 'land' on your site. 3. Copy the formula to the 'Tagged URL' cell for your row. | Our tool is a modified version of Epik One's link tagging tool. Thanks Epik One for putting this awesome spreadhseet together. | ||||||||||||
5 | ||||||||||||||
6 | utm_campaign | utm_source | utm_medium | utm_content | utm_term | destination URL | tagged URL | Bit.ly URL | ||||||
7 | new-feature-example-2014-may | newsletter | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=email&utm_source=newsletter | ||||||||
8 | new-feature-example-2014-may | blog | post | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=post&utm_source=blog | |||||||
9 | new-feature-example-2014-may | social | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=social&utm_source=twitter | ||||||||
10 | new-feature-example-2014-may | social | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=social&utm_source=facebook | ||||||||
11 | new-feature-example-2014-may | google-plus | social | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=social&utm_source=google-plus | |||||||
12 | new-feature-example-2014-may | social | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=new-feature-example-2014-may&utm_medium=social&utm_source=pinterest | ||||||||
13 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
14 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
15 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
16 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
17 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
18 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
19 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
20 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
21 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
22 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
23 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
24 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
25 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
26 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
27 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
28 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
29 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
30 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
31 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
32 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
33 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
34 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
35 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
36 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
37 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
38 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
39 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
40 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
41 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
42 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
43 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
44 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
45 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
46 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
47 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
48 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
49 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
50 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
51 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
52 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
53 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
54 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
55 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
56 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
57 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
58 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
59 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
60 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
61 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
62 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
63 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
64 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
65 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
66 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
67 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
68 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
69 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
70 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
71 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
72 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
73 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
74 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
75 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
76 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
77 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
78 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
79 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
80 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
81 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
82 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
83 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
84 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
85 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
86 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
87 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
88 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
89 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
90 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
91 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
92 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
93 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
94 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
95 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
96 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
97 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
98 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
99 | - | - | http://www.rafflecopter.com | http://www.rafflecopter.com?utm_campaign=&utm_medium=&utm_source= | ||||||||||
100 |