ABCDEFGHIJKLMNOPQR
1
Mass URL Builder for Tracking Marketing Campaigns
Big thanks to:
Bit.ly for being awesome: https://dev.bitly.com/spreadsheets.html
Folks at Google Analytics Academy: https://analyticsacademy.withgoogle.com/
2
By Ricky Wheeler, SaaS CMO @rickwheels | https://medium.com/ricky-wheeler | https://www.linkedin.com/in/rickywheeler/
3
4
Instructions: 1. Download this document. 2 Create a Bit.ly Access Token and insert into Cell B6.
5
6
Bit.ly Access Token
9cc29b3e2c7bc7369c7de5a101e5cf142865d971
https://bitly.com/a/oauth_apps
7
NB: API calls run out quickly with free Bit.ly Accounts
8
UTM MediumUTM SourceUTM CampaignUTM ContentUTM TermURLShorterned Bit.ly LinkAutomatic URL Generator
9
socialtwitterEbsta Spring ReleasePersonalized Meeting Pagehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page
10
socialtwitterEbsta Spring ReleaseMeeting Booking Softwarehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software
11
socialtwitterEbsta Spring ReleaseEmail Campaignshttps://www.ebsta.com/automated-email-campaigns/#N/Ahttps://www.ebsta.com/automated-email-campaigns/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page
12
socialtwitterEbsta Spring ReleaseEmail Mining for Leads
https://www.ebsta.com/salesforce-contact-lead-discover/
#N/Ahttps://www.ebsta.com/salesforce-contact-lead-discover/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Email%20Mining%20for%20Leads
13
paidlinkedinEbsta Spring ReleaseMeeting Booking Softwarehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=paid&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software
14
cpmlinkedinEbsta Spring ReleasePersonalized Meeting Pagehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpm&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page
15
cpmlinkedinEbsta Spring ReleaseMeeting Booking Softwarehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpm&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software
16
sociallinkedinEbsta Spring ReleaseMeeting Booking Softwarehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software
17
emailemailcampaignEbsta Spring ReleaseEmail Campaignshttps://www.ebsta.com/automated-email-campaigns/#N/Ahttps://www.ebsta.com/automated-email-campaigns/?utm_medium=email&utm_source=emailcampaign&utm_campaign=Ebsta%20Spring%20Release&utm_content=Email%20Campaigns
18
emailcubeEbsta Spring Releasehttps://www.ebsta.com/salesforce-usage-report.html#N/Ahttps://www.ebsta.com/salesforce-usage-report.html?utm_medium=email&utm_source=cube&utm_campaign=Ebsta%20Spring%20Release
19
displayblogEbsta Spring ReleaseFree 14-day Trialhttp://www2.ebsta.com/gmail-free-trial#N/Ahttp://www2.ebsta.com/gmail-free-trial?utm_medium=display&utm_source=blog&utm_campaign=Ebsta%20Spring%20Release&utm_content=Free%2014-day%20Trial
20
displayblogEbsta Spring ReleaseFree 14-day Trialhttp://www2.ebsta.com/gmail-free-trial#N/Ahttp://www2.ebsta.com/gmail-free-trial?utm_medium=display&utm_source=blog&utm_campaign=Ebsta%20Spring%20Release&utm_content=Free%2014-day%20Trial
21
referralring-dnaEbsta Spring ReleaseCombat Salesforce Challengehttps://www.ebsta.com/salesforce-usage-report.html#N/Ahttps://www.ebsta.com/salesforce-usage-report.html?utm_medium=referral&utm_source=ring-dna&utm_campaign=Ebsta%20Spring%20Release&utm_content=Combat%20Salesforce%20Challenge
22
cpctwitterEbsta Spring ReleaseMeeting Booking Softwarehttps://www.ebsta.com/meeting-scheduling-software/#REF!#REF!
23
cpctwitterEbsta Spring ReleasePersonalized Meeting Pagehttps://www.ebsta.com/meeting-scheduling-software/#N/Ahttps://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpc&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page
24
cpctwitterEbsta Spring ReleaseEmail Mining for Leads
https://www.ebsta.com/salesforce-contact-lead-discover/
#N/Ahttps://www.ebsta.com/salesforce-contact-lead-discover/?utm_medium=cpc&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Email%20Mining%20for%20Leads
25
Simlply Begin Populating Your UTM Values and URLs in the columns below to automatically create your tracked links
Please enter a Campaign SOURCE.
26
27
28
socialmedium.comExample CampaignExample Contenthttp://www.example.com#N/Ahttp://www.example.com?utm_medium=social&utm_source=medium.com&utm_campaign=Example%20Campaign&utm_content=Example%20Content
29
emailout of officeRicky W Out of OfficeGDPR is going to get youhttp://www2.ebsta.com/l/20102/2017-07-06/31wbfyg#N/A
http://www2.ebsta.com/l/20102/2017-07-06/31wbfyg?utm_medium=email&utm_source=out%20of%20office&utm_campaign=Ricky%20W%20Out%20of%20Office&utm_content=GDPR%20is%20going%20to%20get%20you
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