It is also possible to delete the Phone Number Database entered link immediately. Final link function Perhaps the most important function of this entire UTM tagging sheet: the function in the 'Link to Copy' column. In this column Phone Number Database the tagged link is generated using this function. A simplified version can be found in the column next to it. It contains only the UTM parameter part. url-builder-functionWhile I think Phone Number Database this feature is fairly self-explanatory (it looks bigger than it is), I'll go through it anyway. The function will not return a link as long as you have not filled in the required fields (base link, medium, source and campaign.
In addition, it checks whether Phone Number Database there are already query parameters in the base link, based on the question mark. If so, the UTM piece starts with a & sign. Otherwise just with a question mark. Of course, the Phone Number Database function only shows the optional UTM parameters if something is Phone Number Database entered here. Finally, all parameters are converted to lowercase and the spaces and other weird characters are replaced by minuses or underscores (depending on the MailChimp settings.
Extensions on the sheet While I am Phone Number Database personally convinced that I am hereby presenting you with the currently best UTM tagging sheet, I do believe that there is always room for improvement. Hopefully with your help I can make the sheet even better. So do you have any ideas? I'd love to hear from you via Phone Number Database the comment form below! I would also like to give you four ideas of how you could improve this sheet for your situation: 1. Automatic generation of Bitly links Using the Bitly API it is possible to have your final link converted into a Bitly link immediately, in the sheet. Remember Rule.