GA4 BIGQUERY ANALYTICS

Unlock the power of Google Analytics with Big Query

HOW IT WORKS (Step-by-Step) — SIMPLIFIED

3-Step Setup (You’ll do this once. Then it’s automatic.)

Step 1: Name your campaign (5 minutes) Go to Campaign Naming tab. Enter your brand, channel, audience, and quarter. The tool generates ozempic_email_hcp_awareness_2026q2. Copy this into SFMC, GA4, and Salesforce CRM. This is your attribution anchor.

Step 2: Build your UTM URLs (3 minutes per email) Open UTM Builder. Paste your landing page URL. Select your email platform from the dropdown (40+ options). Choose utm_content for each clickable element (hero CTA, secondary CTA, footer, logo, etc.). Copy each generated URL directly into SFMC. No typing. No typos.

Step 3: Run QA before you hit send (10 minutes) Work through the 22-item checklist across 5 phases. Pay special attention to the 5 critical checks (marked red). If all 22 pass, you send with full confidence. If QA fails, fix before send. Data is never broken retroactively.

Then: Validate in GA4 + CRM (5 minutes post-send) Within 10 minutes of send, check GA4 real-time. Confirm sessions appear under the right campaign name. Check utm_content breakdown to see which CTA drove traffic. In CRM, confirm leads are attributed to the right Campaign ID. Loop closes.

Email Campaign Tagging System

Email Campaign Tagging System is a plug-and-play toolkit designed to:

Standardize your UTM tagging code, eliminate manual errorsm ensure eveyr email is fully trakable and give you clean, reliable campaign data for actionable insights.


Campaign Tagging Toolkit

Campaign Tagging Toolkit

Enter your access code to unlock your toolkit.
Campaign naming convention builder
UTM builder — 40+ email sources
Pre & post-send QA checklist
Cross-system alignment validator

Campaign Tagging Toolkit

Campaign naming · UTM builder · QA checklist

PRO
Build your campaign name
Format: YYYYqQ or YYYYMM
Same ID used in utm_campaign
Name breakdown
Brand
Channel
Theme
Audience
Date
Generated campaign name
Fill in the fields above to generate your campaign name.
Naming rules reference
Rule✓ Correct✗ Wrong
Lowercase onlyozempicOzempic
Underscores, not spaceshcp_awarenesshcp awareness
Date format2026q2Q2-2026
Same name in all systemsCMP_10234 everywhereDiffers per system
Never reuse campaign namesNew ID each campaignOld names reused
No special charactershcp_launch_2026q2hcp launch (2026)
Campaign details
Landing page — no UTMs, no trailing slash
40+ platforms — grouped by category
Must match SFMC, GA4 & CRM
Unique per clickable element
Audience or segment
Generated URL
Fill in your base URL above to generate your tagged link.
Pre & post-send QA 0 / 22 complete
Why the Campaign Tagging Toolkit exists

Most email attribution data is wrong before the email even sends.

Manual UTM entry, inconsistent naming, and no QA process means your GA4 reports are filled with ghost campaigns, split traffic, and invisible clicks. The Campaign Tagging Toolkit fixes all three — permanently.

90%
of attribution failures come from just 8 repeated mistakes
3
systems that must stay in sync — SFMC, GA4 & Salesforce CRM
0
manual URL typing required when you use this toolkit correctly
How to use this toolkit — step by step
1
Start with Campaign Naming

Before building any links, go to the Campaign Naming tab. Enter your brand, channel, campaign theme, audience, and date. The tool auto-generates a standardised name like ozempic_email_hcp_awareness_2026q2. Copy this exact name into SFMC, GA4, and your Salesforce CRM. This is your attribution anchor — every other step depends on it.

2
Build your UTM URLs

Go to the UTM Builder tab. Enter your landing page URL, select your sending platform from the dropdown (never type it), paste your Campaign ID, and choose the correct utm_content for each link in your email. Build one URL per clickable element — hero CTA, secondary CTA, footer link, banner, logo. Copy each URL directly into SFMC. No manual typing, no typos.

3
Run the QA checklist before every send

Go to the QA Checklist tab. Work through all 22 checks before hitting send. Pay special attention to items tagged critical — these are the checks that catch the failures that can never be fixed retroactively. Do not skip post-send validation. Errors caught 10 minutes after send are fixable. Errors found in a monthly report are not.

4
Validate in GA4 and CRM after send

Within 10 minutes of sending, open GA4 real-time view. Confirm sessions are appearing under the correct campaign name. Check utm_content breakdown to see which CTA drove traffic. In Salesforce CRM, confirm leads are being attributed to the correct Campaign ID. This closes the full attribution loop from email click to revenue.

What each tool does
📋
Campaign Naming

Builds your campaign name to a fixed format every time. Prevents the single biggest cause of attribution failure — campaign names that don’t match across systems. Includes a live cross-system alignment checker that shows you exactly what to put in SFMC, GA4, and CRM.

Solves: fragmented GA4 data · CRM attribution gaps · campaign duplication
🔗
UTM Builder

Generates clean, consistent UTM URLs using dropdowns — not free text. Supports 45+ sending platforms grouped by category including pharma-specific tools like Veeva Vault and Veeva Engage. Every URL follows the same structure, every time, for every person on your team.

Solves: typos in UTM values · inconsistent source values · missing utm_content
QA Checklist

22 checks across 5 phases: link validation, consistency, click testing, GA4 validation, and CRM attribution. Each check is tagged as pre-send, post-send, or critical. Collapsible sections let you work through phases independently. Progress bar shows completion at a glance.

Solves: broken links · redirect stripping · missing post-send validation
The 8 failures this toolkit prevents
01
No naming standard — every sender builds their own campaign name. GA4 fills with hundreds of unconnected variants.
02
Missing utm_content — you know a link was clicked, but not which one. Hero CTA vs footer link — invisible.
03
Redirect stripping — a link shortener or redirect silently removes UTM parameters before the user hits the landing page.
04
Campaign duplication — the same campaign runs twice with different names. Data is permanently split.
05
No pre-send QA — errors are discovered after 50,000 sends. Nothing can be fixed retroactively.
06
CRM disconnect — leads are captured but never tied to the email campaign that drove them.
07
Case inconsistencyCMP_10234 and cmp_10234 are two separate campaigns in GA4.
08
Journey blind spots — journey emails have no tracking. You know the journey ran, not what it achieved.
Who this toolkit is built for
Email Marketing Manager

You send 10–50 campaigns a month across multiple brands. This toolkit standardises your team’s output and eliminates the QA rework that happens before every send.

Digital Analytics Lead

You spend hours cleaning GA4 data caused by inconsistent UTM tagging. This toolkit enforces the conventions upstream — before the data gets dirty.

Pharma / HCP Marketer

You work in a compliance-sensitive environment where traceability matters. This toolkit gives you an auditable, repeatable process for every campaign you run in SFMC.

CRM / Salesforce Admin

You need campaign IDs to match between SFMC and Salesforce CRM. This toolkit bakes that alignment into the campaign-naming step so it’s never an afterthought.


Discover more from GA4 BIGQUERY ANALYTICS

Subscribe to get the latest posts sent to your email.

Leave a Reply

Discover more from GA4 BIGQUERY ANALYTICS

Subscribe now to keep reading and get access to the full archive.

Continue reading