A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 Medium | UTM Source | UTM Campaign | UTM Content | UTM Term | URL | Shorterned Bit.ly Link | Automatic URL Generator | ||||||||||
9 | social | Ebsta Spring Release | Personalized Meeting Page | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page | ||||||||||||
10 | social | Ebsta Spring Release | Meeting Booking Software | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software | ||||||||||||
11 | social | Ebsta Spring Release | Email Campaigns | https://www.ebsta.com/automated-email-campaigns/ | #N/A | https://www.ebsta.com/automated-email-campaigns/?utm_medium=social&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page | ||||||||||||
12 | social | Ebsta Spring Release | Email Mining for Leads | https://www.ebsta.com/salesforce-contact-lead-discover/ | #N/A | https://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 | paid | Ebsta Spring Release | Meeting Booking Software | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=paid&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software | ||||||||||||
14 | cpm | Ebsta Spring Release | Personalized Meeting Page | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpm&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page | ||||||||||||
15 | cpm | Ebsta Spring Release | Meeting Booking Software | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpm&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software | ||||||||||||
16 | social | Ebsta Spring Release | Meeting Booking Software | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=social&utm_source=linkedin&utm_campaign=Ebsta%20Spring%20Release&utm_content=Meeting%20Booking%20Software | ||||||||||||
17 | emailcampaign | Ebsta Spring Release | Email Campaigns | https://www.ebsta.com/automated-email-campaigns/ | #N/A | https://www.ebsta.com/automated-email-campaigns/?utm_medium=email&utm_source=emailcampaign&utm_campaign=Ebsta%20Spring%20Release&utm_content=Email%20Campaigns | ||||||||||||
18 | cube | Ebsta Spring Release | https://www.ebsta.com/salesforce-usage-report.html | #N/A | https://www.ebsta.com/salesforce-usage-report.html?utm_medium=email&utm_source=cube&utm_campaign=Ebsta%20Spring%20Release | |||||||||||||
19 | display | blog | Ebsta Spring Release | Free 14-day Trial | http://www2.ebsta.com/gmail-free-trial | #N/A | http://www2.ebsta.com/gmail-free-trial?utm_medium=display&utm_source=blog&utm_campaign=Ebsta%20Spring%20Release&utm_content=Free%2014-day%20Trial | |||||||||||
20 | display | blog | Ebsta Spring Release | Free 14-day Trial | http://www2.ebsta.com/gmail-free-trial | #N/A | http://www2.ebsta.com/gmail-free-trial?utm_medium=display&utm_source=blog&utm_campaign=Ebsta%20Spring%20Release&utm_content=Free%2014-day%20Trial | |||||||||||
21 | referral | ring-dna | Ebsta Spring Release | Combat Salesforce Challenge | https://www.ebsta.com/salesforce-usage-report.html | #N/A | https://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 | cpc | Ebsta Spring Release | Meeting Booking Software | https://www.ebsta.com/meeting-scheduling-software/ | #REF! | #REF! | ||||||||||||
23 | cpc | Ebsta Spring Release | Personalized Meeting Page | https://www.ebsta.com/meeting-scheduling-software/ | #N/A | https://www.ebsta.com/meeting-scheduling-software/?utm_medium=cpc&utm_source=twitter&utm_campaign=Ebsta%20Spring%20Release&utm_content=Personalized%20Meeting%20Page | ||||||||||||
24 | cpc | Ebsta Spring Release | Email Mining for Leads | https://www.ebsta.com/salesforce-contact-lead-discover/ | #N/A | https://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 | social | medium.com | Example Campaign | Example Content | http://www.example.com | #N/A | http://www.example.com?utm_medium=social&utm_source=medium.com&utm_campaign=Example%20Campaign&utm_content=Example%20Content | |||||||||||
29 | out of office | Ricky W Out of Office | GDPR is going to get you | http://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 |