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
Try it out on Perplexity
Copy Prompt and Open Claude
Copy Prompt and Open Sora
Evaluate Prompt
Organize and Improve Prompts with Curio AI Brain