Struggling with copy-pasting utm_source, utm_medium, and utm_campaign parameters into URL builders? Try out CampTag’s URL builder spreadsheet for super-charged campaign URL tagging.
If you are new to the world of paid marketing campaigns, or if you have been using free URL builder tools, it’s time to graduate one step towards URL builder spreadsheets that help you generate URLs in bulk.
Changing values in the data validation table
Data validation values are added to Sheet 2, so that your campaign managers will not type in random values, resulting in data entry errors and bad campaign analytics.
Sheet 2 has standard values for utm_source, utm_medium, utm_campaign, utm_content and utm_geography.
Remove a value from there, or add a new value to the respective column based on your requirement. The values will get updated automatically in Sheet 1.
Remember that you can type these in capital letter, small letter or Title case, and the final formula will convert them to small letters.
Right click on the sheet name called Parameter values at the bottom of the sheet. Click on Protect the sheet. Specify who can edit the parameter values.
This step will ensure that the parameter values are not manipulated or modified by all the users of this spreadsheet.
While CampTag's URL builder spreadsheet is simple and powerful. It also has some limitations.
If you come across these limitations, please reach out to us. CampTag’s marketing taxonomy and Custom URL builder tool can help you create hundreds of custom dimensions efficiently. It’s error-proof, and also offers different Workspaces to separate your campaigns.
Column A – URL : This is the website landing page URL that you want your visitors to land. Make sure to use the full URL including https://, but do not add any spaces or ? at the end.
Column B – Source: This is the utm_source parameter which denotes the source your traffic is coming from, like Google Ads, LinkedIn, Twitter, Instagram etc.
Column C – Medium: This is the utm_medium parameter which specifies the channel you use for the paid marketing campaign like PPC, Email, Affiliate, Directory submissions etc.
Column D – Campaign Name: This is the utm_campaign parameter which is the name of you campaign and will help you distinguish this campaign from others.
Column E – Content: This is the utm_content parameter which specifies the type of campaign like Text Ads, Banner Ads, Carousel, Email Signature etc.
Column F – Term: This is the utm_term parameter which specifies the keyword used for that specific campaign. These are derived from keyword research tools, and usually cannot have data validation.
Column G, H, I – Custom dimensions: These are dummy values for custom dimensions you could add to your campaign. Replace them with the values you would like.
What if you do not want custom dimensions?
In this case, leave the column empty, or change the formula to remove the column values. Otherwise, the formula would throw an error.
What if you want to add more custom dimensions?
You could add more columns to this sheet, and then modify the formula to take care of the extra columns.
Base formula
=IF(A3="",,IF(OR(C3="",B3="",D3=""),"You must enter MEDIUM, SOURCE and CAMPAIGN NAME",SUBSTITUTE(LOWER(CONCATENATE(A3,"?","utm_source=",B3,"&utm_medium=",C3,"&utm_campaign=",D3,IF(E3="","","&utm_content="&E3),IF(F3="","","&utm_term="&F3),IF(G3="","","&utm_"&G2&"="&G3),IF(H3="","","&utm_"&H2&"="&H3),IF(I3="","","&utm_"&I2&"="&I3)))," ","+")))
Modified formula with extra parameters
=IF(A3="",,IF(OR(C3="",B3="",D3=""),"You must enter MEDIUM, SOURCE and CAMPAIGN NAME",SUBSTITUTE(LOWER(CONCATENATE(A3,"?","utm_source=",B3,"&utm_medium=",C3,"&utm_campaign=",D3,IF(E3="","","&utm_content="&E3),IF(F3="","","&utm_term="&F3),IF(G3="","","&utm_"&G2&"="&G3),IF(H3="","","&utm_"&H2&"="&H3), IF(I3="","","&utm_"&I2&"="&I3), IF(J3="","","&utm_"&J2&"="&J3), IF(K3="","","&utm_"&K2&"="&K3),IF(L3="","","&utm_"&L2&"="&L3)))," ","+")))
We hope that CampTag’s simple yet powerful URL builder spreadsheet makes your campaign tagging, and reporting easier and more efficient. Get in touch with us if you need help with marketing taxonomy or URL building.