Link URL Generator

	A	B	C	D	E	F	G	H
1	Link URL Generator - to add campaign parameters to links to your website from email or social media
2	Make a copy of this file and then you will be able to enter and delete data. Log into Google and right click the file name in the 'Shared with me' section of your Google Drive and 'Make a Copy', or 'Make a Copy' from the file menu of the open file.
3	Using these kinds of URLs will enable data in the Google Analytics Campaigns reports, so you can see website visits from specific emails and social media campaigns
4	Enter data in the turquoise columns (be systematic); copy the generated URL from the white column (G) to the yellow column (H) using 'Paste special > Paste values only'
5	Adapted from Annie Cushing - annielytics.com
6	Target URL	Source	Medium	Campaign	Content	Term	Calculated URL (do not enter anything in this column)	Copy from previous column and right-click > Paste special> Paste values only
7	Your link URL (including forward slash at the end)	Email: The name of the email service provider, e.g. Infusionsoft, Mailchimp. Social: the name of the social network. Be consistent with capitalisation.	Use 'Email' or 'Social' Be consistent with capitalisation.	A name that identifies the specific email, e.g. 'newsletter + date'; 'nurture sequence #2'. Social: a name that identifies the campaign , post or ad.	This field is optional. Email: if an email has >1 link, you could identify each	This field is optional.	This column contains a formula that builds the URL with parameters	This is the URL you will use as the link in your email or social media campaign.
8	Examples:
9	https://www.websiteinsights.net/posts/google-analytics-where-to-start/	Mailchimp	Email	Newsletter+10Aug20	article link		https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Mailchimp&utm_medium=Email&utm_campaign=Newsletter+10Aug20&utm_content=article link	https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Mailchimp&utm_medium=Email&utm_campaign=Newsletter+10Aug20&utm_content=article link
10	https://www.websiteinsights.net/posts/google-analytics-where-to-start/	Mailchimp	Email	Newsletter+10Aug20	download checklist link		https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Mailchimp&utm_medium=Email&utm_campaign=Newsletter+10Aug20&utm_content=download checklist link	https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Mailchimp&utm_medium=Email&utm_campaign=Newsletter+10Aug20&utm_content=download checklist link
11	https://www.websiteinsights.net/posts/google-analytics-where-to-start/	LinkedIn	Social	Post+15Aug20			https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=LinkedIn&utm_medium=Social&utm_campaign=Post+15Aug20	https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=LinkedIn&utm_medium=Social&utm_campaign=Post+15Aug20
12	https://www.websiteinsights.net/posts/google-analytics-where-to-start/	Facebook	Social	Ad+20Aug20			https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Facebook&utm_medium=Social&utm_campaign=Ad+20Aug20	https://www.websiteinsights.net/posts/google-analytics-where-to-start/?utm_source=Facebook&utm_medium=Social&utm_campaign=Ad+20Aug20
13
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
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