Library › Marketing AI › Marketing and content

Generate UTM tracking links in a CSV that follow the naming rules

  • For Marketing and content
  • You practice Asking for a format you can use
  • Time about 5 minutes
  • Level Advanced

About this exercise

Build tracking links for the Spring Sale 2027 campaign. Write a prompt that outputs one CSV code block with the header channel,url and one row per approved channel. Each url is the base link plus utm_source, utm_medium and utm_campaign, in that order, all lowercase with hyphens instead of spaces. Medium rules: email for newsletters, social for social posts, cpc for paid search, referral for partner blogs. No text outside the block.

Common mistakes when you ask AI for this

  • Including cancelled channels. The AI lists every row in the sheet. Try: Say: "Only channels with status Approved."
  • Copying last year's format. The AI copies the broken example's capitals and underscores. Try: Say: "All lowercase, hyphens instead of spaces or underscores."
  • Wrong medium. The AI guesses mediums like 'paid' or 'cpm'. Try: Give the mapping: email, social, cpc, referral.
  • Extra rows or chatter. The AI adds a notes row or an intro. Try: Say: "Header plus 4 rows only; no text outside the block."

What a strong prompt includes

  • Gives the CSV header
  • States parameter order
  • Gives the medium mapping
  • Only approved channels
  • Lowercase with hyphens

Practice this now ↑

Related exercises