UTM Builder and Shortener Spreadsheet (OPEN)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Please make a copy of this sheet. We do not give edit access to the template. Go to "File" then "Make a copy" <- Read this before emailing us for access.Sorry, we increase the font size each time someone emails us for access. Make a copy. Don't email, we won't respond about access to this sheet. Generated CELLS - Don't EditMake cell empty to trigger lookup. Then paste values only from col J
2
DescriptionDateMedium*Source*Campaign Name*Ad ContentKeywordDestination URLCampaign-Tagged URLBitly Shortened URLLive Count of Clicks (L)Saved URL
3
Testing the system3/15/2016testtesttesthttps://google.comhttps://google.com?utm_medium=test&utm_source=test&utm_campaign=testFALSE284http://bit.ly/1Lp3V4u
4
Live lookup example3/16/2016bitlyapitestwholewhalehttps://wholewhale.com/impacthttps://wholewhale.com/impact?utm_medium=bitly&utm_source=api&utm_campaign=test&utm_term=wholewhale#N/A<--copy over J3 Bitly to save as has been done in L3
5
FALSEMake this cell empty to trigger lookup in Cell J
6
FALSEMake this cell empty to trigger lookup in Cell J
7
You must enter a Campaign SOURCE.FALSEMake this cell empty to trigger lookup in Cell J
8
FALSEMake this cell empty to trigger lookup in Cell J
9
FALSEMake this cell empty to trigger lookup in Cell J
10
FALSEMake this cell empty to trigger lookup in Cell J
11
FALSEMake this cell empty to trigger lookup in Cell J
12
FALSEMake this cell empty to trigger lookup in Cell J
13
FALSEMake this cell empty to trigger lookup in Cell J
14
Make this cell empty to trigger lookup in Cell J
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu