Skip to main content
Back to Home

Marketing Analytics Portfolio

Cross-platform social media data stacks, behavior-driven email follow-ups, and multi-channel ROAS & attribution models.

Smart Email Campaign Manager: Follow-ups Based on Opens & Clicks — Marketing Analytics case study by Alfa Analytics
Video WalkthroughEmail Automation Developer
Watch Video & Read Case Study
Marketing Analytics
3 weeks

Smart Email Campaign Manager: Follow-ups Based on Opens & Clicks

The client was sending the exact same follow-up email to every lead regardless of what they did with the previous message—someone who clicked a link got the same follow-up as someone who never opened it. Worse, replies were easy to miss, so leads sometimes kept getting automated follow-ups after they had already answered.

15 Mins
Maximum time to detect a customer reply in Gmail and halt follow-ups
3 Branches
Tailored follow-ups for Opened, Clicked, and Unopened leads
Zero
Leads accidentally chased after they already replied
n8nSupabaseOpenAI APIGmail API+2
AI LinkedIn Content Engine: Posts & Carousels with Owner Approval — Marketing Analytics case study by Alfa Analytics
Video WalkthroughAI Automation Developer
Watch Video & Read Case Study
Marketing Analytics
3 weeks

AI LinkedIn Content Engine: Posts & Carousels with Owner Approval

Publishing strong LinkedIn content every day was taking the founder hours—finding a real source worth writing about, drafting the post, and designing a matching carousel. On busy days nothing went out, yet the owner still wanted 100% final approval before anything was published under their name.

Minutes
Spent by the owner approving posts instead of hours writing & designing
100%
Human-approved before anything goes live on LinkedIn
Post + Deck
Written post and designed carousel slides generated together on schedule
n8nLinkedIn APIApifyOpenRouter+3
AI Music & Sports Content Generator with Email Approval — Marketing Analytics case study by Alfa Analytics
Video WalkthroughAI Automation Developer
Watch Video & Read Case Study
Marketing Analytics
2 weeks

AI Music & Sports Content Generator with Email Approval

The client publishes weekly music and sports content, but keeping up with breaking news, picking trending stories, writing posts, and creating visuals took hours every week—and by the time assets were finished manually, some stories were already stale.

Weekly Pack
Researched stories and visuals delivered to the client's inbox automatically
Real-Time
Catches trending music & sports stories while they are still fresh
100%
Client email approval before any content is published
n8nApifyOpenAI APIAI Image Generation+2
Ecommerce RFM Dashboard: Identified $50k in Churn Risks — Marketing Analytics case study by Alfa Analytics
Video WalkthroughSenior Analyst
Watch Video & Read Case Study
Marketing Analytics
3 weeks

Ecommerce RFM Dashboard: Identified $50k in Churn Risks

The business had 693 customers but no clear way to tell them apart. Everyone got the same emails and offers—whether they bought every week or hadn't ordered in almost a year. There was no quick way to see who the best customers were or who had stopped buying.

$50K
Churn risk flagged in customers who used to buy but went quiet
$185K
Sales identified from top Champion customers alone
11 Segments
693 customers grouped for targeted loyalty & win-back offers
TableauRFM AnalysisData EngineeringCustomer Segmentation+2
Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbt — Marketing Analytics case study by Alfa Analytics
Video WalkthroughLead Architect
Watch Video & Read Case Study
Marketing Analytics
6 weeks

Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbt

The client's analysts were pulling social media data by hand every week—logging into YouTube, Facebook, Instagram, TikTok, and other platforms one by one, exporting CSVs, and pasting numbers into reports. That took 8+ hours every week, and because each platform names and counts metrics differently, reports never matched.

95%
Drop in manual data collection time
8+ hrs/wk
Analyst time saved and redirected to insights
1 Source
Trusted set of audience & engagement metrics across all platforms
dbtBigQueryAirbyteFivetran+3
CRM on Autopilot: Daily Lead Pipeline Automation — Marketing Analytics case study by Alfa Analytics
Video WalkthroughCRM Automation Developer
Watch Video & Read Case Study
Marketing Analytics
3 weeks

CRM on Autopilot: Daily Lead Pipeline Automation

