GA4 BIGQUERY ANALYTICS

Unlock the power of Google Analytics with Big Query

The SFMC + GA4 Attribution Toolkit

What Is the Email Campaign Tagging System?

It’s a plug-and-play toolkit built for marketing teams who are tired of cleaning up attribution after the fact. It standardizes your UTM tagging, eliminates manual errors, and ensures every email you send is fully trackable — so your campaign data is clean, consistent, and actually useful when it’s time to report.

Step 1: Name Your Campaign

Time: ~5 minutes

Open the Campaign Naming tab. Enter your brand, channel, audience, and quarter. The tool outputs a standardized name like:

ozempic_email_hcp_awareness_2026q2
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

Naming · UTM builder · QA checklist · Guide

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

Most email attribution is broken before the email even sends.

Manual UTM entry, inconsistent naming, and no QA process means your GA4 reports fill up with ghost campaigns, split traffic, and invisible clicks. This toolkit fixes all three — permanently, before a single email goes out.

90%
of attribution failures trace back to 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
1
Start with Campaign Naming

Before building any links, go to Campaign Naming. Enter your brand, channel, theme, audience, and date. The tool outputs a standardised name like ozempic_email_hcp_awareness_2026q2. Copy it into SFMC, GA4, and Salesforce CRM. This is your attribution anchor — everything else depends on it being identical in all three places.

2
Build your UTM URLs

Go to UTM Builder. Paste your landing page URL, select your sending platform from the dropdown, paste your Campaign ID, then choose the correct utm_content for each link. Build one URL per clickable element — hero CTA, secondary CTA, footer, banner, logo. Copy each directly into SFMC. No typing, no typos.

3
Run the QA checklist before every send

Go to QA Checklist and work through all 22 checks. Items tagged critical catch failures that can never be fixed after send — don’t skip them. A broken link found 10 minutes post-send is fixable. The same error discovered in a monthly report is permanent data loss.

4
Validate in GA4 and CRM after send

Within 10 minutes of sending, open GA4 real-time. Confirm sessions appear under the correct campaign name and check the utm_content breakdown to see which CTA drove traffic. In Salesforce CRM, confirm leads are tied to the right Campaign ID. That’s the loop closed — from email click to attributed revenue.

What each tool does
📋
Campaign Naming

Builds your campaign name to a fixed, enforced 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 showing exactly what to enter 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 including pharma-specific tools like Veeva Vault and Veeva Engage. Every URL follows the same structure, every time, regardless of who on your team built it.

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

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

Solves: broken links · redirect stripping · skipped 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 disconnected variants that can never be merged.
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 reaches your landing page.
04
Campaign duplication. The same campaign runs twice under different names. Traffic is permanently split and can’t be reconciled.
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. Revenue goes unattributed.
07
Case inconsistency. CMP_10234 and cmp_10234 are two entirely separate campaigns in GA4.
08
Journey blind spots. Journey emails run with no tracking. You know the journey fired — not what it achieved.
Who this 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 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 SFMC campaign you run.

CRM / Salesforce Admin

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

Step 2: Build Your UTM URLs

Time: ~3 minutes per email

Open the UTM Builder. Paste your landing page URL, then:

  • Select your email platform from the dropdown (40+ supported)
  • Choose a utm_content value for each clickable element — hero CTA, secondary CTA, footer link, logo, etc.
  • Copy each generated URL directly into SFMC

No typing. No typos. No “wait, what did I call that campaign again?”

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

Naming · UTM builder · QA checklist · Guide

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

Most email attribution is broken before the email even sends.

Manual UTM entry, inconsistent naming, and no QA process means your GA4 reports fill up with ghost campaigns, split traffic, and invisible clicks. This toolkit fixes all three — permanently, before a single email goes out.

90%
of attribution failures trace back to 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
1
Start with Campaign Naming

Before building any links, go to Campaign Naming. Enter your brand, channel, theme, audience, and date. The tool outputs a standardised name like ozempic_email_hcp_awareness_2026q2. Copy it into SFMC, GA4, and Salesforce CRM. This is your attribution anchor — everything else depends on it being identical in all three places.

2
Build your UTM URLs

Go to UTM Builder. Paste your landing page URL, select your sending platform from the dropdown, paste your Campaign ID, then choose the correct utm_content for each link. Build one URL per clickable element — hero CTA, secondary CTA, footer, banner, logo. Copy each directly into SFMC. No typing, no typos.

3
Run the QA checklist before every send

