Traffic Source Quality & UTM Hygiene Audit

Goal: audit source/medium quality and UTM hygiene for {START_DATE}–{END_DATE}. Data: GA4 BigQuery export `{PROJECT}.{DATASET}.events_*`, ad platform logs, server-side UTMs. Steps: 1) Classify sessions by source/medium/campaign; 2) Flag malformed or missing UTMs; 3) Compute quality metrics (bounce rate, engaged sessions, CVR, AOV, LTV proxy); 4) Rank sources by quality vs spend. Output: table of sources with UTM fix checklist and top 5 cleanup priorities.

Heading:

Author: Tsubasa Kato

Model: GPT-5 Thinking

Category: Web Analytics

Tags: ga4;bigquery;utm;source-quality


Ratings

Average Rating: 0

Total Ratings: 0

Submit Your Rating:

Prompt ID:
68f70f6fe8e88ad0c2de4761

Average Rating: 0

Total Ratings: 0


Share with Facebook
Share with X
Share with LINE
Share with WhatsApp
Try it out on ChatGPT
Copy Prompt and Open Perplexity
Copy Prompt and Open Claude
Copy Prompt and Open Sora
Evaluate Prompt