Bonus: Build a UTM Spreadsheet with AI
A shared UTM builder in Google Sheets is one of the most useful things a marketing team can have. Everyone uses the same tool, the formulas do the work, and naming stays consistent.
Here's a prompt you can paste directly into Claude, ChatGPT, or any AI tool:
"Create a UTM builder spreadsheet in Google Sheets. Include columns for base URL, source, medium, campaign, term, and content. Generate a final column that automatically builds the full UTM link using formulas. Ensure the formula correctly appends parameters using question marks and ampersands. Include example rows and make it easy to duplicate for ongoing use."
Once you have it set up, share it with your whole team and make it the one source of truth for building links. Future-you will be grateful.
UTMs aren't complicated; they just need someone to explain them without assuming you already know the answer. If any of this clicked today, you're already ahead of where I was at year five.
If you made it this far, you probably care about doing marketing the right way. If you need support for your apartment communities, we're here for it. Let’s talk.