Klaviyo • Make.com • AWeber • Looker • SQL • AI Workflows
Marketing automation specialist who builds data-driven systems for high-volume email & SMS operations. SQL analytics + AI workflows + Make.com automation — managing 23M+ subscribers and 3.6M+ monthly sends.
$4.2M+
Annual Revenue
23M+
Subscribers Managed
400+
Campaigns Analyzed/Cycle
3.6M+
Monthly Sends
-- Revenue Analysis: 400+ Campaigns/Cycle
-- Tier Classification + Fatigue Detection System
SELECT
offer_name,
revenue / sends AS rpe,
CASE
WHEN revenue/sends > 0.001 THEN 'TOP_SHELF'
WHEN revenue/sends > 0.0005 THEN 'MEDIUM_SHELF'
ELSE 'LOW_SHELF'
END AS tier,
(current_ctr - peak_ctr) / peak_ctr AS fatigue_score
FROM campaign_performance
WHERE send_date > CURRENT_DATE - 90
ORDER BY rpe DESC;
-- 🔍 Pattern Found: CVS fatigue @ -56.2% CTR
-- 📈 KFC recovery: +155.6% via rotation
-- 💰 Scoredit gap: $15K/mo identified
-- ✓ 30% revenue decline REVERSED
Watch me walk through the data analysis and automation architecture behind a $4.2M email operation — from forensic campaign analysis to automated revenue optimization.
Full case study details below · SQL workflows · Looker dashboards · Automation architecture
Technical Stack
Managing 23M+ subscribers and 3.6M+ monthly sends requires the right infrastructure. Here's what I use daily to analyze 400+ campaigns per cycle and drive measurable revenue improvements.
My Analytical Approach
I approach email operations with forensic rigor — tier classification, fatigue detection, and slot optimization working together as a systematic decision engine.
Revenue Per Email (RPE) Based
Premium slots only (MD). High-value offers with proven performance.
Ex: milestone_tng ($0.0039), destiny_tng ($0.0032)
Secondary slots (AM, TAR). Rotation candidates.
Ex: mdfoodbreakfast ($0.00089)
Eliminate or pause. Dragging down averages.
Ex: bundled_offers ($0.00000)
Early Warning System
→ Safe to continue
→ Increase rotation gap
→ PAUSE IMMEDIATELY
Formula: Optimal_Gap = (Peak_CTR / Current_CTR) × 14 days
Time-Based Optimization
11am-1pm window
BASELINE
7am-9am window
Segment-specific
3pm-5pm window
Rule: TOP_SHELF offers → MD slots only. Medium performers rotate through AM/TAR.
📊 Real Data From My Dashboard
Fatigue Detection in Action: Open Rate, CTR, and Unsub trends tracked over 90-day windows
This approach analyzes 400+ campaigns per cycle and drives measurable revenue improvements.
See It In ActionProof, Not Promises
From scaling $4.2M email operations to automating $137K+ in manual workflows — here's how I've applied data analytics and automation to drive measurable results.
$4.2M in revenue but profit margins stuck at 22%. Performance was declining, offer rotation was disorganized, and there was no systematic tracking. The team needed visibility into what was actually driving results.
Manual processes + poor segmentation meant no visibility into what actually drove performance. The team needed a systematic tracking approach.
Built custom tracking analyzing 400+ campaigns per reporting cycle across 90-day windows, systematically finding offer fatigue patterns, slot performance sweet spots, and optimal send times
Built Zapier workflows connecting Looker analytics to Ongage, eliminating manual processes and enabling real-time rotation based on AI-predicted fatigue scores
Managed 5 daily campaigns across 23M+ subscribers with 3.6M+ monthly sends across multiple domains while maintaining deliverability
Managed 99+ affiliate offers via Synergy/Everflow, coordinated ad revenue across ZAN, Ezoic, LiveIntent, and Outbrain. Executed cross-platform revenue forensics that caught $8,400+ in misattributed revenue
Monitored IP reputation via Google Postmaster Tools. Executed emergency recovery from 100% Medium to 40% High in 5 days using targeted 30-day engaged user strategy
$15K/mo
Revenue gap identified via placement analysis—identical traffic, 100x revenue difference
+155.6%
CTR improvement via strategic rotation—documented methodology for replication
-56.2%
CTR decline caught early via fatigue detection—implemented 30-day pause protocol
Demographic Analytics
AI Subscriber Analysis
Looker Master Dashboard
Affiliate Revenue Tracking
| AM | MD | PM | TAR | |
|---|---|---|---|---|
| Mon | $607 | $1,204 | $390 | $430 |
| Tue | $0 | $1,726 | $645 | $640 |
| Wed | $0 | $1,588 | $265 | $796 |
| Thu | $512 | $2,103 | $478 | $689 |
| Fri | $723 | $1,891 | $312 | $445 |
Green = High RPE | Yellow = Medium | Red = Low | Gray = Skip
# Campaign Scheduling Decision Engine
DECISION_CRITERIA = {
1: "Historical RPE by slot",
2: "Days since last send (min 10)",
3: "Brand conflict check",
4: "Slot multiplier applied",
5: "Day-of-week psychology"
}
SLOT_MULTIPLIERS = {
"MD": 1.00, # Baseline - premium
"AM": 0.53, # Morning secondary
"TAR": 0.44, # Targeted segments
"PM": 0.34 # Afternoon lower
}
# Output: $41K+ weekly projection
# Accuracy: 87% vs actual revenue
Revenue by Slot
Testing Framework
Campaign scheduling was guesswork. Offers got burned out, premium slots wasted on low performers, and nobody tracked why certain days outperformed others. We needed a system—not opinions.
Historical RPE → Fatigue check (10-day minimum) → Brand conflicts → Slot multipliers → Day psychology
MD slot = 1.00x baseline (premium placement). PM slot = 0.34x. TOP_SHELF offers only go to MD.
No duplicate brands per week. Competitive offers separated by 3+ days minimum.
Claude for SQL query building, Gemini for pattern detection across 5 properties simultaneously
99+ affiliate offers restricted to TAR/PM slots only (spam trap avoidance). RPC thresholds >$0.50, brand conflict separation by 3+ days
Revenue forecasting per calendar
Projection vs actual revenue
Simultaneous calendar coordination
Full weekly calendar build time
Key Insight: The methodology matters more than individual campaign wins. Once I built this system, calendar planning went from 8+ hours of guesswork to 2 hours of systematic data application.
The entire marketing operation relied on **100% manual execution**. Every link was checked by hand, every purchase was logged manually, and every segmentation tag was applied one-by-one. This human-dependency led to a **90% revenue collapse** when manual errors caused massive link failure and carrier blocks.
The business was attempting to scale a $100K+ operation on a "broken manual engine." Without automation, high-intent windows like the **"Day 11 Danger Zone"** were missed, and $41.7K in dormant VIP revenue was ignored because there was no automated way to identify "Whales."
Replaced hours of manual data entry with a real-time Make.com sync that instantly routes Stripe events to AWeber and HubSpot, ensuring zero data-lag.
Engineered a self-healing native lookup database that automatically segments "Whales" vs. VIPs, triggering high-touch recovery without a single manual click.
Built an AI-assisted automated verification system (Claude Code + Playwright) to audit 100% of links and carrier-banned copy before any broadcast is deployed.
CORE_ORCHESTRATION_LOGIC.MAKE
MOBILE_UX.JPG
LIFECYCLE_FLOW.PNG
Campaign-by-Campaign Revenue Reconciliation
UTM Tracking Implementation & Verification
Revenue numbers weren't adding up. Our internal tracking showed one figure, the affiliate platform reported another, and nobody knew which was accurate.
Established reliable reconciliation process
Caught attribution timing gaps
Restored confidence in reporting
Ongoing monitoring protocol
Key Insight: Revenue discrepancies aren't always about wrong numbers—they're often about different measurement windows. Understanding the "why" behind mismatches is more valuable than just forcing numbers to match.
Track Record
5+ years building automation infrastructure and scaling email operations — from Fortune 500 companies to high-growth startups.
Architected and deployed a mission-critical SMS & Email automation infrastructure
Managing $4.2M+ annual email revenue operation with 23M+ subscribers
Let's Work Together
I bring automation systems, SQL analytics, and AI workflows that scale email operations into high-performing revenue engines. Currently seeking a full-time remote role where I can make an immediate impact.
© 2024 Alberto Torres. Built with clean code, just like my campaigns.