luvv to helpDiscover the Best Free Online Tools
Topic 4 of 8

Date And Text Functions For UTMs

Learn Date And Text Functions For UTMs for free with explanations, exercises, and a quick test (for Marketing Analyst).

Published: December 22, 2025 | Updated: December 22, 2025

Why this matters

  • Has slugs for source/medium/campaign.
  • Appends yyyymm to the campaign.
  • Uses ? or & correctly.
Show a sample result

https://example.com/landing?utm_source=google-ads&utm_medium=cpc&utm_campaign=back-to-school_202508

Next steps

  • Complete the exercises above, then take the quick test below to check understanding.
  • Note: The test is available to everyone; only logged-in users will have their progress saved.

Practice Exercises

2 exercises to complete

Instructions

Create a sheet with columns: A base_url, B source, C medium, D campaign, E date, F term, G content.

  1. Make helper columns: source_clean, medium_clean, term_clean, content_clean using =LOWER(SUBSTITUTE(TRIM(cell)," ","-")).
  2. Create campaign_code = slug(campaign) & "_" & TEXT(date, "yyyymm").
  3. Build a TEXTJOIN to form the query, skipping blanks for term/content.
  4. Assemble the final URL and handle existing ? with FIND.
Expected Output
A full URL like https://example.com/landing?utm_source=facebook-ads&utm_medium=paid-social&utm_campaign=summer-promo_202506&utm_term=beach-wear&utm_content=image-a

Date And Text Functions For UTMs — Quick Test

Test your knowledge with 8 questions. Pass with 70% or higher.

8 questions70% to pass
Campaign Reporting TemplatesConditional Formatting For Monitoring

Have questions about Date And Text Functions For UTMs?

AI Assistant

Ask questions about this tool