A sales team in Spain was running its entire pipeline by hand. Three people spent their days inside the CRM: checking Gmail to see who had replied, moving leads from one stage to the next, setting follow-up reminders, and fixing contact records. It was slow, error-prone, and the only way to handle more leads was to hire more people.

3 People
Of daily manual CRM updating work fully automated
9:00 AM
Pipeline updated automatically every morning before work starts
100%
Active leads checked against Gmail threads daily
n8nCRM AutomationGmail APIREST API Integration+2
AI Lead Finder Chatbot (Yelp, Google Maps & US Directories) — Marketing Analytics case study by Alfa Analytics
Video WalkthroughAI Automation Developer
Watch Video & Read Case Study
Marketing Analytics
3 weeks

AI Lead Finder Chatbot (Yelp, Google Maps & US Directories)

Building local business lead lists by hand took hours. To build a single prospect list—like coffee shop owners in Miami—someone had to search Yelp, then Google Maps, then US business directories, and manually open every business's website to hunt for an email address or phone number.

Minutes
To build complete local prospect lists (down from hours by hand)
3 Sources
Yelp, Google Maps & US Directories searched simultaneously
100% Enriched
Website, address, phone & email scraped for every lead
n8nAI AgentGoogle MapsYelp Scraping+2
Multi-Channel DTC Data Stack & Seasonality ROAS Analytics — Marketing Analytics case study by Alfa Analytics
Featured Case StudyLead Data & BI Architect
Read Full Case Study
Marketing Analytics
5 weeks

Multi-Channel DTC Data Stack & Seasonality ROAS Analytics

The brand was selling on Shopify/WooCommerce and running paid ads across Meta, Google, TikTok, and Amazon, with email in Klaviyo and payments in Stripe. Data was siloed across 8 platforms, manual reporting took 2+ days every month, and leadership couldn't account for seasonal swings when evaluating ROAS or true net margin.

90%
Reduction in monthly reporting time with daily automated syncs
+25%
Improvement in paid ad spend efficiency across channels
8 Sources
Unified into one BigQuery & dbt source of truth
FivetranBigQuerydbtPower BI+3
E-Commerce Data Architecture: 8-Platform BigQuery & dbt Stack — Marketing Analytics case study by Alfa Analytics
Lead Data Architect
Read Full Case Study
Marketing Analytics
5 weeks

E-Commerce Data Architecture: 8-Platform BigQuery & dbt Stack

Data was siloed across 8 different platforms (WooCommerce, Meta Ads, TikTok Ads, Google Ads, GA4, Klaviyo, Stripe, and ERP inventory) with no way to see the complete customer journey or calculate true customer acquisition cost.

8
Data sources unified into a single source of truth
Daily
Automated data syncs (replacing manual weekly exports)
100%
Attribution visibility across the customer journey
FivetranBigQuerydbtLooker Studio+2
AI Auto-Blogging Pipeline with Notion & GitHub Actions — Marketing Analytics case study by Alfa Analytics
Featured Case StudyAI Automation Architect
Read Full Case Study
Marketing Analytics
4 weeks

AI Auto-Blogging Pipeline with Notion & GitHub Actions

Publishing 5+ SEO blog posts a week required a full-time copywriter at $200+ per article, plus hours of manual CMS formatting and image creation.

99%
Cost reduction per article ($200 → $1.50)
10x
Increase in weekly publishing velocity
10 mins
Editorial review time per article (down from 4 hours)
n8nClaude AINotion APIGitHub Actions+1
WordPress to YouTube Shorts Video Automation — Marketing Analytics case study by Alfa Analytics
Featured Case StudyAI Automation Architect
Read Full Case Study
Marketing Analytics
4 weeks

WordPress to YouTube Shorts Video Automation

The firm published 4–6 written articles weekly but had zero video presence because producing YouTube Shorts manually required a scriptwriter, videographer, and editor—costing $150/video and 3–5 days per asset.

97%
Cost reduction per video ($150 → $5)
30/mo
Short-form videos published monthly (up from 4)
4 hrs
Total hands-on time per month (~8 min per video)
n8nClaude AIHeyGen APIWordPress API+2

Have a similar problem in your business?

Book a 30-minute call and we'll walk through how we would architect and automate your exact workflow.