Sebastien Aubinaud

Growthisn'tluck.

It'sinfrastructure.

I don't just run ads or write SQL. I build the systems that connect data to revenue—replacing "gut feeling" with engineering precision.

01 / ARCHITECTURE

Data that actually makes sense.

No more spreadsheet graveyards. I design PostgreSQL schemas that scale with your business, turning disconnected chaos into a single source of truth.

Evidence: Turned a martial arts academy's 12 disconnected spreadsheets into a system that tripled their student base (30 → 110 students).

02 / SYSTEMS

Marketing as code.

40x ROAS isn't a fluke; it's proper instrumentation. I build campaigns that are measurable from the first click to the final LTV calculation.

Current Focus: Building the analytics infrastructure for UnaLuka (e-commerce) to drive product import decisions based on real market data.

03 / AUTOMATION

If it repeats, automate it.

I create automation systems for marketing solutions and businesses. Using n8n workflows and webhooks to eliminate human drudgery. If you're spending 15 hours a week copying rows between tools, you're doing it wrong.

Innovation: Developing NodumCRM to turn raw databases into Notion-quality interfaces without migration.

04 / CROSS-CONTINENTAL BUILDER

Bridging disciplines with a dual degree in Administration & Marketing (ESAN) and International Business (YSchools SCBS).

My background goes beyond academia. It is a proof of adaptability. I combine commercial strategy with technical execution to build infrastructure that scales across diverse markets.

Based in: Lima

"No te detengas, confía en que todo se va a conectar."

Validated Systems

SelectedWork

A collection of systems designed for growth. scroll to explore the blueprints.

tallytown-predictive-modeling_Analytics_v2.0
96.4% Accuracy0.8156 AUC-ROC28.3x conversion multiplier
CASE STUDY

TallyTown Predictive Modeling

96.4%Impact Metric

Predicting user conversion with 96.4% accuracy

analysis_report.pdf
CRITICAL ISSUE
ID: #RISK_FACTOR

"Inefficiency Detected"

High churn in a 7-day trial ($4.99/user). 1.71% conversion rate meant marketing wasted budget on low-intent users.

0.8156
AUC-ROC
28.3x
conversion multiplier

Investigation & Model Selection

STEP 01

Processing...

Data: Processed 50k rows. Normalized 24 behavioral features.

STEP 02

Processing...

Insight: Users with >10 tasks in 48h convert 28x more.

STEP 03

Processing...

Model: Random Forest (96.4% Acc) selected for interpretability.

STEP 04

Processing...

Action: Pipeline exports 'High Propensity' users to Meta Ads.

Performance Report
Q1

96.4% Model Accuracy (vs 1.7 baseline)

Q2

0.8156 AUC-ROC Score verified on holdout set

Q3

Identified 'Magic Window': 72.8% of conversions happen days 0-3

Q4

Projected +162% ROI impact by cutting spend on 'Dead Leads'

VIRAL CAMPAIGN CORE

Lynx Educate AI Course

Acquiring 8-12K learners across Africa at $2 CAC

Mission Objective

Mission Critical:
205M TAM

Launch a pan-African marketing campaign for a free 15-hour IBM-certified AI course. The goal: Acquire 8,000-12,000 verified learners from English-speaking countries (Nigeria, Kenya, Ghana, South Africa) with a strict budget cap of $2.00 per acquisition.

1

Strategy Node 1

Segment: Sized TAM at 205M. Focused on 'Tech-Adjacent Youth'.

2

Strategy Node 2

Persona: Targeting 'Side-Hustlers'. Angle: 'Don't get left behind'.

3

Strategy Node 3

Channel: WhatsApp & Reddit to bypass expensive Ads.

4

Strategy Node 4

Score: Tiered system filters 'freebie seekers'.

CAMPAIGN VIRAL
14,500+
Registrations (Exceeded max target by 20%)
CAC
dropped from $1.50 to $0.28 at scale (86% efficiency gain)
38%
Completion Rate (vs Industry Standard of ~12% for MOOCs)
Secured
strategic partnerships with She Code Africa & ALX
vibe-combinator-aeo_Analytics_v2.0
BotRank AnalysisVisibility AuditPrompt Strategy
CASE STUDY

Vibe Combinator AEO Analysis

BotRankImpact Metric

Diagnosing why an AI marketing course was invisible to LLMs

analysis_report.pdf
CRITICAL ISSUE
ID: #RISK_FACTOR

"Inefficiency Detected"

Vibe Combinator, a cutting-edge AI marketing course, was nearly invisible to the very tools it taught. Searches on Perplexity or ChatGPT for 'Vibe Coding course' returned generic results instead of the brand.

Visibility
Audit
Prompt
Strategy

Investigation & Model Selection

STEP 01

Processing...

Audit: Identified blocking issues (No sitemap, no schema, missing llms.txt).

STEP 02

Processing...

Prompts: Analyzed 'Direct' vs 'Indirect' queries.

STEP 03

Processing...

Roadmap: Strategy to make content machine-readable.

Performance Report
Q1

Identified 5 Critical Technical Failures.

Q2

Designed 'llms.txt' and Schema strategy.

Q3

Created 'Prompt-First' content plan.

Mastery Level
Live Dojo
The Gold Standard

AMAS Team Wolf Transformation

From chaotic spreadsheets to automated growth

The Opponent

"A traditional academy drowned in manual admin. Student tracking and payments were scattered across 12 discordant Google Sheets, costing the owner 15+ hours/week."

Vital Sign 013x Growth
Vital Sign 02High ROAS
Vital Sign 03-87% Manual Work

Technique

Forged in Fire
1

Form 1

Normalization: Consolidated 12 sheets into one PostgreSQL DB.

2

Form 2

Automation: 'Set & Forget' n8n workflows for Admin.

3

Form 3

Marketing: Meta campaigns feeding directly into CRM.

4

Form 4

Pricing: Dynamic calculator for capacity tiers.

Championship Results

Tripled Growth: Scaled from 30 to 110 active students in 12 months

High ROAS: Ad spend optimized to generate significant LTV

Zero Admin Time: Automated registration, payments, and reminders freed 15h/week

Launched 'Black Belt Leadership' upsell program

LIVE

NodumCRM

Your PostgreSQL database, transformed into a Notion-style CRM

The User Pain

Companies with production databases are tool-poor. Sales teams beg for SQL queries, Support uses ugly admin panels, and Ops exports to spreadsheets. Building internal tools takes months.

Zero-Schema-Touch
Target KPI
Feature 01

Headless: Direct SQL connection. No migration.

Feature 02

Virtual Layer: Metadata overlay for formulas/pipelines.

Feature 03

UX First: Notion-like interface for adoption.

Performance Report

Solving the 'Buy vs Build' dilemma for internal tools.
Eliminating the need for data migration to dedicated CRMs (Salesforce/HubSpot).
Bridge gap between DevOps (Database) and SalesOps (Interface).

ROAS Achieved

Model Accuracy

Student Growth

Projected Leads

TechnicalArsenal

The tools I use to build scalable growth systems.

Data & Analytics

PostgreSQLPython (Pandas, Scikit-learn)SQLMetabaseData Visualization

Automation

n8nWebhooksAPI IntegrationsZapier

Marketing

Meta AdsGoogle AdsEmail Marketing (Courier)Landing Pages

Development

Next.jsReactTailwind CSSNode.js

Machine Learning

Random ForestXGBoostSMOTEFeature Engineering