AnalyticsTracking, UTMs and data qualityIntermediateBuilds a checklist

UTM governance audit from a list of campaign URLs

Audits a list of tagged URLs for naming drift, case issues and missing parameters, and produces a naming standard you can enforce.

For: Performance marketers, Marketing analysts, Growth marketers · Works with: Any capable chat model (ChatGPT, Claude, Gemini, others), Google Analytics 4, Google Sheets / Excel

Public beta. This prompt was drafted with AI assistance and checked by automated rules, but it has not been reviewed or tested by a person yet. Treat it as a starting point and check the output. It is hidden from search engines while in beta. Use the “Was this prompt useful?” box to tell us what works.

Your prompt

Act as a marketing-operations analyst. Audit the UTM tagging in the URLs below against my naming rules. Naming rules I intend to follow: lowercase, hyphen-separated, campaign = yyyymm_theme_audience. Allowed sources and mediums (if defined): sources: google, meta, linkedin, newsletter; mediums: cpc, paid-social, email, referral. URLs (one per line): https://example.com/offer?utm_source=Google&utm_medium=CPC&utm_campaign=202610_spring_smb https://example.com/offer?utm_source=meta&utm_medium=paid_social&utm_campaign=Spring Sale https://example.com/offer?utm_source=newsletter&utm_campaign=202610_spring_smb Deliver: 1. Assumptions (for example how you treat case, spaces and encoded characters; that GA4 treats values as case-sensitive strings in reports). 2. A table with each URL's parsed utm_source, utm_medium, utm_campaign, utm_content and utm_term, and a status: OK, NEEDS FIX or MISSING PARAMETER, with the reason. Parse only what is literally in the URLs; if something is not provided, write "missing". 3. A summary of the patterns found (case variants, near-duplicate values, spaces, wrong medium for the source, missing campaign names). 4. A proposed naming standard (lowercase, separators, allowed values, campaign naming pattern) consistent with my rules, plus a validation checklist before launching a link. 5. How the issues could distort reporting (channel grouping, duplicates), described as risks, not measured effects. 6. A corrected version of each URL labelled "suggested", which I must verify before use. Rules: do not invent values that are not in my URLs or rules. Check that every row in your table corresponds to a URL I gave. Verify parsing carefully; if a URL is malformed, say so.

Customize

The fields start with example values so you can see how the prompt works. Everything stays in your browser.

Your intended standard.

Allowed lists, or 'none defined'.

Paste your URLs. The default is small fictional sample data so the preview works; replace it with your own.

Example of what to expect

Illustrative only. It describes the kind of result this prompt aims for; real output varies by tool, model and run.

A per-URL parse table with statuses (for example 'Google/CPC: case drift', 'missing utm_medium'), patterns found, a proposed naming standard, a pre-launch checklist and suggested corrected URLs to verify. (Illustrative.)

Expected format: Parse table, patterns, naming standard, checklist, suggested fixes.

How to use it

  1. Verify suggested URLs before replacing live links.
  2. Adopt the naming standard across teams.
  3. Generate new links with a builder to enforce it.

Limitations

  • Do not change live tracked URLs without checking downstream reports.
  • The model parses text; verify with a tool for edge cases.

Platform notes

Any capable chat model (ChatGPT, Claude, Gemini, others)

Official docs read · checked 2026-10-11

Works in any capable chat model. Paste a small anonymised sample and recompute the key numbers yourself: chat models can misread columns or miscalculate, and they cannot run your statistical tests reliably.

General notes on Any capable chat model (ChatGPT, Claude, Gemini, others)
  • These prompts are plain text and work in any chat assistant. For analytics prompts, paste a small, anonymised export; a chat model can misread columns or miscalculate, so recompute key numbers yourself.

Google Analytics 4

Official docs read · checked 2026-10-11

GA4 exports and the interface can differ (sampling, thresholds, attribution, data freshness); state which one your numbers came from.

General notes on Google Analytics 4
  • The BigQuery export has daily events_YYYYMMDD tables and intraday tables; intraday lacks some fields, and late-arriving data can update a daily table for up to 3 days.
  • Exported data and the GA4 interface can differ; the export documentation links to separate comparison articles that we did not read.

Google Sheets / Excel

Not verified: third-party guidance only · checked 2026-10-11

Test any formulas on a small range first; syntax depends on locale and version.

General notes on Google Sheets / Excel
  • Formulas are written for common functions in both products. Locale settings (decimal and argument separators) can change what you must type.

Source, license and attribution

Origin
Original by MarketerTools
Publisher
MarketerTools
License
Original work by MarketerTools, free to copy and use. Informed by the linked documentation; no third-party text is reproduced.
Platform assumptions checked
2026-10-11

Documentation and references behind this prompt

These informed the structure and the platform notes. A reference is not a license, and no third-party prompt text is copied here.

Spotted an attribution error, or are you a source owner with a request? Use the chat button at the bottom right and quote prompt ID ana-039. We will correct or remove it.

Related prompts

  • AnalyticsIntermediateBuilds a checklist

    GA4 event and conversion tracking audit from an event list

    Reviews your event list and key-event setup for naming, duplication, missing parameters and gaps against a measurement plan.

    Google Analytics 4 · Any capable chat model (ChatGPT, Claude, Gemini, others)

  • AnalyticsIntermediateBuilds a checklist

    Lead-data cleaning and lead-quality audit

    Plans how to clean a lead export (duplicates, formats, junk) and how to check lead quality by source, using only fields you have.

    Google Sheets / Excel · Any capable chat model (ChatGPT, Claude, Gemini, others)

  • AnalyticsIntermediateWrites a report

    GA4 weekly channel performance summary from an export

    Summarises a GA4 channel export into a short report of what changed, with every figure computed from your data and every explanation labelled as a hypothesis.

    Google Analytics 4 · Any capable chat model (ChatGPT, Claude, Gemini, others)