andydataguy
ABOUT

Andy Houston. Revenue systems builder. Practitioner, not pundit.

I design and ship full-stack revenue systems for small-business operators. Sales copy, PPC, CRO, data engineering, AI agent systems, and the operational glue between them. Across the last decade my work has touched over $20M in collective ad spend, three e-commerce stores past seven figures, a $199.5K coaching launch in under thirty days, and a portfolio intelligence layer covering 50+ paid accounts. Receipts on the case studies page. This page is for the question that comes after.

Based
Cebu, PH
Working
Solo, no agency overhead
Stack
Pydantic · FastAPI · LogFire · Convex · Gemini · MCP
THE WORK I ACTUALLY DO

Six functions, one operator.

The catalog is wider than most solo practitioners can credibly claim, so the framing matters. There's no team running behind the scenes with my face on the deck. I do the work. The catalog is wide because the same set of problems shows up in different costumes across sales, growth, intelligence, ops, attention, and AI engineering. Solving one well usually requires touching the other five.

Sales copywriting for cold and warm traffic, grounded in real customer language scraped from reviews, threads, and support tickets. PPC and CRO as one engineered system, treating the ad account and the landing page as a single machine. Market research and data analytics using Python, Pandas, and SQL on raw exports rather than dashboard veneer. CRM administration and business automation across HubSpot, ClickUp, Notion, Salesforce, Make, and n8n. AI solutions engineering built around the twelve-component Agent Redwood assessment so projects ship in days or weeks. Knowledge engineering with custom RAG pipelines, cluster-semantic chunking, and Gemini task-typed embeddings for retrieval that works at the multi-million-word scale.

Creative, Technical, and Business are three different languages, and their native speakers genuinely struggle to hear each other. Campaigns die in the gap between the copywriter and the engineer. Data platforms die in the gap between the engineer and the P&L. I spent a decade getting fluent in all three so the translation happens in one head, with nothing lost at the handoffs. That's the actual job. Everything on the case-studies page is that job wearing different clothes.

All six route through the same diagnostic spine. People, then product, then process. Diagnose before prescribing.

WHAT I LEARNED THE HARD WAY

Four moments where reality contradicted what I thought.

Past performance is not a guarantee of future results. The thing that does carry across projects is how an operator thinks under pressure and what they keep doing differently after they get burned. These are the four times reality forced a methodology change.

2012 to 2015 · DOOR-TO-DOOR & INSURANCE

"No" is data, not personal.

Knocking on doors in Dallas selling knives and soap. Cold-calling thousands of people for life insurance. Raising real-estate capital from investors three times my age. The early years burned in a working belief that rejection is a numerical signal, not a verdict on the operator. You earn about four seconds to justify the next thirty. After that the math takes over.

Methodology shift: every funnel I have built since starts with qualification language designed to repel the wrong fit, on purpose. The "Velvet Rope" pattern in my agency lead-gen work, where deal flow at $5K to $25K only books calls from prospects targeting at least an extra $10K monthly, is a direct descendant of those door-to-door years.

2015 to 2016 · VEGAS THERAPY CLINIC

Hear what is not being said.

A year holding space for trauma victims at a clinic in Las Vegas. The lesson that translated directly into market research: the surface complaint is rarely the real problem. The customer who says "I need more leads" almost always means "I'm terrified my business doesn't actually work." The customer who says "the website looks dated" almost always means "I'm embarrassed to send the URL to the people I want to impress."

Methodology shift: every diagnostic now runs seven layers deep before recommending a deliverable. The 180-point ICP profile I use on every engagement was built so I'd never again propose a solution to the wrong layer of pain.

2017 to 2021 · AGENCY, ECOM, MANUFACTURING

Scale breaks everything that was hand-held.

Ran my own agency at $10K a day in sustained ad spend, peaking above $50K. Built three e-commerce brands past seven figures, including a metal-art DTC business that went from $10K monthly to $150K monthly in 90 days, crossed $1M within seven months, and eventually went eight-figure. Ran a 10,000 square foot manufacturing shop in Colorado upstairs from the agency office. Closed $199.5K in coaching sales in under thirty days as head coach of a hybrid program. Built CRMs for teams ranging from 20 to 250 people.

