Hey there,
We’ve spent 3 weeks building your GA4 foundation:
- ✅ Week 1: Fixed critical tracking issues
- ✅ Week 2: Mastered e-commerce events
- ✅ Week 3: Implemented privacy compliance
Now it’s time for the advanced stuff - the features that separate good marketers from great ones.
The features we’re covering today will:
- Increase ROAS by 20-40%
- Reduce customer acquisition cost
- Predict which users will convert
- Automate your reporting
- Give you SQL superpowers
You’re getting it for free.
Let’s go. 🚀
📊 Part 1: Audience Building Strategy
Audiences are GA4’s killer feature. Here’s why:
- Remarket to high-intent visitors
- Exclude recent converters
- Build lookalike audiences
- Segment your analysis
- Trigger automated actions
But most marketers create weak audiences. Today, I’ll show you how to build audiences that actually drive revenue.
The Audience Hierarchy
Build these audiences in order:
Tier 1: Core Audiences (Create These First)
1. Cart Abandoners (Last 7 Days)
Name: Cart Abandoners - 7D
Membership: Last 7 days
Conditions:
- Event: add_to_cart (at least once)
- Event: purchase (NOT happened)
- Within: Last 7 days
Use case: High-intent remarketing
Expected size: 2-5% of traffic
Conversion rate: 15-25%
Why 7 days?
- Fresh intent (still interested)
- Short enough for urgency
- Long enough to capture weekend browsers
How to activate:
- Export to Google Ads
- Create remarketing campaign
- Offer 10-15% discount
- Use countdown timers
2. Product Viewers (No Purchase)
Name: Product Viewers - No Purchase - 14D
Membership: Last 14 days
Conditions:
- Event: view_item (at least once)
- Event: add_to_cart (NOT happened)
- Event: purchase (NOT happened)
- Within: Last 14 days
Use case: Move from consideration to cart
Expected size: 10-20% of traffic
Remarketing strategy:
- Show product they viewed
- Add social proof (reviews, ratings)
- Display limited stock alerts
- Offer free shipping
3. Past Purchasers (30, 90, 180 Days)
Name: Purchasers - Last 30D
Membership: Last 30 days
Conditions:
- Event: purchase (at least once)
- Within: Last 30 days
Use case:
- Upsell/cross-sell
- Exclude from acquisition campaigns
- VIP treatment
Create 3 versions:
- Last 30 days: Recent buyers (upsell immediately)
- Last 90 days: Repeat purchase window
- Last 180 days: Win-back campaigns
4. High-Intent Visitors
Name: High Intent Visitors - 7D
Membership: Last 7 days
Conditions:
Include users who meet ANY:
- Event: view_item (3+ times)
- Event: add_to_cart (1+ times)
- Event: begin_checkout (1+ times)
- Event: page_view (5+ pages)
- Session duration: >180 seconds
Use case: Aggressive remarketing
Expected conversion rate: 8-12%
5. Engaged Newsletter Subscribers
Name: Newsletter Subscribers - Engaged
Membership: Last 90 days
Conditions:
- Event: sign_up (method = 'newsletter')
- Event: page_view (3+ times since signup)
Use case:
- Content promotion
- Product launches
- Loyalty campaigns
Tier 2: Exclusion Audiences (Save Ad Spend)
6. Recent Converters
Name: Recent Converters - 30D
Membership: Last 30 days
Conditions:
- Event: purchase (1+ times)
- Within: Last 30 days
Use case: EXCLUDE from acquisition campaigns
Ad spend saved: 10-20%
Why exclude:
- They already converted
- Don’t waste budget showing them ads
- Focus budget on new prospects
Apply to:
- All acquisition campaigns
- Awareness campaigns
- Brand campaigns
7. Bounced Visitors
Name: Bounced Visitors - 7D
Membership: Last 7 days
Conditions:
- Session engaged: = 0
- Pages per session: = 1
- Session duration: <10 seconds
Use case: Exclude from remarketing
Low intent, high cost
Tier 3: Advanced Segmentation
8. VIP Customers (High LTV)
Name: VIP Customers - High LTV
Membership: Last 540 days (18 months)
Conditions:
Include users who meet ANY:
- Purchase count: ≥ 3
- Total revenue: ≥ $500
- Event: purchase (last 60 days)
Use case:
- Exclusive offers
- Early access
- Premium support
- Loyalty rewards
9. Feature Adopters (SaaS)
Name: Feature Adopters - [Feature Name]
Membership: Last 30 days
Conditions:
- Event: feature_used (parameter: feature_name = 'advanced_reporting')
- Event count: ≥ 5 times
Use case:
- Upsell to higher tier
- Case study candidates
- Beta testers
- Product feedback
10. Content Enthusiasts
Name: Content Enthusiasts - 30D
Membership: Last 30 days
Conditions:
- Event: page_view (parameter: page_type = 'blog')
- Event count: ≥ 3
- Session duration: ≥ 120 seconds
Use case:
- Newsletter promotion
- Webinar invitations
- Lead magnets
- Content upgrades
Audience Activation Strategy
Google Ads Integration:
1. Admin → Product Links → Google Ads
2. Enable "Personalized advertising"
3. Select audiences to share
4. Wait 24-48 hours for population
5. Create remarketing campaigns
Campaign structure:
- Campaign 1: Cart Abandoners (high bid, aggressive)
- Campaign 2: Product Viewers (medium bid)
- Campaign 3: High Intent (medium bid)
- Campaign 4: Content Engaged (low bid, awareness)
Audience Membership Duration:
Cart Abandoners: 7 days (urgency)
Product Viewers: 14 days (consideration window)
Past Purchasers: 30-180 days (depends on purchase cycle)
High Intent: 7 days (strike while hot)
VIP Customers: 540 days (max allowed)
🔮 Part 2: Predictive Analytics
GA4’s predictive metrics use machine learning to forecast user behavior.
Requirements:
- ✅ 1,000+ returning users in last 28 days
- ✅ 1,000+ users who triggered conversion event
- ✅ Model quality threshold met (GA4 decides)
- ⏰ Takes 7+ days to generate predictions
The 3 Predictive Metrics:
1. Purchase Probability
Metric: Purchase probability
Meaning: Likelihood user will purchase in next 7 days
Range: 0-100%
Create audience:
Name: Likely Purchasers - 7D
Condition: Purchase probability ≥ 50%
Use case:
- Proactive outreach
- Personalized offers
- Aggressive remarketing
- Premium ad placement
2. Churn Probability
Metric: Churn probability
Meaning: Likelihood user will NOT purchase again in next 7 days
Range: 0-100%
Create audience:
Name: Likely Churners - 7D
Condition: Churn probability ≥ 50%
Use case:
- Win-back campaigns
- Special offers
- Customer success outreach
- Survey for feedback
3. Revenue Prediction
Metric: Predicted revenue
Meaning: Expected revenue from user in next 28 days
Range: $0 - $X
Create audience:
Name: High Value Potential - 28D
Condition: Predicted 28-day revenue ≥ $100
Use case:
- VIP treatment
- Premium customer service
- Upsell opportunities
- Account-based marketing
Combining Predictive Metrics
Power Combo #1: High Purchase Probability + No Recent Purchase
Name: Hot Prospects - Ready to Buy
Membership: Last 7 days
Conditions:
- Purchase probability: ≥ 60%
- Event: purchase (NOT happened in last 30 days)
Result: Users highly likely to buy for first time
Campaign: Aggressive acquisition, slight discount
Power Combo #2: High Churn + High Historic Value
Name: At-Risk VIPs
Membership: Last 7 days
Conditions:
- Churn probability: ≥ 50%
- Lifetime revenue: ≥ $500
Result: Valuable customers about to leave
Campaign: Urgent win-back, personal outreach
Power Combo #3: High Revenue Prediction + Feature Usage
Name: Expansion Opportunities
Membership: Last 30 days
Conditions:
- Predicted 28-day revenue: ≥ $200
- Event: feature_used (advanced features)
- Subscription tier: = 'pro'
Result: Users ready for enterprise upgrade
Campaign: Sales outreach, enterprise demo
📊 Part 3: Custom Funnels & Explorations
Move beyond standard reports with Explorations.
Essential Explorations to Create:
1. Purchase Funnel with Segment Comparison
Explore → Funnel Exploration
Steps:
1. view_item (Baseline: 100%)
2. add_to_cart (Typical: 40%)
3. begin_checkout (Typical: 60% of cart)
4. purchase (Typical: 70% of checkout)
Add comparison:
- New vs Returning users
- Mobile vs Desktop
- Paid vs Organic traffic
Insights:
- Which segment converts best?
- Where's the biggest drop-off?
- Device-specific issues?
2. Path Analysis: Journey to Purchase
Explore → Path Exploration
Starting point: add_to_cart
Ending point: purchase
Shows:
- Most common path
- Drop-off points
- Alternative journeys
- Time to conversion
Use case:
- Identify friction
- Optimize checkout flow
- Understand user behavior
3. Cohort Analysis: Retention Over Time
Explore → Cohort Exploration
Cohort by: Week (first visit)
Return: Week 1, 2, 3, 4 after first visit
Metric: Active users
Shows:
- How many users return?
- Which cohorts are stickiest?
- Product-market fit signal
By traffic source:
- Which channels have best retention?
- Paid vs organic retention
4. User Lifetime Value by Cohort
Explore → Cohort Exploration
Cohort by: Month (first purchase)
Metric: Total revenue
Time range: 12 months
Shows:
- LTV by acquisition month
- Seasonal patterns
- Campaign effectiveness over time
Example insight:
"Users acquired in Q4 have 30% higher LTV than Q2"
5. Segment Overlap
Explore → Segment Overlap
Segments:
- Mobile users
- Purchasers
- Newsletter subscribers
- High engagement (5+ pages)
Shows:
- Overlap between segments
- Unique to each segment
- Combination opportunities
Example insight:
"Mobile users who subscribe convert 2x"
🗄️ Part 4: BigQuery Export (SQL Superpowers)
BigQuery is where GA4 gets REALLY powerful.
Why BigQuery?
Standard GA4 Limitations:
- ❌ 14-month data retention max
- ❌ Can’t query raw event data
- ❌ Limited custom analysis
- ❌ Can’t join with other data sources
- ❌ Sampling on large datasets
BigQuery Benefits:
- ✅ Unlimited data retention
- ✅ SQL queries on raw data
- ✅ Join with CRM, ads, finance data
- ✅ No sampling
- ✅ Custom attribution models
- ✅ Machine learning integration
- ✅ FREE up to 1M events/day
Setting Up BigQuery Export
1. Create Google Cloud Project
- Go to console.cloud.google.com
- Create new project
2. Enable BigQuery API
- APIs & Services → Enable APIs
- Search "BigQuery API"
- Enable
3. Link GA4 to BigQuery
- GA4 Admin → Product Links → BigQuery
- Link → Choose project
- Select:
☑ Daily export (free up to 1M events/day)
☐ Streaming export (costs money)
4. Wait 24 hours
- First export happens next day
- Dataset: analytics_<property_id>
- Tables: events_YYYYMMDD
Essential BigQuery Queries
Query 1: Daily Active Users
SELECT PARSE_DATE('%Y%m%d', event_date) AS date,
COUNT(DISTINCT user_pseudo_id) AS daily_active_users
FROM `project.dataset.events_*`
WHERE _TABLE_SUFFIX BETWEEN '20250101' AND '20251231'GROUP BY dateORDER BY date DESC
Query 2: Revenue by Source/Medium
SELECT traffic_source.source,
traffic_source.medium,
traffic_source.name AS campaign,
COUNT(DISTINCT CASE WHEN event_name = 'purchase' THEN user_pseudo_id END) AS purchasers,
SUM(CASE WHEN event_name = 'purchase' THEN ecommerce.purchase_revenue END) AS revenue,
ROUND(SUM(CASE WHEN event_name = 'purchase' THEN ecommerce.purchase_revenue END) /
COUNT(DISTINCT CASE WHEN event_name = 'purchase' THEN user_pseudo_id END), 2) AS avg_order_value
FROM `project.dataset.events_*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY))
AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
AND event_name = 'purchase'GROUP BY source, medium, campaign
HAVING revenue > 0ORDER BY revenue DESC
Query 3: Custom Funnel with Time to Convert
WITH funnel AS (
SELECT user_pseudo_id,
MIN(CASE WHEN event_name = 'page_view' THEN event_timestamp END) AS step1_time,
MIN(CASE WHEN event_name = 'add_to_cart' THEN event_timestamp END) AS step2_time,
MIN(CASE WHEN event_name = 'begin_checkout' THEN event_timestamp END) AS step3_time,
MIN(CASE WHEN event_name = 'purchase' THEN event_timestamp END) AS step4_time
FROM `project.dataset.events_*`
WHERE _TABLE_SUFFIX = FORMAT_DATE('%Y%m%d', CURRENT_DATE())
GROUP BY user_pseudo_id
)
SELECT COUNT(DISTINCT user_pseudo_id) AS total_users,
COUNT(DISTINCT CASE WHEN step1_time IS NOT NULL THEN user_pseudo_id END) AS step1_users,
COUNT(DISTINCT CASE WHEN step2_time IS NOT NULL THEN user_pseudo_id END) AS step2_users,
COUNT(DISTINCT CASE WHEN step3_time IS NOT NULL THEN user_pseudo_id END) AS step3_users,
COUNT(DISTINCT CASE WHEN step4_time IS NOT NULL THEN user_pseudo_id END) AS step4_users,
-- Conversion rates ROUND(COUNT(DISTINCT CASE WHEN step2_time IS NOT NULL THEN user_pseudo_id END) * 100.0 /
COUNT(DISTINCT CASE WHEN step1_time IS NOT NULL THEN user_pseudo_id END), 2) AS step1_to_2_rate,
-- Time to convert (seconds) ROUND(AVG(CASE WHEN step4_time IS NOT NULL AND step1_time IS NOT NULL
THEN (step4_time - step1_time) / 1000000 END), 0) AS avg_seconds_to_purchase
FROM funnel
Query 4: Top Products by Revenue
SELECT item.item_id,
item.item_name,
item.item_category,
item.item_brand,
SUM(item.quantity) AS total_quantity_sold,
ROUND(SUM(item.item_revenue), 2) AS total_revenue,
ROUND(AVG(item.price), 2) AS avg_price,
COUNT(DISTINCT user_pseudo_id) AS unique_purchasers
FROM `project.dataset.events_*`,
UNNEST(items) AS item
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY))
AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
AND event_name = 'purchase'GROUP BY item.item_id, item.item_name, item.item_category, item.item_brand
ORDER BY total_revenue DESCLIMIT 50
Query 5: User Journey (First Touch Attribution)
WITH first_touch AS (
SELECT user_pseudo_id,
FIRST_VALUE(traffic_source.source) OVER (
PARTITION BY user_pseudo_id
ORDER BY event_timestamp ASC ) AS first_source,
FIRST_VALUE(traffic_source.medium) OVER (
PARTITION BY user_pseudo_id
ORDER BY event_timestamp ASC ) AS first_medium
FROM `project.dataset.events_*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY))
AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
),
purchases AS (
SELECT user_pseudo_id,
SUM(ecommerce.purchase_revenue) AS total_revenue
FROM `project.dataset.events_*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY))
AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
AND event_name = 'purchase' GROUP BY user_pseudo_id
)
SELECT ft.first_source,
ft.first_medium,
COUNT(DISTINCT ft.user_pseudo_id) AS total_users,
COUNT(DISTINCT p.user_pseudo_id) AS purchasers,
ROUND(SUM(p.total_revenue), 2) AS total_revenue,
ROUND(SUM(p.total_revenue) / COUNT(DISTINCT ft.user_pseudo_id), 2) AS revenue_per_user
FROM first_touch ft
LEFT JOIN purchases p ON ft.user_pseudo_id = p.user_pseudo_id
GROUP BY ft.first_source, ft.first_medium
ORDER BY total_revenue DESC NULLS LAST
🤖 Part 5: Automation Opportunities
Now that you have advanced GA4, let’s automate it.
Automation Idea #1: n8n Workflow - Daily Revenue Alert
Trigger: Schedule (every morning)
↓
BigQuery: Query yesterday's revenue
↓
Compare: Revenue vs 7-day average
↓
Condition: If >15% difference
↓
Slack: Send alert to #marketing channel
Benefit: Catch issues immediately
Automation Idea #2: Cart Abandonment Email Sequence
Trigger: Webhook from GA4 (cart_abandoned event)
↓
Delay: 1 hour
↓
Check: Did user purchase? (GA4 Measurement Protocol)
↓
If NO → Send email 1: "You left something in your cart"
↓
Delay: 24 hours
↓
If still NO → Send email 2: "10% off your cart"
↓
Delay: 48 hours
↓
If still NO → Send email 3: "Last chance - expires today"
Benefit: Recover 10-15% of abandoned carts
Automation Idea #3: Weekly Performance Report
Trigger: Schedule (Monday morning)
↓
BigQuery: Run 5 key queries
- Revenue by source
- Top products
- Conversion rate
- New vs returning
- AOV trend
↓
Google Sheets: Update dashboard
↓
Looker Studio: Refresh report
↓
Email: Send PDF to stakeholders
Benefit: Save 2-3 hours/week
Automation Idea #4: Audience Sync to CRM
Trigger: Schedule (daily)
↓
GA4 Reporting API: Export audience members
- VIP Customers
- High Intent Visitors
- At-Risk Churners
↓
Match: Email/User ID
↓
HubSpot/Salesforce: Update contact properties
- GA4_Segment: "VIP"
- Last_Engagement: Date
- Purchase_Probability: 75%
↓
CRM: Trigger automations based on segments
Benefit: Sales team knows who to prioritize
✅ Your Advanced GA4 Checklist
Audiences (This Week):
- [ ] Create Cart Abandoners audience
- [ ] Create Product Viewers audience
- [ ] Create Past Purchasers audience (30d, 90d)
- [ ] Create High Intent audience
- [ ] Create Recent Converters (exclusion)
- [ ] Export audiences to Google Ads
- [ ] Set up remarketing campaigns
Predictive Analytics (This Month):
- [ ] Check if you meet requirements (1,000+ users)
- [ ] Wait for predictive metrics to populate (7+ days)
- [ ] Create Likely Purchasers audience
- [ ] Create Likely Churners audience
- [ ] Build campaigns around predictions
Explorations (This Month):
- [ ] Create purchase funnel exploration
- [ ] Set up path analysis
- [ ] Build cohort retention analysis
- [ ] Create segment overlap exploration
- [ ] Schedule weekly review
BigQuery (Advanced Users):
- [ ] Set up Google Cloud Project
- [ ] Enable BigQuery API
- [ ] Link GA4 to BigQuery
- [ ] Wait for first export (24 hours)
- [ ] Run your first query
- [ ] Schedule automated queries
- [ ] Build Looker Studio dashboards
Automation (As Needed):
- [ ] Identify manual reporting tasks
- [ ] Build n8n workflows for reports
- [ ] Set up cart abandonment automation
- [ ] Create alert system for anomalies
- [ ] Sync audiences to CRM
📥 Download Week 4 Resources
Advanced Audience Templates (JSON)
|
🎓 GA4 Certification Path
Want to master GA4? Here’s your learning path:
Beginner → Intermediate:
- ✅ Complete this 4-week series
- [ ] Google Analytics Academy (free)
- [ ] GA4 Certification (free)
Intermediate → Advanced:
- [ ] Learn SQL (Mode Analytics tutorials)
- [ ] BigQuery fundamentals course
- [ ] Looker Studio training
Advanced → Expert:
- [ ] Master GA4 Measurement Protocol
- [ ] Server-side tagging implementation
- [ ] Custom ML models with BQML
- [ ] Data engineering with Airflow
🚀 What’s Next?
You’ve completed the 4-week GA4 Audit Series. Here’s what to do now:
Week 5+: Maintain & Optimize
- Monthly: Revenue reconciliation
- Monthly: Audience performance review
- Quarterly: Full GA4 audit
- Quarterly: Update privacy policy
- Continuously: Test new audiences
Join the Community: I’m building a community of AI-driven marketers. We share:
- Advanced GA4 tips
- Automation workflows
- Real campaign results
- Battle-tested guides
Join the AI Driven Marketer Community →
🏆 You’re Now in the Top 5%
Seriously.
If you’ve implemented even half of what we covered in this series, you now know more about GA4 than 95% of marketers.
Most marketers will:
- Keep using broken tracking
- Waste budget on bad data
- Miss attribution opportunities
- Ignore predictive metrics
- Never touch BigQuery
You won’t.
You’re equipped with:
- ✅ Rock-solid tracking foundation
- ✅ Privacy-compliant setup
- ✅ E-commerce mastery
- ✅ Advanced audiences
- ✅ Predictive analytics
- ✅ SQL superpowers
- ✅ Automation capabilities
What you do with this knowledge determines your results.
📚 Bonus: Complete GA4 Resource Library
I’ve compiled every resource mentioned in this 4-week series:
Official Documentation:
Learning Resources:
- Google Analytics Academy
- GA4 Certification (free)
- BigQuery Fundamentals
- SQL for Marketers course
Tools:
- Google Tag Assistant
- GA4 DebugView
- BigQuery Sandbox (free)
- Looker Studio (free)
Communities:
- GA4 Subreddit
- Measure Slack community
- Analytics Mania blog
- The AI Driven Marketer (you’re here!)
Thank you for joining me on this 4-week journey.
Your dedication to better analytics will pay dividends for years to come.
Keep optimizing, keep learning, and most importantly - keep taking action.
See you in the next series! 🚀
About The AI Driven Marketer:
I help digital marketers leverage AI and automation to work smarter, not harder.
What’s coming next:
- LinkedIn Ads Optimization Series
- Advanced Attribution Modeling
- AI-Powered Content Creation
- Marketing Automation with n8n
Stay tuned.