Go to QA Checklist and work through all 22 checks. Items tagged critical catch failures that can never be fixed after send — don’t skip them. A broken link found 10 minutes post-send is fixable. The same error discovered in a monthly report is permanent data loss.

4
Validate in GA4 and CRM after send

Within 10 minutes of sending, open GA4 real-time. Confirm sessions appear under the correct campaign name and check the utm_content breakdown to see which CTA drove traffic. In Salesforce CRM, confirm leads are tied to the right Campaign ID. That’s the loop closed — from email click to attributed revenue.

What each tool does
📋
Campaign Naming

Builds your campaign name to a fixed, enforced 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 showing exactly what to enter 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 including pharma-specific tools like Veeva Vault and Veeva Engage. Every URL follows the same structure, every time, regardless of who on your team built it.

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

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

Solves: broken links · redirect stripping · skipped 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 disconnected variants that can never be merged.
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 reaches your landing page.
04
Campaign duplication. The same campaign runs twice under different names. Traffic is permanently split and can’t be reconciled.
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. Revenue goes unattributed.
07
Case inconsistency. CMP_10234 and cmp_10234 are two entirely separate campaigns in GA4.
08
Journey blind spots. Journey emails run with no tracking. You know the journey fired — not what it achieved.
Who this 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 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 SFMC campaign you run.

CRM / Salesforce Admin

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

Step 3: QA Before You Hit Send

Time: ~10 minutes

Work through the 22-item checklist across 5 phases. The 5 critical checks are flagged in red — don’t skip them.

The rule is simple: all 22 pass, you send. Any QA failure means fixing it before send. Unlike most marketing mistakes, broken UTM data can’t be fixed retroactively. Once those emails are out, that data is gone.

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

Naming · UTM builder · QA checklist · Guide

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

Most email attribution is broken before the email even sends.

Manual UTM entry, inconsistent naming, and no QA process means your GA4 reports fill up with ghost campaigns, split traffic, and invisible clicks. This toolkit fixes all three — permanently, before a single email goes out.

90%
of attribution failures trace back to 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
1
Start with Campaign Naming

Before building any links, go to Campaign Naming. Enter your brand, channel, theme, audience, and date. The tool outputs a standardised name like ozempic_email_hcp_awareness_2026q2. Copy it into SFMC, GA4, and Salesforce CRM. This is your attribution anchor — everything else depends on it being identical in all three places.

2
Build your UTM URLs

Go to UTM Builder. Paste your landing page URL, select your sending platform from the dropdown, paste your Campaign ID, then choose the correct utm_content for each link. Build one URL per clickable element — hero CTA, secondary CTA, footer, banner, logo. Copy each directly into SFMC. No typing, no typos.

3
Run the QA checklist before every send

Go to QA Checklist and work through all 22 checks. Items tagged critical catch failures that can never be fixed after send — don’t skip them. A broken link found 10 minutes post-send is fixable. The same error discovered in a monthly report is permanent data loss.

4
Validate in GA4 and CRM after send

Within 10 minutes of sending, open GA4 real-time. Confirm sessions appear under the correct campaign name and check the utm_content breakdown to see which CTA drove traffic. In Salesforce CRM, confirm leads are tied to the right Campaign ID. That’s the loop closed — from email click to attributed revenue.

What each tool does
📋
Campaign Naming

Builds your campaign name to a fixed, enforced 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 showing exactly what to enter 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 including pharma-specific tools like Veeva Vault and Veeva Engage. Every URL follows the same structure, every time, regardless of who on your team built it.

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

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

Solves: broken links · redirect stripping · skipped 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 disconnected variants that can never be merged.
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 reaches your landing page.
04
Campaign duplication. The same campaign runs twice under different names. Traffic is permanently split and can’t be reconciled.
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. Revenue goes unattributed.
07
Case inconsistency. CMP_10234 and cmp_10234 are two entirely separate campaigns in GA4.
08
Journey blind spots. Journey emails run with no tracking. You know the journey fired — not what it achieved.
Who this 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 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 SFMC campaign you run.

CRM / Salesforce Admin

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

After Send: Close the Loop in GA4 + CRM

Time: ~5 minutes post-send

Within 10 minutes of send, open GA4 real-time:

  • Confirm sessions are appearing under the correct campaign name
  • Check the utm_content breakdown to see which CTA is driving traffic

Then jump into your CRM and confirm leads are attributed to the right Campaign ID.

That’s it. The loop closes. Every click is traceable, every lead is attributed, and your next campaign starts with clean data.


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