I also blew it up. I took on every adjacent business at once because I was 24 and had just made real money for the first time. The smarter move was to double down on what was working. Instead I tried to run an agency, an ecom store, and a metal shop simultaneously. The mistakes compounded into a hole the businesses could not climb out of.

Methodology shift: scope discipline became non-negotiable. The Agent Redwood twelve-component assessment, the spec-driven development workflow, and the "MVP in days or weeks, not months or never" principle all exist because I have personally paid the bill for the alternative.

2022 to 2025 · DATA ENGINEERING, CRYPTO, AI

Pure marketing skill is a single point of failure.

After watching a dozen consulting clients get smacked by the iOS 14 attribution collapse and the Facebook ad-pocalypse, I stopped being purely a marketer. Two years self-taught into data engineering, building production systems on Pydantic, FastAPI, LogFire, and Hypothesis. Helped design an algorithmic trading system where data quality bugs cost houses, not reports. Worked tokenomics and incentive design for over two dozen Solana projects on a $500M+ TVL platform. Got rugged on a Polkadot project I helped scale from $10M to over $100M market cap, and learned the hard way that investor character is more load-bearing than the team's technical talent.

Methodology shift: marketing, data, and AI engineering now operate as one practice. Every revenue system I propose ships with a working observability layer, type-safe data contracts, and property-based tests. Boring reliability is the unfair advantage at the small-business price point.

WHAT I AM WORKING ON RIGHT NOW

What I'm building right now.

I left consulting full-time for six months in 2025 to research agent-native compiler technologies, then came back. The current set of work is what feeds the methodology. If you're evaluating whether the practitioner is still in the practice, this section is the answer.

THE CONTENT COMPILER

Two-year obsession. An LLVM-IR-inspired pipeline that treats long-form content as a compiled artifact rather than one giant prompt. Atomic node graph, optimization passes for cadence and logic, surgical re-generation. Cuts token cost roughly 90% on long-form work versus full re-rolls. Currently MVP, in production for my own writing. The research behind it has its own entry on the case-studies page: the research layer.

CONSTELLATION PORTFOLIO

A growing set of named and unnamed companies. ContentFactory live and paid for by its first dealership client. WikiDesignCo, FreelanceBuddy, SocialStoryboard, Constellation Media, Node Foreman, QuantScientist, Depths of the Void in various stages. Each company is a productized version of a service I previously delivered as a freelancer.

AGENTIC RAG & KNOWLEDGE

Local retrieval system on Archon with custom cluster-semantic chunkers and Gemini Embedding 2 task types. Five million plus words of personal corpus indexed. MCP server exposes it to any agent. The same architecture deploys for client knowledge bases.

WRITING IN PUBLIC

The Wiki is the curated reference library across all six service categories. The Field Notes stream is the daily firehose: build logs, half-finished thoughts, wrong takes left up so the next one is less wrong. Both are the working surface of the methodology, not retrospective marketing.

HOW I WORK

Constraints, not promises.

I'm autistic. The way that surfaces in the work is direct language, fast pattern recognition, and an allergy to corporate scaffolding. If a sentence does not earn its place, I cut it. Communication is once, directly, positively. People who like that find it refreshing. People who want softer framing usually self-select out, which is fine.

I don't take retainers that can't support deep work, because a budget stretched that thin means cutting corners. I don't take projects where the operator wants a magic button and refuses to share data. Every paid acquisition engagement includes a quoted test budget because the market gets the final vote on whether it responds. The system, the diagnostic depth, and the output quality are mine to guarantee.

I work from Cebu, Philippines, on Pacific or Asia time depending on the engagement. Async over synchronous wherever the work allows. Weekly reports use the "what, so what, now what" format so the client never has to ask what changed.

Two paths from here. Both work.

If you came for the substance, the Wiki is the reference library across every service category, with the methodology essays and the technical deep dives. If you came because you have a specific problem, the quote form is the fastest way to put it in front of me.