UTM Builder and Shortener Spreadsheet (OPEN)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
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 Edit			Use the Bitly Advanced Shortener for batch processing	Bitly Shortener addon
2	Description	Date	Medium*	Source*	Campaign Name*	Ad Content	Keyword	Destination URL	Campaign-Tagged URL	Legacy Bitly hook	Legacy Bitly Count of Clicks (L)	Saved URL	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-	Use this add-on to batch process URL shortening	Direct link to the add-on for Bit.ly URL creation with 4.0 API

3	Testing the system	3/15/2016	test	test	test			https://google.com	https://google.com?utm_medium=test&utm_source=test&utm_campaign=test	FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
4	Live lookup example	3/16/2016	bitly	api	test		wholewhale	https://wholewhale.com/impact	https://wholewhale.com/impact?utm_medium=bitly&utm_source=api&utm_campaign=test&utm_term=wholewhale	#N/A
5										FALSE		Use the bitly shortener
6										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
7									You must enter a Campaign SOURCE.	FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
8										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
9										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
10										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
11										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
12										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
13										FALSE	#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
14											#N/A	https://support.bitly.com/hc/en-us/articles/360024372212-Can-I-integrate-Bitly-with-Google-Sheets-
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